ProductDetails
Retrieve the list of product details.
Table Specific Information
Select
This view returns a list of product details for the authenticated user.
The only filter supported by the PayPal API is ProductId. Server-side processing is only supported for the '=' operator.
The connector processes other filters client side within the connector.
For example, the following queries are processed server side.
SELECT * FROM ProductDetails SELECT * FROM ProductDetails WHERE ProductId = 'PP-D-12345'
Columns
| Name | Type | References | Description |
| ProductId [KEY] | String | The ID of the product. | |
| CreateTime | Datetime | The date and time when the product was created, in Internet date and time format. | |
| UpdateTime | Datetime | The date and time when the product was updated, in Internet date and time format. | |
| Description | String | The product description. | |
| Name | String | The product name. | |
| Type | String | The product type. Indicates whether the product is physical or digital goods, or a service.
The allowed values are PHYSICAL, DIGITAL, SERVICE. | |
| Category | String | The product category. | |
| ImageURL | String | The image URL for the product. | |
| HomeURL | String | The home URL for the product. |