Method for paging REST API results
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Solved! Go to Solution.
- Labels:
- API
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@GreggD This article posted earlier talks about this, please take a look!
You would have to use the iteration macro. You have to use the Interface Designer to set the loop. Part of the look will be the results and the 2nd part would be to create a string of the next url. Attached is a sample workflow that I like to show to clients around this use case.
Alteryx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Greg, you can change the version of the workflows by right clicking the yxmd files (after unpackaging the yxzp) and editing with a text editor like Notepad or Notepad++. Then change the yxmdVer on the second line to 2018.4 and save the file. You will need to turn the process into either an Iterative Macro or a Batch Macro to download the data from each of the pages. Check out the link to the article that Digan included in his previous reply!
Cady
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No problem! The yxzp is an Alteryx packaged workflow similar to a zip. Save the yxzp somewhere in your documents so that it's not in your downloads folder. When you open it, it should open in Alteryx and ask you a few questions - you can just hit yes, Import, yes, etc. Then you'll probably see the message that it was created in a newer version Alteryx. That's okay. Go back to the folder where you saved the yxzp and you will see a new folder in there that contains the workflows and contents. There you can change the workflow version of the .yxmd and you will need to open the macros folder and update the macro Web Scraping.yxmc version as well.
Then you can open the yxmd and run the example. Since it does include the Macro - you can open it to look at how it's made by right clicking on the Web Scraping macro in the workflow and choosing Open Macro.
I just updated the versions to 2018.4 for you in this attachment so you should be able to open it now.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@GreggD Attached is the macro with 2018.4 version changed! Let me know if this works!
Alteryx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
