Leads

Create, update, delete, and query information regarding leads.

Table-Specific Information

Select

This table supports COQL for filtering, meaning that most filters comparing columns to values are submitted server-side.

Insert

INSERT INTO Leads(FirstName, LastName, Title) VALUES('Alert', 'Bat', 'Mr')
INSERT INTO LEADS(FirstName, LastName, Email, Trigger) VALUES('Enthusiastic', 'Panda', '[email protected]', 'workflow,approval,blueprint')

Required fields: LastName.

Any field which is not read-only (ReadOnly = false in the table below) can be inserted.

Delete

You must specify the Id in the WHERE clause when executing a delete against this table.

DELETE FROM Leads WHERE Id = '3152079000000153079'

Update

You must specify the Id in the WHERE clause when executing an update against this table.

UPDATE Leads SET Description = 'Changed from the API.' WHERE Id = '3152079000000488014'

Required fields: Id.

Any field which is not read-only (ReadOnly = false in the table below) can be updated.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False
LeadOwner_Id	String	False
LeadOwner_Name	String	False
FirstName	String	False
Salutation	String	False
Company	String	False
Title	String	False
LastName	String	False
FullName	String	False
Phone	String	False
Email	String	False
Mobile	String	False
Fax	String	False
LeadSource	String	False
Website	String	False
Industry	String	False
LeadStatus	String	False
EmailOptOut	Bool	False
No.ofEmployees	Int	False
AnnualRevenue	Decimal	False
ModifiedBy_Id	String	False
ModifiedBy_Name	String	False
Layout_Id	String	False
Layout_Name	String	False
Rating	String	False
Tag	String	False
CreatedBy_Id	String	False
CreatedBy_Name	String	False
SkypeID	String	False
CreatedTime	Datetime	False
SecondaryEmail	String	False
ModifiedTime	Datetime	False
Twitter	String	False
LastActivityTime	Datetime	False
UnsubscribedMode	String	True
ConvertedDateTime	Datetime	False
ConvertedAccount_Id	String	False
ConvertedAccount_Name	String	False
LeadConversionTime	Int	False
ConvertedDeal_Id	String	False
ConvertedDeal_Name	String	False
UnsubscribedTime	Datetime	True
RecordId	Long	True
ConvertedContact_Id	String	False
ConvertedContact_Name	String	False
LastEnrichedTime	Datetime	True
IsConverted	Bool	True
EnrichStatus	String	True
Locked	Bool	True
Street	String	False
City	String	False
State	String	False
ZipCode	String	False
Country	String	False
Description	String	False
LeadImage	String	False

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
DuplicateCheckFields	String	The field/s to be used for checking in an upsert.
CustomViewId	Long	The custom view Id to be used for filtering this record. Will work when useCOQL=false.
Trigger	String	To trigger the rule while inserting record into CRM account.

ODBC Driver for Zoho CRM