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 本製品 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.
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. |