Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

ImportAccountEntJSON - SUBSTRING in colsToProps Mapping attribute

Saviynt_Savvy
Regular Contributor
Regular Contributor

Hi All, 

In an application, I have the employeeName attribute value as "xyz\jamespaul" and I need to bring it to the Account customproperty 9 as "jamespaul" and need to remove the string before the "\" character.
What is the syntax I should use in the colsToPropsMap to get the substring  after the character "\".

"colsToPropsMap":{
"accountID":"employeeId~#~char",
"name":"employeeName",
"status":"status~#~char",
"customproperty1":"userName~#~char",
"customproperty2":"emplClassCode~#~char",
"customproperty3":"tellerClassCode~#~char",
"customproperty4":"ptid~#~char",
"customproperty5":"status~#~char",
"customproperty6":"networkAcct~#~char",
"customproperty8":"employeeId~#~char",
"customproperty9":"#CONST#${LEFT(employeeName, CHARINDEX('\\\\',employeeName) -1)}~#~char",
"customproperty31":"STORE#ACC#ENT#MAPPINGINFO~#~char"
},

I am getting  the above syntax as same in the Account CustomProperty 9 as shown below:

Saviynt_Savvy_0-1715921514243.png

What is the correct syntax to use?

Thanks & Regards,
SaviyntSavvy

1 REPLY 1

rushikeshvartak
All-Star
All-Star

You need to use java functions


"#CONST#${employeeName.split('\\\\')[0]}~#~char"



Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.