Media
Query media objects. Requires the instagram_basic and instagram_content_publish scopes.
Select
The driver will use the Instagram APIs to process filters by Id and will process other filters client-side within itself. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false, in which case any search criteria that refers to other columns will cause an error.
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. |