Datastores
Store tabular information in Studio.
The datastore properties follow. See also View Data in the Datastore and Upload Data to the Datastore.
Name
Give the datastore a name.
Webhook URL
Type a Webhook URL to post transcription information to an external service such as a CMS (content management system).
Studio sends the following data to the Webhook URL.
-
Datastore ID
-
Row ID
-
Public URL of the audio file
-
Audio transcription text
Transcription Language
Select the expected spoken language. Studio transcribes caller audio into text.
Data Retention
Studio clears the datastore data after the selected time period. Periods range from one day to one year. Select Keep All to keep the data indefinitely.
Data is cleared overnight in the local time zone of the region/system. If the data retention period is one day then the data is retained for 24 hours and cleared the following night.
Structure
Assign to each column a name and data type.
The first column you define in the datastore is indexed.
Select Secure to encrypt values stored in the column. Encrypted values cannot be seen within Studio.
|
Data Type |
Description |
|---|---|
| String |
A string of characters used to represent text. The characters have no added meaning, so numeric 1 is treated the same as character A. |
| Integer |
Positive and negative numbers and zero without a fractional component. Values are not rounded. |
| Audio |
A data type that represents sound information, typically in the form of waveforms or digital audio files. You can upload files with extension mp3 or wav. The maximum upload size is 2MB. Select Transcribe Audio. This adds another column to the database, type string. The column name is the same as the audio column with suffix _transcription. The column stores a speech-to-text transcription of the captured audio. |
| Double |
A data type for floating-point numbers, it is precise to four decimal places and rounded. |
|
Date |
A data type that represents a calendar date, typically including the year, month, and day. The date is stored for comparison as YYYY-MM-DD. On download, the date format is YYYY-MM-DD. |
|
DateTime |
A data type that combines both date and time information. The date and time are stored for comparison as YYYY-MM-DD HH:MM:SS. On download, the date and time format is YYYY-MM-DD HH:MM:SS. |
|
Boolean |
A data type that represents a logical value, either true or false. When uploading data, only zero, empty string, and the “false” (case insensitive) string, translate to false. |
Refer to this table to differentiate integer from double data types.
|
Input |
Integer Data Type |
Double Data Type |
|---|---|---|
| 1 | 1 |
1 |
| -1 | -1 |
-1 |
| 0.1 | 0 |
0.1 |
| 1.2345678 | 1 |
1.2346 |
| 1234.01234 | 1234 |
1234.0123 |
| 1.99999 | 1 |
2 |
|
-1.99999 |
-1 |
-2 |