Forum Discussion

lkshck's avatar
lkshck
Helper III
3 years ago

2-Step API GET Request

Hey, 

I would like to do a 2-Step API Get request to a Billing API. The API looks like the following:

https://customer.service.com/billing/invoices

For this first API you will get a JSON which shows the information about all the past invoices with the total numbers but without any details about the single invoices. To get those details you need to make a second request which looks like the following:

https://customer.service.com/billing/invoices/<id>

In this second call you need to put the Id of the Invoice and you will get all details about the invoice.

Is this a scenario which can be setup in PowerBI? I would like to have one big table which contains all the detailed information about every invoice.

Thanks in advance!

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    This will be the least of your issues.  What's the authentication method?

    • lkshck's avatar
      lkshck
      Helper III
      3 years ago

      In the first use case it's basic auth with an API key and in the second use case it's with digest auth with public and private key. I just read that digest auth isn't working, but maybe it works for the first use case with basic auth.