Rooms
A Room resource represents a Programmable Video communication session among multiple endpoints using Twilio's Video SDKs. When listing Rooms, the API returns only Rooms with a status of in-progress.
Table-Specific Information
SELECT
The connector uses the Twilio API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the connector.
| Column | Supported Operators |
| Sid | = |
| UniqueName | = |
| Status | = |
| DateCreated | =, >, >=, <, <= |
For example:
SELECT * FROM Rooms WHERE Sid = 'RMabc123def456'
INSERT
INSERT INTO Rooms(UniqueName) VALUES ('MyRoom')
UPDATE
UPDATE Rooms SET Status = 'completed' WHERE Sid = 'RMabc123def456'
Columns
| Name | Type | ReadOnly | References | Description |
| Sid [KEY] | String | True |
The unique string that identifies the Room resource. | |
| AccountSid | String | True |
Accounts.Sid |
The SID of the Account that created the Room resource. |
| UniqueName | String | False |
An application-defined string that uniquely identifies the resource. SDK clients can use this name to connect to the room. | |
| Status | String | False |
The status of the room. Can be: in-progress, completed, or failed. The allowed values are in-progress, completed, failed. | |
| Type | String | False |
Type of room. Use group for new implementations. go, peer-to-peer, and group-small are deprecated. The allowed values are group, go, peer-to-peer, group-small. | |
| MaxParticipants | Integer | False |
The maximum number of concurrent Participants allowed in the room. The maximum allowed value is 50. | |
| MaxParticipantDuration | Integer | False |
The maximum number of seconds a Participant can be connected to the room. The maximum possible value is 86400 seconds (24 hours). | |
| MaxConcurrentPublishedTracks | Integer | True |
The maximum number of published audio, video, and data tracks all participants combined are allowed to publish in the room at the same time. | |
| Duration | Integer | True |
The duration of the room in seconds. | |
| MediaRegion | String | False |
The region for the Room's media server. | |
| AudioOnly | Boolean | False |
When set to true, indicates that the participants in the room will only publish audio. No video tracks will be allowed. | |
| LargeRoom | Boolean | False |
Indicates if this is a large room. | |
| EmptyRoomTimeout | Integer | False |
Specifies how long (in minutes) a room will remain active after the last participant leaves. Valid values range from 1 to 60 minutes. | |
| UnusedRoomTimeout | Integer | False |
Specifies how long (in minutes) a room will remain active if no one joins. Valid values range from 1 to 60 minutes. | |
| RecordParticipantsOnConnect | Boolean | False |
Whether to start recording when Participants connect. | |
| StatusCallback | String | False |
The URL Twilio calls to send status information to your application on every room event. | |
| StatusCallbackMethod | String | False |
The HTTP method Twilio uses to call status_callback. Can be POST or GET. The allowed values are GET, POST. | |
| VideoCodecs | String | False |
The video codecs supported when publishing a track in the room. Can be: VP8 and H264. Multiple values can be specified as a comma-separated list in INSERT statements (for example, VP8,H264). | |
| EnableTurn | Boolean | True |
Deprecated, now always considered to be true. | |
| EndTime | Datetime | True |
The UTC end time of the room in ISO 8601 format. | |
| DateCreated | Datetime | True |
The date and time in GMT when the resource was created specified in ISO 8601 format. | |
| DateUpdated | Datetime | True |
The date and time in GMT when the resource was last updated specified in ISO 8601 format. | |
| Url | String | True |
The absolute URL of the resource. | |
| LinksParticipants | String | True |
The URL of the Participants sub-resource for the room. | |
| LinksRecordings | String | True |
The URL of the Recordings sub-resource for the room. | |
| LinksRecordingRules | String | True |
The URL of the RecordingRules sub-resource for the room. | |
| LinksTranscriptions | String | True |
The URL of the Transcriptions sub-resource for the room. |
Pseudocolumns
Pseudocolumn fields can be used in SELECT, INSERT, and UPDATE statements to provide additional control over data retrieval and modification in the data source.
| Name | Type | Description |
| TranscribeParticipantsOnConnect | Boolean |
Whether to start real-time transcriptions when Participants connect. If TranscriptionsConfiguration is not provided, default settings will be used. Used in INSERT statements. |
| RecordingRules | String |
A JSON array of Recording Rules that describe how to include or exclude matching tracks for recording. Each rule specifies a type (include or exclude) and an all flag. Used in INSERT statements. |
| TranscriptionsConfiguration | String |
A JSON string with key-value configuration settings for the transcription engine (e.g. languageCode, speechModel, partialResults). Used when TranscribeParticipantsOnConnect is true. Used in INSERT statements. |