Data Store - Mysql

Unlock the full potential of your data management with Flexito OmniAI's Data Store. Whether you're looking to manually update records or automate processes through Action steps, this guide will walk you through setting up and managing your data with ease and efficiency.

Flexito OmniAI's Data Store is an integrated data storage solution that simplifies managing your data. You can effortlessly add, delete, update, or verify your data manually or through Action steps.

How to Set Up Data Store

To create a new data store, navigate to your dashboard and follow steps 1 to 4.

1. Name the Data Store.

2. Click "+ Add Field" to open the configuration window.

3. Once completed, click "Save".

1. Enter a name for the field (no spaces allowed, used within the system).

2. Select a value type (Arrays can hold multiple values, similar to JSON variables).

3. Optionally, add a label for a more user-friendly display.

4. Optionally, set a default value.

5. When done, click "Save".

1. Click "Browse" to view and edit records.

2. Click the pencil icon to edit Data Store fields.

There are two methods to add, edit, or delete records in the data store:

• Manually in the "Browse" window, as shown in the image below.

• Automatically through Action steps, allowing the flow to handle the process.

Note: When a new record is added, the system automatically assigns it a unique "Record Id." This can be accessed using the field name "_id."

Manual Record Management

1. Add new records (see image below).

2. Edit or delete existing records.

3. Search for records.

When adding a new record, you must provide values for the fields defined in the data store (these can be left blank). The editing window includes a "Delete" button and resembles the interface shown above.

Managing Records via Action Steps

Within an Action step, follow steps 1 to 3 as shown in the image above. A list of available functions will then appear.

Tip: These functions operate through API calls. By providing inputs, you can retrieve outputs from the data store, which are then stored in custom fields for future use.

Warning: Familiarity with building flows and using variables is recommended before exploring the following functions. Refer to the links below for further guidance.

• [Flow Builder Overview]()

• [Variable Operation]()

Adding a Record

Updating a Record

Adding or Replacing a Record

Retrieving a Record

Checking if a Record Exists

Deleting a Record

Deleting All Records

Counting Records

Searching Records

Finding a Record

In Progress: A text tutorial for this page is currently being developed. Please check back soon for guidance. We apologise for any inconvenience.