Work with data tables

AI-generated summary

Genesys Cloud provides a comprehensive data tables functionality that enables organizations to store and manage configuration data locally within the platform. The system supports up to 300 tables per organization, with each table capable of holding a maximum of 10,000 rows and 50 fields, though organizations requiring higher limits can request increased capacity through Genesys Cloud Customer Care. Data tables are designed exclusively for storing configuration data and explicitly prohibit the storage of personal or sensitive information that could identify individuals. Access to all table management operations is controlled through granular Architect permissions, with distinct Add, Delete, Edit, and View permissions applying to both data tables and individual rows. This permission structure ensures strict access controls across all operations. Core functionality includes comprehensive data management capabilities such as table creation with schema-defined row structures, row management for updating or deleting entries, and import/export features that support both data appending and replacement operations. The system maintains division-specific organization to preserve data structure integrity and includes activity tracking and error reporting for import operations. Reference keys are limited to and serve as unique identifiers for table rows, with optional descriptions enhancing data identification. Integration with third-party CRM systems is supported through external data mapping to Genesys Cloud queues via lookup operations within Architect flows. The Data Table Lookup action in Architect workflows facilitates seamless integration and provides superior data management capabilities compared to alternative approaches such as switch statements, particularly for larger datasets. However, data tables cannot be deleted if they are actively referenced in flows. The platform provides a user interface with Name, Reference Key Label, Description, and Division columns, along with View, Edit, and Delete buttons accessible on hover. Organizations can manage imports, export data, refresh tables, and add new entries through core operational functions. Additional documentation is available for reference table operations, import/export procedures, and decision table functionality

PrerequisitesClick to expand

All permissions under Architect > Datatable
All permissions under Architect > Datatable
To add a data table: Architect > Datatable – Add
To delete a data table: Architect > Datatable – Delete
To edit a data table: Architect > Datatable – Edit
To view a data table: Architect > Datatable – View
To add a data table row: Architect > Datatable Row – Add
To delete a data table row: Architect > Datatable Row – Delete
To edit a data table row: Architect > Datatable Row – Edit
To view a data table row: Architect > Datatable Row – View

Data tables allow you to store data locally and ensure that Architect can access it within an interaction.

Important: Data tables are intended for the use of configuration data. Data tables are not intended to contain personal information. Do not submit any information that could be used to identify a natural, living person, or any other sensitive or confidential information.

You can use data tables to access data sets larger than allowed by a switch statement. This feature is also useful when you combine Genesys Cloud with third-party integrations. Direct Genesys Cloud to look up the value returned from the CRM (customer relationship management) system to find the queue to which the interaction must transfer.

For example, you can map external data from a CRM system to a Genesys Cloud queue. After callers enter a flow, they enter an account number. The CRM system includes stored information that identifies the department within the organization best equipped to deal with this customer and, when the system receives the account number, it returns the department name.

Notes:

The number of data tables allowed in a single organization is 300.
The number of data rows allowed in a single table is 10000.
The number of fields allowed in a single table is 50.
The number of characters allowed in a single reference key is 256.
For more information about limitations and upgradeable fields, see Limits in the Developer Center.
To request a higher limit of data rows or an increased number of data tables, contact Genesys Cloud Customer Care.

Name		Description
Export Data		Export the data table rows.
Manage Imports		Import data table rows into an existing data table.
Delete		Delete one or more data tables. Note: You cannot delete a data table if it is used in a flow.
Refresh		Refresh the list of data tables.
Add		Create a new data table and add and configure custom fields for the table.
Name column		The links in this column represent the data table. To open the entry and view, edit, or delete fields associated with the table, click the desired link.
Reference Key Label column		Entries in this column describe the purpose or intent of the primary keys in each data table. Reference key labels uniquely identify each table row. For example, if your reference key label is “Street address,” then users know that the value to enter is a street address.
Description column		(Optional) Add descriptive information to the data table.
Division column		The division where the data table belongs.
		The View button appears when you hover over a data table row. Click this button or the data table’s name to view the table rows.
		The Edit button appears when you hover over a data table row. Click this button to edit the table, or to edit table rows.
		The Delete button appears when you hover over a data table row. Click this button to delete a table. To delete more tables at the same time, use the Delete button.

For more information about reference tables, see the tasks outlined in the following articles.

Task	Description
Create a data table	Create and configure a data table, adding a collection of rows whose structure that a data table schema defines.
Manage a data table	Update or delete a data table, and add, edit, or delete a table row.
Import or export data tables	Import or export a data table. Append or replace data during an import. View recent imports. View import errors.
Data Table Lookup action	Learn how you can use this action in an Architect flow.

[NEXT] Was this article helpful?

Get user feedback about articles.

Loading...

Work with data tables

[NEXT] Was this article helpful?