Unable to import timestamp to datetime using the new Import API

Developer Support APIs & Integrations
1

I want to import csv using the new import API ( Accounts Dashboard | HubSpot )

before, I created a property “test_timestamp2” with “datetime” as type

Here is example of the csv I am trying to import

email, firstname, test_timestamp2

crmtestimport@crmtest.com, Testingxssx, 1590462184000

Other fields successfully load, however the timestamp failed to load

everything is importing except the timestamp

I tried to use date format “5/26/2020” and it works. However I also want to add hour-minute-second information, not only date.

What format works for import? Why it is not working?

2

after a lot of trials, I found this to work

“5/20/2020 15:52”

wished to found this on documentation so i dont waste my time :disappointed_face:

3

Hey @rendybjunior

Thanks for updating the thread! I’m going to take this feedback and push it onto our Team to ensure we take note and look to improve our documentation.

Thanks!

4

was this every fixed?

5

Seems like that went nowhere @Willson ?