CatalogTypeRetailItems
Get the items of the catalog of type RETAIL owned by the operation user_account
Table Specific Information
Select
The connector will use the Pinterest API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector. Country, Language, CatalogType, and RetailItemId are required columns to access this view.
- CatalogId supports the '=' operator.
- CatalogType supports the '=' operator.
- RetailItemId supports the '=' operator.
- Country supports the '=' operator.
- Language supports the '=' operator.
- AdAccountId supports the '=' operator.
Select * from CatalogTypeRetailItems where Country='US' AND Language='en-US' AND CatalogType = 'RETAIL' AND RetailItemId = '31176763998231,39870493392919,39870493458455'
Columns
| Name | Type | References | Description |
| RetailItemId | String | The catalog retail item id in the merchant namespace. | |
| CatalogType | String | Type of the catalog entity. | |
| CatalogId | String | Catalog id pertaining to the retail item. If not provided, default to oldest retail catalog. | |
| Country | String | Country ID from ISO 3166-1 alpha-2. | |
| Language | String | Catalog Language. | |
| AttributesAdditionalImagelink | String | The links to additional images for your product.Must start with http:// or https://. | |
| AttributesImageLink | String | The link to the main product images.Must start with http:// or https://. | |
| AttributesVideoLink | String | Hosted link to the product video. | |
| AttributesAdLink | String | Allows advertisers to specify a separate URL that can be used to track traffic coming from Pinterest shopping ads. Must send full URL including tracking—do not send tracking parameters only.Must start with http:// or https://. | |
| AttributesAdult | Boolean | Set this attribute to TRUE if you're submitting items that are considered “adult”. These will not be shown on Pinterest. | |
| AttributesAgeGroup | String | The age group to apply a demographic range to the product.
The allowed values are newborn, infant, toddler, kids, adult. | |
| AttributesAvailability | String | The availability of the product.
The allowed values are in stock, out of stock, preorder. | |
| AttributesAverageReviewRating | Integer | Average reviews for the item. Can be a number from 1-5. | |
| AttributesBrand | String | The brand of the product. | |
| AttributesColor | String | The primary color of the product. | |
| AttributesCondition | String | The condition of the product.
The allowed values are new, used, refurbished. | |
| AttributesCustomLabel0 | String | Custom grouping of products. | |
| AttributesCustomLabel1 | String | Custom grouping of products. | |
| AttributesCustomLabel2 | String | Custom grouping of products. | |
| AttributesCustomLabel3 | String | Custom grouping of products. | |
| AttributesCustomLabel4 | String | Custom grouping of products. | |
| AttributesCustomNumber0 | Long | An attribute for any integer information ranging from 0 to 4,294,967,295, which can be used to group items. | |
| AttributesCustomNumber1 | Long | An attribute for any integer information ranging from 0 to 4,294,967,295, which can be used to group items. | |
| AttributesCustomNumber2 | Long | An attribute for any integer information ranging from 0 to 4,294,967,295, which can be used to group items. | |
| AttributesCustomNumber3 | Long | An attribute for any integer information ranging from 0 to 4,294,967,295, which can be used to group items. | |
| AttributesCustomNumber4 | Long | An attribute for any integer information ranging from 0 to 4,294,967,295, which can be used to group items. | |
| AttributesDescription | String | The description of the product. | |
| AttributesFreeShippingLabel | Boolean | The item is free to ship. | |
| AttributesFreeShippingLimit | String | The minimum order purchase necessary for the customer to get free shipping.Only relevant if free shipping is offered. | |
| AttributesGender | String | The gender associated with the product.
The allowed values are male, female, unisex. | |
| AttributesGoogleProductCategory | String | The categorization of the product based on the standardized Google Product Taxonomy. | |
| AttributesGtin | Long | The unique universal product identifier. | |
| AttributesItemGroupId | String | The parent ID of the product. | |
| AttributesLastUpdatedTime | Datetime | The millisecond timestamp when the item was lastly modified by the merchant. | |
| AttributesLink | String | The landing page for the product. | |
| AttributesMaterial | String | The material used to make the product. | |
| AttributesMinAdPrice | String | The minimum advertised price of the product. | |
| AttributesMobileLink | String | The mobile-optimized version of your landing page. Must begin with http:// or https://. | |
| AttributesMpn | String | Manufacturer Part Number are alpha-numeric codes created by the manufacturer of a product to uniquely identify it among all products from the same manufacturer. | |
| AttributesNumberOfRatings | Integer | The number of ratings for the item. | |
| AttributesNumberOfReviews | Integer | The number of reviews available for the item. | |
| AttributesPattern | String | The description of the pattern used for the product. | |
| AttributesPrice | String | The price of the product. | |
| AttributesProductType | String | The categorization of your product based on your custom product taxonomy. | |
| AttributesSalePrice | String | The discounted price of the product. The sale_price must be lower than the price. | |
| AttributesShipping | String | Shipping consists of one group of up to four elements, country, region, service (all optional) and price (required). | |
| AttributesShippingHeight | String | The height of the package needed to ship the product. | |
| AttributesShippingWeight | String | The weight of the product. | |
| AttributesShippingWidth | String | The width of the package needed to ship the product. | |
| AttributesSize | String | The size of the product. | |
| AttributesSizeSystem | String | Indicates the country’s sizing system in which you are submitting your product.
The allowed values are US, UK, EU, DE, FR, JP, CN, IT, BR, MEX, AU. | |
| AttributesSizeType | String | Additional description for the size.
The allowed values are regular, petite, plus, big_and_tall, maternity. | |
| AttributesTax | String | Tax consists of one group of up to four elements, country, region, rate (all required) and tax_ship (optional). | |
| AttributesTitle | String | The name of the product. | |
| AttributesVariantNames | String | Options for this variant. People will see these options next to your Pin and can select the one they want. | |
| AttributesVariantValues | String | Option values for this variant. People will see these options next to your Pin and can select the one they want. List them in the order you want them displayed. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| AdAccountId | String | Unique identifier of an ad account. |