Forum Discussion
Solved
Delay an API call from a custom column
I have an API that has a rate limit of one call per second. I'm using a custom column and add the following code below. The actual quaery is in Column 1. How do I add a delay to avoid the rate limit...
Yes! That video is it. Final conditional column code works out to be what I have below, with the missing URL data in Column 2 (for reference for anyone in the future):
= Function.InvokeAfter(()=> Json.Document(Web.Contents("https://api.xxxxxxxx.com/search/articles.json?q=" & [Column2] & "&api_key=xxxxxxxx")),#duration(0,0,0,1))
