Skip to main content

rooms

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

Overview

Namerooms
TypeResource
Idazure.communication_rooms.rooms

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
createinsertendpointCreates a new room. Creates a new room.
updateupdateroom_id, endpointUpdate a room with given changes. Update a room with given changes.
deletedeleteroom_id, endpointDelete a room. Delete a room.
get_rawexecroom_id, endpointRetrieves an existing room by id. Retrieves an existing room by id.
list_rawexecendpointRetrieves all created rooms. Retrieves all created rooms.

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
endpointstringThe service endpoint host (no scheme), e.g. myaccount.table.cosmos.azure.com:443 - value of the client endpoint parameter. (default: )
room_idstringThe id of the room requested. Required.

INSERT examples

Creates a new room. Creates a new room.

INSERT INTO azure.communication_rooms.rooms (
endpoint
)
SELECT
'{{ endpoint }}'
;

UPDATE examples

Update a room with given changes. Update a room with given changes.

UPDATE azure.communication_rooms.rooms
SET
-- No updatable properties
WHERE
room_id = '{{ room_id }}' --required
AND endpoint = '{{ endpoint }}' --required;

DELETE examples

Delete a room. Delete a room.

DELETE FROM azure.communication_rooms.rooms
WHERE room_id = '{{ room_id }}' --required
AND endpoint = '{{ endpoint }}' --required
;

Lifecycle Methods

Retrieves an existing room by id. Retrieves an existing room by id.

EXEC azure.communication_rooms.rooms.get_raw 
@room_id='{{ room_id }}' --required,
@endpoint='{{ endpoint }}' --required
;