TeamBillableInfo
Returns per-user billing eligibility under Slack's Fair Billing policy for the current team.
View-Specific Information
SELECT
The provider uses the Slack API to process search criteria that refer to the UserId column. This column supports server-side processing for the = and IN operators. The provider processes other filters client-side within the provider.
The TeamBillableInfo view exposes a TeamId pseudocolumn for use with org-level tokens. When you connect with an org-level token, supply TeamId in the WHERE clause to target a specific workspace. The value is ignored when the API call is sent using a workspace-level token.
For example, the following queries are processed server side by the Slack APIs:
SELECT * FROM TeamBillableInfo
SELECT * FROM TeamBillableInfo WHERE UserId = 'U01KZFNNTPC'
SELECT * FROM TeamBillableInfo WHERE UserId IN ('U01KZFNNTPC','U04QTH44D9S')
SELECT * FROM TeamBillableInfo WHERE TeamId = 'T01LC4ASB2M'
Columns
| Name | Type | References | Description |
| UserId [KEY] | String | The Id of the user. | |
| IsBillingActive | Boolean | Indicates whether the user is subject to billing under Slack's Fair Billing policy. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| TeamId | String | The Id of the team. This field is only relevant when using an org-level token; the API call ignores it when sent using a workspace-level token. |