topic Re: Hubspot & Zapier - Meeting Engagement Showing Wrong Duration in APIs & Integrations

Hubspot & Zapier - Meeting Engagement Showing Wrong Duration

ChrisEldridge — Tue, 25 Jun 2019 15:03:29 GMT

Hello, we are using your API via Zapier to create Meeting Engagements on contacts whenever someone books a call through Calendly which is what we use for meeting schedules.

The times are correct on the contact and the engagement, but the "Duration" is incorrect. They are all showing as 15 Minutes instead of what should be 30 minutes (1:00-1:30)

Here is the meeting on the contact record: https://cl.ly/2be1b3b03b57

Here is the meeting on Google Calendar: https://cl.ly/3c21347615e1

Here is the jQuery I got from Hubspot support which shows the two EPOC timestamps in the meta data reflecting 1:00-1:30.

https://cdnp.hubspot.net/hubfs/53/2019-06-25%2015_40_53-3925488%20engagements%20for%20contact%2033560301.png?Expires=1561477270&Signature=XYgOzSlHNfS2ylXtsRkO3m5ioIMsBrehCOQk60r8m0mqtA8zAdD2Q0RmwR4IwRbHzuUExZp8d3vWXlVr47cJxsnEyy~hpVBOneVorxwIiyYot53Y6N1wg5WMkrNK0Slc-lN60wGal6wIa~tg3VTf-svxWdRS6mHw8USG8EkdRQNmc6LOTHJ0mgJh87xdS2tWVzu77ac8DLdqBIcWRYPhQGmex7zxZW1vic6gzVEdFV8Ln1vnJxVMfwEdsimRK8LVoEI4blq6rpwMPp4cQxfo6PKV83NmjWFcJxaBJPRxzy7sNpBusGtufBllkB8rCR8Tvh1QRIETMM~fcRzGt8ry~w__&Key-Pair-Id=APKAJDNICOKANPHVCSBQ

Zapier only asks for the start time and the end time.

Re: Hubspot & Zapier - Meeting Engagement Showing Wrong Duration

IsaacTakushi — Wed, 26 Jun 2019 12:58:20 GMT

Welcome, @ChrisEldridge.

I'm happy to help, however I'm getting a 404 from that hubfs link.

To clarify, are these meeting engagements showing the correct times in the back end JSON, but not under "Duration" on the front end?

Could you share the support ticket number and perhaps a link to a contact record with an inaccurate engagement? I looked through your accounts but didn't see any open tickets citing this issue. I'd like to review my colleague's notes and continue digging for you.

Re: Hubspot & Zapier - Meeting Engagement Showing Wrong Duration

ChrisEldridge — Wed, 26 Jun 2019 14:18:47 GMT

Hello @IsaacTakushi

Here is the ticket number: 2553136

Here is an example contact: https://app.hubspot.com/contacts/3925488/contact/33560301

Correct, the meeting times in the jQuery Hubspot provided me in a screenshot are correct 1:00 and 1:30 however the duration is showing incorrectly on the engagement. Its showing 15 Minutes when it should be 30 minutes.

Re: Hubspot & Zapier - Meeting Engagement Showing Wrong Duration

IsaacTakushi — Wed, 26 Jun 2019 14:59:51 GMT

Hi, @ChrisEldridge.

Thanks for sharing that information. I'll close the loop with Steve.

I created a few MEETING engagements in my own account and the "Duration" correctly reflected the difference between the startTime and endTime I defined.

For example, this payload:

{
    "engagement": {
        "active": true,
        "ownerId": 18624860,
        "type": "MEETING",
        "timestamp": 1561559798348
    },
    "associations": {
        "contactIds": [100001],
        "companyIds": [ ],
        "dealIds": [ ],
        "ownerIds": [ ]
    },
"metadata": {
    "body": "I had a 3:30 hour meeting with Sam.",
    "startTime": 1561554000000,
    "endTime": 1561566600000,
    "title": "My 3.5 Hour Meeting"
  }
}

renders as:

While the meeting with this contact has UNIX timestamps for startTime and endTime that come out to 30 minutes apart (1562072400 and 1562074200, respectively), they are in seconds rather than milliseconds. HubSpot's APIs accept millisecond timestamps, so I'm a bit surprised the engagement was accepted and placed on the timeline in 2019 instead of 1970.

That abnormality aside, I suspect that HubSpot had trouble calculating the difference between these second timestamps and automatically set the "Duration" to "15 minutes" because that is the shortest default duration for meetings.

Are you seeing this behavior across all meeting engagements? Could you provide additional examples?

If all MEETING engagements are coming through with second timestamps, we'll likely have to work with Zapier to get millisecond timestamps sent over.

Re: Hubspot & Zapier - Meeting Engagement Showing Wrong Duration

ChrisEldridge — Wed, 26 Jun 2019 15:14:23 GMT

Hello Again @IsaacTakushi

We are seeing this on all meeting engaements coming over through Zapier.

Here are two additional examples:

https://app.hubspot.com/contacts/3925488/contact/33045401

https://app.hubspot.com/contacts/3925488/contact/32968151

Here is my formatting settings in Zapier: https://cl.ly/2bf5bf095b60

Re: Hubspot & Zapier - Meeting Engagement Showing Wrong Duration

IsaacTakushi — Thu, 27 Jun 2019 20:43:29 GMT

Hi, @ChrisEldridge.

Thanks for sharing. I've confirmed that the behavior is caused by epoch timestamps in seconds. A meeting's duration updates correctly with millisecond timestamps.

Zapier's documentation doesn't list millisecond timestamps as an option, so it can only send timestamps over in seconds. As such, there is no out-of-the-box solution to this issue.

I will work with my team to see if we can set meeting durations based on the differences between second timestamps. Alternatively, we may be able to transform the second timestamps to millisecond timestamps on our end. To be transparent, we will likely not be able to prioritize this change in the immediate future, so I apologize for any inconvenience.

I will update this thread with pertinent developments.