Returns all variations for a given product, including variant names and their associated pricing data.

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.

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

SELECT * FROM ProductVariations WHERE ProductId = 1        

INSERT

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

INSERT INTO ProductVariations (Name, ProductId) VALUES ('product var', 1)

UPDATE

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

UPDATE ProductVariations SET Name = 'updated product var' WHERE Id = 2 AND ProductId = 1

DELETE

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

DELETE FROM ProductVariations WHERE Id = 2 AND ProductId = 1

Columns