How to Hardcode current date in colsToPropsMap of an import JSON

[VamsheeVazza]

Hi are importing few entitlements that are non requestable but are populated as a dropdown values in an application form. we are not getting status for those entitlements from end system. now when app team deleted some of those in there application. even when we ran the collections we are still seeing the delete entitlements in the drop down.

not sure what is the solution for this. Please suggest if any ideas.

One solution i though is hardcode the current date in one of the update date columns of the entitlements and ad this date filter in the dropdown query only to show lates entitlements. Not sure if this works but want to try.

Tried the below in the import JSON but didnt get anything. Please suggest.

"UPDATEDATE":"#DATE#${date a = sysdate; return a}~#~char"

[rushikeshvartak]

"customproperty30": "#CONST#${new Date(Calendar.getInstance().getTimeInMillis()).format('yyyy-MM-dd hh:mm:ss')}~#~char"

[NM]

Hi @VamsheeVazza , ideally if an entitlement is deleted on application end it should make entitlement inactive on saviynt as well, please share importaccountentjson

[CR]

you can use below also ;

"#CONST#${new Date().format('yyyy-MM-dd')}~#~char"