Forum Discussion

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

Loading data from dynamic URLs

Good afternoon I have 5 URLs (webservices) where in the URL, ONLY the ID (1, 3, 5, 7, 10) and the year changes. The tables of the 5 URLs that contain the data are exactly the same, only the id and t...
mh2587's avatar
mh2587
Icon for Super User rankSuper User
4 years ago

Get the Data from all the sources then combine the data in one query 

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

Thank you for your reply.

Does it refer to the Power Query Editor button \ "Merge Queries" or "Append Queries" ???

I understand that it refers to loading 5 times data from the 5 different URLs

http://11.12.13.14:5000/api/arbol/1/arbol_process/?year=2021

http://11.12.13.14:5000/api/arbol/2/arbol_process/?year=2021

http://11.12.13.14:5000/api/arbol/3/arbol_process/?year=2021

http://11.12.13.14:5000/api/arbol/4/arbol_process/?year=2021

http://11.12.13.14:5000/api/arbol/5/arbol_process/?year=2021

And then?

- Clean all data from the 5 tables?

- Consolidate the resulting table with a single query?

Thanks a lot