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
To do

Transformation

CSV Input

Add constant values

HTTP Client

HTTP Client Parameters

JSON Input

JSON Input fields

Field splitter

Replace in string

Select values Metadata

Calculator

Selectvalues

Microsoft Excel output

Microsoft Excel output content

Microsoft Excel output fields

Execution result preview