Iterative macro for API GET throttling

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

Macros

API

Iterative Macro

Accepted answers

abacon

@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

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

All comments

abacon

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

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 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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703