Leads
Captures unqualified prospects with details such as source and rating, and supports conversion into contacts, accounts, or deals.
Table-Specific Information
Select
This table supports COQL for filtering, meaning that most filters comparing columns to values are submitted server-side.
Note: When UseCOQL is set to true, a SELECT * query may fail due to the large number of columns in this table. To avoid this error:
- Specify fewer than 50 columns in the SELECT clause
- Or set the UseCOQL connection property to false to disable COQL and use the REST or BULK API
Insert
You must specify the LastName column when inserting a new lead. The following examples demonstrate valid insert operations:
-- Insert a lead with a first name, last name, and title
INSERT INTO Leads (FirstName, LastName, Title) VALUES ('Alert', 'Bat', 'Mr')
-- Insert a lead and trigger associated workflows, approvals, or blueprints
INSERT INTO Leads (FirstName, LastName, Email, Trigger) VALUES ('Enthusiastic', 'Panda', '[email protected]', 'workflow,approval,blueprint')
Required fields: LastName is required.
Any field which is not read-only (ReadOnly = false in the table schema) can be inserted.
Delete
You must specify the Id column in the WHERE clause to delete a record. The following example demonstrates a delete operation:
-- Delete a lead by its unique ID
DELETE FROM Leads WHERE Id = '3152079000000153079'
Update
You must specify the Id column in the WHERE clause to update a record. The following example demonstrates an update operation:
-- Update the description field for a specific lead
UPDATE Leads SET Description = 'Changed from the API.' WHERE Id = '3152079000000488014'
Required fields: Id is required. The update must target a specific record.
Any field which is not read-only (ReadOnly = false in the table schema) can be updated.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
Unique identifier for the lead. |
| LeadOwner_Id | String | False |
Unique identifier of the lead owner. |
| LeadOwner_FirstName | String | True |
First name of the lead owner. |
| LeadOwner_LastName | String | True |
Last name of the lead owner. |
| LeadOwner_Email | String | True |
Email address of the lead owner. |
| LeadOwner_Name | String | True |
Full name of the lead owner. |
| Company | String | False |
Name of the company associated with the lead. |
| FirstName | String | False |
First name of the lead. |
| LastName | String | False |
Last name of the lead. |
| FullName | String | False |
Full name of the lead. |
| Title | String | False |
Job title of the lead. |
| String | False |
Email address of the lead. | |
| Phone | String | False |
Primary phone number of the lead. |
| Fax | String | False |
Fax number of the lead. |
| Mobile | String | False |
Mobile number of the lead. |
| Website | String | False |
Website associated with the lead. |
| LeadSource | String | False |
Source from which the lead originated. |
| LeadStatus | String | False |
Current status of the lead. |
| Industry | String | False |
Industry in which the lead operates. |
| No.ofEmployees | Int | False |
Number of employees in the lead's company. |
| AnnualRevenue | Decimal | False |
Annual revenue of the lead's company. |
| Rating | String | False |
Rating of the lead. |
| EmailOptOut | Bool | False |
Indicates whether the lead has opted out of email communication. |
| SkypeID | String | False |
Skype Id of the lead. |
| CreatedBy_Id | String | False |
Unique identifier of the user who created the lead. |
| CreatedBy_FirstName | String | True |
First name of the user who created the lead. |
| CreatedBy_LastName | String | True |
Last name of the user who created the lead. |
| CreatedBy_Email | String | True |
Email address of the user who created the lead. |
| CreatedBy_Name | String | True |
Full name of the user who created the lead. |
| ModifiedBy_Id | String | False |
Unique identifier of the user who last modified the lead. |
| ModifiedBy_FirstName | String | True |
First name of the user who last modified the lead. |
| ModifiedBy_LastName | String | True |
Last name of the user who last modified the lead. |
| ModifiedBy_Email | String | True |
Email address of the user who last modified the lead. |
| ModifiedBy_Name | String | True |
Full name of the user who last modified the lead. |
| CreatedTime | Datetime | False |
Date and time when the lead was created. |
| ModifiedTime | Datetime | False |
Date and time when the lead was last modified. |
| Salutation | String | False |
Salutation used for the lead. |
| SecondaryEmail | String | False |
Secondary email address of the lead. |
| LastActivityTime | Datetime | True |
Date and time of the last activity related to the lead. |
| String | False |
Twitter handle of the lead. | |
| Tag | String | False |
Tags associated with the lead. |
| Street | String | False |
Street address of the lead. |
| City | String | False |
City of the lead's address. |
| State | String | False |
State of the lead's address. |
| ZipCode | String | False |
Postal code of the lead's address. |
| Country | String | False |
Country of the lead's address. |
| Description | String | False |
Additional notes or description about the lead. |
| LeadImage | String | False |
Profile image of the lead. |
| ConvertedDateTime | Datetime | False |
Date and time when the lead was converted. |
| LeadConversionTime | Int | True |
Time taken to convert the lead, in minutes. |
| UnsubscribedMode | String | True |
Mode by which the lead unsubscribed from communications. |
| UnsubscribedTime | Datetime | True |
Date and time when the lead unsubscribed. |
| ConvertedAccount_Id | String | False |
Unique identifier of the account the lead was converted to. |
| ConvertedAccount_Name | String | True |
Name of the account the lead was converted to. |
| ConvertedContact_Id | String | False |
Unique identifier of the contact the lead was converted to. |
| ConvertedContact_Name | String | True |
Name of the contact the lead was converted to. |
| ConvertedDeal_Id | String | False |
Unique identifier of the deal the lead was converted to. |
| ConvertedDeal_Name | String | True |
Name of the deal the lead was converted to. |
| RecordId | Long | True |
Internal record identifier. |
| ChangeLogTime | Datetime | True |
Timestamp when the record was last included in the change log. |
| IsConverted | Bool | True |
Indicates whether the lead has been converted. |
| Locked | Bool | True |
Indicates whether the lead record is locked for editing. |
| LastEnrichedTime | Datetime | True |
Timestamp when the lead was last enriched. |
| EnrichStatus | String | True |
Status of the lead enrichment process. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DuplicateCheckFields | String |
Fields used to check for duplicate records during upsert. The REST API supports multiple fields, while the BULK API supports only one. |
| Trigger | String |
Indicates whether to trigger workflow rules when inserting the record. |
| CustomViewId | Long |
Custom view identifier used to filter this record. Only applies when the useCOQL parameter is false. |