[Index]
Data model for dashboard column chart widget.
Model ref.: data/DashboardWidgetChartColumn
The full URL would include the host-proxy name: https://[host-proxy].
Variables are enclosed in square brackets.
{
"$schema": "http://json-schema.org/draft-03/schema",
"type": "object",
"properties": {
"title": {
"title": "Title",
"description": "The title to be displayed for this widget.",
"type": "string",
"required": true
},
"description": {
"title": "Description",
"description": "Provide a useful description for this widget.",
"type": "string"
},
"condition": {
"title": "Condition",
"description": "Only show this widget if this condition evaluates to true.",
"type": "string",
"required": false,
"readonly": false,
"displayable": true
},
"resource": {
"title": "Resource",
"description": "Specify resource",
"type": "string",
"format": "uri",
"target": "/api/data/ReporterResource/choices/?field=name&format=json&hierarchy=[hierarchy]&auth_token=[authtoken],
"target_attr": "name",
"target_model_type": "data/ReporterResource",
"choices": []
},
"datasource": {
"title": "Data Source",
"description": "The source from which the data for this column chart is obtained.",
"type": "string",
"default": "LXT0"
},
"datasourceInstance": {
"title": "Data Source Instance",
"description": "Specify Data Source Instance",
"type": "string",
"format": "uri",
"target": "/api/data/DashboardDatasource/choices/?format=json&hierarchy=[hierarchy]&auth_token=[authtoken],
"target_model_type": "data/DashboardDatasource",
"choices": []
},
"allowDatasourceSelection": {
"title": "Allow Data Source Selection on Dashboard",
"description": "Specify that the Data Source Instance can be modified on Dashboard.",
"type": "boolean",
"default": true
},
"resource_definition": {
"title": "Resource Definition",
"description": "Returns the resource definitions",
"type": "string"
},
"_lowerTs": {
"title": "Start Timestamp",
"description": "Lower timestamp bound for the data range shown in the chart",
"type": "integer"
},
"_upperTs": {
"title": "End Timestamp",
"description": "Upper timestamp bound for the data range shown in the chart",
"type": "integer"
},
"_outputType": {
"title": "Output Type",
"description": "The format in which the data will be presented in the chart",
"type": "string",
"default": "highcharts",
"choices": [
{
"value": "raw",
"title": "Raw"
},
{
"value": "highcharts",
"title": "Highcharts"
}
]
},
"_groupingLimit": {
"title": "Series Limit",
"description": "The maximum number of groups to display on the chart",
"type": "string",
"default": "0",
"choices": [
{
"value": "0",
"title": "All"
},
{
"value": "1",
"title": "1"
},
{
"value": "2",
"title": "2"
},
{
"value": "3",
"title": "3"
},
{
"value": "4",
"title": "4"
},
{
"value": "5",
"title": "5"
},
{
"value": "6",
"title": "6"
},
{
"value": "7",
"title": "7"
},
{
"value": "8",
"title": "8"
},
{
"value": "9",
"title": "9"
},
{
"value": "10",
"title": "10"
},
{
"value": "15",
"title": "15"
},
{
"value": "20",
"title": "20"
},
{
"value": "25",
"title": "25"
},
{
"value": "30",
"title": "30"
},
{
"value": "40",
"title": "40"
},
{
"value": "50",
"title": "50"
},
{
"value": "60",
"title": "60"
},
{
"value": "70",
"title": "70"
},
{
"value": "80",
"title": "80"
},
{
"value": "90",
"title": "90"
},
{
"value": "100",
"title": "100"
},
{
"value": "200",
"title": "200"
},
{
"value": "300",
"title": "300"
},
{
"value": "400",
"title": "400"
},
{
"value": "500",
"title": "500"
},
{
"value": "1000",
"title": "1000"
},
{
"value": "10000",
"title": "10000"
},
{
"value": "50000",
"title": "50000"
},
{
"value": "100000",
"title": "100000"
}
]
},
"interval": {
"title": "Interval",
"description": "The time range over which the chart is presented.",
"type": "integer",
"default": 3,
"choices": [
{
"value": 6,
"title": "Per Second"
},
{
"value": 5,
"title": "Per Minute"
},
{
"value": 4,
"title": "Hourly"
},
{
"value": 3,
"title": "Daily"
},
{
"value": 2,
"title": "Weekly"
},
{
"value": 1,
"title": "Monthly"
}
]
},
"type": {
"title": "Type",
"description": "The chart type.",
"type": "integer",
"default": 1,
"choices": [
{
"value": 0,
"title": "Line"
},
{
"value": 1,
"title": "Column"
},
{
"value": 2,
"title": "Pie"
},
{
"value": 3,
"title": "Gauge"
},
{
"value": 7,
"title": "Counters"
},
{
"value": 16,
"title": "Table"
}
]
},
"fields": {
"title": "Fields",
"description": "Specify the fields from the resource to be used in the chart.",
"type": "array",
"items": {
"type": "object",
"properties": {
"guid": {
"title": "GUID",
"description": "Unique identifier for the field.",
"type": "string"
},
"ruleName": {
"title": "Field Name",
"description": "This is the field name.",
"type": "string",
"choices": []
},
"headerName": {
"title": "Friendly Name",
"description": "Specify a friendly name to be used in the chart.",
"type": "string"
},
"ruleTypeString": {
"title": "Field Type",
"description": "This is the field type",
"type": "string",
"readonly": true
},
"ruleType": {
"title": "Field Type",
"description": "This is the field type",
"type": "integer"
},
"valueType": {
"title": "Value Type",
"description": "This is the operation value type",
"type": "integer"
},
"operation": {
"title": "Operation",
"description": "Select the operation to be performed on the field.",
"type": "string",
"choices": []
},
"value_mapping": {
"title": "Value Mapping",
"description": "Select the value mapping to display user-friendly values. This will override the resource value mapping if one exists. To use the raw value, select 'NO MAPPING'.",
"type": "string"
}
}
}
},
"filters": {
"title": "Filters",
"description": "Specify filters to be applied to the data.",
"type": "array",
"items": {
"type": "object",
"properties": {
"guid": {
"title": "GUID",
"description": "Unique identifier for the filter field.",
"type": "string"
},
"ruleName": {
"title": "Field Name",
"description": "Specify Field Name",
"type": "string",
"choices": []
},
"operation": {
"title": "Operation",
"description": "Specify operation",
"type": "string",
"choices": []
},
"filterValue": {
"title": "Filter Value",
"description": "Specify filter value",
"type": "string"
},
"ignore_case": {
"title": "Ignore Case",
"type": "boolean",
"required": false,
"readonly": false
},
"type": {
"title": "Filter Type",
"description": "Specify type",
"type": "integer"
}
}
}
},
"sorts": {
"title": "Sorts",
"description": "Specify sorts to be applied to the fields.",
"type": "array",
"items": {
"type": "object",
"properties": {
"guid": {
"title": "GUID",
"description": "Unique identifier for the sort field.",
"type": "string"
},
"ruleName": {
"title": "Field Name",
"description": "Select the field name to sort by.",
"type": "string",
"choices": []
},
"sort": {
"title": "Sort Type",
"description": "Select the sort type",
"type": "integer",
"choices": [
{
"value": 0,
"title": "Ascending"
},
{
"value": 1,
"title": "Descending"
}
]
}
}
}
},
"settings": {
"title": "Chart Settings",
"description": "Chart Settings",
"type": "object",
"properties": {
"xtitle": {
"title": "X Title",
"description": "Specify xtitle",
"type": "string"
},
"ytitle": {
"title": "Y Title",
"description": "Specify ytitle",
"type": "string"
},
"stackType": {
"title": "Stack Type",
"description": "Specify stackType",
"type": "integer",
"default": 0,
"choices": [
{
"value": 0,
"title": "None"
},
{
"value": 1,
"title": "Normal"
},
{
"value": 2,
"title": "Percentage"
}
]
},
"axisXType": {
"title": "Axis X Type",
"description": "Specify axisXType",
"type": "integer",
"default": 0,
"choices": [
{
"value": 0,
"title": "Category"
},
{
"value": 1,
"title": "Date Time"
}
]
},
"numericPrecision": {
"title": "Numeric Precision",
"description": "Specify numericPrecision",
"type": "integer",
"default": 2
},
"isHorizontal": {
"title": "Is Horizontal",
"description": "Specify isHorizontal",
"type": "boolean"
},
"is3d": {
"title": "Is 3D",
"description": "Specify is 3D",
"type": "boolean"
},
"overTime": {
"title": "Over Time",
"description": "Specify overTime",
"type": "boolean"
},
"showLabels": {
"title": "Show Labels",
"description": "Specify showLabels",
"type": "boolean"
},
"showLegend": {
"title": "Show Legend",
"description": "Specify showLegend",
"type": "boolean"
},
"legendPlacement": {
"title": "Legend Placement",
"description": "Specify legendPlacement",
"type": "string",
"required": true,
"default": "bottom",
"choices": [
{
"value": "top",
"title": "Top"
},
{
"value": "bottom",
"title": "Bottom"
},
{
"value": "left",
"title": "Left"
},
{
"value": "right",
"title": "Right"
}
]
},
"defaultValue": {
"title": "Default Text",
"description": "Specify the default text to be displayed when no data is available.",
"type": "string"
},
"emptyGroupText": {
"title": "Empty Group Text",
"description": "Text will be used when group name is empty.",
"type": "string"
}
}
},
"drilldowns": {
"title": "Drilldown Settings",
"description": "Drilldown Settings",
"type": "object",
"properties": {
"filterOption": {
"title": "Filter Options",
"description": "Specify Filter option",
"type": "string",
"default": "IN",
"choices": [
{
"value": "IN",
"title": "IN"
},
{
"value": "REGEX",
"title": "REGEX"
}
]
},
"drilldownOption": {
"title": "Drilldown Options",
"description": "Specify Drilldown option",
"type": "integer",
"default": "0",
"choices": [
{
"value": 0,
"title": "None"
},
{
"value": 1,
"title": "Filter Other Widgets"
},
{
"value": 2,
"title": "Link to Another Dashboard"
},
{
"value": 4,
"title": "Launch Third-Party URL"
},
{
"value": 5,
"title": "Conditional Drilldown"
}
]
},
"dashboardId": {
"title": "Dashboards",
"description": "Specify Dashboard ID",
"type": "string",
"choices": []
},
"url": {
"title": "Third-Party URL",
"description": "Specify Third-Party URL",
"type": "string"
},
"jsonConf": {
"title": "Conditional Drilldown",
"description": "Specify Json Conditional Drilldown Configuration",
"type": "string"
},
"drilldownFields": {
"title": "Drilldown Fields",
"description": "Specify Drilldown Fields",
"type": "array",
"items": {
"type": "object",
"properties": {
"ruleName": {
"title": "Field Name",
"description": "Specify field name",
"type": "string",
"choices": []
}
}
}
}
}
}
},
"schema_version": "0.9"
}
| Task | Call | URL | Parameters | Response |
|---|---|---|---|---|
| Get the GUI Add form. | GET | /api/data/DashboardWidgetChartColumn/add/ |
|
The GUI Add form of data/DashboardWidgetChartColumn as JSON |
The API call to the /add/ URL can only be made from a hierarchy that allows the model type to be added. The actions in the response shows the url for the POST API call to create an instance.
| Task | Call | URL | Parameters | Payload |
|---|---|---|---|---|
| Create | POST | /api/data/DashboardWidgetChartColumn | hierarchy=[hierarchy] |
|
tool/Transaction/[trans pkid]to inspect the created resource and its instance pkid.
| Task | Call | URL | Parameters | Response |
|---|---|---|---|---|
| List | GET | /api/data/DashboardWidgetChartColumn/ |
|
The data/DashboardWidgetChartColumn schema and all instances as JSON. |
(The list will return 0 to 3 data/DashboardWidgetChartColumn instances)
{
"pagination": {
"skip": 0,
"limit": 3,
"maximum_limit": 2000,
"total": 0,
"total_limit": null,
"order_by": "title",
"direction": "asc",
"current": "/api/data/DashboardWidgetChartColumn/?skip=0&limit=3&order_by=title&direction=asc&traversal=fulltree"
},
"operations": [
"export",
"help",
"update",
"migration",
"get",
"list",
"remove",
"move",
"configuration_template",
"add",
"export_bulkload_template",
"transform",
"bulk_update_form",
"field_display_policy"
],
"meta": {
"model_type": "data/DashboardWidgetChartColumn",
"summary_attrs": [
{
"name": "title",
"title": "Title"
},
{
"name": "resource",
"title": "Resource"
},
{
"name": "description",
"title": "Description"
},
{
"name": "hierarchy_friendly_name",
"title": "Located At",
"allow_filtering": true
}
],
"tagged_versions": [],
"tags": [],
"title": "",
"business_key": {},
"api_version": "21.2",
"cached": true,
"references": {
"children": [],
"parent": [
{
"href": "/api/data/HierarchyNode/6t0ggef2c0deab00hb595101",
"pkid": "6t0ggef2c0deab00hb595101"
}
],
"device": [
{
"href": "",
"pkid": ""
}
],
"foreign_key": []
},
"model_specific_actions": [
"get",
"add",
"list"
],
"schema_version": "0.9",
"actions": [
{
"add": {
"method": "GET",
"class": "add",
"href": "/api/data/DashboardWidgetChartColumn/add/?hierarchy=[hierarchy]",
"support_async": false,
"title": "Add"
}
},
{
"list": {
"method": "GET",
"class": "list",
"href": "/api/data/DashboardWidgetChartColumn/?hierarchy=[hierarchy]",
"support_async": false,
"title": "List"
}
}
]
},
"resources": []
}
| Task | Call | URL | Parameters | Response |
|---|---|---|---|---|
| Get | GET | /api/data/DashboardWidgetChartColumn/[pkid] | hierarchy=[hierarchy] | The data/DashboardWidgetChartColumn instance with [pkid]. |