Media

Query media objects. Requires the instagram_basic and instagram_content_publish scopes.

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'


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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
FromDateTime	Datetime	The earliest time for media object creation.
ToDateTime	Datetime	The latest time for media object creation.