Tabular Views
Tabular Views are saved table layouts for viewing and editing Entity data. Each one lists the columns to show, and the Entities come from a DataLab query picked when the table is opened.
They are mostly opened through our Tabular View embed, a standalone table you can open on its own or embed in an iframe. Entity tables in Navigator and Operator also offer them as quick column selections.
This article will cover how to manage Tabular View records and descriptions about each column type.
Data model
Below is the core data model for a Tabular View. You can manage a record without populating the settings.
Columns
Every column has a name and a type. The type dictates what the column shows and which other settings are relevant.
Here is a small example with a name column, an editable attribute and the Entity's photos.
Columns: Calculation
A calculation column shows a value worked out per Entity, such as a colour, an icon or a progress bar, instead of a raw attribute.
Calculated settings use the same calculator as Entity Styles. Each one is an array of calculator items, and the first item that resolves with a value is applied. An item can be a fixed value, an attribute value, a gradient or a mapping. You can read about each item type in the Style calculator section.
Here is a progress bar column that fills by an inspection score out of 10, turning red below 4.
Requesting records
You can request a list of all Tabular Views or an individual one. Both include the settings JSON.
Get a list of Tabular Views
Get Tabular View by ID
Create and update records
You can create a record by performing a POST request to the same URL as the GET. If you specify the ID as '0' then it'll create a new record and return it. If you specify an existing ID then it'll update the record and return it.
When updating, only the properties you include are changed. Settings are replaced as a whole, so send every column rather than only the ones that changed.
Create or update Tabular View
Delete a record
We don't provide any bulk deletion but you can delete by record ID. Deleting an ID that does not exist still succeeds.