Help with ACCOUNTS_IMPORT_JSON in SOAP connector?

[Sandeep]

Hello, need assistance in building Accounts_Import_Json for retrieving Accounts and Account -entitlement mapping in single call.

Here is the sample response from Postman:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">

    <s:Body>

        <GetUserRoleAssignmentsResponse xmlns="http://tempuri.org/">

            <GetUserRoleAssignmentsResult xmlns:a="http://schemas.datacontract.org/2004/07/Mar.End.RA.Common.Interfaces.UserAccessManagement" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

                <a:StatusMessage>Number of users not found in Active Directory: 2. Number of active users: 883.</a:StatusMessage>

                <a:UserRoleAssignments>

                    <a:UserRoleEntity>

                        <a:User>T-J36</a:User>

                        <a:Roles xmlns:b="http://schemas.microsoft.com/2003/10/Serialization/Arrays">

                            <b:string>Risk</b:string>

                        </a:Roles>

                    </a:UserRoleEntity>

                    <a:UserRoleEntity>

                        <a:User>T-7Q3</a:User>

                        <a:Roles xmlns:b="http://schemas.microsoft.com/2003/10/Serialization/Arrays">

                            <b:string>Security</b:string>

                        </a:Roles>

                    </a:UserRoleEntity>

                    <a:UserRoleEntity>

                        <a:User>T-U1W</a:User>

                        <a:Roles xmlns:b="http://schemas.microsoft.com/2003/10/Serialization/Arrays">

                            <b:string>Financial Approval Authority</b:string>

                            <b:string>Contract Management - SDP</b:string>

                        </a:Roles>

                    </a:UserRoleEntity>

[SB]

You can refer the SOAP Documentation on examples of JSON construction.'

https://docs.saviyntcloud.com/bundle/SOAP-v23x/page/Content/Examples-for-SOAP-API-Request-and-Respon...

[Sandeep]

Tried with below JSON but getting error - "Error parsing parameter ACCOUNTS_IMPORT_JSON:
java.lang.NumberFormatException: For input string: "N""

ACCOUNTS_IMPORT_JSON:

{
"CONNECTION": "accountsImport",
"REQUESTXML": "***********************************",
"REQUESTPARAMS": {
"Content-Type": "text/xml",
"SOAPAction": "***************************************"},
"RESPONSEDATAPATH": "Body.GetUserRoleAssignmentsResponse.GetUserRoleAssignmentsResult.UserRoleAssignments.UserRoleEntity.children()",
"ACCOUNTMAPPING": "Name:@User,accountID:@User",
"ENTITLEMENTMAPPING": {
"Roles": "@Roles.string"
}
}

[Sandeep]

Can someone assist me on this??

[SB]

There appears to be an issue with your JSON format. You can follow the below documentation for sample format and fix it accordingly.

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

[Sandeep]

Thanks for the response Sahil. I referenced Scenario 9 from the link you sent, which is Accounts & Entitlements in Single call but still getting same error. Here is the JSON i tried with:

{
"CONNECTION": "accountsImport",

"REQUESTTYPE":"EACHACCOUNT",
"RECONCILIATIONFIELD":"NAME",

"REQUESTXML": "***********************************",
"REQUESTPARAMS": {
"Content-Type": "text/xml",
"SOAPAction": "***************************************"},
"RESPONSEDATAPATH": "Body.GetUserRoleAssignmentsResponse.GetUserRoleAssignmentsResult.UserRoleAssignments.UserRoleEntity.children()",
"ACCOUNTMAPPING": "Name:@User,accountID:@User",
"ENTITLEMENTMAPPING": {
"Roles": "@Roles.string"
}
}

Error:

[quartzScheduler_Worker-3] DEBUG provisoning.SoapProvisioningService - Error parsing parameter ACCOUNTS_IMPORT_JSON:
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:396)
at com.saviynt.provisoning.SoapProvisioningService.initializeConnectionForImport(SoapProvisioningService.groovy:334)
at com.saviynt.provisoning.SoapProvisioningService.doImport(SoapProvisioningService.groovy:107)
at com.saviynt.ecm.integration.ExternalConnectionCallService.invokeExternalMethod(ExternalConnectionCallService.groovy:224)
at SapImportJob.execute(SapImportJob.groovy:109)
at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
2023-11-07 21:41:46,747 [quartzScheduler_Worker-3] DEBUG provisoning.SoapProvisioningService - End Initializing Connection Parameters...
2023-11-07 21:41:46,747 [quartzScheduler_Worker-3] DEBUG provisoning.SoapProvisioningService - Error - Error parsing parameter ACCOUNTS_IMPORT_JSON - For input string: "N"
2023-11-07 21:41:46,751 [quartzScheduler_Worker-3] DEBUG provisoning.SoapProvisioningService - Dropping temp tables

[SB]

Can you share the complete log file once of the job run time. Also, can you confirm if you re able to make the call from SOAP UI. Can you also share the dump of the call from SOAP UI

[Sandeep]

Here you go -