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.