Skip to main content

rooms

Creates, updates, deletes, gets or lists a rooms resource.

Overview

Namerooms
TypeResource
Idaws.chime.rooms

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
account_idstringThe Amazon Chime account ID. (pattern: <code>.\S.</code>)
created_bystringThe identifier of the room creator. (pattern: <code>.\S.</code>)
created_timestampstring (date-time)The room creation timestamp, in ISO 8601 format.
namestringThe room name.
room_idstringThe room ID. (pattern: <code>.\S.</code>)
updated_timestampstring (date-time)The room update timestamp, in ISO 8601 format.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_roomselectaccount_id, room_id, regionRetrieves room details, such as the room name, for a room in an Amazon Chime Enterprise account.
list_roomsselectaccount_id, regionmember-id, max-results, next-tokenLists the room details for the specified Amazon Chime Enterprise account. Optionally, filter the results by a member ID (user ID or bot ID) to see a list of rooms that the member belongs to.
create_roominsertaccount_id, region, NameCreates a chat room for the specified Amazon Chime Enterprise account.
update_roomupdateaccount_id, room_id, regionUpdates room details, such as the room name, for a room in an Amazon Chime Enterprise account.
delete_roomdeleteaccount_id, room_id, regionDeletes a chat room in an Amazon Chime Enterprise account.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
account_idstringThe Amazon Chime account ID.
regionstringAWS region (default: us-east-1)
room_idstringThe chat room ID.
max-resultsintegerThe maximum number of results to return in a single call.
member-idstringThe member ID (user ID or bot ID).
next-tokenstringThe token to use to retrieve the next page of results.

SELECT examples

Retrieves room details, such as the room name, for a room in an Amazon Chime Enterprise account.

SELECT
account_id,
created_by,
created_timestamp,
name,
room_id,
updated_timestamp
FROM aws.chime.rooms
WHERE account_id = '{{ account_id }}' -- required
AND room_id = '{{ room_id }}' -- required
AND region = '{{ region }}' -- required
;

INSERT examples

Creates a chat room for the specified Amazon Chime Enterprise account.

INSERT INTO aws.chime.rooms (
Name,
ClientRequestToken,
account_id,
region
)
SELECT
'{{ Name }}' /* required */,
'{{ ClientRequestToken }}',
'{{ account_id }}',
'{{ region }}'
RETURNING
room
;

UPDATE examples

Updates room details, such as the room name, for a room in an Amazon Chime Enterprise account.

UPDATE aws.chime.rooms
SET
Name = '{{ Name }}'
WHERE
account_id = '{{ account_id }}' --required
AND room_id = '{{ room_id }}' --required
AND region = '{{ region }}' --required
RETURNING
room;

DELETE examples

Deletes a chat room in an Amazon Chime Enterprise account.

DELETE FROM aws.chime.rooms
WHERE account_id = '{{ account_id }}' --required
AND room_id = '{{ room_id }}' --required
AND region = '{{ region }}' --required
;