Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/11/2024 01:57 AM - edited 10/11/2024 01:59 AM
Hi All,
We are using a REST connection for Azure AD account import and we are able to import all attributes in Saviynt except for displayName.
Using 'char' in displayName was failing with the error - Incorrect string value: '\xF0\x9F\x91\xAC' for column 'DISPLAYNAME' at row 1, so we updated the mapping with 'emchar'. The account import job is not failing anymore but it is not mapping displayName in Saviynt.
In logs, I am able to see API response bringing displayName but it is not getting stored in Saviynt account attribute.
"colsToPropsMap": {
"accountID": "id~#~char",
"name": "userPrincipalName~#~char",
"displayname": "displayName~#~emchar",
"customproperty10": "employeeId~#~char",
"customproperty1": "givenName~#~char",
"customproperty2": "surname~#~char",
"customproperty3": "mail~#~char",
"customproperty4": "accountEnabled~#~char",
"status": "accountEnabled~#~char"
},
Please let me know for more info or any suggestions on this
10/11/2024 02:34 AM
@Gurukrishna96 never used emchar in rest connector.. i believe it is not supported..
10/11/2024 04:40 AM
Hey @NM
What could be a workaround for this error -
Incorrect string value: '\xF0\x9F\x91\xAC' for column 'DISPLAYNAME' at row 1
10/11/2024 08:30 AM
You need to take export from Azure AD of all groups and find which groups contains emoji and remove manually. Third party emoji are not supported
https://ideas.saviynt.com/ideas/EIC-I-5080