Forum Discussion
Call API 1 day at a time and create/append the data until end date is satisfied. Add 60 sec delay
That's not how delays work, unfortunately. Please read about Function.InvokeAfter . Please note that this is a rather advanced topic, so expect slow going.
Please also thoroughly read the documentation for Web.Contents - PowerQuery M | Microsoft Learn and use the Query parameter.
Sorry for the confusion. This post is about the loop not working. The 61 sec delay is commented out and just is a place holder that I will tackle once the loop is working.
please read both documentations. Refactor your code accordingly. Then we can work on the pagination, and on the delay.
Good morning,
I actually thought you were replying to my most recent post where I simplifed it and got it as close as I could and from what I can see my loop is not iterating otherwise I would get a 429 too mant request error. I can not get it to go to the next day. Once the loop is working I was going to go back and address the 60 second delay between api calls. This seems like a pretty common requirement, I worked through a bunch of youtube videos on looping but their a bit different, so I am reaching out to the community which I only do on ocassion when I am stuck.
Thanks for your help!
I still don't see you applying the documented principles (the Query parameter being the most important one). Happy to help you but you need to bring some effort to this too.