JDBC Driver for Instagram

Build 22.0.8462

Replies

Query and insert replies on a media object. Requires the instagram_basic and instagram_manage_comments scopes.

Only the select and insert operations are supported.

Select

The driver will process a filter on CommentId server side and will execute 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 returns replies from all comments in your account. UserId will be null if the reply is from an account that is not a business account.

    SELECT * FROM Replies

  • To query replies for a specific comment, CommentId is required. The supported operator for the CommentId column is =. For example:

    SELECT * FROM Replies WHERE CommentId = '1501471279105199430_5380790872'

Insert

Create a reply on a comment object with the following rules:

  • CommentId and Text are the only available and required fields.
  • The total length of the comment cannot exceed 300 characters.
  • The reply cannot contain more than 4 hashtags.
  • The reply cannot contain more than 1 URL.
  • The reply cannot consist of all capital letters.
For example:
INSERT INTO Replies (CommentId, Text) VALUES ('1501471279105199430_5380790872', 'My reply #instadevelopers')

Update

Update is not supported.

Delete

Delete is not supported.

Columns

Name Type ReadOnly Description
Id [KEY] String True

The unique identifier for the reply.

Username String True

The username for the user.

CommentId String False

The unique identifier for the comment.

Created Datetime True

The time when the reply was created.

UserId String True

The unique identifier for the user.

MediaId String True

The unique identifier for the associated media.

Text String False

The comment.

LikeCount Int True

The number of likes.

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