# Activities ## Documentation The activities: calls, meetings, tasks and other things to do, linked to deals, leads, persons, organizations and projects. Each request costs 10 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Activities` - Primary Keys: `id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Activities` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `add_time` | `datetime` | | ☐ | The creation date and time of the activity. | | `attendees` | `varchar2` | | ☐ | The attendees of the activity. | | `busy` | `char` | | ☐ | Whether the activity marks the assignee as busy or not in their calendar. | | `conference_meeting_client` | `varchar2` | | ☐ | The client used for the conference meeting. | | `conference_meeting_id` | `varchar2` | | ☐ | The ID of the conference meeting. | | `conference_meeting_url` | `varchar2` | | ☐ | The URL of the conference meeting. | | `creator_user_id` | `int64` | | ☐ | The ID of the user who created the activity. | | `deal_id` | `int64` | | ☐ | The ID of the deal linked to the activity. | | `done` | `char` | | ☐ | Whether the activity is marked as done or not. | | `due_date` | `datetime` | | ☐ | The due date of the activity. | | `due_time` | `varchar2` | | ☐ | The due time of the activity. | | `duration` | `varchar2` | | ☐ | The duration of the activity. | | `id` | `int64` | | ☑ | The ID of the activity. | | `is_deleted` | `char` | | ☐ | Whether the activity is deleted or not. | | `lead_id` | `varchar2` | | ☐ | The ID of the lead linked to the activity. | | `location_admin_area_level_1` | `varchar2` | | ☐ | Admin area level 1 (e.g. state) of the activity. | | `location_admin_area_level_2` | `varchar2` | | ☐ | Admin area level 2 (e.g. county) of the activity. | | `location_country` | `varchar2` | | ☐ | Country of the activity. | | `location_locality` | `varchar2` | | ☐ | Locality (e.g. city) of the activity. | | `location_postal_code` | `varchar2` | | ☐ | Postal code of the activity. | | `location_route` | `varchar2` | | ☐ | Route (e.g. street) of the activity. | | `location_street_number` | `varchar2` | | ☐ | Street number of the activity. | | `location_sublocality` | `varchar2` | | ☐ | Sublocality (e.g. neighborhood) of the activity. | | `location_subpremise` | `varchar2` | | ☐ | Subpremise (e.g. apartment/suite number) of the activity. | | `location_value` | `varchar2` | | ☐ | The full address of the activity. | | `location` | `varchar2` | | ☐ | Location of the activity. Only taken when writing; empty when read. | | `marked_as_done_time` | `datetime` | | ☐ | The date and time when the activity was marked as done. | | `note` | `varchar2` | | ☐ | The note of the activity. | | `org_id` | `int64` | | ☐ | The ID of the organization linked to the activity. | | `outcome` | `int64` | | ☐ | The ID of the Outcome for the activity. | | `owner_id` | `int64` | | ☐ | The ID of the user who owns the activity. | | `participants` | `varchar2` | | ☐ | The participants of the activity. | | `person_id` | `int64` | | ☐ | The ID of the person linked to the activity. | | `priority` | `int64` | | ☐ | The priority of the activity. | | `project_id` | `int64` | | ☐ | The ID of the project linked to the activity. | | `public_description` | `varchar2` | | ☐ | The public description of the activity. | | `subject` | `varchar2` | | ☐ | The subject of the activity. | | `type` | `varchar2` | | ☐ | The type of the activity. | | `update_time` | `datetime` | | ☐ | The last updated date and time of the activity. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `creator_user_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform | | `deal_id` | [[Deals-Deals\|Deals.Deals]] | `id` | In words only: The deal, in Deals or, once archived, in ArchivedDeals; a deleted deal stays readable for 30 days with status 'deleted'. | | `deal_id` | [[Deals-ArchivedDeals\|Deals.ArchivedDeals]] | `id` | In words only: The deal, in Deals or, once archived, in ArchivedDeals; a deleted deal stays readable for 30 days with status 'deleted'. | | `lead_id` | [[Leads-Leads\|Leads.Leads]] | `id` | In words only: The lead, in Leads or, once archived, in ArchivedLeads. | | `lead_id` | [[Leads-ArchivedLeads\|Leads.ArchivedLeads]] | `id` | In words only: The lead, in Leads or, once archived, in ArchivedLeads. | | `org_id` | [[Contacts-Organizations\|Contacts.Organizations]] | `id` | Declared by the connector, not enforced by the platform | | `owner_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform | | `person_id` | [[Contacts-Persons\|Contacts.Persons]] | `id` | Declared by the connector, not enforced by the platform | | `project_id` | [[Projects-Projects\|Projects.Projects]] | `id` | In words only: The project, in Projects or, once archived, in ArchivedProjects. | | `project_id` | [[Projects-ArchivedProjects\|Projects.ArchivedProjects]] | `id` | In words only: The project, in Projects or, once archived, in ArchivedProjects. | | `type` | [[Activities-ActivityTypes\|Activities.ActivityTypes]] | `key_string` | Declared by the connector, not enforced by the platform | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Activities-CallLogs\|Activities.CallLogs]] | `activity_id` | Declared by the connector, not enforced by the platform | | [[Leads-Leads\|Leads.Leads]] | `next_activity_id` | Declared by the connector, not enforced by the platform | | [[Notes-Files\|Notes.Files]] | `activity_id` | Declared by the connector, not enforced by the platform | | [[Settings-RecentChangesBySinceTimestamp\|Settings.RecentChangesBySinceTimestamp]] | `id` | In words only: The changed row of Activities, when item is 'activity'. |