CData Python Connector for Zoho CRM

Build 24.0.9060

Vendors

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

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 Vendors(VendorName, Email, Website) VALUES('XYZVendor', '[email protected]', 'vendeverything.xyz') 

Required fields: VendorName.

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

Update

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

UPDATE Vendors SET Description = 'Changed from the API' WHERE Id = '3152079000000492032'

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

The unique identifier for this record.

VendorOwner_Id String False

The Id of the owner of the vendor.

VendorOwner_FirstName String False

The First Name of the owner of the vendor.

VendorOwner_LastName String False

The Last Name of the owner of the vendor.

VendorName String False

The name of the vendor.

Phone String False

The phone number of the vendor.

Email String False

The email address of the vendor.

Website String False

The website of the vendor.

GLAccount String False

The GL account of the vendor.

Category String False

The category in which this vendor is placed at.

CreatedBy_Id String False

The Id of the User who created the record.

ModifiedBy_Id String False

The Id of the User who modified the record.

ModifiedBy_FirstName String False

The First Name of the User who modified the record.

ModifiedBy_LastName String False

The Last Name of the User who modified the record.

CreatedTime Datetime False

The time when the record was created.

ModifiedTime Datetime False

The time when the record was modified.

Tag String False

A list of tags related to this record.

Street String False

The street associated with this vendo's address.

City String False

The city associated with this vendo's address.

State String False

The state associated with this vendo's address.

ZipCode String False

The ZIP code associated with this vendo's address.

Country String False

The country associated with this vendo's address.

Description String False

A brief description regarding this vendor.

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.

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