Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

AzureAD "displayName" not mapping in Saviynt account's displayName

Gurukrishna96
New Contributor
New Contributor

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

3 REPLIES 3

NM
Honored Contributor III
Honored Contributor III

@Gurukrishna96 never used emchar in rest connector.. i believe it is not supported..

Hey @NM

What could be a workaround for this error - 
Incorrect string value: '\xF0\x9F\x91\xAC' for column 'DISPLAYNAME' at row 1

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


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.