Export license/usage reports per customer to CSV
Real-time usage reports which include dollar amounts so we know what to bill our customers at a glance.
Detailed billing reports by customer within 24 hours accuracy EXPORTABLE to excel or PDF
Anonymous
shared this idea
Good Morning,
With the newly Added Account Payable APIs and with a few lines of Power Query Script you should now be able to extract invoices data from either Microsoft Excel, Power Automate or Power BI to create an outstanding report.
Those APIs include 36 months of historical data. You will also get access to the upcoming invoice; this one being updated daily to reflect the latest changes (licensing or usages) in your account.
To start using the Power Query Script technology you will need to activate and configure an API key, instructions and configurations available under the ‘Security’ section of the left side panel then under the submenu ‘APIs’ of the Partner Portal Application (‘Cumulus’).
If you’re not familiar with Power Query Script here a piece of script interacting with our APIs: https://gist.github.com/EricLacroix/e6313e893f3f107f22eccfb79cddadb7
If your looking for a turn-key Excel file using the previous Power Query Script , we’ve also attached an example with this email, you will still need to provide the various APIs configuration keys but as soon as you finish the configuration you should be able to slice and dice your data. Here a quick recording to configure the Excel File: https://www.screencast.com/t/UAhpgMhx
Please do not hesitate for any questions, we have a dedicated group of talented individuals: api@sherweb.com
3 comments
-
Éric Brazeau
commented
Hi DEV,
client mentioned he would appreciate to ba able to export CSV of Azure Usage to present to Mnagement.
-
Dan Baird
commented
ability to export items as a materials list to import into ERP systems
-
Export the technical usage of your organizations and resellers in comma-separated values (CSV) format for easy importing into your favorite software.
---------------------------
Exportez les données sur l'utilisation technique de vos clients et revendeurs au format CSV pour les importer dans votre application favorite.
