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

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.

Gallery

API

Iterative Macro

Accepted answers

alexnajm

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

All comments

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

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703