Forum Discussion
Passing multiple query results into new query
Scenario;
I have a WEB API call that passes back info about a group of items. In that dataset it contains the UID for the individual items. I then need to use the individual UID to create a new WEB API call for each item. This part will be dynamic as the list of items will change. After that I need to merge/append the queries for my final dataset. Is this possible? Below is the step by step need. The order is sensitive since each part is dependant on the previous to have data.
1. Query Group Data
2. Extract Column with content UID
3. Create new queries dependant on number of group items returned
4. Merge/Append queries from 3
5. Apply
Because of security rules in my company I cant share data set or queries.
This is doable. Do you first query, get to the list of IDs, convert it to a table (if needed) with the ID column as text, and then concatenate the ID into a custom column with = Web.Contents("start of url" & [ID] & "rest of url if needed"). You should get a Table in each row; expand that column to combine all the data.
Pat
1 Reply
This is doable. Do you first query, get to the list of IDs, convert it to a table (if needed) with the ID column as text, and then concatenate the ID into a custom column with = Web.Contents("start of url" & [ID] & "rest of url if needed"). You should get a Table in each row; expand that column to combine all the data.
Pat