Forum Discussion
Call API 1 day at a time and create/append the data until end date is satisfied. Add 60 sec delay
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.
Thanks for replying. I gave it my best shot. This part of power bi I find to be very obscure that is why I usually write a .net console app to handle the complexity. I thought I might be able to do the same thing in Power BI instead of writing an application but I wasn't expecting this. Each one teach one.