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 | = |
For example:
SELECT * FROM Pins WHERE Id = '3457832451'
SELECT * FROM Pins WHERE BoardId = '3457832451'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Id of the Pin | |
| BoardId | String |
Boards.Id | Id of the Board |
| SectionId | String | Id of the Section | |
| AltText | String | AltText | |
| BoardOwnerUsername | String | UserName of the BoardOwner. | |
| CreatedAt | Datetime | Created At Date Time | |
| 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 | If the pin is removable. | |
| ProductTagsAggregate | String | The array of product tags of the Pin. | |
| CreativeType | String | Ad creative type enum.
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 | Dominant pin color. | |
| IsOwner | Boolean | Whether the operation user_account is the Pin owner. | |
| IsStandard | Boolean | Whether the Pin is standard or not. | |
| ParentPinId | String | The source pin id if this pin was saved from another pin. |