Looping in Alteryx
- 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
I have a spreadsheet of data that I am trying to use to post data to an API endpoint. The endpoint will only accept one JSON file at a time. I current have created Record ID using the Record ID Tool. I have it filtered on record 1 and everything is working. How do I loop through each record and post them one at a time. I was thinking I could try and use the multi row tool but not exactly sure how it would work. Thanks!
Solved! Go to Solution.
- Labels:
- API
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You do not need to filter row by row to pass it to the download tool, the download tool will send each row as one request alone automatically. You just need to be sure that you build your workflow in a way that provides all rows with the same structure that you are providing the 1 row alone and it is working.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for your quick response! When I remove the filter the JSON tool combines all of the records together into 1 JSON file. Screen shot attached in Excel file
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can group by recordID (or whatever field is necessary to make each individual row contain an unique and valid json) inside of the Json build tool:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That did it. Thank you so much for your help!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am glad it worked. Please accept my answer as a solution to the problem.
Thanks.
![](/skins/images/5A278AAD67B5F68761E04A0A1AFFBB3D/responsive_peak/images/icon_anonymous_message.png)