Data Views
What is a data view
Summary The platform does not require an off-line ETL process to extract data from the origins, but associated with the view, find a set of rules that the data engine interprets for check the source on demand or periodically, extract the data updated ...
Select data and headers
Summary Data views allow you to select the data and define the headers or titles that would be available in APIs methods. It is possible to make selections from the entire table, columns, column intersections and rows. In addition, it is possible to ...
Row limits in data views
The platform has the capacity to collect from the origins to 10,000 rows. This means that data views would show up to 10,000 rows. The line is in line with the definitions of other known databases and aims to ensure greater efficiency in loading time ...
Apply data formats in data view
Summary Data formats make it possible to modify the values of data view columns and configure when the content is JSON type. To apply a format you must select the option Configure data type and column format and you could select: The column on which ...
Add filters and parameters in data view
Summary Data views allow you to add fixed or dynamic filters, these are parameters. Fixed filters To add a filter you must click on the option Filter data. A form would be displayed where you should select the column on which the filter, the type of ...
Group and calculate data on columns
Summary Data views allow groupings and links on columns. Group data To group data you must select the option Group by columns You should select and add the columns on which the group would apply. Initial values would be grouped together. Once the ...
How to set up multi-environment in data views
Summary The platform makes it possible to configure multiple environments for APIs methods. Multi-environment is configured at the data view level. Different data sources that correspond to each environment can be selected in the data view. For ...
Add aliases in data view columns
Summary APIs method templates allow you to obtain the values of the data view columns by position or alias name. Here we explain how to configure the aliases of the data view columns. Add alias To add aliases to the data view columns you must select ...
Calculate values on rows
Summary It is possible to apply calculations and computations in the direction of the rows, that is, in the horizontal direction. To apply calculations you should select the option Calculate values on rows. Calculate data When selecting the ...
Popular Articles
How to create an application
Summary The application obtains the credentials that allow you to identify when consuming APIs. Create an application To create an application you must be registered and authenticated on the portal. Once authenticated, click Create application. ...
Platform IPs
If your data sources are protected and access limited by IP lists, you can add the following addresses so that the platform can access the sources: 20.102.116.145 52.146.3.80 52.146.3.26 20.232.188.143 20.169.239.2 20.169.231.134 The IP addresses of ...
User roles
Summary Vor-Tex uses the assignment of user roles so that account administrators can control what users can and cannot do. Roles Summary: Owner: Owns the account, has the permissions of the administrator role, and can also manage the account ...
Build and publish an API from scratch
Summary In this article you would find how to use the platform to build, publish and manage your first API. In order to follow these steps you need a data source. If not, you can use this example. Example In this article we will use an example from ...
Overview of the platform
Summary Vor-Tex is a non-code platform that allows you to build, publish, and manage APIs easily and simply. Using Vor-Tex does not require programming knowledge. With Vor-Tex, you can connect to data sources, transform and enrich data, build managed ...