REST Connector - Date format for the value of field in milliseconds

[Community_User]

Originally posted on July 1 2020 at 11:18 UTC

What is the date format for milliseconds value please?

The REST API I'm using to import accounts is returning values of date in milliseconds:

"createdOn": 1592833329826, "lastModifiedOn": 1592833550479,

What configuration should I set for the dateformat in ImportAccountEntJSON please?

"globalSettings": {     "dateFormat": "yyyy-MM-dd'T'HH:mm:ss"   }

[Community_User · Accepted solution]

Originally posted on July 1 2020 at 11:26 UTC

Hello Ramanpreet,

You can try with this below format in your JSON before colsToPropsMap -

"globalSettings": {"dateFormat": "yyyy-MM-dd HH:mm:ss"}

[Community_User]

Originally posted on July 14 2020 at 13:38 UTC

Hi Abir,

It didn't work.

I have tried both date and char as the date format for the fields mappings and the global settings as you have suggested but it didn't work.

"CREATED_ON": "createdOn~#~date"

"CREATED_ON": "createdOn~#~char"