JDBC Driver for Instagram

Build 23.0.8868

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.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8868