CatalogRetailReport
Returns the retail catalog processing report with status, run timestamps, item counts, and error summaries.
View-Specific Information
SELECT
The provider 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 provider.
| Column | Supported Operators |
| CatalogId | = |
| CatalogType | = |
| ReportType | = |
| FeedId | = |
| ProcessingResultId | = |
| AdAccountId | = |
For example:
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 more granular control over the data 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. |