Forum Discussion
ApiTrader
3 years agoFrequent Visitor
How to handle api rate call limit within a function?
With the following step I invoke a function in order to get more details about a record. My API request, based on a Power Automate Flow, is running into some trouble due to the amount of calls. Now I...
- 3 years ago
Hi ApiTrader ,
Sounds like you could use Function.InvokeAfter to delay your requests in accordance with your throttle limit:
https://learn.microsoft.com/en-us/powerquery-m/function-invokeafter
Chris Webb briefly describes its actual usage and an extended enhancement here:
https://blog.crossjoin.co.uk/2015/04/30/using-function-invokeafter-in-power-query/
Pete
BA_Pete
3 years agoSuper User
Hi ApiTrader ,
Sounds like you could use Function.InvokeAfter to delay your requests in accordance with your throttle limit:
https://learn.microsoft.com/en-us/powerquery-m/function-invokeafter
Chris Webb briefly describes its actual usage and an extended enhancement here:
https://blog.crossjoin.co.uk/2015/04/30/using-function-invokeafter-in-power-query/
Pete