ProductGroups
Get a list of product groups for a given catalog feed owned by the operation user account.
View-Specific Information
SELECT
The add-in uses the Pinterest API to process WHERE clause conditions built with the following columns and operators. Any remaining filters are processed client-side within the add-in.
| Column | Supported Operators |
| Id | = |
| CatalogId | = |
| FeedId | = |
| AdAccountId | = |
For example:
SELECT * FROM ProductGroups
SELECT * FROM ProductGroups WHERE Id = '443727193917'
SELECT * FROM ProductGroups WHERE CatalogId = '2680059592705'
SELECT * FROM ProductGroups WHERE FeedId = '2680059592705'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | ID of the catalog product group. | |
| CatalogId | String |
Catalogs.Id | Catalog ID pertaining to the product group. |
| CatalogType | String | The catalog type of the product group.
The allowed values are RETAIL, HOTEL, CREATIVE_ASSETS. | |
| FeedId | String |
Feeds.Id | ID of the catalog feed belonging to this catalog product group. |
| Name | String | Name of the catalog product group. | |
| Description | String | Description of the catalog product group. | |
| Country | String | Country associated with the product group. | |
| Locale | String | Locale associated with the product group. | |
| Status | String | Status of the product group.
The allowed values are ACTIVE, INACTIVE. | |
| Type | String | Type of the catalog product group.
The allowed values are MERCHANT_CREATED, ALL_PRODUCTS, BEST_DEALS, PINNER_FAVORITES, TOP_SELLERS, BACK_IN_STOCK, NEW_ARRIVALS, SHOPIFY_COLLECTIONS, I2PC, CATALOG_EXPANSION. | |
| Filters | String | The filters used to define the product group. | |
| CreatedAt | Datetime | The time the catalog product group was created. Unix timestamp in seconds. | |
| UpdatedAt | Datetime | The time the catalog product group was last updated. Unix timestamp in seconds. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| AdAccountId | String | Unique identifier of an ad account, used for Business Access. |