Use this form to define a query over an external datasource, e.g., a SQL database. Query results can be then visualized using templates or used in External Query Terms Filter aggregations in visualizations (which in turn create filters when clicked). Used in conjunction with the Kibi Query Viewer visualization, queries can be parametric and will be executed again on user clicks.
Config
Special placeholders for username, password and auth_token can be used in values of the headers, parameters and body.
They are respectively: ${username}, ${password}, ${auth_token}
Name
Value
Name
Value
Optional map of variable names to JSONPath expressions.
Variables can be used in:
Kibi Data Table visualisation
Kibi Query Viewer visualisation
External Query Terms aggregations
To know more about JSONPath operators and syntax, see here,
Below some examples of jsonpath expressions that use the following sample data: