Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/12/2022 12:55 PM
Is there any way to convert date format for account fields mapping - CREATED_ON and LASTLOGONDATE, while importing accounts?
XML Response from REST API:
<CREATION_DATE>2020-04-02T01:01:01Z</CREATION_DATE> <LAST_LOGIN_DATE>2020-04-02T01:01:01Z</LAST_LOGIN_DATE>
Mapping of these 2 fields in ImportAccountEntJSON:
"colsToPropsMap": { "accountID": "USER_ID~#~char", "name": "USER_LOGIN~#~char", "status": "USER_STATUS~#~char", "CREATED_ON": "CREATION_DATE~#~date", "LASTLOGONDATE": "LAST_LOGIN_DATE~#~date",
I have tried 3 datatypes and it doesn't work i.e. accounts created_on field value is empty after accounts import:
1. "CREATED_ON": "CREATION_DATE~#~customDate--yyyy-MM-dd'T'HH:mm:ss'Z'"
2. "CREATED_ON": "CREATION_DATE~#~char"
3. "CREATED_ON": "CREATION_DATE~#~date"
But if I just map it with any customproperty of account using char datatype, it works.
Now my requirement is to map it directly with the out-of-the-box field - create_on. Is it possible please?
Solved! Go to Solution.