Data Dictionary
Field | Type | Notes |
Archived | Boolean | True if the Call 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 | Call Body |
Call ID | Integer | HubSpot's unique ID for the Call |
Call Status | Text | |
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. |
Duration | Interval | Call Duration |
From Number | Text | The phone number that the Call is from |
Internal Link via Company | Text | The link to the Call record - only available if it has been linked to a Company and to those that have access to HubSpot. |
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. |
Recording Link | Text | The link to the Call recording. |
Title | Text | Call Title |
To Number | Text | The phone number that the Call is to |
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. |