topic Re: Finding the next meeting in APIs & Integrations

Finding the next meeting

KSimmons — Fri, 08 Sep 2023 20:38:41 GMT

Is there a good way to search or retrieve the start time of the NEXT meeting for a company or contact?

I need the start time (date plus time in a string or text field) to include in emails and documents.

Seems like there are two ways to approch pulling the start date of a meeting for a particular company.

1. Get all of the meetings associated with the company and then filter for the soonest upcoming date. Return next date

2. Search for meetings that occur in the next 14 days. Return the meeting date that the search API returns

Are either of these two options better? Or is there a more straightforward workflow to print the meeting start time to a property?

Re: Finding the next meeting

Jaycee_Lewis — Mon, 11 Sep 2023 16:41:22 GMT

Hi, @KSimmons 👋 Thanks for the interesting question. I'd like to invite some of our community members to the conversation. Hey, @Teun @KimM @LMeert, have you tackled anything similar in your work?

Thanks for taking a look! — Jaycee

Re: Finding the next meeting

KimM — Wed, 13 Sep 2023 13:24:10 GMT

Hi @KSimmons ,

I presume you are planning on using the Hubspot API and custom code workflow actions for this. So I would suggest using the Meetings Engagements Search endpoint. First I would assign today's date/time to a variable. You can then filter by association with the company or contact and hs_meeting_start_time greater than the date variable you assigned earlier. Make sure to sort by hs_meeting_start_time ascending and set the limit to 1.

This will return just the one meeting which is the next meeting associated with that company or contact. You can then extract the hs_meeting_start_time from the results and format it as you like.

This way you don't have to pull a load of meetings to loop through and are less likely to encounter edge cases when a meeting might not be scheduled in the next 14 days. You may also want to adjust the code or the workflow to handle cases where there are no future-dated meetings.

I just tested it and this seems to work for me:

Hope this helps and feel free to reach out if you encounter any problems.

Cheers,

Kim

Re: Finding the next meeting

KSimmons — Wed, 13 Sep 2023 21:13:32 GMT

Thanks. That works!

Re: Finding the next meeting

KimM — Thu, 14 Sep 2023 07:30:08 GMT

Great to hear @KSimmons. Happy to help.