Create a data table


Prerequisites
  • Architect > Data Table > All permission

Create data tables with custom fields that make up the data table schema. For more information about editing and deleting data tables and rows, see Manage a data table.

Notes:
  • You cannot create duplicate table names. For example, by creating a new table or renaming an existing table.
  • Table names cannot be longer than 256 characters, and cannot include the following special characters: / or \.
  • When you add field label information, PureCloud automatically populates the API Field ID, letting you know what field to use if you add data via the API.
  • After you save the data table, you cannot delete a custom field. You must either create a duplicate table with the fields and rows you want to keep, or simply ignore the field in the original data table.
  • After you create a data table, you cannot change the API value of custom fields. You can only change the labels.


  1. Click Admin.
  2. Under Architect, click Data Tables.
  3. Click Add .
  4. In the Name box, type a meaningful, unique name for the data table.
  5. (Optional) In the Notes box, enter any helpful information about the table.
  6. In the Reference Key Label box, add a descriptive name to describe the purpose or intent of the table’s primary key.[/bs_well]
  7. Click Add Field and select one of the following:
    • Boolean
    • Integer
    • Decimal
    • String
  8. To configure a Boolean, or check box, field, do the following:
    1. In the Field Label box, type a meaningful name for the field. 
    2. To ensure the field appears checked by default, select True by default.
    3. Repeat step 8 for each additional Boolean field to add.
  9. To configure an integer field, do the following:
    1. In the Field Label box, type a meaningful name for the field. 
    2. Enter a default value. 
    3. Repeat step 9 for each additional integer you want to add.
  10.  To configure a number, do the following:
    1. In the Field Label box, type a meaningful name for the field.
    2. Enter a default value. 
    3. Repeat step 10 for each additional number you want to add.
  11. To configure a string, do the following:
    1. In the Field Label box, type a meaningful name for the field.
    2. Type a default text value.
    3. Repeat step 11 for each additional text field you want to add.
  12. Click Save.


  1. Click Admin.
  2. Under Architect, click Data Tables.
  3. Next to the table you want to open, click More and from the menu that appears, click Open Table
  4. Click Add .
  5. Based on the reference key and custom fields you created for the data table, add the information to the fields for the table row.
  6. Click Save. Alternatively, to save this row and add another row, click Save and Add Another.