Publishers can also send one or more views for revision by publishers or administrators. Review the
Data view configuration
Selection of data
During the creation, users select the rows, columns or cells of a data source that would then be available in the creation of the API method.
To select the entire table you must click on the first cell in the table, the upper-left corner.
If you want to select or reorder some columns, you should click on each of them. You can also click on the rows to apply the selection.
The functionality of Selecting the headers of the table allows you to define what headers or subjects would be.
If the headers were informed at the data source, you could select the first row and edit their values if required.
If the headers were not informed at the data source, they could add them.
Add alias
Aliases make it possible to define custom names for columns, irrespective of the item or header.
You could then refer the columns of the data view in the templates of methods using their alias, rather than position.
Filter the data
If the data source does not contain pairs or mapping that have been inherited in the data view, or if it requires refining data filtering, you can add new filters to the data.
Filters can be static or dynamic.
To add a filter you must:
- Select the column you would apply to
- The type of operation (Same as, Not equal to, Contains any, etc.)
- Operating: Fixed value allows you to enter a fixed value by which to filter the data, without exposing this filter as a parameter of the method, whileParameterallows you to enter a name, description, default value and validation rules.
Configuration of data types and formats allows for transformations to column data.
To apply a format you should:
- Select the column.
- Define the type of data.
- Configure the format and patron of the origin, that is, what you see on screen.
- Configure the output format
Numbers
For number formats, you should consider:
- The format and patronage of the origin, indicate whether or not their data is decimal and which are the separators of thousands and decimal.
- The format and output patron, that is, he wants the data to be displayed.
- The location, where the separators of thousands and decimal separators would be applied as selected.
Dates
For date formats, you should consider:
- The format and patronage of the origin selected some of those available or entered a custom format.
- The format and output patron, that is, he wants the data to be displayed.
JSON
If the cells in the column contain a JSON object, you should apply the JSON format to the column containing them. If it does not, the contents of the cell would be treated as text instead of a JSON object.
Group by columns
The functionality of Group by columns allows aggregations of unique values from one or more columns, and calculations (AVG, SUM, COUNT).
To carry out groupings you should:
- Select the columns on which to apply the group, and click Done.
- The option ofCalculate aggregate values on columns where you could define Operation (Count, Sum, Average), select the column on which to apply the operation and enter a column name. You can make calculations on multiple columns.
Calculate values on rows
The functionality of Calculate values on rows allows the application of circles horizontally, i.e. in the direction of rows.
To carry out groupings you should:
- Select operation: sum, subtraction or divide.
- Select the first column of the operation.
- Select the second column of the operation.
Vertical search
The functionality of Vertical search allows you to add a new column in the current view by searching for data in another data view. This functionality is similar to Excel XLookUp.
To apply a vertical search you should:
- Select the data view you want to relate.
- Select the column to search for identifiers matching the current data view.
- Select match operation.
- Select the column from search date.
- Select the column with value to be returned in case of coincidence