EditorialArticles
Get a list of published editorial articles for a given region. Translations are provided when available; otherwise the default language is English.
View-Specific Information
SELECT
The connector 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 connector.
Region is a required column to query this view.
| Column | Supported Operators |
| Region | = |
For example:
SELECT * FROM EditorialArticles WHERE Region = 'US'
Columns
| Name | Type | References | Description |
| Region | String | The geographic region of interest, formatted as ISO 3166-2 country codes delimited by '+' (for example US, GB+IE, CA). | |
| Title | String | Title of the editorial article. | |
| Description | String | Description of the editorial article. | |
| BoardUrl | String | URL of the editorial board. | |
| Interests | String | List of interests related to the editorial article. | |
| PinsUrl | String | URLs of the pins related to the editorial article. | |
| RelatedKeywords | String | List of keywords related to the editorial article. |