# Persons ## Documentation The persons: contacts of the company, linked to at most one organization. Each request costs 10 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Contacts` - Primary Keys: `id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Persons` 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 | |---|:---:|---|:---:|---| | `acme_linkedin_handle` | `varchar2` | ACME LinkedIn Handle | ☐ | The custom field 'ACME LinkedIn Handle' of the company. | | `add_time` | `datetime` | | ☐ | The creation date and time of the person. | | `birthday` | `datetime` | | ☐ | The birthday of the person, included if contact sync is enabled for the company. | | `emails` | `varchar2` | | ☐ | The emails of the person. | | `first_name` | `varchar2` | | ☐ | The first name of the person. | | `id` | `int64` | | ☑ | The ID of the person. | | `im` | `varchar2` | | ☐ | The instant messaging accounts of the person, included if contact sync is enabled for the company. | | `is_deleted` | `char` | | ☐ | Whether the person is deleted or not. | | `job_title` | `varchar2` | | ☐ | The job title of the person, included if contact sync is enabled for the company. | | `label_ids` | `varchar2` | | ☐ | The IDs of labels assigned to the person. | | `last_name` | `varchar2` | | ☐ | The last name of the person. | | `marketing_status` | `varchar2` | | ☐ | If the person does not have a valid email address, then the marketing status is **not set** and no_consent is returned for the marketing_status value when the new person is created. Only taken when writing; empty when read. | | `name` | `varchar2` | | ☐ | The name of the person. | | `notes` | `varchar2` | | ☐ | Contact sync notes of the person, maximum 10 000 characters, included if contact sync is enabled for the company. | | `org_id` | `int64` | | ☐ | The ID of the organization linked to the person. | | `owner_id` | `int64` | | ☐ | The ID of the user who owns the person. | | `phones` | `varchar2` | | ☐ | The phones of the person. | | `picture_id` | `int64` | | ☐ | The ID of the picture associated with the person. | | `postal_address_admin_area_level_1` | `varchar2` | | ☐ | Admin area level 1 (e.g. state) of the person. | | `postal_address_admin_area_level_2` | `varchar2` | | ☐ | Admin area level 2 (e.g. county) of the person. | | `postal_address_country` | `varchar2` | | ☐ | Country of the person. | | `postal_address_locality` | `varchar2` | | ☐ | Locality (e.g. city) of the person. | | `postal_address_postal_code` | `varchar2` | | ☐ | Postal code of the person. | | `postal_address_route` | `varchar2` | | ☐ | Route (e.g. street) of the person. | | `postal_address_street_number` | `varchar2` | | ☐ | Street number of the person. | | `postal_address_sublocality` | `varchar2` | | ☐ | Sublocality (e.g. neighborhood) of the person. | | `postal_address_subpremise` | `varchar2` | | ☐ | Subpremise (e.g. apartment/suite number) of the person. | | `postal_address_value` | `varchar2` | | ☐ | The full address of the person. | | `postal_address` | `varchar2` | | ☐ | Postal address of the person, included if contact sync is enabled for the company. Only taken when writing; empty when read. | | `update_time` | `datetime` | | ☐ | The last updated date and time of the person. | | `visible_to` | `int64` | | ☐ | The visibility of the person. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `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 | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Activities-Activities\|Activities.Activities]] | `person_id` | Declared by the connector, not enforced by the platform | | [[Activities-CallLogs\|Activities.CallLogs]] | `person_id` | Declared by the connector, not enforced by the platform | | [[Contacts-PersonPicturesByPersonId\|Contacts.PersonPicturesByPersonId]] | `item_id` | In words only: The person of the picture, when item_type is 'person'. | | [[Deals-ArchivedDeals\|Deals.ArchivedDeals]] | `person_id` | Declared by the connector, not enforced by the platform | | [[Deals-Deals\|Deals.Deals]] | `person_id` | Declared by the connector, not enforced by the platform | | [[Leads-ArchivedLeads\|Leads.ArchivedLeads]] | `person_id` | Declared by the connector, not enforced by the platform | | [[Leads-Leads\|Leads.Leads]] | `person_id` | Declared by the connector, not enforced by the platform | | [[Notes-Files\|Notes.Files]] | `person_id` | Declared by the connector, not enforced by the platform | | [[Notes-Notes\|Notes.Notes]] | `person_id` | Declared by the connector, not enforced by the platform | | [[Settings-RecentChangesBySinceTimestamp\|Settings.RecentChangesBySinceTimestamp]] | `id` | In words only: The changed row of Persons, when item is 'person'. |