Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/06/2022 12:17 AM
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
10/07/2022 03:15 AM
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
10/07/2022 03:20 AM
Hi Srinivas,
I used ~#~epochdate datatype but it didn't help us.
Thank you
Sandeep
10/07/2022 03:29 AM
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