I'm trying to use the results of one web query to run a series of web queries, and ideally append all the results. Here is the general scenario:
Web endpoint: "https://127.0.0.1/SalesRegions"
Returns: "London, Paris, New York, Tokyo" ... up to X results. Could be hundreds.
Web endpoint: "https://127.0.0.1/SalesRegion/<RegionName>"
<RegionName> is the list of results from the previous query. There could be 1 to hundreds of endpoints we need to hit.
Returns: A list of rows and columns. For example "SaleDate, Price, Item"
So I'm essentially looking for two steps. Firstly how do I use the results of the first query to run multiple subsequent queries. I understand how to do it if the Sales Regions are known in advance -- just create a bunch of static queries. But I have no way of knowing what the first query will return and it could be hundreds of endpoints.
The second step is simply how to append all of these query results into one table, when the total number of queries isn't known in advance.
TIA if anyone can help at all!!!
