Forum Discussion
DBATTIN
5 years agoFrequent Visitor
Getting Paginated Data from REST API
I am attempting to get data from a RST API where the number of records is limited to 1,000 records. The data ia paginated. I have the following script but I still only get 1,000 records let Sou...
mahoneypat
5 years agoMicrosoft Employee
Please see this video for how to leverage the offset approach in an easier way.
Power BI - Tales From The Front - REST APIs - YouTube
Pat
- DBATTIN5 years agoFrequent Visitor
Whilst this returns data it keeps calling the same data from the API
The site is telling me I need to include the NEXT call in the script to get the next page of data but I am unsure how to incorporate this in to your solution
Their response was - Paginated requests will include two extra response headers; X-Total-Count (the total number of results), and Link (containing one or more hypermedia link relations