Products

Get all products.

Table-Specific Information

SELECT

The provider uses the Pipedrive API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.


Column	Supported Operators
Id	=

For example, the following query is processed server-side:

SELECT * FROM Products WHERE Id = 1

INSERT

Execute INSERT by specifying the Name column. You can also insert any optional columns. For example:

INSERT INTO Products (Name) VALUES ('My product name')

UPDATE

Execute UPDATE by specifying the Id in the WHERE clause. You can update any columns that are not read-only. For example:

UPDATE Products SET Name = 'Updated product name' WHERE Id = 8

DELETE

Execute DELETE by specifying the Id in the WHERE clause. For example:

DELETE FROM Products WHERE Id = 8

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the product.
Name	String	False		The name of the product.
Description	String	False		The description of the product.
PricesAggregate	String	False		Array of price details for the product.
Tax	Integer	False		The tax levied on the product.
Unit	String	False		The unit in which this product is sold.
AddTime	Datetime	True		The date-time at which the product was added.
BillingFrequency	String	False		The frequency of billing of the product.
BillingFrequencyCycles	Integer	False		The cycle of the billing frequency of the product.
Category	Integer	False		The category of the product.
Code	String	False		The code of the product.
CustomFields	String	False		The custom-fields for the product.
IsDeleted	Boolean	True		Indicates whether the product is deleted.
IsLinkable	Boolean	False		Whether this product can be added to a deal or not.
OwnerId	Integer	False		The Id of the owner of the product.
UpdateTime	Datetime	True		The date-time at which the product was updated.
VisibleTo	Integer	False		The visibility of the product.