Leads

Captures unqualified prospects with fields for source, rating, and follow-up dates; supports conversion into contacts and 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.
Email	String	False	Email address of the lead.
Phone	String	False	Business phone number of the lead.
Fax	String	False	Fax number of the lead.
Mobile	String	False	Mobile phone number of the lead.
Website	String	False	Website associated with the lead.
LeadSource	String	False	Source from which the lead was acquired.
LeadStatus	String	False	Current status of the lead.
Industry	String	False	Industry associated with the lead.
No.ofEmployees	Int	False	Number of employees at the lead's company.
AnnualRevenue	Decimal	False	Estimated annual revenue of the lead's company.
Rating	String	False	Rating assigned to the lead.
EmailOptOut	Bool	False	Indicates whether the lead has opted out of email communications.
SkypeID	String	False	Skype Id of the lead.
CreatedBy_Id	String	False	Unique identifier of the user who created the record.
CreatedBy_FirstName	String	True	First name of the user who created the record.
CreatedBy_LastName	String	True	Last name of the user who created the record.
CreatedBy_Email	String	True	Email address of the user who created the record.
CreatedBy_Name	String	True	Full name of the user who created the record.
ModifiedBy_Id	String	False	Unique identifier of the user who last modified the record.
ModifiedBy_FirstName	String	True	First name of the user who last modified the record.
ModifiedBy_LastName	String	True	Last name of the user who last modified the record.
ModifiedBy_Email	String	True	Email address of the user who last modified the record.
ModifiedBy_Name	String	True	Full name of the user who last modified the record.
CreatedTime	Datetime	False	Date and time the record was created.
ModifiedTime	Datetime	False	Date and time the record was last modified.
Salutation	String	False	Salutation for the lead, such as Mr. or Ms.
SecondaryEmail	String	False	Secondary email address of the lead.
LastActivityTime	Datetime	True	Timestamp of the last activity related to the lead.
Twitter	String	False	Twitter handle of the lead.
Tag	String	False	Tag or label 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 or province of the lead's address.
ZipCode	String	False	Postal or ZIP code of the lead's address.
Country	String	False	Country of the lead's address.
Description	String	False	Additional information or notes about the lead.
LeadImage	String	False	Image or avatar associated with the lead.
LeadConversionTime	Int	True	Time taken to convert the lead.
UnsubscribedMode	String	True	Indicates how the lead unsubscribed from communications.
UnsubscribedTime	Datetime	True	Timestamp when the lead unsubscribed.
ChangeLogTime	Datetime	True	Timestamp of the last change to the record.
Locked	Bool	True	Indicates whether the record is locked from editing.
LastEnrichedTime	Datetime	True	Timestamp of the most recent enrichment of the lead data.
EnrichStatus	String	True	Status of the data enrichment for the lead.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
DuplicateCheckFields	String	Field or fields used to check for duplicate records during an upsert. The REST API supports multiple fields, while the BULK API supports only one.
Trigger	String	Used to trigger workflow rules when inserting a record into the CRM account.
CustomViewId	Long	Custom view Id used to filter the record. Applies when the useCOQL parameter is false.

ODBC Driver for Zoho CRM