[Index]
Data model for Custom Calculation fields in Reporter resources.
Model ref.: data/CustomReporterModel
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": {
"name": {
"title": "Name",
"description": "Unique name for this custom reporter model.",
"type": "string",
"required": true
},
"models": {
"title": "Reporter resources",
"description": "Data and rules that will be used to add custom calculation fields to Reporter resources.",
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"title": "Reporter resource name",
"type": "string",
"required": true
},
"calculation_fields": {
"title": "Custom Calculation Fields",
"description": "Specifies how calculation fields are created.",
"type": "array",
"items": {
"type": "object",
"properties": {
"field_name": {
"title": "Field Name",
"description": "Name of the calculation field.",
"type": "string"
},
"value_type": {
"title": "Value Type",
"description": "Data type for the calculation field.",
"type": "string",
"default": "string",
"choices": [
{
"value": "string",
"title": "String"
},
{
"value": "integer",
"title": "Integer"
},
{
"value": "float",
"title": "Float"
}
]
},
"string_operations": {
"title": "Operations",
"description": "Available operations for string value types.",
"type": "array",
"items": {
"type": "string",
"choices": [
{
"value": "Grouping Count",
"title": "Grouping Count"
},
{
"value": "Select Query",
"title": "Select Query"
},
{
"value": "Count",
"title": "Count"
}
]
}
},
"number_operations": {
"title": "Operations",
"description": "Available operations for numeric value types.",
"type": "array",
"items": {
"type": "string",
"choices": [
{
"value": "Value",
"title": "Value"
}
]
}
},
"is_aggregated": {
"title": "Math Calculation",
"description": "Required when a calculation is performed based on the formula specified in the selected string, supporting operations such as sum, avg, min, max, and count.",
"type": "boolean"
},
"is_ratio": {
"title": "Ratio Calculation",
"description": "Required if the formula in the selected string involves ratio calculation; applicable when the math calculation option is enabled.",
"type": "boolean"
},
"select_str": {
"title": "Select String",
"description": "SQL statement used to generate the value of this field.",
"type": "string"
}
}
}
}
}
}
}
},
"schema_version": "1.0.0"
}
| Task | Call | URL | Parameters | Response |
|---|---|---|---|---|
| Get the GUI Add form. | GET | /api/data/CustomReporterModel/add/ |
|
The GUI Add form of data/CustomReporterModel 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/CustomReporterModel | hierarchy=[hierarchy] |
|
tool/Transaction/[trans pkid]to inspect the created resource and its instance pkid.
| Task | Call | URL | Parameters | Payload |
|---|---|---|---|---|
| Bulk delete [pkid1],[pkid2]... | DELETE | /api/data/CustomReporterModel/ | hierarchy=[hierarchy] | {"hrefs":["/api/data/CustomReporterModel/[pkid1]", "/api/data/CustomReporterModel/[pkid2]", ...]} |
GET http://[host-proxy]/api/data/CustomReporterModel/?hierarchy=[hierarchy]&format=json
| Task | Call | URL | Parameters | Payload |
|---|---|---|---|---|
| Get a selected [export_format] of the schema and instances [pkid1], [pkid2],... of data/CustomReporterModel; optionally with tag_version at [version] and Configuration Template as [configtemplate]. | POST | /api/data/CustomReporterModel/export/ |
|
{ "hrefs":["/api/data/CustomReporterModel/[pkid1]", "/api/data/CustomReporterModel/[pkid2]",...]}} |
For export_format=json, the response is a time stamped zip file of data in JSON as in the system database. Item properties such as strings that are empty or Boolean values that are not set, are not included. The filename in the response is of the format as the example:
Content-Disposition: attachment; filename=export_2013-05-17_14:20:19.186444.json.zip
Content-Language:en
Content-Type:application/x-zip
For export_format=raw_xlsx, the response is a MS Excel spreadsheet with columns corresponding to the JSON format export and a response filename format:
Content-Disposition: attachment; filename=<resource_type>_<resource_name>_exportedsheet_CCYY-MM-DD_HH-MM-SS.xlsx
Content-Language:en
Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
For export_format=xlsx, the response is a MS Excel spreadsheet, arranged by any Field Display Policies that apply. The columns correspond with those of a Bulk Load Template export sheet. The response filename format is:
Content-Disposition: attachment; filename=<resource_type>_<resource_name>_exportedsheet_formatted_CCYY-MM-DD_HH-MM-SS.xlsx
Content-Language:en
Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
The XLSX format can be used to bulk load instances of data/CustomReporterModel and the JSON format can be used to import instances of data/CustomReporterModel.
GET http://[host-proxy]/api/data/CustomReporterModel/?hierarchy=[hierarchy]
| Task | Call | URL | Parameters | Response |
|---|---|---|---|---|
| Configuration Template | GET | /api/data/CustomReporterModel/configuration_template/ | hierarchy=[hierarchy] |
|
POST http://[host-proxy]/api/data/ConfigurationTemplate/?hierarchy=[hierarchy]
| Task | Call | URL | Parameters | Response |
|---|---|---|---|---|
| List | GET | /api/data/CustomReporterModel/ |
|
The data/CustomReporterModel schema and all instances as JSON. |
(The list will return 0 to 3 data/CustomReporterModel instances)
{
"pagination": {
"skip": 0,
"limit": 3,
"maximum_limit": 2000,
"total": 0,
"total_limit": null,
"order_by": "name",
"direction": "asc",
"current": "/api/data/CustomReporterModel/?skip=0&limit=3&order_by=name&direction=asc&traversal=down"
},
"operations": [
"help",
"export",
"configuration_template",
"field_display_policy",
"list",
"get",
"update",
"bulk_update_form",
"migration",
"add",
"remove",
"export_bulkload_template",
"transform"
],
"meta": {
"model_type": "data/CustomReporterModel",
"summary_attrs": [
{
"name": "name",
"title": "Name"
},
{
"name": "hierarchy_friendly_name",
"title": "Located At",
"allow_filtering": true
}
],
"tagged_versions": [],
"tags": [],
"title": "?",
"business_key": {
"unique": [
"name"
],
"hierarchy": true
},
"api_version": "21.2",
"cached": true,
"references": {
"children": [],
"parent": [
{
"href": "/api/data/HierarchyNode/6t0ggef2c0deab00hb595101",
"pkid": "6t0ggef2c0deab00hb595101"
}
],
"device": [
{
"href": "",
"pkid": ""
}
],
"foreign_key": []
},
"model_specific_actions": [
"add",
"clone",
"configuration_template",
"export",
"get",
"help",
"list",
"remove",
"update"
],
"schema_version": "1.0.0",
"actions": [
{
"add": {
"method": "GET",
"class": "add",
"href": "/api/data/CustomReporterModel/add/?hierarchy=[hierarchy]",
"support_async": false,
"title": "Add"
}
},
{
"remove": {
"method": "DELETE",
"class": "delete",
"href": "/api/data/CustomReporterModel/?hierarchy=[hierarchy]",
"support_async": true,
"title": "Delete"
}
},
{
"export": {
"method": "POST",
"class": "export",
"href": "/api/data/CustomReporterModel/export/?hierarchy=[hierarchy]",
"support_async": false,
"title": "Export",
"view": "/api/view/ExportData/add/?auth_token=[authtoken],
"submit": "payload"
}
},
{
"configuration_template": {
"method": "GET",
"class": "config",
"href": "/api/data/CustomReporterModel/configuration_template/?hierarchy=[hierarchy]",
"support_async": false,
"title": "Configuration Template"
}
},
{
"list": {
"method": "GET",
"class": "list",
"href": "/api/data/CustomReporterModel/?hierarchy=[hierarchy]",
"support_async": false,
"title": "List"
}
},
{
"help": {
"method": "GET",
"class": "help",
"href": "/api/data/CustomReporterModel/help?hierarchy=[hierarchy]",
"support_async": false,
"title": "Help"
}
}
]
},
"resources": []
}
| Task | Call | URL | Parameters | Response |
|---|---|---|---|---|
| Get the on-line Help for data/CustomReporterModel. | GET | /api/data/CustomReporterModel/help | hierarchy=[hierarchy] | On-line help of Model ref.: data/CustomReporterModel as HTML |
| Task | Call | URL | Parameters | Payload |
|---|---|---|---|---|
| Modify | PUT | /api/data/CustomReporterModel/[pkid] | hierarchy=[hierarchy] | (For payload specification) |
For Bulk modification, refer to the Bulk Modify section.
| Task | Call | URL | Parameters | Response |
|---|---|---|---|---|
| Delete | DELETE | /api/data/CustomReporterModel/[pkid] | hierarchy=[hierarchy] |
| Task | Call | URL | Parameters | Response |
|---|---|---|---|---|
| Clone instance with [pkid]. The schema rules are applied. | GET | /api/data/CustomReporterModel/[pkid]/clone/?schema=&schema_rules=true |
|
A JSON payload with:
|
GET http://[host-proxy]/api/data/CustomReporterModel/?hierarchy=[hierarchy]&format=json
| Task | Call | URL | Parameters | Response |
|---|---|---|---|---|
| Get a selected [export_format] of the schema and a single instance with [pkid] of data/CustomReporterModel; optionally with tag_version at [version] and Configuration Template as [configtemplate]. | GET | /api/data/CustomReporterModel/[pkid]/export |
|
The response is an attachment. Refer to the list below. |
For export_format=raw_xlsx, the response is a "raw" MS Excel spreadsheet with columns corresponding to the JSON format export and a response format:
Content-Disposition: attachment; filename=<resource_type>_<resource_name>_exportedsheet_CCYY-MM-DD_HH-MM-SS.xlsx
Content-Language:en
Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
For export_format=xlsx, the response is a MS Excel spreadsheet, formatted to show all columns and a response format:
Content-Disposition: attachment; filename=<resource_type>_<resource_name>_exportedsheet_formatted_CCYY-MM-DD_HH-MM-SS.xlsx
Content-Language:en
Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
For export_format=json, the response is a time stamped zip file of data in JSON and a response format:
Content-Disposition: attachment; filename=export_2013-05-17_14:20:19.186444.json.zip
Content-Language:en
Content-Type:application/x-zip
The XLSX format can be used to bulk load instances of data/CustomReporterModel and the JSON format can be used to import instances of data/CustomReporterModel.
For Bulk Export, refer to the Bulk Export section.
| Task | Call | URL | Parameters | Response |
|---|---|---|---|---|
| Get | GET | /api/data/CustomReporterModel/[pkid] | hierarchy=[hierarchy] | The data/CustomReporterModel instance with [pkid]. |
| Task | Call | URL | Parameters | Response |
|---|---|---|---|---|
| Help | GET | /api/data/CustomReporterModel/[pkid]/help | hierarchy=[hierarchy] | The on-line Help for data/CustomReporterModel. |