API - Iterative Macro - control container - Download tool

[nzp1]

I may be trying to make this program do more than designed.

I have an API that is limited by how many records it can pull at one time so I must use an iterative macro to loop through the process.  If it is ok I want to take out the data and then iterate the offiset  to the next level and then loop around.  This is easy.

However, If it does not give me a 200 OK and it is one of two error messages I want to regenerate access keys and then loop around for the same set of data.

I am attempted to leverage the control containers to only reproduce a key if it fails.  This works fine my issue is I can only connect to one loop and it does not appear to allow me to union the items back together once they pass into the control container.

[PhilipMannering]

Perhaps a simpler solution might be to regenerate the access key every loop (or every nth loop) pre-empting running out of API calls?

[NZP]

There is a limit to how many access codes can be generated within a certain time frame so trying to limit the frequency.

[PhilipMannering]

What is the API? Can you tell from the documentation how many API calls you get per key? With a lot of APIs you can set a parameter to limit on the number of pages or records you want to return.