IGMedia
This View Represents an Instagram Photo, Video, Story, Album, or IGTV media.
Select
The connector will use the Instagram API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- Id supports the '=' operator.
SELECT * FROM IGMedia WHERE Id = '1234'
Columns
| Name | Type | Description |
| Id [KEY] | String | Media ID. |
| IGId | String | Instagram media ID. |
| Caption | String | Caption for the IGMedia. |
| CommentsCount | Integer | Count of comments on the media. |
| IsCommentEnabled | Boolean | Indicates if comments are enabled or disabled. Excludes album children. |
| LikeCount | Integer | Count of likes on the media. |
| MediaProductType | String | Surface where the media is published. |
| MediaType | String | Media type. |
| MediaUrl | String | Media URL. |
| Owner | String | ID of Instagram user who created the media. |
| PermanentURL | String | Permanent URL to the media. |
| ShortCode | String | Shortcode to the media. |
| ThumbnailUrl | String | Media thumbnail URL. |
| Timestamp | Datetime | ISO 8601 formatted creation date in UTC. |
| Username | String | Username of user who created the media. |
| InstagramBusinessAccountId | String | The unique identifier for the Instagram business account Id. |