Comments

Create, delete, and query Comments on a media object. Requires the instagram_basic and instagram_manage_comments scopes.

Only the select, delete, and insert operations are supported.

Select

The connector will use the Instagram APIs to filter results by MediaId and will execute other filters client-side within itself.

The following query returns all comments on all media in your account. UserId will be null if the comment is from an account that is not a business account.
```
SELECT * FROM Comments
```
To query comments for a specific media object, MediaId is required. The MediaId column supports the = operator. For example:
```
SELECT * FROM Comments WHERE MediaId = '1501471279105199430_5380790872'
```

Insert

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

MediaId and Text are the only available and required fields.
The total length of the comment cannot exceed 300 characters.
The comment cannot contain more than 4 hashtags.
The comment cannot contain more than 1 URL.
The comment cannot consist of all capital letters.

For example:

INSERT INTO Comments (MediaId, Text) VALUES ('1501471279105199430_5380790872', 'My comment text #instadevelopers')

Update

UPDATE is not supported.

Delete

Id (the comment's primary key) is required. For example, the following query removes a comment either on the authenticated user's media object or authored by the authenticated user.

DELETE FROM Comments WHERE Id = '1668776136772254'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	The unique identifier for the comment.
Text	String	False	The text of the comment.
MediaId	String	False	The unique identifier for the media.
Created	Datetime	True	The time when the media was created.
UserId	String	True	The unique identifier for the user.
Username	String	True	The username for the user.
Likes	Int	True	The number of likes.
Hidden	Boolean	True	The boolean that shows if the comment is hidden.
InstagramBusinessAccountId	String	True	The unique identifier for the Instagram business account Id.