Workday RaaS - ModifyuserdataJSON

[ejeong]

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 

RaaS Connection

I can't find "modifyuserdataJSON" in this connection

[ejeong]

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", ?

[rushikeshvartak]

Add MODIFYUSERDATAJSON in Connection Type

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

USER_IMPORT_MAPPING is used to map saviynt vs workday attribute