Multiple Iteration Criteria

[smoskowitz]

Hi All --

I am working on learning how to build iterative macros as well as API's and have successfully been able to build one that works. I have been using http://www.brewerydb.com/ and getting a list of breweries by year. Kind of fun to do.

So, if a year has 10 pages worth of data for a year (which is a required parameter) I can build a macro that paginates through each of the pages and pull the data. Not a big deal to do for most of you -- but I think I fist pumped when I got it to work.

So, as I stated, I was able to do this for a parameter I entered in the payload tab of the download tool. Now I am getting bold and want to try to figure out how I could start with a year, paginate through all of the information, and once done -- move to another year.

I attached my workflow (removing the API key) but was curious how to iterate through multiple criteria. You can sign up for a free API here: http://www.brewerydb.com/developers/apps. 

If you have any insight, I would greatly appreciate it.

Thanks,

Seth

[Joe_Mako · Accepted solution]

Here are the changes I made:

Added "established" as a field that is passed in the loop, and adjusted the Download tool

Changed the filter to continue the loop as long as either the page is not the last or the year is not the the current

adjusted formula to calculate the page and added calc for established