Skip to main content
Tasks
Nick Maxwell avatar
Written by Nick Maxwell
Updated over 2 months ago

Data Dictionary

Field

Type

Notes

Archived

Boolean

True if the Task has been archived

Associated Companies

JSON

A JSON array that holds the Company ID and Association Type of any Companies associated with this record.

Associated Contacts

JSON

A JSON array that holds the Contact ID and Association Type of any Contacts associated with this record.

Associated Deals

JSON

A JSON array that holds the Deal ID and Association Type of any Deals associated with this record.

Body

Text

Task Body

Connection Name

Text

The name of the Connection. Typically the name of the HubSpot Organisation.

Created

Datetime

The date and time that the record was created.

Created Date

Date

The date that the record was created. This is useful so you can create a relationship with the Dates table, and analyze data over days, weeks, months and so on.

Data current as of

Datetime

Gives the date and time that this record was taken from HubSpot.

Due

Datetime

When the task is due to be completed.

Owner ID

Integer

The Owner ID of the person that owns/is responsible for the record. Not necessarily the same as the Created By Owner ID. Find related details in the Owners table.

Primary Company ID

Integer

If one exists, the Company ID for the primary Company associated with this record. Find related details in the Companies table.

Primary Contact ID

Integer

If one exists, the Contact ID for the primary Contact associated with this record. There may not be any associated Contact. Find related details in the Contacts table.

Primary Deal ID

Integer

If one exists, the Deal ID for the primary Deal associated with this record. Find related details in the Deals table.

Priority

Text

Task Priority

Subject

Text

Task Subject

Task ID

Integer

HubSpot's unique ID for the Task

Task Status

Text

Updated

Datetime

The date and time that the record was updated.

Updated Date

Date

The date that the record was updated. This is useful so you can create a relationship with the Dates table, and analyze data over days, weeks, months and so on.

Did this answer your question?