Hubspot date field sync fail

  • 104Views
  • Last Post 5 weeks ago
3
votes
Niels van Eck posted this 15 July 2022

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.

Order By: Standard | Newest | Votes
0
votes
C.J. Land posted this 15 July 2022

Same here.  I thought it was a FLUKE.  All my objects for Hubspot failed.

1
votes
C.J. Land posted this 15 July 2022

  • Run ID 99110263 - Hubspot DEALS
  • Run ID 99111120 - Hubspot COmpanies
  • Etc.

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']

  • Supported by
  • Andrew Rogencamp
2
votes
Mariia Zaharova posted this 16 July 2022

Dear customers,

 

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.

 

 

Best regards,

Mariia

  • Supported by
  • Andrew Rogencamp
  • clheng heng
1
votes
Diari ARA posted this 16 July 2022

Hi Mariia,

I have the same problem, since yesterday too

 

  • Supported by
  • Andrew Rogencamp
0
votes
Andrew Rogencamp posted this 18 July 2022

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?

0
votes
Diari ARA posted this 5 weeks ago

Hi Mariia,

 

Do you have any news? We can't download data from Hubspot since last Friday

 

Thanks.

0
votes
Mariia Zaharova posted this 5 weeks ago

Hello,
   

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.  

Best regards,

Mariia

Close