Dataset

1. Access Technology > Administration > Dataset > New dataset;
2. Enter the data to identify the Dataset and clickVisual editor for settings;
3. Add the tables. When more than one table is selected, the optionExpressions... is available for inclusion of the fields responsible for theJoin in the Dataset;
4. Choose the data inProjection and, optionally, determine the grouping, ordering and filtering of table fields;
5. click inTo save.

When adding a Dataset, the resource res://<tenant-domain>/custom/dataset/<dataset-id>, which is linked only to your user. To share it, you must add permission for this resource, for each desired role, including administrator.

1. Access the menu Technology > Administration > Dataset > New dataset;
2. Enter the Name and Description to identify the dataset;
3. Then select API mode;
4. Enter the HTTP method, API URL and Authentication in the Dataset Settings;
5. The API Return must be selected according to the data returned from the call, if it is in JSON format it is necessary to inform the API return property, if the return is in CSV it is necessary to inform the data delimiter;
6. In the Body of the Request, enter the input parameters required to execute the API;
7. In Request Headers it is possible to enter Authorization, Content-Type and Tenant automatically or include new ones manually;
8. In Projection it is possible to configure automatically, based on the dataset return, or manually the information;
9. Click Save.

At any time you can clickTo view To see a preview of the dataset, you can also click onCancel to discard the changes.

Go to Technology > Administration > Dataset > New dataset, enter the data to identify the Dataset. click inSQL Editor, build the SQL as needed and clickTo save.

When adding a Dataset, the resource res://<tenant-domain>/custom/dataset/<dataset-id>, which is linked only to your user. To share it, you must add permission for this resource, for each desired role, including administrator.

Editing and deleting a Dataset must be done in Technology > Administration > Dataset > Manage.

click inTo edit in the created Dataset, make the necessary changes and clickTo save, or, to delete, click Delete.