Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
04/04/2024
11:40 AM
- last edited on
04/09/2024
10:49 PM
by
Sunil
Hi Team,
We are developing a rest connector and able to successfully authenticate. We have the importacctentjson configured to import the acocunts and could see following error.
Invalid record not processed. Error Message - null |
The debug logs are also enabled and could see following error in logs,
The following are the importacctentjson,
{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "xxxxxxxxxxxxxxxx ",
"httpHeaders":
{
"Authorization": "${access_token}",
"accessToken": "xxxxxxxx"
},
"httpContentType": "application/json",
"httpMethod": "POST"
},
"listField": "status.data",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"colsToPropsMap": {
"accountID": "username~#~char",
"name": "username~#~char",
"displayName": "pin_number~#~char",
"customproperty1": "id~#~char",
"customproperty2": "email~#~char",
"customproperty3": "first_name~#~char",
"customproperty4": "last_name~#~char",
"customproperty5": "timezone~#~char",
"status": "active~#~char",
"customproperty6": "role~#~char",
"customproperty7": "location~#~char",
"customproperty8": "type~#~char",
"customproperty9": "auto_assign~#~char",
"customproperty10": "departments~#~char",
"customproperty11": "status~#~char",
"customproperty12": "groups~#~char"
}
}
},
"entitlementParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Role": {
"entTypeOrder": 1,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "xxxxxxxxxxxxxxxxxxx ",
"httpHeaders":
{
"Authorization": "${access_token}",
"accessToken": "xxxxxxxxx"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "status.data.groups",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "groups~#~char",
"entitlement_value": "groups~#~char"
}
}
}
}
}
},
"acctEntParams": {
"entTypes": {
"Role": {
"entKeyField": "entitlementID",
"acctKeyField": "accountID",
"call": {
"call1": {
"processingType": "http",
"connection": "acctAuth",
"callOrder": 0,
"stageNumber": 0,
"http": {
"httpHeaders":
{
"Authorization": "${access_token}",
"accessToken": "xxxxxxxxx"
},
"url": "xxxxxxxxxxxxxxx",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "status.data.groups",
"acctIdPath": "username",
"entIdPath": "groups",
"colsToPropsMap": {
"uuid": "sys_id~#~char"
}
}
}
}
}
}
}
}
The response from the postman is below,
I see the error is because of the special characters in department field,
the postman response for department is
How do we ignore the special characters while accounts & access import? we don't need it to be replaced because while creating the accounts we need to pass the exact department names.
[This post has been edited by a Moderator to merge two posts.]
I even tried using but still same error
cleanUpTextContent": true,
[This post has been edited by a Moderator to remove sensitive information.]
04/04/2024 04:53 PM
Does your import work if you remove the department field from your mapping?
04/04/2024 08:47 PM
It seems you have issue with department attribute which contains & as special characters.
04/05/2024 07:43 AM
Yes Rushi, How do we handle the special characters in import? We don't want to clear or replace the special character as we need to pass the exact department name with "&" while creating an account or else the create account will fail.
04/09/2024 07:52 PM
Use emchar instead of char data type
04/10/2024 09:51 AM
Still we are seeing the same issue.
04/10/2024 07:28 PM
use CONST to replace & from response
Refer samples https://docs.saviyntcloud.com/bundle/Dev-Handbook-REST-v24x/page/Content/Developers-Handbook.htm