Insert KPI's records (Upload CSV) - Shorter Loop API Documentation

This API endpoint allows users to insert Key Performance Indicators (KPIs) by uploading a CSV file. This request supports only the insertion of new KPI records via the CSV file upload.

Request

Query Params

product_external_key

string

required

Follow these steps to find your product_external_key:

Visit https://app.shorterloop.com/ACME/product/MGMT/dashboard.
The product_external_key is the segment in the URL, in this example, MGMT.
Use this product_external_key in the product_external_key Query Params when making the API request.

Example:

MGMT

kpi_external_key

string

required

Follow these steps to find your kpi_external_key:

Open the dialog box for the desired metric.
Locate the field labeled "KPI Unique Key."
Click the copy button next to the "KPI Unique Key" field to copy the key.
Use this key as the value for the kpi_external_key query parameter when making the API request.

Example:

KPI-46

Header Params

Authorization

string

required

Default:

Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MjA3NSwiZmlyc3ROYW1lIjoiZGVlcGlrYSIsImxhc3ROYW1lIjpudWxsLCJ1c2VyRXhwZXJpZW5jZSI6bnVsbCwiZW1haWwiOiJkcGF0aWFsK2ppcmFAc2hvcnRlcmxvb3AuY29tIiwiZGlzcGxheU5hbWUiOiJkZWVwaWthIiwicHJvZmlsZUltYWdlIjoiMTM3OC9nZW5lcmFsL3VzZXJzL0lJM0YyMDc1YzZhNS5zdmciLCJ0aW1lWm9uZUFiYnIiOm51bGwsInN0YXR1cyI6ImFjdGl2ZSIsInByb3ZpZGVyIjoiY3VzdG9tIiwidGVybXNBY2NlcHRlZCI6MSwibGFzdFBhZ2UiOiIvQ09OT1AvcHJvZHVjdC9ERUUvZG9jdW1lbnRhdGlvbi91bnRpdGxlZC02LTY0ZjQiLCJ2ZXJpZmljYXRpb25Ub2tlbiI6IiIsImxhc3RTaWduSW4iOiIyMDI1LTA0LTAxVDE0OjMwOjIwLjAwMFoiLCJyb2xlIjoic3VwZXJhZG1pbiIsImlzUHJvZGVhc3lBZG1pbiI6MCwiZ3JvdXAiOjEsInJlZmVycmVyIjpudWxsLCJpc1ZlcmlmaWVkIjoxLCJyZWZlcnJlclRva2VuIjpudWxsLCJyZWZyZXNoUmVmZXJyZXJUb2tlbiI6bnVsbCwiYmlvIjpudWxsLCJjcmVhdGVkQXQiOiIyMDI1LTAzLTE3VDA5OjM2OjU2LjAwMFoiLCJ1cGRhdGVkQXQiOiIyMDI1LTA0LTAxVDE0OjMwOjIwLjAwMFoiLCJzdWJzY3JpcHRpb24iOnsidXNlclJvbGUiOiJzdXBlcmFkbWluIiwic3Vic2NyaXB0aW9uRXh0ZXJuYWxLZXkiOiJDT05PUCIsImV4dGVybmFsS2V5IjoiQ09OT1AiLCJjbmFtZSI6bnVsbCwiaWQiOjEzNzh9LCJzdWJzY3JpcHRpb25JZCI6MTM3OCwiZXh0ZXJuYWxLZXkiOiJDT05PUCIsInN1YnNjcmlwdGlvbkV4dGVybmFsS2V5IjoiQ09OT1AiLCJ0aW1lIjoiMjAyNS0wNC0wMlQwNTo0Mzo1NC41MDRaIiwiaWF0IjoxNzQzNTcyNjM0LCJleHAiOjE3NDM4MzE4MzR9.UJaUHpd_XJyGSv4C0DaaEVxDDQKzKZ_lKPkf8Yrr-Oc

initiativeId

string

required

How to get initiativeId:

Visit https://app.shorterloop.com/ACME/product/SHO-MJXR/dashboard.

The initiativeId is SHO-MJXR in the URL.

Use this initiativeId in the initiativeId header for API requests.

Default:

DEE

Example:

MGMT

Content-Type

string

required

Default:

application/json

Body Params multipart/form-data

metrics

file

required

Upload CSV for JSON file to insert or update data.

Example:

cmMtdXBsb2FkLTE3MTYzODAxOTUwOTQtMg==/csv-sample.csv

Request samples

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

Responses

🟢201Created

application/json

Body

success

boolean

required

message

string

optional

data

object

required

integer

required

title

string

required

externalKey

string

optional

benchmark

string

optional

visualization

boolean

required

Default:

true

benchmarkUnit

string

optional

benchmarkType

string

optional

initiativeId

integer

optional

dueDate

string

optional

dashboardVisualization

boolean

optional

statement

string

optional

createdAt

string

optional

kpi_revisions

array [object {3}]

optional

Example

{
  "success": true,
  "message": "Records inserted successfully. 2 out of 9 KPI records were not inserted due to incorrect entries in the provided data.",
  "data": {
    "id": 1162,
    "title": "Matrics sample",
    "externalKey": "KPI-15",
    "benchmark": "334455.00",
    "visualization": true,
    "benchmarkUnit": "INR",
    "benchmarkType": "MORE",
    "initiativeId": 1139,
    "dueDate": "2024-06-29T18:30:00.000Z",
    "dashboardVisualization": true,
    "statement": "4455",
    "createdAt": "2024-05-16T06:48:10.000Z",
    "kpi_revisions": [
      {
        "id": 1008,
        "createdAt": "2024-05-16T06:53:19.000Z",
        "value": "148.00"
      },
      {
        "id": 1010,
        "createdAt": "2024-05-16T06:53:19.000Z",
        "value": "33.99"
      },
      {
        "id": 1011,
        "createdAt": "2024-05-16T06:53:19.000Z",
        "value": "14.00"
      },
      {
        "id": 1013,
        "createdAt": "2024-05-16T06:53:19.000Z",
        "value": "18.00"
      },
      {
        "id": 1002,
        "createdAt": "2024-05-16T06:49:36.000Z",
        "value": "12.00"
      },
      {
        "id": 1003,
        "createdAt": "2024-05-16T06:49:36.000Z",
        "value": "14.00"
      },
      {
        "id": 1004,
        "createdAt": "2024-05-16T06:49:36.000Z",
        "value": "130.00"
      },
      {
        "id": 1006,
        "createdAt": "2024-05-16T06:49:36.000Z",
        "value": "33.99"
      },
      {
        "id": 1007,
        "createdAt": "2024-05-16T06:49:36.000Z",
        "value": "22.89"
      },
      {
        "id": 999,
        "createdAt": "2024-05-16T06:49:12.000Z",
        "value": "148.00"
      },
      {
        "id": 1001,
        "createdAt": "2024-05-16T06:49:12.000Z",
        "value": "33.99"
      },
      {
        "id": 996,
        "createdAt": "2024-05-16T06:48:52.000Z",
        "value": "130.00"
      },
      {
        "id": 998,
        "createdAt": "2024-05-16T06:48:52.000Z",
        "value": "33.99"
      },
      {
        "id": 995,
        "createdAt": "2024-05-16T06:48:10.000Z",
        "value": "4455.00"
      },
      {
        "id": 997,
        "createdAt": "2024-05-11T07:38:05.000Z",
        "value": "223.09"
      },
      {
        "id": 1014,
        "createdAt": "2024-04-04T07:38:05.000Z",
        "value": "23.90"
      },
      {
        "id": 1012,
        "createdAt": "2024-03-10T07:38:05.000Z",
        "value": "223.09"
      },
      {
        "id": 1000,
        "createdAt": "2024-03-01T07:38:05.000Z",
        "value": "223.09"
      },
      {
        "id": 1005,
        "createdAt": "2024-03-01T07:38:05.000Z",
        "value": "223.09"
      },
      {
        "id": 1009,
        "createdAt": "2024-02-21T07:38:05.000Z",
        "value": "22.00"
      }
    ]
  }
}

🟠400Invalid Input

🟠404Record not found