04/10/2023 03:17 AM
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.
04/10/2023 07:07 PM
Hi @nutanranee , we are reviewing this question and testing some options in our internal environment. We will respond shortly.
04/11/2023 02:35 PM
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.
04/11/2023 11:01 PM
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
04/12/2023 11:59 AM
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
04/12/2023 09:56 PM
This is the response from Postman.