CData Python Connector for Zoho CRM

Build 24.0.9062

PriceBooks

Create, update, delete, and query information regarding price books. Not available in free and standard ZohoCRM accounts.

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 PriceBooks (PriceBookName, Active) VALUES ('pricebook_2018', true) 

Required fields: PriceBookName.

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 PriceBooks WHERE Id = '3152079000000153079'

Update

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

UPDATE PriceBooks SET Description = 'Changed from the API.' WHERE Id = '3152079000000488023'

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

PriceBookOwner_Id String False

PriceBookOwner_Name String False

PriceBookName String False

Active Bool False

CreatedBy_Id String False

CreatedBy_Name String False

PricingModel String False

ModifiedBy_Id String False

ModifiedBy_Name String False

CreatedTime Datetime False

ModifiedTime Datetime False

Tag String False

RecordId Long True

Locked Bool True

Description String False

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062