Rocket.Chat Connector Reference

The Rocket.Chat connector exposes 81 fields (10 metrics, 71 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Rocket.Chat Fields

Rocket.Chat channels fields

The channels report of the Rocket.Chat connector includes 17 fields.

ID	Type	Name	Description
channels___id	TEXT	channels._id	channels._id
channels___updatedat	TIMESTAMP	channels._updatedAt	channels._updatedAt
channels__broadcast	BOOLEAN	channels.broadcast	channels.broadcast
channels__default	BOOLEAN	channels.default	channels.default
channels__description	TEXT	channels.description	channels.description
channels__encrypted	BOOLEAN	channels.encrypted	channels.encrypted
channels__fname	TEXT	channels.fname	channels.fname
channels__msgs	NUMERIC	channels.msgs	channels.msgs
channels__name	TEXT	channels.name	channels.name
channels__ro	BOOLEAN	channels.ro	channels.ro
channels__sysmes	BOOLEAN	channels.sysMes	channels.sysMes
channels__t	TEXT	channels.t	channels.t
channels__teamid	TEXT	channels.teamId	channels.teamId
channels__teammain	BOOLEAN	channels.teamMain	channels.teamMain
channels__ts	TEXT	channels.ts	channels.ts
channels__u	OBJECT	channels.u	channels.u
channels__userscount	NUMERIC	channels.usersCount	channels.usersCount

Rocket.Chat roles fields

The roles report of the Rocket.Chat connector includes 6 fields.

ID	Type	Name	Description
roles___id	TEXT	roles._id	roles._id
roles__description	TEXT	roles.description	roles.description
roles__mandatory2fa	BOOLEAN	roles.mandatory2fa	roles.mandatory2fa
roles__name	TEXT	roles.name	roles.name
roles__protected	BOOLEAN	roles.protected	roles.protected
roles__scope	TEXT	roles.scope	roles.scope

Rocket.Chat rooms fields

The rooms report of the Rocket.Chat connector includes 19 fields.

ID	Type	Name	Description
rooms___id	TEXT	rooms._id	rooms._id
rooms___updatedat	TIMESTAMP	rooms._updatedAt	rooms._updatedAt
rooms__broadcast	BOOLEAN	rooms.broadcast	rooms.broadcast
rooms__customfields	OBJECT	rooms.customFields	rooms.customFields
rooms__default	BOOLEAN	rooms.default	rooms.default
rooms__description	TEXT	rooms.description	rooms.description
rooms__encrypted	BOOLEAN	rooms.encrypted	rooms.encrypted
rooms__federated	BOOLEAN	rooms.federated	rooms.federated
rooms__fname	TEXT	rooms.fname	rooms.fname
rooms__lastmessage	OBJECT	rooms.lastMessage	rooms.lastMessage
rooms__lm	TEXT	rooms.lm	rooms.lm
rooms__msgs	NUMERIC	rooms.msgs	rooms.msgs
rooms__name	TEXT	rooms.name	rooms.name
rooms__ro	BOOLEAN	rooms.ro	rooms.ro
rooms__sysmes	BOOLEAN	rooms.sysMes	rooms.sysMes
rooms__t	TEXT	rooms.t	rooms.t
rooms__ts	TEXT	rooms.ts	rooms.ts
rooms__u	OBJECT	rooms.u	rooms.u
rooms__userscount	NUMERIC	rooms.usersCount	rooms.usersCount

Rocket.Chat subscriptions fields

The subscriptions report of the Rocket.Chat connector includes 15 fields.

ID	Type	Name	Description
subscriptions___id	TEXT	subscriptions._id	subscriptions._id
subscriptions___updatedat	TIMESTAMP	subscriptions._updatedAt	subscriptions._updatedAt
subscriptions__alert	BOOLEAN	subscriptions.alert	subscriptions.alert
subscriptions__fname	TEXT	subscriptions.fname	subscriptions.fname
subscriptions__groupmentions	NUMERIC	subscriptions.groupMentions	subscriptions.groupMentions
subscriptions__ls	TEXT	subscriptions.ls	subscriptions.ls
subscriptions__name	TEXT	subscriptions.name	subscriptions.name
subscriptions__open	BOOLEAN	subscriptions.open	subscriptions.open
subscriptions__rid	TEXT	subscriptions.rid	subscriptions.rid
subscriptions__roles	OBJECT	subscriptions.roles	subscriptions.roles
subscriptions__t	TEXT	subscriptions.t	subscriptions.t
subscriptions__ts	TEXT	subscriptions.ts	subscriptions.ts
subscriptions__u	OBJECT	subscriptions.u	subscriptions.u
subscriptions__unread	NUMERIC	subscriptions.unread	subscriptions.unread
subscriptions__usermentions	NUMERIC	subscriptions.userMentions	subscriptions.userMentions

Rocket.Chat teams fields

The teams report of the Rocket.Chat connector includes 9 fields.

ID	Type	Name	Description
teams___id	TEXT	teams._id	teams._id
teams___updatedat	TIMESTAMP	teams._updatedAt	teams._updatedAt
teams__createdat	TIMESTAMP	teams.createdAt	teams.createdAt
teams__createdby	OBJECT	teams.createdBy	teams.createdBy
teams__name	TEXT	teams.name	teams.name
teams__numberofusers	NUMERIC	teams.numberOfUsers	teams.numberOfUsers
teams__roomid	TEXT	teams.roomId	teams.roomId
teams__rooms	NUMERIC	teams.rooms	teams.rooms
teams__type	NUMERIC	teams.type	teams.type

Rocket.Chat users fields

The users report of the Rocket.Chat connector includes 10 fields.

ID	Type	Name	Description
users___id	TEXT	users._id	users._id
users__active	BOOLEAN	users.active	users.active
users__emails	OBJECT	users.emails	users.emails
users__lastlogin	TEXT	users.lastLogin	users.lastLogin
users__name	TEXT	users.name	users.name
users__nameinsensitive	TEXT	users.nameInsensitive	users.nameInsensitive
users__roles	OBJECT	users.roles	users.roles
users__status	TEXT	users.status	users.status
users__type	TEXT	users.type	users.type
users__username	TEXT	users.username	users.username

Rocket.Chat other fields

The Rocket.Chat connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Report
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date