Since yesterday suddenly our Hubspot replication fails because of an incorrect date format. The error we got is '1452470400000' was not recognized as a valid DateTime. Before yesterday the date was saved in the DD-MM-YYYY format. I hope this can be fixed as soon as possible. If there is anything we can do please let me know.
Hubspot date field sync fail
- Last Post 21 July 2022
- Run ID 99110263 - Hubspot DEALS
- Run ID 99111120 - Hubspot COmpanies
My Message read: (Added some X's here)
'XXXX584000000' was not recognized as a valid DateTime: [Table: "Companies", Column: "XXXX Some Date Field", Id: 'XXXXX4469']
Thank you for contacting us.
We have reproduced this issue and created a request for our developers to investigate the issue with a high priority.
We will contact you as soon as the issue is fixed.
If you can let us know when this is fixed. Only just started using the integration today. Did this work before today? I thought Hubsoit always exported dates in epoch mode?
We would like to inform you that we updated Skyvia with the fix today. The issue was related to recent changes in HubSpot API in regards to retrieving Date values. Currently, dates are returned from HubSpot in both formats: 'YYYY-MM-DD' and a Unix one (1598227200000).
Please check and let us know the results.