Media
Query media objects. Requires the instagram_basic and instagram_content_publish scopes.
Select
The provider 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 | The unique identifier for the media object. |
| InstagramBusinessAccountId | String | The unique identifier of the Instagram business account Id. |
| Username | String | The username. |
| MediaType | String | The type of media (image or video or reels or carousel). |
| MediaProductType | String | The Surface where the media is published Can be AD, FEED, STORY or REELS. |
| Caption | String | The caption for the media. Excludes carousel children. |
| CommentsCount | Integer | The number of comments. |
| LikesCount | Integer | The number of likes. |
| Mediaurl | String | The video URL of the media. |
| Link | String | The link of the media. |
| Created | Datetime | The time when the media was created. |
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 earliest time for media object creation. |
| ToDateTime | Datetime | The latest time for media object creation. |