Tables
The connector models the data in Slack as a list of tables in a relational database that can be queried using standard SQL statements.
CData Power BI Connector for Slack Tables
| Name | Description |
| Bookmarks | Retrieves the list of bookmarks for the channel. |
| Calls | Register, update, or return information about a Call. |
| Channels | Create, update, and query the available channels in Slack. |
| ConversationMembers | Retrieve members of a conversation. |
| FeaturedWorkflows | Query, add, replace, and remove featured workflow triggers configured per channel in Slack. Each row represents a single (ChannelId, TriggerId) pairing. ChannelId is required on every operation. UPDATE on this table uses bulk-replace semantics: it replaces all featured workflows in the channel with the value of TriggerId (which may be a comma-separated list of up to 15 trigger Ids). |
| Files | Query and delete team files. |
| MessageReplies | Create, update, delete, and query threads of messages posted to a conversation. |
| Messages | Create, update, delete, and query the available messages in Slack. |
| Pins | Create, delete, and query all items pinned to a channel. |
| Reactions | Create, delete, and query reactions on items. |
| Reminders | Create, delete, and query all reminders by or for a given user. |
| ScheduledMessages | Query all scheduled messages. |
| SlackListItems | Query, create, update, and delete rows (items) within a Slack List. Each row in a Slack List is represented as an item whose cells correspond to the columns defined in that list's schema. The Fields column exposes the cells as JSON, since each list has a user-defined column shape. |
| SlackLists | Query, create, update, and delete Slack Lists. Slack Lists are structured data tables within a Slack workspace that let teams organize information (such as projects, tasks, requests, or any custom dataset) into rows and columns with typed fields like text, select, user, date, and to-do tracking. |
| UserGroups | Create, update, and query all User Groups for a Slack team. |
| UserProfile | Retrieve a user's profile information, including their custom status. This table supports only Select and Update operations. |
| Users | Update and query all users for a Slack team. |