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.

SSIS Components for Zoho CRM