Forum Discussion
API Pagination in JSON Body - How to Access with Power Query in Custom Connector?
Hello, I have built a custom connector to connect to the Vimeo API via OAuth2. Everything is working well, but it appears I need to come up with a solution to deal with pagination, as I am only g...
Vimeo may be throttling your requests. Have you gotten a 429 yet?
Table.GenerateByPage is syntax sugar for List.Generate.
No 429, but I think the payload from this API was particularly large. I was able to filter the fields I want in the query itself, and speed has improved greatly.
Thank you for all of your help with this. I ended up implementing the custom column strategy you mentioned and it works very well. You've been very helpful!