Change Date Format in REST API ImportUserJSON

[Community_User]

Originally posted on September 15 2020 at 07:05 UTC

I am using REST API to import accounts and the date format I am receiving from the API is as follows:

"startDate": "/Date(1597276800000)/",

"endDate": "/Date(253402214400000)/",

How to convert this format to Saviynt date format?

I tried the below approaches but none of them seem to work:

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

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

[Community_User · Accepted solution]

Originally posted on September 16 2020 at 08:05 UTC

Hi Arushi,

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"

}

Thank you

Vedanth B.K

[Community_User]

Originally posted on September 17 2020 at 09:04 UTC

I tried using epochdate as the data type for date but it still did not work.

[Community_User]

Originally posted on September 21 2020 at 08:21 UTC

Hi Arushi,

Please mention the version of SSM.

Thank you

Vedanth B.K

[Community_User]

Originally posted on September 21 2020 at 08:25 UTC

I am using SSM version 5.4.1

[Community_User]

Originally posted on September 25 2020 at 09:51 UTC

Hi Arushi,

The epoch date is supported in the later versions. please raise a ticket for the same.

Thank you

Vedanth B.K