Forum Discussion
yuvapraveen
5 years agoRegular Visitor
Paginate API POST Response
I am trying to accumulate API response from an URL. Initial response contains three JSON objects 1. events-containing the list that I wanted to accumulate and create a dataset 2. next_page- containin...
mahoneypat
5 years agoMicrosoft Employee
Since you can pass an offset in your web call, please see if the approach demonstrated in this video, using List.Numbers, would be simpler.
Power BI - Tales From The Front - REST APIs - YouTube
Regards,
Pat
yuvapraveen
5 years agoRegular Visitor
mahoneypat thanks for pointing to the link. The API server I am working is slightly different 1. It expects the query parameters in the content (like I mentioned in my code). 2. The subsequent call needs an extra parameter end_time that is within next_page (I am passing the entire json object in next_page for my next calls). Do you have code snippet for such scenario please?