Managing Entities

Once your Entity is created, you can configure its fields and indexes, preprocess incoming data with the Schema Parser, and manage your data entries directly from the Admin or via the API.

Managing fields​

You can easily manage your fields by accessing the Fields tab within your Entity. Here, you have the option to add, edit, and remove fields.

Data types​

When adding new fields, you have several data types to choose from. It's important to note that once a field is created, its data type cannot be changed.

Indexing fields to improve searching and sorting​

In order to optimize search operations and determine the order of results, you can index your data. Indexes play a crucial role in improving database performance and are required for API and Analysis requests.

By default, every entity will have an index on the field id.

Adding new indexes​

To create a new index, go to the Fields tab and click the "+ Add Index" button. From this menu, you can select the fields you want to include in the index and assign it a name. Note that indexes cannot be edited once created, but they can be deleted and recreated if necessary.

Since you can add multiple fields to your index, the order of selection is crucial because sorting is only possible by the last field chosen. Additionally, some dashboard functionalities will automatically select the most appropriate index based on the filters applied, unless a specific index is explicitly designated.

Using Indexes​

When filtering data, you must provide all filters matching the index from left to right:

1. You don't need to use all fields in the index, but you must use them in order, starting from the leftmost field.
2. For example, if you have an index with fields (A, B, C):
   • You can filter using only field A.
   • You can filter using fields A and B.
   • You can filter using fields A, B, and C.
   • You cannot filter using only B, or B and C, without including A.

Preprocessing data before insertion​

Before storing data in your entity, you can preprocess it using the Schema Parser. This tool is especially beneficial for validating, normalizing, or transforming data before storage. The Schema Parser operates as a JavaScript code that executes during data insertion.

To activate it, go to the Schema Parser tab and toggle the "Enable" button. Once activated, you can begin writing your code.

Global Variables​

The following global variables are available in the Schema Parser:

Managing the data in your Entity​

Once the data is added to your Entity, you can easily manage it by viewing, filtering, inserting, editing, and deleting data entries. You can also manage your data through Analysis SDK or the TagoIO API.

Additionally, you can completely empty the data of your Entity by going to the More tab and clicking the "Empty Entity Data" button.

Best Practices when managing your data​

1. Regularly review and clean up outdated or invalid data.
2. Use Analysis scripts for bulk operations and complex data management tasks.
3. Implement robust validation in your Schema Parser to ensure data integrity.

The number of data entries available per entity is determined by your subscription plan. For more detailed information, please refer to the Limits and Restrictions section.

Limits and Restrictions​

The Entity has certain limits based on your TagoIO account plan. These limits apply to the number of entities, fields, indexes, and data entries you can create.

Entity operations are subject to the same rate limits (Requests Per Minute) as other mutable operations in your plan. For detailed information on these limits, please refer to the Rate Limits documentation.