Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Method for paging REST API results

GreggD
8 - Asteroid
I have over 30,000 records I need to retrieve via my Rest API call, however my REST API limits the number of records we can return to 1,000 records. SO I need create a paging solution. In a regular procedural language I would use control flow logic like a WHILE loop to control pulling 900 records at a time, until I reach the last record and then stop. Is there a way to accomplish the same thing in Alteryx? Thanks in advance!
13 REPLIES 13
GreggD
8 - Asteroid
Guess I don't have permissions here to attach things. Wonder why.... I see others attach screenshots to their posts. It acts like it was ok with accepting my attachments, however nothing uploads. Any ideas?
GreggD
8 - Asteroid

I my issue with uploading attachments to my post was a browser issue. Apparently you need chrome to upload attachments.
Attached is what my IntefaceDesigner looks like when trying to configure the Iteration Macro.

GreggD
8 - Asteroid

Attached is my workflow.
I am hoping someone can see what I am doing wrong.

 

There appears to be a correlation between my workflow and the Interface Designer, however I don't know what it is. Is there anyone who can help me connect the dots. I just need to understand what Interface Designer is expecting so I can give it what it is looking for.

GreggD
8 - Asteroid

Ok - after a lot of searching I finally found the following video in the Alteryx Academy that helped me to at least get the basics down:

 

https://community.alteryx.com/t5/Videos/Build-Your-First-Iterative-Macro/m-p/55565

 

Labels
Top Solution Authors