Overview
You can store data in Mirata Data Tables in the Admin Tool. Structure your data by defining schemas with fields and populating them with records. Add records manually or upload from a CSV, then filter, download, or delete records as needed to manage your information effectively.
You can easily configure forms to add/update data to these table or query these tables for data, but this article just covers the basics of Setting up a Data Table.
Define Data Table Schema
Create Data Table
Add Schema Fields
Define the columns for your data table by adding schema fields. Specify if each field is visible, editable, and required. Save the schema to finalize the table's structure.
Note: You should only edit the schema when the data table contains no records.
Populate Data Table
Add Single Record
Under the "Records" tab, you can add individual records to your data table by manually inputting data for each field. Assign a unique record key to identify each entry. Once added, the record appears in the data table and can be brought into forms, allowing you to begin working with your data.
Upload CSV Records
Add multiple records efficiently by uploading a CSV file. Select your CSV file and specify the column to use as the record key. The system imports the data, populating your table with the records from the CSV for quick bulk data loading.
Filter Data Table Records
Apply Record Filter
Narrow down the records displayed in your data table by applying filters. Add query parameters to search for specific data based on field values. Applying a filter updates the table to show only matching records.
Modify Data Table Records
Download Records
Create a backup or export your data table's contents by downloading it as a CSV file under the "Records" tab. This provides a copy of all records as a safeguard before making bulk changes.
Delete Single Record
Remove individual records from your data table directly from the records view. Deleting records is a permanent action. For tables with many records, consider bulk deletion methods for efficiency.
Delete All Records
Clear all records from your data table simultaneously using an integration action. Configure a 'delete data table records' action that queries for all records to execute a bulk deletion. Confirming this action removes every entry from the table.
The bottom screenshot depicts an integration action that can be imported into Mirata environments to delete all records of a specified data table.
Delete All Records
When using the 'delete data table records' integration action and setting the query to 'record key exists', it deletes all records in the table. Verify your filters to prevent unintended data removal.