Really big timestamp values in property history for "Marketing emails opened"

In one of our portals, we are having errors with our integration because it’s not able to parse the timestamps under the property history for “Marketing emails opened”. In other words, if I pull up a contact and look at properties.hs_email_open.versions[0].timestamp, I see that the value is 1.449E+18!

In the HubSpot UI, it does look like it is showing “Invalid date” for the timestamp:

What could be causing these large timestamps to appear in the property history for our contacts?

The HUB ID is 164454 and one such contact has VID 1002315; you will see the large timestamps if you look at the history for the hs_email_open property.

Hi, @arickp1.

Thanks for reporting this and including so much detail.

I haven’t been able to reproduce the issue in my own account, but I do see that the timestamp values on the back end are incorrect.

Do you have any other examples you could share? Have you encountered this behavior in any other accounts?

Hi @IsaacTakushi !

I’ve only seen the issue in this portal. Here are all the VIDs that have caused my JSON parser to blow up with the “timestamp value too big to parse” error:

2245209264364431967941002315

Thanks so much, @arickp1.

I’ll dig into this further with my team and notify you of signficant developments!

Hi, @arickp1.

Apologies for the delayed response. The team is still looking into this behavior.

Hi, @arickp1.

Thanks for your patience. The team was finally able to push a fix for this! Those nanosecond timestamps should now be millisecond timestamps.

Please let me know if you see any lingering issues.