Media
Query media objects. Requires the instagram_basic and instagram_content_publish scopes.
Select
The 本製品 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
FromDateTime | Datetime | The earliest time for media object creation. |
ToDateTime | Datetime | The latest time for media object creation. |