JDBC Driver for Instagram

Build 22.0.8462


This View Represents an Instagram Photo, Video, Story, Album, or IGTV media.


The driver will use the Instagram API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.

  • Id supports the '=' operator.
For example, the following query is processed server side:
 SELECT * FROM IGMedia WHERE Id = '1234'
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.


Name Type Description
Id [KEY] String Media ID.
IGId String Instagram media ID.
Caption String Caption for the IGMedia.
CommentsCount Integer Count of comments on the media.
IsCommentEnabled Boolean Indicates if comments are enabled or disabled. Excludes album children.
LikeCount Integer Count of likes on the media.
MediaProductType String Surface where the media is published.
MediaType String Media type.
MediaUrl String Media URL.
Owner String ID of Instagram user who created the media.
PermanentURL String Permanent URL to the media.
ShortCode String Shortcode to the media.
ThumbnailUrl String Media thumbnail URL.
Timestamp Datetime ISO 8601 formatted creation date in UTC.
Username String Username of user who created the media.
VideoTitle Datetime IGTV media title.

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