Forum Discussion
Resolver ILoop and Combine Web.Contents Query
I am trying to pull data that where I need to set the a 'SiteTag' number. And I have a list of 50 'SiteTag' numbers.
Is there a way that I can loop and combine them all into 1 table? It will be identical columsn with each query.
token = AccessToken,
range = "&BD=1/1/2021&ED=12/31/2021&SiteTag=",
p3286 = Json.Document(Web.Contents(api_base_url & token & range & "3286", [Headers = [#"Authorization"="Bearer "&token,#"Content-Type"="application/json"]])),
p4401 = Json.Document(Web.Contents(api_base_url & token & range & "4401", [Headers = [#"Authorization"="Bearer "&token,#"Content-Type"="application/json"]])),
I have 50+ 'p####' SiteTags to combine.
2 Replies
- amitchandak
Super User
ptmuldoon , refer if this can help
https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78
ptmuldoonThansk for the help and feed back.
I'mnt sure if that article will help as I'm not actually looping pages of website, but querying 50+ separate API calls/URLS to get the JSON data.
But I did find this tutorial in using a custom function, and do have this working. I still need to think the best way I want to generate the list of URLS, but this did help me here.
