Icon

JKISeason3-12_​tark(2)

Challenge 12: Getting Brewery Data

Description: 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/

Author: Lada Rudnitckaia

Get MetadataCalculatethe num of iteration of the loopCurrentPagecreate urlGet dataper_page50>200Node 22latitudes, longitudeslatitudes, longitudes-> remove rowcategoryNode 2126Node 2127GET Request JSON Path Ungroup JSON to Table Table Rowto Variable Math Formula String to Number Counting Loop Start Math Formula(Variable) String Manipulation(Variable) GET Request Loop End ConstantValue Column Lat/Lon to Geometry String to Number Missing Value Table Creator Joiner Column Aggregator Component Get MetadataCalculatethe num of iteration of the loopCurrentPagecreate urlGet dataper_page50>200Node 22latitudes, longitudeslatitudes, longitudes-> remove rowcategoryNode 2126Node 2127GET Request JSON Path Ungroup JSON to Table Table Rowto Variable Math Formula String to Number Counting Loop Start Math Formula(Variable) String Manipulation(Variable) GET Request Loop End ConstantValue Column Lat/Lon to Geometry String to Number Missing Value Table Creator Joiner Column Aggregator Component

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: TA
Created at: 2024-08-03
On NodePit since: 2024-08-10
Last update: 2024-09-16
Created with KNIME version: v5.2.2
Tags: JKISeason3-12

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!