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. |