FollowingBoards
Get a list of the boards a user follows.
Table Specific Information
Select
The connector uses 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.
- AdAccountID supports the '=' operator.
- ExplicitFollowing supports the '=' operator.
Select * from FollowingBoards Select * from FollowingBoards where AdAccountId = '547362621403' Select * from FollowingBoards where ExplicitFollowing = true
Columns
| Name | Type | References | Description |
| Id [KEY] | String | ID | |
| Name | String | Name | |
| Description | String | Description | |
| CreatedAt | Datetime | Date and time of board creation. | |
| BoardPinsModifiedAt | Datetime | Date and time of last board pins modified. | |
| CollaboratorCount | Integer | Count of collaborators on the board. | |
| PinCount | Integer | Count of pins on the board. | |
| FollowerCount | Integer | Board follower count. | |
| MediaImageCoverUrl | String | Board cover image. | |
| MediaPinThumbnailUrls | String | Board pin thumbnail urls. | |
| OwnerUsername | String | Owner Username. | |
| Privacy | String | Privacy setting for a board.Default - PUBLIC
使用できる値は次のとおりです。PUBLIC, PROTECTED, SECRET |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| ExplicitFollowing | Boolean | Whether or not to include implicit user follows, which means followees with board follows. | |
| AdAccountID | String | Unique identifier of an ad account. |