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

REST Connector - CREATED_ON and LASTLOGONDATE fields are not populated while importing accounts

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on April 2 2020 at 19:39 UTC

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?

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.
Who Me Too'd this topic