Iterative Macro for API Pagination - Increasing the Looping ???

[suarezr]

I am trying to pull records from an API that is limited to 100 records per request. I am currently able to pull 200 records with the below workflow, but I know the object has at least 5 times that many records.

Is there a setting I need to change in order to loop more than 1 time?

**and is it possible to run the macro workflow in Designer Gallery? I don't have a run option when I upload this.

[alexnajm]

Your Iteration Output seems to be set to the done records, not the new link for pagination - change the "Iteration Output" to the Next URL

This may help as well: Getting Started with Iterative Macros. And yes you can run iterative macros on Gallery 0 the bigger question is if your Server will allow the Download tool: Safe and Semi-safe Run Modes: Blocked Tools, Events, and Data Connectors

[alexnajm · Accepted solution]

This may also help: 11 Steps to Create an Iterative Macro for Paginati... - Alteryx Community

[KGT]

And you won't be able to run the macro by itself when you load it. It will need to be in a workflow and you run the workflow.

[abacon]

@suarezr I would also set the output mode to auto configure by name. That helps allow for slight variances in schema without bombing the workflow.

Bacon