BizTalk Adapter for Slack

Build 20.0.7654

Users

Update and query all users for a Slack team.

Select

The {i uses the Slack API to process search criteria that refer to the Id column, while other filters are processed client-side within the {i. For example, the following query is processed server side:

SELECT * FROM Users WHERE Id = 'U5SU7GU6N'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Insert

Slack does not support inserting new users.

Update

You can update a user's FirstName, LastName, ProfileDisplayName, and ProfileEmail by providing the Id of the user. Only a team admin of a paid team can update another user's profile.

UPDATE Users Set ProfileDisplayName = 'Dis Name', ProfileEmail = 'test@company.com' where Id = 'U5SU7GU6N'

Delete

Slack does not support deleting users.

Columns

Name Type ReadOnly Description
Id [KEY] String True

The Id of the User.

FirstName String False

Fist name of the user.

LastName String False

Last name of the user.

FullName String True

Full name of the user.

ProfileDisplayName String False

Display name of the user.

ProfileEmail String False

Email of the user.

ProfileImage String True

URLs to square, web-viewable image of a user's profile.

Deleted Boolean True

Indicates if the user is deactivated.

TeamId String True

Id of the Slack team the user belongs to.

IsAdmin Boolean True

Indicates whether the user administers this team.

Color String True

A field used in some clients to display a colored username.

Timezone String True

String for the geographic region.

TimezoneLabel String True

String describing the name of that timezone.

TimezoneOffset Integer True

A signed integer indicating the number of seconds to offset UTC time by.

IsOwner Boolean True

Indicates whether this user is the owner of this team.

IsPrimaryOwner Boolean True

Indicates whether this user is the primary owner of this team.

IsRestricted Boolean True

Indicates whether this user is restricted from the team .

IsUltraRestricted Boolean True

Indicates whether this user is forbidden from the team.

Updated Datetime True

A datetime that shows when the user was last updated.

IsAppUser Boolean True

A boolean value indicating if the user uses the Slack App.

Has2fa Boolean True

A boolean value indicating if the user uses Two Factor Authentication.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654