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 connector will process a filter on CommentId server side and will execute other filters client-side within itself.

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