CatalogRetailReport
Get the retail catalog report
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.
- CatalogId supports the '=' operator.
- CatalogType supports the '=' operator.
- ReportType supports the '=' operator.
- FeedId supports the '=' operator.
- ProcessingResultId supports the '=' operator.
- AdAccountId supports the '=' operator.
Select * from CatalogRetailReport
Select * from CatalogRetailReport where CatalogId='4853306950123'
Select * from CatalogRetailReport where AdAccountId = '549768233165'
Select * from CatalogRetailReport where CatalogType = 'RETAIL'
Select * from CatalogRetailReport where ReportType='DISTRIBUTION_ISSUES'
Columns
| Name | Type | References | Description |
| CatalogId | String | Unique identifier of a catalog. | |
| CatalogName | String | CatalogName. | |
| DataSourceId | String | DataSourceId. | |
| DataSourceName | String | DataSourceName. | |
| ItemId | String | ItemId. | |
| Title | String | Title. | |
| IneligibleForOrganic | String | IneligibleForOrganic. | |
| IneligibleForAds | String | IneligibleForAds. | |
| CodeLabel | String | CodeLabel. | |
| Message | String | Message. | |
| Link | String | Link. | |
| ImageLink | String | ImageLink. | |
| Price | String | Price. | |
| Availability | String | Availability. |
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 | |
| CatalogType | String | Type of the catalog entity.
The allowed values are RETAIL, HOTEL, CREATIVE_ASSETS. | |
| ReportType | String | Report Type.
The allowed values are FEED_INGESTION_ISSUES, DISTRIBUTION_ISSUES, ALL_ITEMS. | |
| FeedId | String | ID of the feed entity. | |
| ProcessingResultId | String | Unique identifier of a feed processing result. | |
| AdAccountId | String | Unique identifier of an ad account. |