Select data and headers

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 select, edit or add headers.


Select data

When you create a data view, you would display the next screen. The first action to be taken is the selection of data.





To select the full table, you should click in the upper-left corner, as shown in the image.




If you want to select just a few columns, you should click on each of them. In addition, you can reorder the columns by clicking on the order you want.




Definition of headers or subjects

The definition of headers or subjects allows for:
  1. Isolate the titles or headers of the rest of the data.
  2. Availability of the titles or headers available in APIs method output templates.

If the data source reports the headers or subjects, you must click on the first row to apply the selection.




In addition to applying the selection, you could modify their names by double clicking on each of the subjects.




If the origin does not report the headers or titles and you want to add them, you can do so by using the second option and then by writing the corresponding items in each column.





    • Related Articles

    • 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 ...

    • 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 ...

    • 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 ...

    • Introduction to WorkSpace

      Summary Workspace is where owners, administrators, publishers, and editors access to manage APIs. In this section, you can find the workspace documentation. We suggest reading What are data resources. If you were unable to access it, please read ...