Connect SOAP API using Azure Data factory

Kota, Kailash 6 Reputation points
2022-02-15T06:44:27.067+00:00

Hello everyone,

I an facing an issue calling a SOAP using ADF. I can make the SOAP API call through the SOAPUI but the same is not working when I am calling it from the ADF pipeline.

Below is the body:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://xmlns.oracle.com/oxp/service/v2">;
<soapenv:Header/>
<soapenv:Body>
<v2:scheduleReport>
<v2:scheduleRequest>
<v2:deliveryChannels>
<v2:ftpOptions>
<!--Zero or more repetitions:-->
<v2:item>
<v2:ftpServerName>xxxxxx</v2:ftpServerName>
<v2:ftpUserName>xxxxx</v2:ftpUserName>
<v2:ftpUserPassword>xxxx</v2:ftpUserPassword>
<v2:remoteFile>xxxxxx</v2:remoteFile>
<v2:sftpOption>1</v2:sftpOption>
</v2:item>
</v2:ftpOptions>
</v2:deliveryChannels>
<v2:reportRequest>
<v2:attributeFormat>csv</v2:attributeFormat>
<v2:parameterNameValues>
<v2:listOfParamNameValues>
<!--Zero or more repetitions:-->
<v2:item>
<v2:name>from_date</v2:name>
<v2:values>
<v2:item>01-03-2022 14:20:01</v2:item>
</v2:values>
</v2:item>
<v2:item>
<v2:name>to_date</v2:name>
<v2:values>
<v2:item>02-03-2022 14:20:01</v2:item>
</v2:values>
</v2:item>
</v2:listOfParamNameValues>
</v2:parameterNameValues>
<v2:reportAbsolutePath>xxxxxx</v2:reportAbsolutePath>
<v2:sizeOfDataChunkDownload>1</v2:sizeOfDataChunkDownload>
</v2:reportRequest>
<v2:userJobName>xxxxxxxxxx</v2:userJobName>
</v2:scheduleRequest>
<v2:userID>xxxxx</v2:userID>
<v2:password>xxxxxxx</v2:password>
</v2:scheduleReport>
</soapenv:Body>
</soapenv:Envelope>

I did check a couple of blogs online using the http protocal but does not seem to work.
Please let me know if there is any process I can follow.

Thanks,
Kailash Kota

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,235 questions
{count} vote

1 answer

Sort by: Most helpful
  1. KeepingItReal 5 Reputation points
    2023-01-16T21:46:58.76+00:00

    Hello @MartinJaffer-MSFT ,

    Just wanted to check on this for solid workarounds. I need to make a post to a SOAP web service API that takes only XML with Azure Data Factory -- a RestAPI is not available. What process should I follow to make this happen? The Sink is a SOAP Webservice which will take Http input with a User ID/Pwd. Should I use DataBricks, an Az Power Shell customization, or Azure Functions? Basically, I'm looking for what MSFT recommends instead of individual developers making it up as they go forward with semi-hacked workarounds.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.