Products

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

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 Products(ProductName, ProductActive) VALUES('C-3PO', true)

Required fields: ProductName.

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

Update

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

UPDATE Products SET Description = 'Changed from the API.' WHERE Id = '3152079000000487023'

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	Id
ProductOwner_Id	String	False	ProductOwner Id
ProductOwner_FirstName	String	True	ProductOwner FirstName
ProductOwner_LastName	String	True	ProductOwner LastName
ProductOwner_Email	String	True	ProductOwner Email
ProductOwner_Name	String	True	ProductOwner Name
ProductName	String	False	ProductName
ProductCode	String	False	ProductCode
VendorName_Id	String	False	VendorName Id
VendorName_Name	String	True	VendorName Name
ProductActive	Bool	False	ProductActive
Manufacturer	String	False	Manufacturer
ProductCategory	String	False	ProductCategory
SalesStartDate	Date	False	SalesStartDate
SalesEndDate	Date	False	SalesEndDate
SupportStartDate	Date	False	SupportStartDate
SupportEndDate	Date	False	SupportEndDate
CreatedBy_Id	String	False	CreatedBy Id
CreatedBy_FirstName	String	True	CreatedBy FirstName
CreatedBy_LastName	String	True	CreatedBy LastName
CreatedBy_Email	String	True	CreatedBy Email
CreatedBy_Name	String	True	CreatedBy Name
ModifiedBy_Id	String	False	ModifiedBy Id
ModifiedBy_FirstName	String	True	ModifiedBy FirstName
ModifiedBy_LastName	String	True	ModifiedBy LastName
ModifiedBy_Email	String	True	ModifiedBy Email
ModifiedBy_Name	String	True	ModifiedBy Name
CreatedTime	Datetime	False	CreatedTime
ModifiedTime	Datetime	False	ModifiedTime
Tag	String	False	Tag
UnitPrice	Decimal	False	UnitPrice
CommissionRate	Decimal	False	CommissionRate
Tax	String	False	Tax
Taxable	Bool	False	Taxable
UsageUnit	String	False	UsageUnit
QtyOrdered	Double	False	QtyOrdered
QuantityinStock	Double	False	QuantityinStock
ReorderLevel	Double	False	ReorderLevel
Handler_Id	String	False	Handler Id
Handler_Name	String	True	Handler Name
QuantityinDemand	Double	False	QuantityinDemand
Description	String	False	Description
ProductImage	String	False	ProductImage
RecordId	Long	True	RecordId
Locked	Bool	True	Locked
LastActivityTime	Datetime	False	LastActivityTime

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 duplicate records in an upsert. The REST API allows for more than one field in the duplicate check but the BULK API only allows one field.
Trigger	String	To trigger the rule while inserting record into CRM account.
CustomViewId	Long	The custom view Id to be used for filtering this record. Will work when useCOQL=false.

MCP Server for Zoho CRM