ImportAccountEntJSON - Exception in converting responseText to Map

[JoshuaLawrence]

We are trying to simply import account guid's with the response in the following format:

{

    "Rsp": {

        "Status": "Ok",

        "Result": [

            {

                "Guid": "36165265-7a83-4619-88fa-00003a9f96a9"

            },

            {

                "Guid": "fbcf528a-ec96-4c04-be35-0000f48e0375"

            },

            {

                "Guid": "19ab5877-d7a3-4681-b0a3-0004cd232fe8"

            },

      ]

    }

}

Currently our ImportAccountEntJSON is:

{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "<url>",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "text/json"
},
"httpContentType": "text/json",
"httpMethod": "GET",
"httpParams": {},
"successResponses": {
"statusCode": [
200
]
},
"unsuccessResponses": {
"statusCode": [
400,
401,
404,
405,
500
]
}
},
"listField": "Rsp.Result",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "Guid~#~char"
}
}
}
}
}

These are the application logs:

3-02-21/19:59:12.541 [{}] [quartzScheduler_Worker-4] DEBUG rest.RestProvisioningService - pullObjectsByRest - responseStatusCode ::200
2023-02-21/19:59:12.541 [{}] [quartzScheduler_Worker-4] DEBUG rest.RestProvisioningService - Exception in converting responseText to Map
2023-02-21/19:59:12.542 [{}] [quartzScheduler_Worker-4] DEBUG rest.RestProvisioningService - Entered getResponseHeaders method
2023-02-21/19:59:12.542 [{}] [quartzScheduler_Worker-4] DEBUG rest.RestProvisioningService - responseError : null
2023-02-21/19:59:12.542 [{}] [quartzScheduler_Worker-4] DEBUG rest.RestProvisioningService - isAuthError: false
2023-02-21/19:59:12.542 [{}] [quartzScheduler_Worker-4] DEBUG rest.RestProvisioningService - pullObjectsByRest - responseMap.size : 0
2023-02-21/19:59:12.542 [{}] [quartzScheduler_Worker-4] DEBUG rest.RestProvisioningService - pullObjectsByRest - objectList.size : null
2023-02-21/19:59:12.542 [{}] [quartzScheduler_Worker-4] DEBUG rest.RestProvisioningService - Inside importAccountsFull:persistAccounts, pptTypeSep : ~#~
2023-02-21/19:59:12.568 [{}] [quartzScheduler_Worker-4] DEBUG services.ImportUtilityService - Entered markStatusBasedOnThreshold
2023-02-21/19:59:12.568 [{}] [quartzScheduler_Worker-4] DEBUG services.ImportUtilityService - statusAndThresholdConfig is empty
2023-02-21/19:59:12.568 [{}] [quartzScheduler_Worker-4] DEBUG rest.RestProvisioningService - Mapping Users to accounts.

Looking at the logs it seems like we are able to get a response but something goes wrong while parsing the data. Just wondering if there are any solutions to this, thanks.

[SB]

Can you update the list filed and use "listField": "Result" instead.

[JoshuaLawrence]

I tried updating "listField" to "Result" but still get the same error in the logs. 

Thanks,

Josh

[SB]

This will require; to check for the response you are receiving in the logs for the api call. Based on the response we need to check the json. Can you create FD ticket so the support team can check this further.

[JoshuaLawrence]

Yes I created a ticket last week, here is the link: https://saviynt.freshdesk.com/support/tickets/1600947

Thanks,

Josh

[SB]

You can work further with the support team on the issue over the FD. Please ensure to attach the complete log file over the FD so the team can check.

[SB · Accepted solution]

Adding a note here. The issue was fixed after adding cleanUpTextContent in Connection JSON.

with "httpContentType": "application/json",

https://docs.saviyntcloud.com/bundle/REST-v55x/page/Content/Developers-Handbook.htm