Skip to main content

channels

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

Overview

Namechannels
TypeResource
Idaws.repostspace.channels

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
channel_descriptionstringA description for the channel. This is used only to help you identify this channel.
channel_idstringThe unique ID of the private re:Post channel.
channel_namestringThe name for the channel. This must be unique per private re:Post.
channel_rolesobjectThe channel roles associated to the users and groups of the channel.
channel_statusstringThe status pf the channel. (CREATED, CREATING, CREATE_FAILED, DELETED, DELETING, DELETE_FAILED)
create_date_timestring (date-time)The date when the channel was created.
delete_date_timestring (date-time)The date when the channel was deleted.
space_idstringThe unique ID of the private re:Post.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_channelselectspace_id, channel_id, regionDisplays information about a channel in a private re:Post.
list_channelsselectspace_id, regionnextToken, maxResultsReturns the list of channel within a private re:Post with some information about each channel.
create_channelinsertspace_id, region, channelNameCreates a channel in an AWS re:Post Private private re:Post.
update_channelupdatespace_id, channel_id, region, channelNameModifies an existing channel.
batch_add_channel_role_to_accessorsexecspace_id, channel_id, region, accessorIds, channelRoleAdd role to multiple users or groups in a private re:Post channel.
batch_remove_channel_role_from_accessorsexecspace_id, channel_id, region, accessorIds, channelRoleRemove a role from multiple users or groups in a private re:Post channel.

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
channel_idstringThe unique ID of the private re:Post channel.
regionstringAWS region (default: us-east-1)
space_idstringThe unique ID of the private re:Post.
maxResultsintegerThe maximum number of channels to include in the results.
nextTokenstringThe token for the next set of channel to return. You receive this token from a previous ListChannels operation.

SELECT examples

Displays information about a channel in a private re:Post.

SELECT
channel_description,
channel_id,
channel_name,
channel_roles,
channel_status,
create_date_time,
delete_date_time,
space_id
FROM aws.repostspace.channels
WHERE space_id = '{{ space_id }}' -- required
AND channel_id = '{{ channel_id }}' -- required
AND region = '{{ region }}' -- required
;

INSERT examples

Creates a channel in an AWS re:Post Private private re:Post.

INSERT INTO aws.repostspace.channels (
channelName,
channelDescription,
space_id,
region
)
SELECT
'{{ channelName }}' /* required */,
'{{ channelDescription }}',
'{{ space_id }}',
'{{ region }}'
RETURNING
channel_id
;

UPDATE examples

Modifies an existing channel.

UPDATE aws.repostspace.channels
SET
channelName = '{{ channelName }}',
channelDescription = '{{ channelDescription }}'
WHERE
space_id = '{{ space_id }}' --required
AND channel_id = '{{ channel_id }}' --required
AND region = '{{ region }}' --required
AND channelName = '{{ channelName }}' --required;

Lifecycle Methods

Add role to multiple users or groups in a private re:Post channel.

EXEC aws.repostspace.channels.batch_add_channel_role_to_accessors
@space_id='{{ space_id }}' --required,
@channel_id='{{ channel_id }}' --required,
@region='{{ region }}' --required
@@json=
'{
"accessorIds": "{{ accessorIds }}",
"channelRole": "{{ channelRole }}"
}'
;