Products

Get all products.

Select

The driver will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.

Id supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Products WHERE Id = 1

INSERT

Insert can be executed by specifying the Name column. The columns that are not required can be inserted optionally.

Insert into Products (Name) values ('My product name')

UPDATE

UPDATE can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

Update Products Set Name = 'Updated product name' where id=8

DELETE

Delete can be executed 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 in which theproduct 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	String	False		The category of the product.
Code	String	False		The code of the product.
CustomFields	String	True		The custom-fields for the product.
IsDeleted	Boolean	True		Is the product 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 in which the product was updated.
VisibleTo	Integer	False		The visibility of the product.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.

Build 25.0.9434