JDBC Driver for Instagram

Build 22.0.8462


Query media objects. Requires the instagram_basic and instagram_content_publish scopes.


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:


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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462