SSIS Components for Instagram

Build 24.0.9060

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

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