SOAP integration error

[AtrayeeDutta07]

Hi Team,

We are facing an error while trying to import accounts using OOTB SOAP connector using XML APIs.

attaching Request and response from POSTMAN.

Connection JSON:

{
"authentications": {
"login": {
"authType": "basic",
"properties": {
"SOAP_ENDPOINT": "**",
"USERNAME": "**",
"PASSWORD": "**",
"company":"**",
"PASSWORD_TYPE": "PasswordText",
"REQUESTPARAMS": {
"CONTENT-TYPE": "text/xml;charset=UTF-8",
"Connection": "Keep-Alive",
"Keep-Alive": "timeout=600, max=1000"
}
}
}
}
}

Account IMPORT JSON:

{
"CONNECTION": "login",
"REQUESTPARAMS": {
"Content-Type": "application/xml"
},
"REQUESTXML": "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><request API_version=\"1.0\" client=\"ULSB2\" client_ver=\"1.1\" namespace=\"default\" key=\"i6SlzfCtaiWgXIRt9xu3\"><Read type=\"User\" method=\"all\" limit=\"1000\"><_Return><name/><id/><nickname/><external_id/></_Return></Read></request>",
"RESPONSEDATAPATH": "response.Read.children()",
"ACCOUNTMAPPING": "Name:User.@name,accountID:User.@name"
}

getting below error:

I can see other posts are there where developers faced same issue?

Any idea how to resolve this?

Thank you in advance.

Regards,

Atrayee

[rushikeshvartak]

{
    "CONNECTION": "login",
    "REQUESTPARAMS": {
        "Content-Type": "application/xml"
    },
    "REQUESTXML": "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><request API_version=\"1.0\" client=\"ULSB2\" client_ver=\"1.1\" namespace=\"default\" key=\"i6SlzfCtaiWgXIRt9xu3\"><Read type=\"User\" method=\"all\" limit=\"1000\"><_Return><name/><id/><nickname/><external_id/></_Return></Read></request>",
    "RESPONSEDATAPATH": "response.Read.children()",
    "ACCOUNTMAPPING": {
        "Name": "User.@name",
        "accountID": "User.@name"
    }
}

[AtrayeeDutta07]

Hi Rushikesh,

Tried with the above JSON, Still getting the same error.

2024-09-03T18:29:54+05:30-ecm-worker-provisoning.SoapProvisioningService-quartzScheduler_Worker-13-4mvhq-DEBUG-Error parsing parameter ACCOUNTS_IMPORT_JSON:

2024-09-03T18:29:54+05:30-ecm-worker--null-4mvhq--java.lang.NumberFormatException: For input string: "N" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) at java.lang.Integer.parseInt(Integer.java:580) at java.lang.Integer.valueOf(Integer.java:766) at com.saviynt.provisoning.SoapProvisioningService$_initializeConnectionForImport_closure3.doCall(SoapProvisioningService.groovy:420) at com.saviynt.provisoning.SoapProvisioningService.initializeConnectionForImport(SoapProvisioningService.groovy:358) at com.saviynt.provisoning.SoapProvisioningService.doImport(SoapProvisioningService.groovy:123) at com.saviynt.ecm.integration.ExternalConnectionCallService.invokeExternalMethod(ExternalConnectionCallService.groovy:269) at ApplicationDataImportJob.execute(ApplicationDataImportJob.groovy:211) at org.quartz.core.JobRunShell.run(JobRunShell.java:199) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)

2024-09-03T18:29:54+05:30-ecm-worker-provisoning.SoapProvisioningService-quartzScheduler_Worker-13-4mvhq-DEBUG-End Initializing Connection Parameters...

2024-09-03T18:29:54+05:30-ecm-worker-provisoning.SoapProvisioningService-quartzScheduler_Worker-13-4mvhq-DEBUG-Error - Error parsing parameter ACCOUNTS_IMPORT_JSON - For input string: "N"

Regards,

Atrayee

[rushikeshvartak]

Refer sample - https://docs.saviyntcloud.com/bundle/SOAP-v24x/page/Content/Scenarios-for-Implementing-the-Connector...

[SumitMassey]

Hi Rushikesh,

Below is the sample response returned when POST call is invoked using PostMan:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<response>
<Auth status = "0"></Auth >
<Read status = "0">
<User>
<name>User1, Test1</name>
<id>1</id>
<external_id/>
<nickname>User1Test1</nickname>
</User>
<User>
<name>User2, Test2</name>
<id>2</id>
<external_id/>
<nickname>User2Test2</nickname>
</User>
</Read >
</response>

ACCOUNTS_IMPORT_JSON is configured as per the document. Please let us know if you have any insights to this.

Thanks,

Sumit