SSIS Components for HubSpot

Build 24.0.9062

EngagementsMeetings

Retrieve the available Meetings in HubSpot.

SELECT

When selecting Meeting Engagements, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operator is: =. 

SELECT * FROM EngagementsMeetings WHERE ID = '11896378834'

INSERT


INSERT INTO EngagementsMeetings ([Activity date], [Meeting name], [Meeting description], [Internal Meeting Notes])
VALUES (current_timestamp(), 'Meeting Engagement Title', 'Meeting Engagement Body', 'Internal Note');

UPDATE


UPDATE EngagementsMeetings SET [Meeting start time] = current_timestamp() WHERE ID = '11896378834'

DELETE


DELETE FROM EngagementsMeetings WHERE ID = '11896378834'

Columns

Name Type ReadOnly References Filterable Description
Id [KEY] Long False True

Unique identifier of the object.

Archived Bool True False

Whether the object is archived or not.

CreatedAt Datetime True False

When the object was created.

UpdatedAt Datetime True False

When the object was last updated.

Call and meeting type String False True

The activity type of the engagement.

Business units String False True

The business units this record is assigned to.

AtMentioned Owner Ids String False True

The owners that have been at_mentioned on the engagement.

Attached file IDs String False True

The IDs of the files that are attached to the engagement.

HubSpot attendee owner IDs String False True

List of HubSpot owner IDs for additional attendees.

Body preview String True True

A truncated preview of the engagegement body.

HTML Body Preview String True True

The HTML representation of the engagement body preview.

Body Preview Truncated Bool True True

Indicates if the engagement body was truncated for the preview.

Activity created by Decimal True True

The user who created the engagement.

Created by user ID Decimal True True

The user that created this object. This value is automatically set by HubSpot and may not be modified.

Create date Datetime True True

The date that an engagement was created.

Engagement Source String False True

The source that created this engagement.

Engagement Source ID String False True

The specific ID of the process that created this engagement.

Follow up action String False True

What action should be performed during follow up.

GDPR deleted Bool True True

Indicates the body of this engagement has been cleared because of a GDPR delete request.

iCalUid String True True

The iCalUid of the synced event.

Internal Meeting Notes String False True

Last modified date Datetime True True

The date any property on this engagement was modified.

Meeting description String False True

The text description of the meeting.

Meeting calendar event hash String False True

The unique hash for the meeting.

Meeting change id String False True

The unique change id for the meeting.

Created From Link ID String False True

Created From Link ID.

Meeting end time Datetime False True

The date when the meeting ends.

External URL String False True

The external URL for the meeting.

Meeting location String False True

Where the meeting takes place.

Location type String False True

The type of location for the meeting event.

Meeting outcome String False True

The outcome of this meeting.

Payments session id String False True

The payments session id for the meeting.

PreMeeting prospect reminders String False True

A list of dates when meeting reminders should be sent to prospects.

Meeting source String True True

The source where the meeting was booked.

Source ID String False True

The source ID of the meeting.

Meeting start time Datetime False True

The date when the meeting starts.

Meeting name String False True

The title of the meeting.

Web conference meeting ID String False True

The meeting ID of the web conference.

Merged object IDs String True True

The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.

Updated by Decimal True True

The user who last updated the engagement.

Record ID Decimal True True

The unique ID for this record. This value is automatically set by HubSpot and may not be modified.

Product name String False True

The name of the product associated with this engagement.

Queue Memberships String False True

The list of queues that contain this engagement.

Read Only Object Bool True True

Is the object read only.

Scheduled tasks String True True

Activity date Datetime False True

The date that an engagement occurred.

Unique creation key String True True

Unique property used for idempotent creates.

Unique ID String False True

The unique ID of the engagement.

Updated by user ID Decimal True True

The user that last updated this object. This value is automatically set by HubSpot and may not be modified.

User IDs of all notification followers String True True

The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.

User IDs of all notification unfollowers String True True

The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.

User IDs of all owners String True True

The user IDs of all owners of this object.

Owner Assigned Date Datetime True True

The timestamp when an owner was assigned to this engagement.

Activity assigned to String False True

The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user_ and can be set manually or via Workflows.

HubSpot Team String True True

The team of the owner of an engagement.

All owner ids String True True

The value of all owner referencing properties for this object_ both default and custom.

All team ids String True True

The team ids corresponding to all owner referencing properties for this object_ both default and custom.

All accessible team ids String True True

The team ids_ including up the team hierarchy_ corresponding to all owner referencing properties for this object_ both default and custom.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062