Forum Discussion
seanmkelly
4 years agoRegular Visitor
Loop to Change Start and End Time in API call
I am making an API call, but the call will only return 90 days' worth of data at a time. I've searched for a solution to create a loop to change start and end time in UTC, while appending the data. I keep coming up short.
Anyone have best practice on this?
Thanks in advance!
1 Reply
- Vijay_A_VermaMost Valuable Professional
You can use one of these to introduce paging in your API call
TEXT -
https://www.sumproduct.com/thought/referencing-multi-page-data-from-a-web-site-with-a-single-url
https://datachant.com/2016/06/27/cursor-based-pagination-power-query/
VIDEOS -
https://www.youtube.com/watch?v=vhr4w5G8bRA
https://www.youtube.com/watch?v=05yhwnuCjRw