This article explains how to get data from SOAP API using Syncfusion Data Integration Platform.
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.
Example Dataflow get data from SOAP API
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 to configure the DBCPConnectionPool for SQL server.
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:
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
In Scheduling tab, the Run Schedule value is set as 1 day and this can be changed as desired.
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
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.
This processor will split the incoming XML FlowFile based on the split depth property as shown in the following screenshot.
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.
This processor will process the incoming FlowFile with the replacement value entered in the property as follows.
Replacement value used
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.
This page will automatically be redirected to the sign-in page in 10 seconds.