JDBC Driver for Instagram

Build 24.0.9062

IGMedia

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

Select

The 本製品 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 本製品.

  • Id supports the '=' operator.
For example, the following query is processed server side:
 SELECT * FROM IGMedia WHERE Id = '1234'

Columns

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.
InstagramBusinessAccountId String The unique identifier for the Instagram business account Id.

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