ODBC Driver for Instagram

Build 20.0.7654

Media

Query media objects. Requires the instagram_basic and instagram_content_publish scopes.

Select

The {i 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:

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).
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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654