Forum Discussion
Solved
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 co...
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
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