Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Parse SOAP response contaning CSV result

nutanranee
New Contributor
New Contributor

Hello,

I am trying to achieve a workday SOAP connection. The JSON is fine, however, I am trying to read the CSV result from the SOAP request and cannot do this at the moment. Can someone please help to find out the correct mapping to the headers ?

Using this docuemntation. Understanding the Integration Between EIC and SOAP (saviyntcloud.com)

The JSON format is
{
"CONNECTION1": "CSN",
"REQUESTXML1": "<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" ><soap:Body><sample></sample></soap:Body> </soap:Envelope>",
"COOKIEOPTIONS1": "SAVEFROMRESPONSE",
"REQUESTPARAMS1": {
"Content-Type": "text/xml; charset=utf-8"
},
"RESPONSEDATAPATH1": "Body.dataTransferResponseType.data.dataText",
"RESPONSEMAPPING1": {
"TOKEN": "LoginResult"
},
"USERMAPPING1": {
"USERNAME": "Result 1",
"FIRSTNAME": "Result 2",
"LASTNAME": "Result 3",
"EMAIL": "Result 4",
"StatusKey": "Status"
}
}

TIA.

5 REPLIES 5

Rishi
Saviynt Employee
Saviynt Employee

Hi @nutanranee , we are reviewing this question and testing some options in our internal environment. We will respond shortly.

timchengappa
Saviynt Employee
Saviynt Employee

Hello @nutanranee 

Have you tried removing the numerics in your JOSN? Snip from our documentation below...

The numbering for REQUESTXML (for example, REQUESTXML1), RESPONSEDATAPATH (for example, RESPONSEDATAPATH1), and other constituents of the JSON are for illustration only. You do not require to add a number for them in the JSON for your implementation. 

Thank you for your response Timchengappa. I get your point. 

However, the solution I am looking for is to read the data(cell data in CSV format) fetched from the SOAP response.

How do I read these data in the JSON? Or do we have any other alternative?

TIA

Hi @nutanranee 

Would you please be able to send a screenshot of the API response(from Postman or SOAP UI) so I can better answer your query?

Also, please check if the below doc helps answer your question...
https://docs.saviyntcloud.com/bundle/QAD-v2020x/page/Content/Using-the-SOAP-Connector.htm

This is the response from Postman.

nutanranee_0-1681361724429.png