JDBC Driver for Instagram

Build 24.0.9062

Media

Query media objects. Requires the instagram_basic and instagram_content_publish scopes.

Select

The 本製品 will use the Instagram APIs to process filters by Id and will process other filters client-side within itself.

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 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.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
FromDateTime Datetime The earliest time for media object creation.
ToDateTime Datetime The latest time for media object creation.

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