Loop through multiple pages in API using power query

[Anonymous]

Hi, 
I am trying to loop through multiple rows,
for example each request gives data of 1 agent, PFB
https://vcc-na8.8x8.com/api/stats/agents/{agent-id}/activities?d=2022-12-1&n={offset}
I want to loop through all agent id's at once. i know next steps like creating a duplicate table and custom invoke function etc.
but problem is creating the function out of the above URL,
Currently im trying to do this and it shows error,

Source = Xml.Tables(Web.Contents("https://vcc-na8.8x8.com",
[RelatedPath = "/api/stats/agents/"&(agent_id)&"/"activities?d=2021-12-1&n=1])),

Thanks,
saad.


 

[mahoneypat]

A few things that seem incorrect:

• It is RelativePath, not RelatedPath
• The " after the / seems incorrect. Probably should be at the end.
• The () around the agentid seems incorrect. Try without those.

Also, are you able to do it with a hard-coded value for agent id for to confirm your syntax is correct, before you start passing parameters into it?

[RelativePath = "/api/stats/agents/"&agent_id&"/activities?d=2021-12-1&n=1"])),

Pat