Forum Discussion
ScottF
10 years agoFrequent Visitor
How can an API query reference another API query?
I'm making API calls to a call tracking service called ResponseTap. Their API allows you to return a list of many call IDs (e.g. clarity-us4-1459508541.810585), but with no further details such as ca...
Greg_Deckler
Community Champion
10 years agoHere is a similar scenario that should help you out.
http://datachix.com/2014/05/22/power-query-functions-some-scenarios/
Basically, the concept is to turn your API Call 2 into a function that takes one or more parameters and then you call API Call 2 function for each row in API Call 1.
In your case, you may have to create multiple functions and custom columns that call those functions, or return everything in a comma-separated return value and then do a split on that column as a subsequent step in your API Call 1 query.