Boards
Get a list of the boards owned by the User
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 |
| Id | = |
| Privacy | = |
| AdAccountId | = |
For example:
SELECT * FROM Boards WHERE Id = '345787634451'
SELECT * FROM Boards WHERE AdAccountId = '549769357724'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the board. | |
| Name | String | The name of the board. | |
| Description | String | The description of the board. | |
| OwnerUsername | String | UserName of the Owner. | |
| Privacy | String | Privacy setting for the board.
The allowed values are PUBLIC, PROTECTED, SECRET. | |
| MediaImageCoverUrl | String | Media image cover url for the board. | |
| MediaPinThumbnailUrls | String | Pin thumbnail urls for the board. | |
| PinCount | Integer | The number of pins on the board. | |
| FollowerCount | Integer | The number of users following the board. | |
| CollaboratorCount | Integer | The number of collaborators on the board. | |
| CreatedAt | Datetime | The date and time when the board was created. | |
| BoardPinsModifiedAt | Datetime | The date and time when the board's pins were last modified. | |
| IsAdsOnly | Boolean | Indicates whether the board is restricted to ad-only content. |
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. When specified, boards are returned for the owner of this ad account. Filter only. |