IGMedia
Represents all media types published via an Instagram business account, including photos, videos, reels, stories, albums, and IGTV. This allows for querying and performance analysis at the media object level, requiring appropriate permissions based on media access.
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 | A unique identifier assigned to the media object by the system. This ID can be used to retrieve, reference, or manipulate the media through various Application Programming Interface (API) operations. |
| IGId | String | The Instagram-specific identifier for the media object. This ID is directly used within Instagram's ecosystem for identifying media content. |
| Caption | String | The textual description or commentary provided by the user when posting the media. This can include hashtags, mentions, and other user-generated content. |
| CommentsCount | Integer | The total number of comments posted on the media. This count includes only top-level comments and not replies to comments. |
| IsCommentEnabled | Boolean | A boolean flag indicating whether users are allowed to post comments on the media. This field excludes child items in album posts. |
| LikeCount | Integer | The total number of likes that the media has received. This metric reflects the audience engagement for the content. |
| MediaProductType | String | The publishing surface or product context of the media, such as feed, story, or reel, helps differentiate where the content was shared within Instagram. |
| MediaType | String | The type of media content, such as IMAGE, VIDEO, or CAROUSEL_ALBUM. This value determines the rendering and functionality of the media object. |
| MediaUrl | String | The direct Uniform Resource Locator (URL) to the actual media content (image or video). This link can be used for display or download purposes. |
| Owner | String | The unique identifier of the Instagram user who originally published the media. This value links to the user profile associated with the content. |
| PermanentURL | String | A stable, publicly accessible URL that leads directly to the media on Instagram. This link remains constant over time. |
| ShortCode | String | A short alphanumeric code used by Instagram to create a compact link to the media. It can be appended to Instagram URLs for direct access. |
| ThumbnailUrl | String | The URL of the thumbnail image generated for the media, typically used as a preview in listings or galleries. |
| Timestamp | Datetime | The Coordinated Universal Time (UTC) timestamp of when the media was created, formatted using ISO 8601. This is useful for chronological sorting and filtering. |
| Username | String | The Instagram handle (username) of the user who posted the media. This is the publicly visible account name. |
| InstagramBusinessAccountId | String | The unique identifier assigned to the Instagram Business Account associated with the media. This is used for account-level filtering or insights. |