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

Workday RaaS - ModifyuserdataJSON

ejeong
Valued Contributor
Valued Contributor

Hello,

 

We have two type of workday import 

SOAP - termination and future hire import

RaaS - update for all active users from Workday (as of effective date = today)

We are creating AD displayname using "modifyUserdataJSON" in SOAP connection but when user is updated by RaaS,  I can't find JSON to implement to generate the displayname.. 

"UPDATE NEWUSERDATA SET CUSTOMPROPERTY17 = CASE WHEN CUSTOMPROPERTY6 LIKE '%Manager%' THEN CONCAT(PREFEREDFIRSTNAME,' ',LASTNAME,' ','[',CUSTOMPROPERTY18,']') ELSE CONCAT(PREFEREDFIRSTNAME,' ',LASTNAME,' ','[',CUSTOMPROPERTY13,']') END",

SOAP connection 

ejeong_0-1661219665308.png

RaaS Connection

I can't find "modifyuserdataJSON" in this connection

ejeong_1-1661219692637.png

 

2 REPLIES 2

ejeong
Valued Contributor
Valued Contributor

can we apply expression in "USER_IMPORT_MAPPING" ? If so , could anyone let me know how to implement "UPDATE NEWUSERDATA SET CUSTOMPROPERTY17 = CASE WHEN CUSTOMPROPERTY6 LIKE '%Manager%' THEN CONCAT(PREFEREDFIRSTNAME,' ',LASTNAME,' ','[',CUSTOMPROPERTY18,']') ELSE CONCAT(PREFEREDFIRSTNAME,' ',LASTNAME,' ','[',CUSTOMPROPERTY13,']') END", ?

Add MODIFYUSERDATAJSON in Connection Type

rushikeshvartak_0-1661226968601.png

 

 

https://saviynt.freshdesk.com/support/solutions/articles/43000618934-workday-connector-guide-2-0 

USER_IMPORT_MAPPING is used to map saviynt vs workday attribute


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