ODBC Driver for HubSpot

Build 25.0.9434

PostalMails

Lists all postal mail records in HubSpot, used for tracking postal communication.

Columns

Name Type ReadOnly References Filterable Description
Id [KEY] Long True 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.

Properties String True False

An aggregate of the properties defined for a given object type.

All teams String True False

The team IDs, including the team hierarchy, of all default and custom owner properties for this record.

Business units String False False

The business units this record is assigned to.

All owner IDs String True False

Values of all default and custom owner properties for this record.

All team IDs String True False

The team IDs of all default and custom owner properties for this record.

AtMentioned Owner Ids String False False

The owners that have been at-mentioned on the engagement.

Attached file IDs String False False

The IDs of the files that are attached to the postal mail.

Body preview String True True

A truncated preview of the engagement body.

HTML Body Preview String True True

The HTML representation of the engagement body preview.

Body Preview Truncated Bool True True

Indicates whether the engagement body was truncated for the preview.

Activity created by Decimal True True

The user who created the postal mail.

Created by user ID Decimal True True

The user who created this record. This value is set automatically by HubSpot.

Object create date/time Datetime True True

The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.

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.

GDPR deleted Bool True True

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

Object last modified date/time Datetime True True

Most recent timestamp of any property update for this object. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.

Merged record IDs String True False

The list of record IDs that have been merged into this record. This value is set automatically by HubSpot.

Updated by Decimal True True

The user who last updated the postal mail.

Record ID Decimal True True

The unique ID for this record. This value is set automatically by HubSpot.

Record creation source String True True

Raw internal PropertySource present in the RequestMeta when this record was created.

Record source detail 1 String True True

First level of detail on how this record was created.

Record source detail 2 String True True

Second level of detail on how this record was created.

Record source detail 3 String True True

Third level of detail on how this record was created.

Record creation source ID String True True

Raw internal sourceId present in the RequestMeta when this record was created.

Record source String True False

The method in which this record was initially created in the system.

Record creation source user ID Decimal True True

Raw internal userId present in the RequestMeta when this record was created.

Postal Mail Body String False True

The body text of the postal mail.

Postal Mail Type String False False

The category of postal mail, as defined by the user.

Queue Memberships String False False

The list of queues that contain this engagement.

Read only object Bool True True

Determines whether a record can be edited by a user.

Shared teams String True False

Additional teams whose users can access the record based on their permissions. This can be set manually or through Workflows or APIs.

Shared users String True False

Additional users that can access the record based on their permissions. This can be set manually or through Workflows and APIs.

Activity date Datetime False True

The date that an engagement occurred.

Unique creation key String True True

The 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 who last updated this record. This value is set automatically by HubSpot.

User IDs of all notification followers String True False

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 False

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 False

The user IDs of all owners of this record.

Performed in an import Bool True True

The object is part of an import.

Owner assigned date Datetime True True

The most recent timestamp of when an owner was assigned to this record. This value is set automatically by HubSpot.

Owner String False True

The owner of the object.

Owner's main team String True False

The main team of the record owner. This value is set automatically by HubSpot.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434