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

Select

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.

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.
VideoTitle	Datetime	IGTV media title.