Forum Discussion
API call for each record of another API call
Hi everyone,
I'm working with an API that let me
- Retrieve all contacts within a list.
- Retrieve all email messages for a specific contact.
I need to extract all email messages for all the contacts identified in my first API call. The first call will provide me with the contact ID I need for the second call. It involved I'll need to make a call for each record returned in the first place.
Is there a way I can do this in Power Query and does it make sense in terms of performance?
Regards
Yes. Add a custom column in your first query and do Web.Contents("your url" & [ColumnFromFirstWebCall]), where you concatenate the column with the rest of your url.
Pat
3 Replies
Performance will depend on how many there are but it can be done within the query editor. Just make your first API call, expand that to a table and transform as needed, and then add a custom column that uses the contact column in the second API call fo reach row.
Pat
Hi Pat,
Thank you for your answer. I must say I'm still new to Power Query and I'm not sure how to dot it. Should I add custom column in the first query and then add the second API call in that column?
Yes. Add a custom column in your first query and do Web.Contents("your url" & [ColumnFromFirstWebCall]), where you concatenate the column with the rest of your url.
Pat
