data_table_primary_values

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

Overview

Name	data_table_primary_values
Type	Resource
Id	aws.connect.data_table_primary_values

Fields

The following fields are returned by SELECT queries:

list_data_table_primary_values

Name	Datatype	Description
last_modified_region	string	The value's last modified region. (pattern: <code>[a-z]{2}(-[a-z]+){1,2}(-[0-9])?</code>)
last_modified_time	string (date-time)	The value's last modified time.
primary_values	array	The value's primary values.
record_id	string	The value's record ID.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_data_table_primary_values	select	instance_id, data_table_id, region	nextToken, maxResults	Lists all primary value combinations for a given data table. Returns the unique combinations of primary attribute values that identify records in the table. Up to 100 records are returned per request.
update_data_table_primary_values	update	instance_id, data_table_id, region, PrimaryValues, NewPrimaryValues, LockVersion		Updates the primary values for a record. This operation affects all existing values that are currently associated to the record and its primary values. Users that have restrictions on attributes and/or primary values are not authorized to use this endpoint. The combination of new primary values must be unique within the table.

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.

Name	Datatype	Description
data_table_id	string	The unique identifier for the data table. Must also accept the table ARN with or without a version alias. If the version is provided as part of the identifier or ARN, the version must be one of the two available system managed aliases, $SAVED or $LATEST.
instance_id	string	The unique identifier for the Amazon Connect instance.
region	string	AWS region (default: us-east-1)
maxResults	integer	The maximum number of data table primary values to return in one page of results.
nextToken	string	Specify the pagination token from a previous request to retrieve the next page of results.

SELECT examples

list_data_table_primary_values

Lists all primary value combinations for a given data table. Returns the unique combinations of primary attribute values that identify records in the table. Up to 100 records are returned per request.

SELECT
last_modified_region,
last_modified_time,
primary_values,
record_id
FROM aws.connect.data_table_primary_values
WHERE instance_id = '{{ instance_id }}' -- required
AND data_table_id = '{{ data_table_id }}' -- required
AND region = '{{ region }}' -- required
AND nextToken = '{{ nextToken }}'
AND maxResults = '{{ maxResults }}'
;

UPDATE examples

update_data_table_primary_values

Updates the primary values for a record. This operation affects all existing values that are currently associated to the record and its primary values. Users that have restrictions on attributes and/or primary values are not authorized to use this endpoint. The combination of new primary values must be unique within the table.

UPDATE aws.connect.data_table_primary_values
SET 
PrimaryValues = '{{ PrimaryValues }}',
NewPrimaryValues = '{{ NewPrimaryValues }}',
LockVersion = '{{ LockVersion }}'
WHERE 
instance_id = '{{ instance_id }}' --required
AND data_table_id = '{{ data_table_id }}' --required
AND region = '{{ region }}' --required
AND PrimaryValues = '{{ PrimaryValues }}' --required
AND NewPrimaryValues = '{{ NewPrimaryValues }}' --required
AND LockVersion = '{{ LockVersion }}' --required
RETURNING
lock_version;