Media
Offers a complete overview of all media objects published on an Instagram Business or Creator account, including images, videos, and carousel posts. It is essential for retrieving metadata such as captions, media types, timestamps, and permalinks. To access this information, the required permissions are instagram_basic and instagram_content_publish.
Select
The connector will use the Instagram APIs to process filters by Id and will process other filters client-side within itself.
The following query gets all media published by the authenticated user:
SELECT * FROM Media
To retrieve a single media object, the Id is required. The Id column supports the = operator. For example:
SELECT * FROM Media WHERE Id = '1501471279105199430_5380790872'
Columns
| Name | Type | Description |
| Id [KEY] | String | A system-generated unique identifier that distinguishes each individual media object posted by the Instagram business account. |
| InstagramBusinessAccountId | String | A globally unique identifier assigned to the Instagram business account that owns or published the media content. |
| Username | String | The handle or username of the Instagram business account that published the media. This is the public-facing account name. |
| MediaType | String | Indicates the format of the media, which can be image, video, reels, or carousel. This helps categorize the type of content for engagement analysis. |
| MediaProductType | String | Specifies the platform surface where the media was published. The possible values include AD, FEED, STORY, or REELS, representing different user experiences. |
| Caption | String | The text description or commentary included with the media post. This does not include captions from individual carousel child media items. |
| CommentsCount | Integer | The total number of comments received on the media post, providing a basic measure of user engagement and interaction. |
| LikesCount | Integer | The total number of likes the media post has received from users, reflecting its popularity or resonance. |
| Mediaurl | String | The direct Uniform Resource Locator (URL) to the video file or media asset, typically used to display or retrieve the actual content programmatically. |
| Link | String | The public-facing link to view the media post on Instagram. This URL can be shared or embedded. |
| Created | Datetime | The date and time in Coordinated Universal Time (UTC) when the media content was first published on Instagram. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| FromDateTime | Datetime | The start of the date-time range used to filter media records based on their creation timestamp. |
| ToDateTime | Datetime | The end of the date-time range used to filter media records based on their creation timestamp. |