Use values returned by API in subsequent API call

[dpjm]

Hi Everyone,

I've really been pulling my hair out on this one. I want to pull data from multiple API calls into one table. The source is a contracts management system called Concord (https://concordapi.docs.apiary.io/#).

I have been successful in using a query to get the list of agreements using "https://api.concordnow.com/api/rest/1/agreement?" that I have successfully transformed into a table. 

Now I need to use the unique identifier (UID) field from the first query to execute the second query which will return additional data about the records returned from the first query. This second query is "https://api.concordnow.com/api/rest/1/agreement/{UID}/metadata" but I am struggling to find a way to pass the values from the UID column into this second query, and for it to iterate on the values in that column. 

Any help is greatly appreciated. 

Cheers

[dpjm]

This is perfect. Thank you @mahoneypat 

[mahoneypat · Accepted solution]

You should be able to make the first web call and convert that to a table with a UID column, and then add a custom column with this formula:

= Web.Contents("https://api.concordnow.com/api/rest/1/agreement/{" & [UID] &"}/metadata")

You'll have to figure out authentication using the same approach used in your first call, of course.

Pat