Help with ACCOUNTS_IMPORT_JSON in SOAP connector?

[johnson]

Hello. I am testing a SOAP connector and have managed to get a successful connection to an open source URL which does not have authentication. I am running a "Accounts Import (Complete) from Database (AccountsImportFullJob)" job to retrieve the sCode and sName from the response listed below but the job keeps failing. 

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<m:ListOfContinentsByNameResponse xmlns:m="http://www.oorsprong.org/websamples.countryinfo">
<m:ListOfContinentsByNameResult>
<m:tContinent>
<m:sCode>AF</m:sCode>
<m:sName>Africa</m:sName>
</m:tContinent>

This is the syntax I have in ACCOUNTS_IMPORT_JSON. Which part of my syntax is incorrect?

{
"REQUESTXML": "<soapenv:Envelope xmlns:soapenv="http://www.w3.org/2003/05/soap-envelope">
<soapenv:Body>
<ListOfContinentsByName xmlns="http://www.oorsprong.org/websamples.countryinfo">
</ListOfContinentsByName>
</soapenv:Body>
</soapenv:Envelope>
",
"REQUESTPARAMS": {
"Content-Type": "text/xml;charset=UTF-8",
"SOAPAction": ""
},
"RESPONSEDATAPATH": "Body.ListOfContinentsByNameResponse.ListOfContinentsByNameResult.tContinent",
"ACCOUNTMAPPING": "Name:@m.sName,accountID:@m.sCode"
}

[rushikeshvartak]

What is error in log? even though its open source you need to add connection1 parameter 

https://saviynt.freshdesk.com/support/solutions/articles/43000505309-soap-connector-guide

[johnson]

I accidentally left out the connection1 parameter, but I have updated the syntax below. I am unable to find an error in the log. I searched for the name of the job and nothing shows up. I only know the job is failing because of the status so it leads me to believe my syntax is wrong.

{
"CONNECTION1": "GenTrackAuthS",
"REQUESTXML1": "<soapenv:Envelope xmlns:soapenv=\ "http://schemas.xmlsoap.org/soap/envelope/\" xmlns:web=\"http://www.oorsprong.org/websamples.countryinfo\">
<soapenv:Header></soapenv:Header>
<soapenv:Body>
<web:ListOfContinentsByName></web:ListOfContinentsByName>
</soapenv:Body>
</soapenv:Envelope>
",
"REQUESTPARAMS1": {
"Content-Type": "text/xml;charset=UTF-8",
"SOAPAction": ""
},
"RESPONSEDATAPATH1": "Body.ListOfContinentsByNameResponse.ListOfContinentsByNameResult.tContinent",
"ACCOUNTMAPPING1": "Name:@m.sName,accountID:@m.sCode"
}

[SB]

You can work with Saviynt Support to get the additional logging enabled for SOAP connector and that might help with the analysis..

[johnson]

Hi Sahil. How do I go about doing this? I submitted a ticket requestioning for additional logging but I am told for v2021 Saviynt doesn't have backend server access and database access....

[johnson]

Is there anyone that can share an example of syntax for the ACCOUNTS_IMPORT_JSON section that worked for them? I am just trying to see what is wrong with my syntax. 

[SB]

Backend and DB access is certainly not doable from 2021 but you should still be able to get the addiotnal logs enabled for your SOAP connection. Would request you to create a ticket with Support and to specify that you need the additional logging enabled for SOAP connector. 

As for the sample, you can refer to our SOAP Guide and under "Creating a Connection" section, you can find the json example.

https://docs.saviyntcloud.com/bundle/SOAP-v2020x/page/Content/Understanding-the-Integration-Between-...