SSIS Components for Slack

Build 24.0.9060

Reactions

Create, delete, and query reactions on items.

Select

The component processes the filters client-side within the component.

SELECT * FROM Reactions 

SELECT * FROM Reactions WHERE Users = 'U046AV8HU3G'

SELECT * FROM Reactions WHERE Team = 'T046W75LRTK' 

SELECT * FROM Reactions WHERE Team = 'T046W75LRTK' AND Users = 'U046AV8HU3G' 

Insert

Inserts are allowed when you specify the ChannelId, Id, and Name. For example:

INSERT INTO Reactions (ChannelId, Id, Name) VALUES ('C04HBS2PS56', '1672114112.994259', 'raised_hands')

Update

Slack does not support UPDATE for reactions.

Delete

You can delete a reaction by providing the ChannelId, Id, and Name.

DELETE FROM Reactions WHERE Name = 'raised_hands' AND ChannelId = 'C04HBS2PS56' AND Id = '1672114112.994259'

Columns

Name Type ReadOnly Description
Id String False

The Id of the reacted item.

ChannelId String False

The ChanneldId where item is reacted

Type String True

The type of the reacted item.

Name String False

The name of the reaction

Count String True

The count of reactions on that message

Users String True

The encoded user id of the user who reacted to the message.

Team String True

The name of the reaction

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