Icon

Just KNIME It S03 _​ CH12 _​ Getting Brewery Data

Did you know that August 2nd is International Beer Day? To celebrate one of the world’s oldest beverages, you are tasked with retrieving all worldwide brewery data from the OpenBreweryDB REST API, which provides data on the breweries in paginated responses. Build a loop that makes successive requests to each page of the API until all data is retrieved.

Not interested in beer? Feel free to use any API of your choice! Find more public APIs here: https://publicapis.io/

Just KNIME It - Season3 - Challenge 12: Getting Brewery Datahttps://hub.knime.com/-/spaces/-/~rRsCIglAVABa760g/current-state/ JKI S03 CH 12 GET Brewery Data GET JSONmeta query extract meta data fieldsget total number of breweriesextract JSON collection queries to listsungroup listsGET JSONpage query get number of pages (assuming up to 50 breweries per page)one row per page page numberone page per iterationURL pages semi querypage full queriesURL columncolumn clean-up collect datacount breweries by country GET Request JSON Path String To Number JSON Path Ungroup GET Request Math Formula One Row to Many Math Formula Table Row ToVariable Loop Start Table Creator String Manipulation Joiner Column Filter Loop End GroupBy Just KNIME It - Season3 - Challenge 12: Getting Brewery Datahttps://hub.knime.com/-/spaces/-/~rRsCIglAVABa760g/current-state/ JKI S03 CH 12 GET Brewery Data GET JSONmeta query extract meta data fieldsget total number of breweriesextract JSON collection queries to listsungroup listsGET JSONpage query get number of pages (assuming up to 50 breweries per page)one row per page page numberone page per iterationURL pages semi querypage full queriesURL columncolumn clean-up collect datacount breweries by country GET Request JSON Path String To Number JSON Path Ungroup GET Request Math Formula One Row to Many Math Formula Table Row ToVariable Loop Start Table Creator String Manipulation Joiner Column Filter Loop End GroupBy

Nodes

Extensions

Links