Knime: Accessing a REST API with dynamic query param

Knime: Accessing a REST API with dynamic query param

Nowadays Rest API is the most widely used way to share data, In which many API returns a subset of complete data in form of page. Sometimes we need to append

Nowadays Rest API is the most widely used way to share data, In which many API returns a subset of complete data in form of page.

Sometimes we need to append multiple query param in the URL to get some specific and filtered data.

In this blog, we will learn how to generate dynamic URLs by adding query param and get data.

Knime platform supports Rest interface with Get-Request and Post-Request Node.

Accessing Rest Interface in Knime

Below is the Knime Analytic workflow which include all the Knime Nodes required to access Rest API in this

blog are as below:

Explaining the Configuration of each Node

Table Creator

This node is with default configuration, It read the table from the native Knime format, The Performance is

Counting Loop Start

The Loop Start is the node that starts a loop that is executed a predefined number of times. At the end of the loop you need LoopEnd, which collects the results from all loop iterations. All nodes in between are executed as many times as you specify in the dialog of LoopStart.

In this node configuration we give the number of time the loop will run.

Math Formula

This node evaluates a mathematical expression based on the values in a row or given expression. The computed results can be either appended as a new column or a variable.

In this node we configure the increment on the loop index, in this case, it is increasing by 1.

String Manipulation

This node Manipulates strings like Search and Replace, to Uppercase remove leading and trailing white spaces.

Here this node will append the page number to the fix part of URL

analytics analysis dynamic methods knime restapi data analysis

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Exploratory Data Analysis is a significant part of Data Science

Data science is omnipresent to advanced statistical and machine learning methods. For whatever length of time that there is data to analyse, the need to investigate is obvious.

5 Essential Data Vs You Have to Take Care Of

Who starts good ends even better? I am pretty sure that on your data journey you came across some courses, videos, articles, maybe use cases where someone takes some data.

Tableau Data Analysis Tips and Tricks

Tableau Data Analysis Tips and Tricks. Master the one of the most powerful data analytics tool with some handy shortcut and tricks.

Exploratory Data Analysis

Suppose you are looking to book a flight ticket for a trip of yours. Now, you will not go directly to a specific site and book the first ticket that you see.

What Is Data Analysis?

DISCLAIMER: absolutely subjective point of view, for the official definition check out vocabularies or Wikipedia. And come on, you wouldn’t read an entire article just to get the definition.