Accounts

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

Table-Specific Information

Select

This table supports COQL for filtering, meaning that most filters comparing columns to values are submitted server-side. The rest of the filter is executed client-side within the component.

Insert

INSERT INTO Accounts(AccountName) VALUES('my name')

Required fields: AccountName.

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

Delete

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

DELETE FROM Accounts WHERE Id = '3152079000000153079'

Update

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

UPDATE Accounts SET Description = 'Updated from API' WHERE Id = '3152079000000153079'

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
AccountOwner_Id	String	False
AccountOwner_Name	String	False
Rating	String	False
AccountName	String	False
Phone	String	False
AccountSite	String	False
Fax	String	False
ParentAccount_Id	String	False
ParentAccount_Name	String	False
Website	String	False
AccountNumber	Long	False
TickerSymbol	String	False
AccountType	String	False
Ownership	String	False
Industry	String	False
Employees	Int	False
AnnualRevenue	Decimal	False
SICCode	Int	False
Tag	String	False
CreatedBy_Id	String	False
CreatedBy_Name	String	False
ModifiedBy_Id	String	False
ModifiedBy_Name	String	False
CreatedTime	Datetime	False
ModifiedTime	Datetime	False
LastActivityTime	Datetime	False
LastEnrichedTime	Datetime	True
EnrichStatus	String	True
Locked	Bool	True
BillingStreet	String	False
ShippingStreet	String	False
BillingCity	String	False
ShippingCity	String	False
BillingState	String	False
ShippingState	String	False
BillingCode	String	False
ShippingCode	String	False
BillingCountry	String	False
ShippingCountry	String	False
Description	String	False
AccountImage	String	False
Attachment	String	False
CF1	String	False

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	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.

SSIS Components for Zoho CRM