2-Step API GET Request

[lkshck]

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!

[lbendlin]

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

[lkshck]

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.