# Leads ## Documentation The leads that are not archived: potential deals still to be qualified. Each request costs 20 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Leads` - Primary Keys: `id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Leads` 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_contract_period_until` | `datetime` | ACME Contract Period | ☐ | Part 'acme_contract_period_until' of the custom field 'ACME Contract Period' of the company. | | `acme_contract_period` | `datetime` | ACME Contract Period | ☐ | The custom field 'ACME Contract Period' of the company. | | `acme_contract_value_currency` | `varchar2` | ACME Contract Value | ☐ | Part 'acme_contract_value_currency' of the custom field 'ACME Contract Value' of the company. | | `acme_contract_value` | `decimal` | ACME Contract Value | ☐ | The custom field 'ACME Contract Value' of the company. | | `acme_delivery_address_admin_area_level_1` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_admin_area_level_1' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_admin_area_level_2` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_admin_area_level_2' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_country` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_country' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_formatted_address` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_formatted_address' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_locality` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_locality' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_postal_code` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_postal_code' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_route` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_route' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_street_number` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_street_number' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_sublocality` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_sublocality' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address_subpremise` | `varchar2` | ACME Delivery Address | ☐ | Part 'acme_delivery_address_subpremise' of the custom field 'ACME Delivery Address' of the company. | | `acme_delivery_address` | `varchar2` | ACME Delivery Address | ☐ | The custom field 'ACME Delivery Address' of the company. | | `acme_external_reference` | `varchar2` | ACME External Reference | ☐ | The custom field 'ACME External Reference' of the company. | | `acme_product_lines_labels` | `varchar2` | ACME Product Lines Labels | ☐ | The labels of the chosen options of the custom field 'ACME Product Lines'. | | `acme_product_lines` | `varchar2` | ACME Product Lines | ☐ | The custom field 'ACME Product Lines' of the company. | | `acme_region_label` | `varchar2` | ACME Region Label | ☐ | The labels of the chosen options of the custom field 'ACME Region'. | | `acme_region` | `int64` | ACME Region | ☐ | The custom field 'ACME Region' of the company. | | `acme_renewal_date` | `datetime` | ACME Renewal Date | ☐ | The custom field 'ACME Renewal Date' of the company. | | `acme_seats` | `decimal` | ACME Seats | ☐ | The custom field 'ACME Seats' of the company. | | `add_time` | `datetime` | | ☐ | The date and time of when the lead was created. | | `archive_reason` | `varchar2` | | ☐ | The reason for archiving the lead. | | `cc_email` | `varchar2` | | ☐ | The BCC email of the lead. | | `channel_id` | `varchar2` | | ☐ | The optional ID to further distinguish the Marketing channel. | | `channel` | `int64` | | ☐ | The ID of your Marketing channel this Lead was created from. | | `creator_id` | `int64` | | ☐ | The ID of the user who created the lead. | | `expected_close_date` | `datetime` | | ☐ | The date of when the deal which will be created from the lead is expected to be closed. | | `id` | `varchar2` | | ☑ | The unique ID of the lead in the UUID format. | | `is_archived` | `char` | | ☐ | A flag indicating whether the lead is archived or not. | | `label_ids` | `varchar2` | | ☐ | The IDs of the lead labels which are associated with the lead. | | `next_activity_id` | `int64` | | ☐ | The ID of the next activity associated with the lead. | | `organization_id` | `int64` | | ☐ | The ID of an organization which this lead is linked to. | | `origin_id` | `varchar2` | | ☐ | The optional ID to further distinguish the origin of the lead - e.g. Which API integration created this Lead. | | `origin` | `varchar2` | | ☐ | The way this Lead was created. | | `owner_id` | `int64` | | ☐ | The ID of the user who owns the lead. | | `person_id` | `int64` | | ☐ | The ID of a person which this lead is linked to. | | `source_deal_id` | `int64` | | ☐ | The ID of the deal if the lead was converted from a deal. | | `source_name` | `varchar2` | | ☐ | Defines where the lead comes from. | | `title` | `varchar2` | | ☐ | The title of the lead. | | `update_time` | `datetime` | | ☐ | The date and time of when the lead was last updated. | | `value_amount` | `decimal` | | ☐ | The value amount. | | `value_currency` | `varchar2` | | ☐ | The value currency. | | `value` | `varchar2` | | ☐ | The potential value of the lead represented by a JSON object: { "amount": 200, "currency": "EUR" }. Only taken when writing; empty when read. | | `visible_to` | `varchar2` | | ☐ | The visible to. | | `was_seen` | `char` | | ☐ | A flag indicating whether the lead was seen by someone in the Pipedrive UI. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `creator_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform | | `next_activity_id` | [[Activities-Activities\|Activities.Activities]] | `id` | Declared by the connector, not enforced by the platform | | `organization_id` | [[Contacts-Organizations\|Contacts.Organizations]] | `id` | Declared by the connector, not enforced by the platform | | `origin` | [[Leads-LeadSources\|Leads.LeadSources]] | `name` | Candidate: Follows from the name of the column and held in every row of the sandbox on 2026-10-31; not stated by Pipedrive. | | `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 | | `source_deal_id` | [[Deals-Deals\|Deals.Deals]] | `id` | In words only: The deal the lead was converted from, in Deals or, once archived, in ArchivedDeals. | | `source_deal_id` | [[Deals-ArchivedDeals\|Deals.ArchivedDeals]] | `id` | In words only: The deal the lead was converted from, in Deals or, once archived, in ArchivedDeals. | | `source_name` | [[Leads-LeadSources\|Leads.LeadSources]] | `name` | Candidate: Follows from the name of the column and held in every row of the sandbox on 2026-10-31; not stated by Pipedrive. | | `value_currency` | [[Settings-Currencies\|Settings.Currencies]] | `code` | 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]] | `lead_id` | In words only: The lead, in Leads or, once archived, in ArchivedLeads. | | [[Activities-CallLogs\|Activities.CallLogs]] | `lead_id` | In words only: The lead, in Leads or, once archived, in ArchivedLeads. | | [[Deals-ArchivedDeals\|Deals.ArchivedDeals]] | `source_lead_id` | In words only: The lead the deal was converted from, in Leads or, once archived, in ArchivedLeads. | | [[Deals-Deals\|Deals.Deals]] | `source_lead_id` | In words only: The lead the deal was converted from, in Leads or, once archived, in ArchivedLeads. | | [[Notes-Files\|Notes.Files]] | `lead_id` | In words only: The lead, in Leads or, once archived, in ArchivedLeads. | | [[Notes-Notes\|Notes.Notes]] | `lead_id` | In words only: The lead, in Leads or, once archived, in ArchivedLeads. |