Results from one DevAzure API results to feed into another DevAzure API call

[newbiekp]

I am using 

https://dev.azure.com/{organization}/{project}/_apis/build/builds/{Buildid}/workitems?api-version=6.... to get WorkItemID and and then I need to loop through the results to get Work Item Details from https://dev.azure.com/{organization}/{project}/_apis/wit/workitems/{WorkItemID}?api-version=6.0 

How can I achieve this? 

[newbiekp · Accepted solution]

Hi, I have figured out what to do.

Created a Custom column that will call a Function which will fetch the details from the child API.

Reference :https://satalyst.com/power-query-creating-a-parameterized-function-in-m/

[v-xiaotang]

Hi @newbiekp 

not sure, could you add more details about your question?

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.