import { DEFAULT_MEETING_PROPERTIES } from "../../common/constants.mjs";
import { OBJECT_TYPE } from "../../common/object-types.mjs";
import hubspot from "../../hubspot.app.mjs";
export default {
key: "hubspot-get-associated-meetings",
name: "Get Associated Meetings",
description:
"Retrieves meetings associated with a specific object (contact, company, or deal) with optional time filtering. [See the documentation](https://developers.hubspot.com/docs/reference/api/crm/associations/association-details#get-%2Fcrm%2Fv4%2Fobjects%2F%7Bobjecttype%7D%2F%7Bobjectid%7D%2Fassociations%2F%7Btoobjecttype%7D)",
version: "0.0.12",
annotations: {
destructiveHint: false,
openWorldHint: true,
readOnlyHint: true,
},
type: "action",
props: {
hubspot,
objectType: {
propDefinition: [
hubspot,
"objectType",
() => ({
includeCustom: true,
}),
],
label: "From Object Type",
description: "The type of the object being associated",
},
objectId: {
type: "string",
label: "Object ID",
description:
"The ID of the object to get associated meetings for. For contacts, you can search by email.",
propDefinition: [
hubspot,
"objectIds",
({ objectType }) => ({
objectType,
}),
],
},
timeframe: {
propDefinition: [
hubspot,
"timeframe",
],
},
mostRecent: {
propDefinition: [
hubspot,
"mostRecent",
],
},
additionalProperties: {
type: "string[]",
label: "Additional Properties",
description: "Additional properties to retrieve for the meetings",
optional: true,
},
},
additionalProps() {
const { timeframe } = this;
if (timeframe !== "custom") {
return {};
}
return {
startDate: {
type: "string",
label: "Start Date",
description:
"The start date to filter meetings from (ISO 8601 format). Eg. `2025-01-01T00:00:00Z`",
},
endDate: {
type: "string",
label: "End Date",
description:
"The end date to filter meetings to (ISO 8601 format). Eg. `2025-01-31T23:59:59Z`",
},
};
},
methods: {
getMeetingTimeFilter(timeframe, startDate, endDate) {
const now = new Date();
const startOfDay = new Date(
Date.UTC(
now.getUTCFullYear(),
now.getUTCMonth(),
now.getUTCDate(),
0,
0,
0,
0,
),
).toISOString();
const endOfDay = new Date(
Date.UTC(
now.getUTCFullYear(),
now.getUTCMonth(),
now.getUTCDate(),
23,
59,
59,
999,
),
).toISOString();
switch (timeframe) {
case "today":
return {
hs_meeting_start_time: {
operator: "GTE",
value: startOfDay,
},
hs_meeting_end_time: {
operator: "LTE",
value: endOfDay,
},
};
case "this_week": {
const dayOfWeek = now.getUTCDay();
const startOfWeek = new Date(
Date.UTC(
now.getUTCFullYear(),
now.getUTCMonth(),
now.getUTCDate() - dayOfWeek,
0,
0,
0,
0,
),
).toISOString();
const endOfWeek = new Date(
Date.UTC(
now.getUTCFullYear(),
now.getUTCMonth(),
now.getUTCDate() + (6 - dayOfWeek),
23,
59,
59,
999,
),
).toISOString();
return {
hs_meeting_start_time: {
operator: "GTE",
value: startOfWeek,
},
hs_meeting_end_time: {
operator: "LTE",
value: endOfWeek,
},
};
}
case "this_month": {
const startOfMonth = new Date(
Date.UTC(now.getUTCFullYear(), now.getUTCMonth(), 1, 0, 0, 0, 0),
).toISOString();
const endOfMonth = new Date(
Date.UTC(
now.getUTCFullYear(),
now.getUTCMonth() + 1,
0,
23,
59,
59,
999,
),
).toISOString();
return {
hs_meeting_start_time: {
value: startOfMonth,
operator: "GTE",
},
hs_meeting_end_time: {
value: endOfMonth,
operator: "LTE",
},
};
}
case "last_month": {
const startOfLastMonth = new Date(
Date.UTC(now.getUTCFullYear(), now.getUTCMonth() - 1, 1, 0, 0, 0, 0),
).toISOString();
const endOfLastMonth = new Date(
Date.UTC(
now.getUTCFullYear(),
now.getUTCMonth(),
0,
23,
59,
59,
999,
),
).toISOString();
return {
hs_meeting_start_time: {
operator: "GTE",
value: startOfLastMonth,
},
hs_meeting_end_time: {
operator: "LTE",
value: endOfLastMonth,
},
};
}
case "custom":
return {
hs_meeting_start_time: {
operator: "LTE",
value: startDate,
},
hs_meeting_end_time: {
operator: "GTE",
value: endDate,
},
};
default:
return {};
}
},
async getAssociatedMeetings({
objectType,
objectId,
timeframe,
startDate,
endDate,
mostRecent,
}) {
const { results: associations } = await this.hubspot.getAssociations({
objectType,
objectId,
toObjectType: OBJECT_TYPE.MEETING,
});
if (!associations?.length) {
return [];
}
const meetingIds = associations.map(({ toObjectId }) => toObjectId);
const timeFilter = this.getMeetingTimeFilter(
timeframe,
startDate,
endDate,
);
const { results } = await this.hubspot.searchMeetings({
data: {
properties: [
...DEFAULT_MEETING_PROPERTIES,
...(this.additionalProperties || []),
],
filterGroups: [
{
filters: [
{
propertyName: "id",
operator: "IN",
values: meetingIds,
},
...Object.entries(timeFilter).map(
([
propertyName,
filterProps,
]) => ({
propertyName,
...filterProps,
}),
),
],
},
],
sorts: [
{
propertyName: "hs_meeting_start_time",
direction: "DESCENDING",
},
],
limit: mostRecent
? 1
: 100,
},
});
return results;
},
},
async run({ $ }) {
let resolvedObjectId = this.objectId;
if (
this.objectType === OBJECT_TYPE.CONTACT &&
this.objectId.includes("@")
) {
const { results } = await this.hubspot.searchCRM({
object: OBJECT_TYPE.CONTACT,
data: {
filterGroups: [
{
filters: [
{
propertyName: "email",
operator: "EQ",
value: this.objectId,
},
],
},
],
},
});
if (!results?.length) {
throw new Error(`No contact found with email: ${this.objectId}`);
}
resolvedObjectId = results[0].id;
}
const meetings = await this.getAssociatedMeetings({
objectType: this.objectType,
objectId: resolvedObjectId,
timeframe: this.timeframe,
startDate: this.startDate,
endDate: this.endDate,
mostRecent: this.mostRecent,
});
const summary = this.mostRecent
? "Successfully retrieved most recent meeting"
: `Successfully retrieved ${meetings.length} meeting(s)`;
$.export("$summary", summary);
return meetings;
},
};
Chase Roberts@chsrbrts@benedictevans If you haven’t used @pipedream yet, then you haven’t lived.
✨Ellie Day✨@heyelliedayEvaluation update: @pipedream has quite literally been a dream to work with! I’m excited to leverage this tool for all the various workflows I need to write. I’m currently at 11k invocations a day from the initial workflows I’ve written in the past couple weeks.
Michael Braedley@MBraedleyUpdate: I got it working properly, and it's working so well that I'm dropping IFTTT. @pipedream can do everything that IFTTT basic can, and most (if not all things) IFTTT pro can for free or at a reasonable price if you need it. I am recommending it for basically any power user.
Thomas Cutting@mrthomascuttingWant quick+dirty integrations for a serverless workflow - @pipedream is my new go-to 😃
Matthew Roberts@mattdotrobertsday 013 - finally hit node js. This is the secret sauce of taking #nocode projects that one step further. Pumped about getting deeper into @pipedream now
Kenneth Auchenberg 💭@auchenbergYahoo Pipes is back! Kinda 😍 @pipedream
Raymond Camden 🥑@raymondcamdenAwesome video by the @pipedream folks showing real time twitter sentiment analysis integrated with Google Sheets. This is where Pipedream *really* shines, connecting systems together in easy workflows.
Nacho Caballero@nachocaballeroI couldn't recommend @pipedream more. It's an amazing service to integrate different APIs. Much more powerful than Zapier and more user-friendly than AWS Lambda. I'm very proud to wear this t-shirt #NoCode
Jason Snow@jyksnwDeveloped a working prototype environmental sensor IoT solution with @particle Photon, @pipedream, and @MongoDB with full graphing and alerting in less than a day! All amazing technology, will def. be exploring these more.
Steven Terrana@steven_terrana@burgwyn you've inspired me to finally set up my own blog. I'll make sure my first blog post explains the tech behind the setup. think @obsdmd + @GatsbyJS + @pipedream.
🚄 James Augeri, PhD@DotDotJamesWant to low-code your back end, need more horsepower than @Bubble / @KnackHQ, or just miss Yahoo! Pipes? Check out @PipeDream
Sébastien Chopin@AtinuxGitHub issues should be like @linear_app for maintainers. Looking forward more integrations with GH actions or tools like @pipedream 👀
Raul@raul_predescuIf you're a dev and not using @pipedream, you're missing out. Been using it for months, daily. FREE for devs. Plenty of integrations and good limits. Absolutely love it.
Bruno Skvorc@bitfallsSo @pipedream is pretty amazing. In 3 minutes I just made a flow which adds @rickastley's Never Gonna Give You Up to my @spotify playlist whenever a new pull request arrives in an old repo of mine.
Zach Lanich@ZachLanichUm, wow 🤯 @pipedream
Steven Bell@bellontechI just used @pipedream to build a Shopify App. Wow, they make small backed tasks easy.
Jay Hack 🎩🇺🇸@_jayhack_Very impressed with this bad boi - it reminds me of a @PalantirTech internal tool, but geared towards integrations instead of data analysis and far more customizable. Great expectations here 🚀🤩
Tree Sturgeon 🔥🚴♂️🌳@philsturgeonFor context this is day 2 of a really challenging and stupid migration from Notion to @airtable with disparate/missing data. It's going better than expected and thanks to @pipedream I don't have to bother the iOS dev to add W3W.