Fields in Vizydrop denote either user-supplied fields or fields within an information schema. There are various types of fields that each represent a different type of data. Fields are also used internally to denote information both required and optional for accounts and filters.

Field Types

The table below lists the types of fields referred to in the Vizydrop app REST API. The first column denotes the string name of the type as expected in the API, the second column the type of underlying data, the third column any comments and remarks for each field type and the last one show additional options that may be specified.

typedatatypecomments and remarksAdditional options
textstringUTF-8 encoding-
numbernumbercan be decimal, integer, or float-
boolbooleanvalidates as true/false-
passwordstringonly used in account schemas, rendered as a password input-
link- (used for view)show link to external sourceNeed to specify "value" field. It should contain link, for example "http://test.com".
highlightTextstringtext with syntax highlight (json and sql supported for now)Need to specify "editorMode" field. For now "json" and "sql" are supported.
datedatedate selection-
oauth- (used for view)display Vizydrop Oauth form-
listvariantallows to select value from multiple optionsOptional "datalist_requires" can be specified. For example "datalist_requires" = ["owner"] means that fetching the list depends on "owner" field.
multidropdownArrayallows to select multiple values from dropdown listOptional "datalist_requires" can be specified. For example "datalist_requires" = ["owner"] means that fetching the list depends on "owner" field.

A Special Note on Dates

Dates, both with and without times, that are parsed as a result of user-input (through the Date range grammar) are timezone-naive objects. Dates received from connected applications may be either aware or naive of timezones and should represent those dates as strings in an ISO-8601 format.