Iterative macro for API GET throttling

[BonusCup]

Hi,

I'm having an issue where I'm trying to pass through over the allowed "1000 calls per 5 minutes". I have roughly 2500 records.  Can someone help with an iterative macro that runs through the records and then when the DownloadDate comes back with "{"error":"too_many_requests","message":"You have exceeded your allowed request limit against the api try again later. See the X-Rate-Limit headers for more details"}" use a pause for 8 mins?  8 minutes just to be safe.

I'd then like to union all the results together.  TIA

[abacon · Accepted solution]

@BonusCup Instead of a macro to do this, use the throttling tool to limit the amount of calls per minute to 200, which is 1000 per 5 minutes. If your search throttle in the search bar, the tool will pop up. Place it before the download tool that is performing the api calls.

Note - AMP does not support the throttle tool but I would still recommend. Much easier than the macro route you are looking at.

Bacon

[alexnajm · Accepted solution]

Could you instead just throttle within the  Download Tool? Or use the  Throttle Tool? That way it slows down from the get go and you don't run into this error

[alexnajm]

@abacon beat me to it! 😊

[abacon]

@alexnajm 

[alexnajm]

😂

[BonusCup]

@abacon and @alexnajm of course there's a throttling tool. LOL.  Thanks for pointing me to that, I'm messing around with it now and finding different results per run so I'm messing with the # of records it passes through per minute.  I started with 200 per minute and it only passed through 989 and then I tried 175 per minute and it passed through 1082.

I'm trying 150 records now, hopefully I can find the sweet spot, but this tool is very helpful.