Forum Discussion
AdministratorUsing the results of one Web query to hit multiple Web query endpoints
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/
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!!!
6 Replies
- lbendlin
Super User
Convert the list from the first result to a table, then add a custom column that calls the web endpoint for each of the table rows. Combine results as appropriate.
Syndicate_AdminSorry any chance you could elaborate a bit? I can create a custom column that's formatted as a valid endpoint but what do you mean by "call" the endpoing?
So for example I've got a table that looks like this:
tblRegions
RegionName cstEndPoint Paris https://127.0.0.1/SalesRegion/Paris London https://127.0.0.1/SalesRegion/London Milan https://127.0.0.1/SalesRegion/Milan Topeka https://127.0.0.1/SalesRegion/Topeka Calling each of those 4 endpoints will return 4 tables that all use the same schema. But how do I actually call all of these endpoints in a query and how do I Append the results of all these results together into a single table if I have no way of knowing in advance what tblRegions will contain and it could be hundreds of records?
I'm sorry if I'm being really simplistic, I'm still very new to all this.
- lbendlin
please post a sample response from one of these urls.
- Syndicate_Admin
RegionName Field1 Field2 Field3 Paris lorem ipsum dolor Paris sit amet consectetur Paris adipiscing elit sed Formatted in JSON of course. The contents of the table are immaterial, what's important is that I:
1. I have to call a REST API that will give me a list of endpoints I need to query. There is no way to know in advance what these endpoints will be, and there could be hundreds of them. So I can't use hard-coded data sources.
2. Every endpoint will return a table with an identical number of fields, and all the fields are the same name. I need to smash together all these individual tables into one large one.
- lbendlin
See attached for the boilerplate code.
- Syndicate_Admin
Oh wow, thank-you. Will take me some time to digest everything but I really appreciate this so much!
