Éric Brazeau

My feedback

  1. 37 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on 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…

    An error occurred while saving the comment
    Éric Brazeau commented  · 

    Hi DEV,

    client mentioned he would appreciate to ba able to export CSV of Azure Usage to present to Mnagement.

    Éric Brazeau supported this idea  · 

Feedback and Knowledge Base