IBM Apptio

Apptio

A place for Apptio product users to learn, connect, share and grow together.

 View Only

  • 1.  How to use an Apptio API GET in Excel Power Query via JSON

    Posted Mon August 05, 2024 07:49 AM

    Has anyone have success in using the JSON API to use the GET from Web function within Excel's Power Query to pull data?

    Tried following the instructions from the MS article -- Using a REST API as a data source and I keep getting an error message as below.



    ------------------------------
    Tony Wong
    ExxonMobil TBM Consultant
    ------------------------------

    #CostingStandard(CT-Foundation)


  • 2.  RE: How to use an Apptio API GET in Excel Power Query via JSON

    Posted Tue August 06, 2024 01:30 AM

    Hi Tony,

    I suspect that error message is the Apptio web page returned when there are issues with the API call (invalid parameters in the call, user account is not an admin or service account, or many other issues).

    I did build an excel macro some years ago that would make GET calls to Apptio API end points and load the response into a worksheet. A clunky solution but did get it to work. Happy to catch up and run through it at some point.

    Cheers Mark



    ------------------------------
    Mark Johnson
    Delivery Manager - TBM Office
    Origin Energy
    +61 467 863 134
    mark.johnson1@origin.com.au
    ------------------------------

    Original Message


  • 3.  RE: How to use an Apptio API GET in Excel Power Query via JSON

    Posted Tue August 06, 2024 10:32 AM

    Thank you, @Mark Johnson. I have sent you an email separately.



    ------------------------------
    Tony Wong
    ExxonMobil TBM Consultant
    ------------------------------

    Original Message