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,
{
"status": {
"error": "false",
"code": "200",
"type": "Success",
"data": [
{
"id": "1250",
"first_name": "Rome1234",
"last_name": "Johnson123",
"username": "Romson",
"email": "101@domain.com",
"pin_number": "192030",
"timezone": "Europe/Berlin",
"role": "Supervisor",
"location": "Marinette WI",
"type": "Signal",
"auto_assign": "End",
"status": "Active",
"departments": [
"S&C"
],
"groups": [
"30014",
"30140"
]
},
{
"id": "1245",
"first_name": "xxxx",
"last_name": "XXXXX",
"username": "153575",
"email": "xxxx.xxxxx@domain.com",
"pin_number": "153575",
"timezone": "America/New_York",
"role": "Employee",
"location": "100",
"type": "Tower Operators",
"auto_assign": "Both",
"status": "Active",
"departments": [
"Dispatch"
],
"groups": [
"Bridge Tenders & Tower Operators"
]
},
The attributes mapping are done correctly in the JSON but still looking the error.
Attaching are the JSON * logs for reference.
Any inputs would be really helpful.
Following is the account correlation rule & account name rule
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.]
