Logo DWBI.org Login / Sign Up
Sign Up
Have Login?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Login
New Account?
Recovery
Go to Login
By continuing you indicate that you agree to Terms of Service and Privacy Policy of the site.
Pentaho Data Integration

Using Pentaho Http Client step

 
Updated on Oct 03, 2020

In this article we will learn how to use Pentaho Data Integration HTTP Client Step. Http Client step is used to send HTTP Requests to web URL's along with optional parameters/arguments and in turn receives the HTTP Response result from the the web methods.

In this article we will be using a free JSON API for foreign exchange rates and currency conversion from fixer. It provides many relevant JSON API and can be accessed via HTTP GET request. So in this use case we want to get the currency conversion rates for various currencies to a base currency, let's say USD.

This is how our sample source data looks like:

Country_Sales.txt

COUNTRY|SALES|CURRENCY
SGP|10000|SGD
IND|125000|INR
AUS|9000|AUD
USA|12000|USD

Please check the self explanatory implementation screenshots as below:

Transformation
Transformation
CSV Input
CSV Input
Add constant values
Add constant values
HTTP Client
HTTP Client
HTTP Client Parameters
HTTP Client Parameters
JSON Input
JSON Input
JSON Input fields
JSON Input fields
Field splitter
Field splitter
Replace in string
Replace in string
Select values Metadata
Select values Metadata
Calculator
Calculator
Select values
Select values
Microsoft Excel output
Microsoft Excel output
Microsoft Excel output Content
Microsoft Excel output Content
Microsoft Excel output Fields
Microsoft Excel output Fields
Execution Result - Preview data
Execution Result - Preview data
PrimeChess

PrimeChess.org

PrimeChess.org makes elite chess training accessible and affordable for everyone. For the past 6 years, we have offered free chess camps for kids in Singapore and India, and during that time, we also observed many average-rated coaches charging far too much for their services.

To change that, we assembled a team of top-rated coaches including International Masters (IM) or coaches with multiple IM or GM norms, to provide online classes starting from $50 per month (8 classes each month + 4 tournaments)

This affordability is only possible if we get more students. This is why it will be very helpful if you could please pass-on this message to others.

Exclucively For Indian Residents: 
Basic - ₹1500
Intermediate- ₹2000
Advanced - ₹2500

Top 10 Articles