Cmdlets for Zoho CRM

Build 25.0.9434

Accounts

Manages account records representing companies or organizations, enabling comprehensive CRUD operations and advanced search.

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

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 True

Unique identifier for the account.

AccountOwner_Id String False

Identifier of the user who owns the account.

AccountOwner_FirstName String True

First name of the account owner.

AccountOwner_LastName String True

Last name of the account owner.

AccountOwner_Email String True

Email address of the account owner.

AccountOwner_Name String True

Full name of the account owner.

Rating String False

Internal rating given to the account.

AccountName String False

Name of the account or organization.

Phone String False

Phone number associated with the account.

Fax String False

Fax number associated with the account.

ParentAccount_Id String False

Identifier of the parent account, if the current account is part of a hierarchy.

ParentAccount_Name String True

Name of the parent account.

Website String False

Website URL of the account.

TickerSymbol String False

Stock ticker symbol for the organization.

AccountType String False

Type of account, such as customer, partner, or vendor.

Ownership String False

Ownership structure of the account, such as public or private.

Industry String False

Industry classification of the account.

Employees Int False

Number of employees in the organization.

AnnualRevenue Decimal False

Annual revenue generated by the organization.

SICCode Int False

Standard Industrial Classification (SIC) code for the account.

CreatedBy_Id String False

Identifier of the user who created the account record.

CreatedBy_FirstName String True

First name of the user who created the account.

CreatedBy_LastName String True

Last name of the user who created the account.

CreatedBy_Email String True

Email of the user who created the account.

CreatedBy_Name String True

Full name of the user who created the account.

ModifiedBy_Id String False

Identifier of the user who last modified the account.

ModifiedBy_FirstName String True

First name of the user who last modified the account.

ModifiedBy_LastName String True

Last name of the user who last modified the account.

ModifiedBy_Email String True

Email of the user who last modified the account.

ModifiedBy_Name String True

Full name of the user who last modified the account.

CreatedTime Datetime False

Timestamp when the account was created.

ModifiedTime Datetime False

Timestamp when the account was last modified.

LastActivityTime Datetime True

Timestamp of the last recorded activity for the account.

AccountNumber Long False

Unique number assigned to the account.

AccountSite String False

Physical or virtual site associated with the account.

Tag String False

Tags or labels applied to the account for categorization.

BillingStreet String False

Street address for billing.

ShippingStreet String False

Street address for shipping.

BillingCity String False

City for billing purposes.

ShippingCity String False

City for shipping purposes.

BillingState String False

State or region for billing.

ShippingState String False

State or region for shipping.

BillingCode String False

Postal or zip code for billing.

ShippingCode String False

Postal or zip code for shipping.

BillingCountry String False

Country for billing.

ShippingCountry String False

Country for shipping.

Description String False

Description or notes about the account.

AccountImage String False

Reference to an image associated with the account.

RecordId Long True

System-generated identifier for record tracking.

ChangeLogTime Datetime True

Time when the change log was last updated for this account.

Locked Bool True

Indicates whether the account is locked from editing.

LastEnrichedTime Datetime True

Time when the account was last enriched with external data.

EnrichStatus String True

Current enrichment status of the account data.

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

Fields used to identify duplicates during an upsert operation. The REST API supports multiple fields; the BULK API supports only one.

Trigger String

Used to activate automation rules when a new account record is inserted.

CustomViewId Long

Custom view identifier used to filter this record when the useCOQL parameter is set to false.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434