# CallLogs ## Documentation The logs of telephone calls. Each request costs 20 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Activities` - Primary Keys: `id` - Retrieve: True - Insert: True - Update: False - Delete: True ## Table Columns The columns of the table `CallLogs` 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. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `activity_id` | `int64` | | ☐ | If specified, this activity will be converted into a call log, with the information provided. | | `company_id` | `int64` | | ☐ | The company ID of the owner of the call log. | | `deal_id` | `int64` | | ☐ | The ID of the deal this call is associated with. | | `duration` | `varchar2` | | ☐ | The duration of the call in seconds. | | `end_time` | `datetime` | | ☐ | The date and time of the end of the call in UTC. | | `from_phone_number` | `varchar2` | | ☐ | The number that made the call. | | `has_recording` | `char` | | ☐ | If the call log has an audio recording attached, the value should be true. | | `id` | `varchar2` | | ☑ | The call log ID, generated when the call log was created. | | `lead_id` | `varchar2` | | ☐ | The ID of the lead in the UUID format this call is associated with. | | `note` | `varchar2` | | ☐ | The note for the call log in HTML format. | | `org_id` | `int64` | | ☐ | The ID of the organization this call is associated with. | | `outcome` | `varchar2` | | ☐ | Describes the outcome of the call. | | `person_id` | `int64` | | ☐ | The ID of the person this call is associated with. | | `start_time` | `datetime` | | ☐ | The date and time of the start of the call in UTC. | | `subject` | `varchar2` | | ☐ | The name of the activity this call is attached to. | | `to_phone_number` | `varchar2` | | ☐ | The number called. | | `user_id` | `int64` | | ☐ | The ID of the owner of the call log. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `activity_id` | [[Activities-Activities\|Activities.Activities]] | `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 | | `person_id` | [[Contacts-Persons\|Contacts.Persons]] | `id` | Declared by the connector, not enforced by the platform | | `user_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform |