Need to build Iteration Macro to paginate API JSON downloads... I think?

Quick overview:

I have a REST API
I have been successful at obtaining a single JSON object that I then parse into a table. Yay!
I know the total number of pages that my request needs to iterate through.

Problem:

I know how to pass values from other fields into my POST body to get desired results but I don't know how to create a loop to increment my page number until it hits the total pages number.

How do I feed the totalpages number into a loop that would stop at (in this example) 4 API calls that append to one database set?

I'm guessing the Download Tool needs to be in my iteration macro along with passing the totalPages and authentication Token into it.

Can someone briefly describe the general make-up of the iterative macro? I feel I can make it if I knew what tools to use in the process.Thanks!

Macros

API

Download

Accepted answers

BretCarr

First, I want to give serious props to @DiganP for his article that included the only instructions that made iterative/pagination make sense! You can catch his example of the whole thing here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Iterative-API-call-with-pagination-amp-updating-URL/td-p/450057

Here is a picture of my iteration macro:

Here is the setup of the iteration properties in the Interface Designer:

I hope all of this helps someone else out there with undertanding another chunk of how the iteration process works! Good luck!

All comments

BretCarr

Here is a picture of my iteration macro:

Here is the setup of the iteration properties in the Interface Designer:

I hope all of this helps someone else out there with undertanding another chunk of how the iteration process works! Good luck!

BretCarr

I'm just thankful I posted this. I couldn't, for the life of me, get an iteration to work in a new workflow and I had to use my own post to get it to work. 🤣

Ofure_Awonuga

Thanks, this was extremely useful for my project

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703