https://community.fabric.microsoft.com/t5/Developer/Results-from-one-DevAzure-API-results-to-feed-into-another/m-p/2099848#M32131 <P>I am using&nbsp;</P><P><A href="https://dev.azure.com/{organization}/{project}/_apis/build/builds/{Buildid}/workitems?api-version=6.0" target="_blank" rel="noopener">https://dev.azure.com/{organization}/{project}/_apis/build/builds/{Buildid}/workitems?api-version=6.0</A>&nbsp;to get WorkItemID and and then I need to loop through the results to get Work Item Details from&nbsp;<A href="https://dev.azure.com/{organization}/{project}/_apis/wit/workitems/{WorkItemID}?api-version=6.0" target="_blank" rel="noopener">https://dev.azure.com/{organization}/{project}/_apis/wit/workitems/{WorkItemID}?api-version=6.0&nbsp;</A></P><P>&nbsp;</P><P>How can I achieve this?&nbsp;</P><P>&nbsp;</P> Mon, 27 Sep 2021 08:07:49 GMT Anonymous 2021-09-27T08:07:49Z https://community.fabric.microsoft.com/t5/Developer/Results-from-one-DevAzure-API-results-to-feed-into-another/m-p/2099848#M32131 <P>I am using&nbsp;</P><P><A href="https://dev.azure.com/{organization}/{project}/_apis/build/builds/{Buildid}/workitems?api-version=6.0" target="_blank" rel="noopener">https://dev.azure.com/{organization}/{project}/_apis/build/builds/{Buildid}/workitems?api-version=6.0</A>&nbsp;to get WorkItemID and and then I need to loop through the results to get Work Item Details from&nbsp;<A href="https://dev.azure.com/{organization}/{project}/_apis/wit/workitems/{WorkItemID}?api-version=6.0" target="_blank" rel="noopener">https://dev.azure.com/{organization}/{project}/_apis/wit/workitems/{WorkItemID}?api-version=6.0&nbsp;</A></P><P>&nbsp;</P><P>How can I achieve this?&nbsp;</P><P>&nbsp;</P> Mon, 27 Sep 2021 08:07:49 GMT https://community.fabric.microsoft.com/t5/Developer/Results-from-one-DevAzure-API-results-to-feed-into-another/m-p/2099848#M32131 Anonymous 2021-09-27T08:07:49Z https://community.fabric.microsoft.com/t5/Developer/Results-from-one-DevAzure-API-results-to-feed-into-another/m-p/2105330#M32135 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P> <P>not sure, could you add more details about your question?</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Community Support Team _Tang</P> <P>If this post<SPAN>&nbsp;</SPAN><STRONG>helps</STRONG>, please consider<SPAN>&nbsp;</SPAN><STRONG><EM>Accept it as the solution</EM></STRONG><SPAN>&nbsp;</SPAN>to help the other members find it more quickly.</P> Wed, 29 Sep 2021 10:16:00 GMT https://community.fabric.microsoft.com/t5/Developer/Results-from-one-DevAzure-API-results-to-feed-into-another/m-p/2105330#M32135 v-xiaotang 2021-09-29T10:16:00Z https://community.fabric.microsoft.com/t5/Developer/Results-from-one-DevAzure-API-results-to-feed-into-another/m-p/2110053#M32182 <P>Hi, I have figured out what to do.</P><P>&nbsp;</P><P>Created a Custom column that will call a Function which will fetch the details from the child API.</P><P>&nbsp;</P><P>Reference :<A href="https://satalyst.com/power-query-creating-a-parameterized-function-in-m/" target="_blank">https://satalyst.com/power-query-creating-a-parameterized-function-in-m/</A></P> Fri, 01 Oct 2021 08:05:57 GMT https://community.fabric.microsoft.com/t5/Developer/Results-from-one-DevAzure-API-results-to-feed-into-another/m-p/2110053#M32182 Anonymous 2021-10-01T08:05:57Z