Pins
Get a Pin owned by the owned by the User or on a group board that has been shared with this account
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 | = |
| BoardId | = |
| SectionId | = |
| AdAccountId | = |
For example:
SELECT * FROM Pins WHERE Id = '3457832451'
SELECT * FROM Pins WHERE BoardId = '3457832451'
SELECT * FROM Pins WHERE AdAccountId = '549769357724'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the Pin. | |
| BoardId | String |
Boards.Id | The unique identifier of the board. |
| SectionId | String | The unique identifier of the section. | |
| AltText | String | The alt text for the Pin's image. | |
| BoardOwnerUsername | String | UserName of the BoardOwner. | |
| CreatedAt | Datetime | The date and time when the Pin was created. | |
| Description | String | Description of the Pin. | |
| Link | String | Link to the Pin. | |
| MediaType | String | MediaType of the Pin.
The allowed values are image, video, multiple_images, multiple_videos, multiple_mixed. | |
| Media | String | Media for the Pin. | |
| Title | String | Title of the Pin. | |
| PinMetrics | String | Pin metrics of the Pin. | |
| IsRemovable | Boolean | Indicates whether the Pin can be removed from a board. | |
| ProductTagsAggregate | String | The array of product tags of the Pin. | |
| CreativeType | String | The creative type of the ad associated with the Pin.
The allowed values are REGULAR, VIDEO, SHOPPING, CAROUSEL, MAX_VIDEO, COLLECTION, IDEA, SHOWCASE, QUIZ, COLLAGE, MAX_WIDTH_REGULAR_COLLECTION, MAX_WIDTH_VIDEO_COLLECTION. | |
| DominantColor | String | The dominant color present in the Pin's image. | |
| IsOwner | Boolean | Indicates whether the authenticated user account is the owner of this Pin. | |
| IsStandard | Boolean | Indicates whether this is a standard Pin. | |
| ParentPinId | String | The ID of the original Pin from which this Pin was saved, if applicable. | |
| HasBeenPromoted | Boolean | Indicates whether the Pin has been promoted. |
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, the Pin is returned for the owner of that ad account. Filter only. |