KPIs
These are the KPIs that are the core of the application.
KPI Object
The object has the following properties:
| Name | Type | Read Only | Mandatory | Max Len. | Notes |
|---|---|---|---|---|---|
| id | integer | yes | no | Automatically generated for the KPI | |
| category_id | integer | no | yes | The id of the category the KPI is in | |
| icon_id | integer (16 bit) | no | yes | The id of the icon to assign to the KPI | |
| unit_id | integer | no | yes | The id of the unit of measure to assign to the KPI | |
| frequency_id | character | no | yes | 1 | The id of the frequency of data entry for the KPI. This field is case sensitive and must be uppercase. |
| name | string | no | yes | 100 | The name of the KPI |
| description | string | no | no | 150 | The description of the KPI |
| target_default | decimal | no | no | The default target value for the KPI. If left blank or null the KPI will not have a target | |
| value_direction | character | no | yes | 1 | The value direction is case sensitive and can only be U(p), D(own) and N(one) |
| aggregate_function | string | no | yes | 3 | The aggregate function determines how the KPI is calculated and can be either AVG (Average) or SUM (Total Sum) |
| sort_order | integer (16 bit) | no | yes | The display order of the KPI | |
| is_active | boolean | no | yes | Active KPIs can have date entered against them otherwise they are display only KPIs | |
| is_calculated | boolean | yes | no | Calculated KPIs cannot be amended via the API and must be added / amended in the interface | |
| created_at | datetime | yes | no | The UTC date and time the KPI was created | |
| updated_at | datetime | yes | no | The UTC date and time the KPI was updated |
JSON Example
{
"id": 1234,
"category_id": 5478,
"icon_id": 1,
"unit_id": 123,
"frequency_id": "W",
"name": "Sales KPI",
"description": "This is the description",
"target_default": null,
"value_direction": "N",
"aggregate_function": "SUM",
"sort_order": 1,
"is_active": true,
"is_calculated": false,
"created_at": "2013-02-21T10:57:00",
"updated_at": "2013-02-21T10:58:00"
}
XML Example
<KPI xmlns="http://schemas.datacontract.org/2004/07/SimpleKPI.Application.Areas.Api.Models"
xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
<id>1234</id>
<category_id>5478</category_id>
<icon_id>1</icon_id>
<unit_id>123</unit_id>
<frequency_id>W</frequency_id>
<name>Sales KPI</name>
<description>This is the description</description>
<target_default>null</target_default>
<value_direction>N</value_direction>
<aggregate_function>SUM</aggregate_function>
<sort_order>1</sort_order>
<is_active>true</is_active>
<is_calculated>false</is_calculated>
<created_at>2013-02-21T10:12:00</created_at>
<updated_at>2013-02-21T10:12:00</updated_at>
</KPI>
Get all KPIs
GET /api/kpis
Using curl
curl https://{subdomain}.simplekpi.com/api/kpis
-v -u {email_address}:{token}
Example Response
Status: 200 OK
[
{
"id": 1234,
"category_id": 5478,
"icon_id": 1,
"unit_id": 123,
"frequency_id": "W",
"name": "Sales KPI",
"description": "This is the description",
"target_default": null,
"value_direction": "N",
"aggregate_function": "SUM",
"sort_order": 1,
"is_active": true,
"is_calculated": false,
"created_at": "2013-02-21T10:57:00",
"updated_at": "2013-02-21T10:58:00"
},
{
"id": 1235,
"category_id": 5478,
"icon_id": 2,
"unit_id": 125,
"frequency_id": "D",
"name": "Daily Calls",
"description": "This is the description",
"target_default": 100,
"value_direction": "U",
"aggregate_function": "AVG",
"sort_order": 2,
"is_active": true,
"is_calculated": false,
"created_at": "2013-02-21T10:57:00",
"updated_at": "2013-02-21T10:58:00"
}
]
Get a KPI
GET /api/kpis/{id}
Using curl
curl https://{subdomain}.simplekpi.com/api/kpis/{id}
-v -u {email_address}:{token}
Example Response
Status: 200 OK
{
"id": 1234,
"category_id": 5478,
"icon_id": 1,
"unit_id": 123,
"frequency_id": "W",
"name": "Sales KPI",
"description": "This is the description",
"target_default": null,
"value_direction": "N",
"aggregate_function": "SUM",
"sort_order": 1,
"is_active": true,
"is_calculated": false,
"created_at": "2013-02-21T10:57:00",
"updated_at": "2013-02-21T10:58:00"
}
Add a KPI
POST /api/kpis
Using curl
curl https://{subdomain}.simplekpi.com/api/kpis
-H "Content-Type: application/json"
-d '{"icon_id":1, "unit_id":123, "frequency_id":"W", "name":"Sales KPI",
"description":"New description", "target_default":100, "value_direction":"N",
"sort_order":1, "is_active":true}'
-v -u {email_address}:{token} -X POST
Example Response
Status: 201 Created
Location: https://{subdomain}.simplekpi.com/api/kpis/{id}
{
"id": 1234,
"category_id": 5478,
"icon_id": 1,
"unit_id": 123,
"frequency_id": "W",
"name": "Sales KPI",
"description": "This is the description",
"target_default": null,
"value_direction": "N",
"aggregate_function": "SUM",
"sort_order": 1,
"is_active": true,
"is_calculated": false,
"created_at": "2013-02-21T10:57:00",
"updated_at": "2013-02-21T10:58:00"
}
Update a KPI
PUT /api/kpis/{id}
Using curl
curl https://{subdomain}.simplekpi.com/api/kpis/{id}
-H "Content-Type: application/json"
-d '{"icon_id":1, "unit_id":123, "frequency_id":"W", "name":"Sales KPI",
"description":"New description", "target_default":100, "value_direction":"N",
"sort_order":1, "is_active":true}'
-v -u {email_address}:{token} -X PUT
Example Response
Status: 200 OK
{
"id": 1234,
"category_id": 5478,
"icon_id": 1,
"unit_id": 123,
"frequency_id": "W",
"name": "Sales KPI",
"description": "This is the description",
"target_default": null,
"value_direction": "N",
"aggregate_function": "SUM",
"sort_order": 1,
"is_active": true,
"is_calculated": false,
"created_at": "2013-02-21T10:57:00",
"updated_at": "2013-02-21T10:58:00"
}
Delete a KPI
DELETE /api/kpis/{id}
Using curl
curl https://{subdomain}.simplekpi.com/api/kpis/{id}
-v -u {email_address}:{token}
Example Response
Status: 200 OK