REST API data source dynamically built from previous separate REST API data source

[moefinley]

I'm trying to get data from TeamCity into Power BI. The data is for each build and I get the list of builds with a separate call.

http://teamcityserver/guestAuth/app/rest/builds

Which returns something like this:

| Attribute:href | build.Attribute:id | build.Attibute:buildTypeId | build.Attribute:number |

How can I then dynamically make more data sources by calling the API again with 

http://teamcityserver/guestAuth/app/rest/builds?buildTypeLocator=ExampleBuildTypeId

Where ExampleBuildTypeId would be taken from the previous call to the API.

Thanks for any help

[v-yuezhe-msft]

@moefinley,

You can add custom column in Power BI Desktop by calling function to return the result of all the calls. For more details, please review the following similar threads.

https://community.powerbi.com/t5/Desktop/Iterating-changing-query-parameter-to-build-a-merged-table/...
https://community.powerbi.com/t5/Desktop/Iterating-over-start-and-end-dates-for-multiple-API-calls/t...

Regards,
Lydia