IGMedia
This View Represents an Instagram Photo, Video, Story, Album, or IGTV media.
Select
The add-in 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 add-in.
- 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. |