Pins
Get a Pin owned by the owned by the User or on a group board that has been shared with this account
Table Specific Information
Select
The connector will use the Pinterest API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- Id supports the '=' operator.
- BoardId supports the '=' operator.
- SectionId supports the '=' operator.
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.
使用できる値は次のとおりです。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. |