Get data from SOAP API using Syncfusion Data Integration Platform

Introduction

This ar­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­ticle explains how to get data from SOAP API using Syncfusion Data Integration Platform.

Objective

To get data response using SOAP API and convert that data response in to SQL insert statement and finally store the resultant data in destination SQL server.

Sample used in this article: SOAP_API_sample.xml

Example Dataflow get data from SOAP API

Overview

Prerequisites

Before configuring this workflow, users must know about DBCPConnectionPool in Syncfusion Data Integration Platform. Because, the DBCPConnectionPool is responsible for creating the database connection to perform database operations. Refer to Configure DBCPConnectionPool to configure the DBCPConnectionPool for SQL server.

Note:

To create the required table in target SQL server for the first time, start the following processor.

In properties tab, enter create statement SQL query. Refer to the following screenshot.

List of processors used in workflow:

GenerateFlowFile Processor

This processor will generate the FlowFile for SOAP API request, enter SOAP API body message in the Custom Text property as follows.

Body message used

 
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="http://www.holidaywebservice.com/HolidayService_v2/">
<SOAP-ENV:Body>
<ns1:GetHolidaysAvailable><ns1:countryCode>UnitedStates</ns1:countryCode></ns1:GetHolidaysAvailable>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
 

In Scheduling tab, the Run Schedule value is set as 1 day and this can be changed as desired.

InvokeHTTP processor

This processor fetches the data from SOAP API by entering the value for HTTP method, Remote URL, Content-type, and add new property SOAPAction using Add button as follows.

SOAP API call used

SOAP action method used

• Remove empty spaces in Basic authentication password and Proxy password properties value. 

UpdateAttribute Processor

This processor will add a new attribute to the incoming FlowFile called “mime.type”, which can be added using Add button and enter the value as follows.

SplitXml

This processor will split the incoming XML FlowFile based on the split depth property as shown in the following screenshot.

EvaluateXPath Processor                                                                                                                                                                       

This processor will evaluate the incoming FlowFile based on the destination property and two new properties “code” and “description” is added by using Add button as follows.

ReplaceText Processor

This processor will process the incoming FlowFile with the replacement value entered in the property as follows.

Replacement value used

PutSQL

This processor will execute the incoming insert query value in the SQL server using the JDBC connection pool property as follows.

After completing all the configurations, start the workflow. It will transfer the SOAP API data into target SQL server.