Products

Retrieves the list of products, which are goods and services.

Table-Specific Information

This view returns a list of products for the authenticated user.

The only filter supported by the PayPal API is Id. Server-side processing is only supported for the '=' operator.

The provider processes all other filters client-side.

For example, the provider processes the following queries server-side.

SELECT * FROM Products
SELECT * FROM Products WHERE Id = 'PP-D-12345'

To insert a product, specify the Name column. You can optionally include other non-required columns. For example:

INSERT INTO Products (Name) VALUES ('Gaming Product')

To update a product, specify the Id in the WHERE clause. You can update any column that is not read-only. For example:

UPDATE Products SET Name = 'New Gaming Product' WHERE Id = 'PROD-09F625306742792Y'


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The ID of the product.
CreateTime	Datetime	True		The date and time when the product was created, in Internet date and time format.
Description	String	False		The product description.
Name	String	False		The product name.
Category	String	False		The product category.
Type	String	False		The product type. The allowed values are PHYSICAL, DIGITAL, SERVICE. The default value is PHYSICAL.
ImageUrl	String	False		The image URL for the product.
HomeUrl	String	False		The home page URL for the product.
UpdateTime	Datetime	True		The date and time when the product was last updated, in Internet date and time format.