Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Using 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" R...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Sorry 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

RegionNamecstEndPoint
Parishttps://127.0.0.1/SalesRegion/Paris
Londonhttps://127.0.0.1/SalesRegion/London
Milanhttps://127.0.0.1/SalesRegion/Milan
Topekahttps://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's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    please post a sample response from one of these urls.