Using web services a practical example

Based on customer feedback, the latest version of Advanced ETL Processor now includes support for web services.

What Are Web Services?

Web services provide a way for applications to communicate with web servers. The application sends a request in XML format and receives a response in XML.

For example, a web service can be used to:

  • Convert Fahrenheit to Celsius
  • Retrieve the latest currency exchange rates

Many modern platforms, such as eBay and Amazon, use web services as standard APIs for developers.

Converting Fahrenheit to Celsius

To communicate with a temperature conversion web service, we need to dynamically build both the HTTP Request Header and the HTTP Request Body.

The easiest way to achieve this is by using the “In Place Replace” transformation function.

Generating the HTTP Request Header

Generating HTTP Request Header

Creating the HTTP Request Body

HTTP Request Body

Configuring the Web Service URL

Web Service URL

Transformation Process

Transformation


For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Posted on November 14, 2025 • 2 min read • 220 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License