SuccessFactor - Epoch to Human readable date format

[sandeepverma]

Hi All,

We are extracting data from SuccessFactor to Saviynt using the rest connector but we are getting different date formats so due to this we are unable to map it in Saviynt.

So anyone please suggest how can I resolve this during import the user what JSOn line should I use.

Thank you

[Srinivas]

Hi Sandeep

Please use the datatype epochdate when the target date format is in the epoch. The mapping in ImportAccountEntitlementJSON needs to be done as shown in the below example.

example:

  "colsToPropsMap": {

    "accountID": "id~#~char",

    "name": "name~#~char",

    "displayName": "name~#~char",

    "customproperty2": "startDate~#~epochdate"

  }

Hope this Helps!

Regards

Srinivas

[sandeepverma]

Hi Srinivas,

I used ~#~epochdate datatype but it didn't help us.

Thank you

Sandeep

[Srinivas]

Sandeep , could you please try this

"startdate": "new java.text.SimpleDateFormat('yyyy-mm-dd').parse(new java.time.Instant().ofEpochMilli(1287878400000))~#~date",

    "enddate": "new java.text.SimpleDateFormat('yyyy-mm-dd').parse(endDate)~#~date"

Regards

Srinivas