Get Things Services Usage Report

This guide will show you how you can get your Things (SIM) Usage Report via an API command.

Please note that in order to get Services Usage Report you will need to run multiple API commands:

1. Create Report template

2. Generate Report using the created template

3. Get CSV Report location

4. Download CSV Report informaiton

1st API command - Create Report template

Create Report template

POST https://console.monogoto.io/report-template

Headers

Name	Type	Description
YOUR_TOKEN*	String	Your authentication token

Request Body

Name	Type	Description
REPORT_NAME*	String	Report name
REPORT_DESCRIPTION*	String	Report description
START_DATE*	String	Start date of the Report in epoch format with milliseconds. You can use converter following this link
END_DATE*	String	End date of the Report in epoch format with milliseconds. You can use converter following this link

200: OK OK

{
    Newly created Report Template ID
}

400: Bad Request Invalid Input Data

{
    "message": "string"
}

401: Unauthorized Unauthorized

{
    Unauthorized
}

500: Internal Server Error

{
    "message": "string"
}

Example using cURL:

curl -X POST \
     --url "https://console.monogoto.io/report-template/" \
     -H "accept: application/json" \
     -H "Authorization: Bearer {YOUR_TOKEN}" \
     -d "{ \"Name\": \"{REPORT_NAME}\", \"Description\": \"{REPORT_DESCRIPTION}\", \"GroupBy\": \"servingNetwork\", \"rateByCurrentPricePlan\": true, \"ReportType\": \"rating\", \"ReportPeriod\": { \"startDate\": {START_DATE}, \"endDate\": {END_DATE}}}" \

Example of request

curl -X POST \
     --url "https://console.monogoto.io/report-template/" \
     -H "accept: application/json" \
     -H "Authorization: Bearer eyJhb6IkpXVCJ9.eyJSb2xlIjoiVXN4lclByb2ZpbGVJZF9kZGM2MThhNC0wNTI1LTQ2MmUtYWN3NzhhMGQxYmbSI6Im4zgFkbWluIiwiQ3VzdG9tsbCwiVXNlcklkIjoiVklkXzg5Yj5Y2OGEyUtNDQThhLTEzZjA0MzJhZDE3YyINTAzgZmUtZGI51My00ZjRiLTktN2U5Yjc0ZWU1ZThlIiwiaWNzM3MjI5L2MDY3NTE2Mjl9.99aSLzP7kTgK6TZGW-xalrMu0GkW6viunt3XxbNng" \
     -d "{ \"Name\": \"September_report\", \"Description\": \"September_report\", \"GroupBy\": \"servingNetwork\", \"rateByCurrentPricePlan\": true, \"ReportType\": \"rating\", \"ReportPeriod\": { \"startDate\": 1661979600000, \"endDate\": 1664571599000}}" \

Example of response to our request:

ReportTemplateId_a14901d4b-7691-4548-8110-72abcba0be22

Add Report Template

POSThttps://console.monogoto.io/report-template

Body

application/json

New Report Template parameters

Name*string

Report Template name

Description*string

Description of the Report Template

FilterByenum

Field to filter by. Allowed values are:

nonecustomerthings groupthingstags

FilterByItemsobject

Object with filter values

GroupByenum

Field to group by. Allowed values are:

nonecustomerthings grouptags

GroupByIntervalenum

Field to group by time interval. Allowed values are:

hdwMqy

ReportType*enum

Report Template type. Allowed value are:

traffic

ReportPeriodobject

Time Period of the Report Template

CustomerId*string

Customer ID

OrganizationIdstring

Organization ID

Response

200400401500

Newly created Report Template ID

Request

JavaScriptCurlPython

const response = await fetch('https://console.monogoto.io/report-template', {
    method: 'POST',
    headers: {
      "Content-Type": "application/json"
    },
    body: JSON.stringify({
      "Name": "text",
      "Description": "text",
      "ReportType": "traffic",
      "CustomerId": "text"
    }),
});
const data = await response.json();

Response

400401500

{
  "message": "text"
}

2nd API command - Generate Report using the created template

Generate Report using the created template

POST https://console.monogoto.io/report-history/{reportTemplateId}

Path Parameters

Name	Type	Description
REPORT_TEMPLATE_ID*	String	Report template ID, it can be seen in response of Report template creation (1st API command)

Headers

Name	Type	Description
YOUR_TOKEN*	String	Your authentication token

200: OK ok

Newly generated Report History ID

400: Bad Request Invalid Input Data

{
    "message": "string"
}

401: Unauthorized Unauthorized

{
    "message": "string"
}

500: Internal Server Error Internal Server Error

{
    "message": "string"
}

Please note that this API may take a while to be completed if you have a lot of Things (SIM) in your Monogoto account.

Example using cURL:

curl -X POST \
     --url "https://console.monogoto.io/report-history/{REPORT_TEMPLATE_ID}" \
     -H "accept: application/json" \
     -H "Authorization: Bearer {YOUR_TOKEN}" \

Example of request

curl -X POST \
     --url "https://console.monogoto.io/report-history/ReportTemplateId_a14901d4b-7691-4548-8110-72abcba0be22" \
     -H "accept: application/json" \
     -H "Authorization: Bearer eyJhb6IkpXVCJ9.eyJSb2xlIjoiVXN4lclByb2ZpbGVJZF9kZGM2MThhNC0wNTI1LTQ2MmUtYWN3NzhhMGQxYmbSI6Im4zgFkbWluIiwiQ3VzdG9tsbCwiVXNlcklkIjoiVklkXzg5Yj5Y2OGEyUtNDQThhLTEzZjA0MzJhZDE3YyINTAzgZmUtZGI51My00ZjRiLTktN2U5Yjc0ZWU1ZThlIiwiaWNzM3MjI5L2MDY3NTE2Mjl9.99aSLzP7kTgK6TZGW-xalrMu0GkW6viunt3XxbNng" \

Example of response to our request:

ReportHistoryId_611bac7b-abc9-4c18-9cbb-a497889180b7

Generate Report History by Report Template ID

POSThttps://console.monogoto.io/report-history/{reportTemplateId}

Path parameters

reportTemplateId*string

Report Template ID

Response

200400401500

Newly generated Report History ID

Request

JavaScriptCurlPython

const response = await fetch('https://console.monogoto.io/report-history/{reportTemplateId}', {
    method: 'POST',
    headers: {},
});
const data = await response.json();

Response

400401500

{
  "message": "text"
}

3rd API command - Get CSV Report location

Get CSV Report location

GET https://console.monogoto.io/report-history/byTemplate

Headers

Name	Type	Description
YOUR_TOKEN*	String	Your authentication token

200: OK Array of Report Histories

[
  {
    "Name": "string",
    "ReportTemplateDescription": "string",
    "ReportTemplateName": "string",
    "FilterBy": "string",
    "FilterByItems": {
      "CustomerId": [
        null
      ],
      "ThingsGroupId": [
        null
      ],
      "ThingId": [
        null
      ],
      "TagId": [
        null
      ]
    },
    "GroupBy": "string",
    "GroupByInterval": "string",
    "ReportType": "string",
    "ReportPeriod": {
      "startDate": "2022-10-04T12:56:06.957Z",
      "endDate": "2022-10-04T12:56:06.957Z"
    },
    "CustomerId": "string",
    "OrganizationId": "string",
    "ReportTemplateId": "string",
    "ReportHistoryId": "string",
    "DateCreated": "2022-10-04T12:56:06.957Z",
    "DateModified": "2022-10-04T12:56:06.957Z",
    "Type": "string"
  }
]

401: Unauthorized Unauthorized

{
    "message": "string"
}

500: Internal Server Error Internal Server Error

{
    "message": "string"
}

Example using cURL:

curl -X GET \
     --url "https://console.monogoto.io/report-history/report-history/byTemplate" \
     -H "accept: application/json" \
     -H "Authorization: Bearer {YOUR_TOKEN}" \

Example of request

curl -X GET \
     --url "https://console.monogoto.io/report-history/report-history/byTemplate" \
     -H "accept: application/json" \
     -H "Authorization: Bearer eyJhb6IkpXVCJ9.eyJSb2xlIjoiVXN4lclByb2ZpbGVJZF9kZGM2MThhNC0wNTI1LTQ2MmUtYWN3NzhhMGQxYmbSI6Im4zgFkbWluIiwiQ3VzdG9tsbCwiVXNlcklkIjoiVklkXzg5Yj5Y2OGEyUtNDQThhLTEzZjA0MzJhZDE3YyINTAzgZmUtZGI51My00ZjRiLTktN2U5Yjc0ZWU1ZThlIiwiaWNzM3MjI5L2MDY3NTE2Mjl9.99aSLzP7kTgK6TZGW-xalrMu0GkW6viunt3XxbNng" \

In the response to our request, you will need to find a Report matching our Report template ID or Report history ID. Then take csvPath and use it in the 4th API command.

Example of response to our request:

{
  "dbResponse": [
    {
      "ReportHistoryId": "ReportHistoryId_611bac7b-abc9-4c18-9cbb-a497889180b7",
      "ReportTemplateId": "ReportTemplateId_a14901d4b-7691-4548-8110-72abcba0be22",
      "ReportType": "rating",
      "FilterBy": "none",
      "FilterByItems": {},
      "OrganizationId": "OrganizationId_2ds578d7d-abc9-4123-acbb-1ec67a98b01a",
      "CustomerId": "cid_eb426486-488a-4f44-9c6d-3627a66150cb",
      "GroupBy": "servingNetwork",
      "GroupByInterval": "d",
      "ReportTemplateName": "September_report",
      "ReportTemplateDescription": "September_report",
      "ReportPeriod": {
        "startDate": 1661979600000,
        "endDate": 1664571599000
      },
      "csvPath": "/efs/reports/csv/2022/10/4/Report_September_report_#8d351.csv",
      "pdfPath": "/efs/reports/pdf/2022/10/4/Report_September_report_#8d351.pdf",
      "ReportData": null,
      "Name": "Report September_report #8d351",
      "rateByCurrentPricePlan": false,
      "Type": "ReportHistory",
      "DateCreated": 1664887341012
    }

Get Report Histories by Report Template ID

GEThttps://console.monogoto.io/report-history/byTemplate

Query parameters

Response

200401500

Array of Report Histories

Body

application/json

Name*string

Report History name

ReportTemplateDescription*string

Description of the Report Template

ReportTemplateName*string

Name of the Report Template

FilterBy*enum

Field to filter by. Allowed values are:

nonecustomerthings groupthingstags

FilterByItemsobject

Object with filter values

GroupBy*enum

Field to group by. Allowed values are:

nonecustomerthings grouptags

GroupByInterval*enum

Field to group by time interval. Allowed values are:

hdwMqy

ReportType*enum

Report Template type. Allowed value are:

traffic

ReportPeriod*object

Time Period of the Report History

CustomerIdstring

Customer ID

OrganizationIdstring

Organization ID

ReportTemplateId*string

Report Template ID

ReportHistoryId*string

Report History ID

DateCreatedstring (date-time)

Date created

DateModifiedstring (date-time)

Date modified

Type*string

Report History type

Request

JavaScriptCurlPython

const response = await fetch('https://console.monogoto.io/report-history/byTemplate', {
    method: 'GET',
    headers: {},
});
const data = await response.json();

Response

200401500

[
  {
    "Name": "text",
    "ReportTemplateDescription": "text",
    "ReportTemplateName": "text",
    "FilterBy": "none",
    "FilterByItems": {
      "CustomerId": [],
      "ThingsGroupId": [],
      "ThingId": [],
      "TagId": []
    },
    "GroupBy": "none",
    "GroupByInterval": "h",
    "ReportType": "traffic",
    "ReportPeriod": {
      "startDate": "2024-12-30T17:14:39.218Z",
      "endDate": "2024-12-30T17:14:39.218Z"
    },
    "CustomerId": "text",
    "OrganizationId": "text",
    "ReportTemplateId": "text",
    "ReportHistoryId": "text",
    "DateCreated": "2024-12-30T17:14:39.218Z",
    "DateModified": "2024-12-30T17:14:39.218Z",
    "Type": "text"
  }
]

4th API command - Download CSV Report information

Download CSV Report information

GET https://console.monogoto.io /report-history/downloadReport/csv/{csvPath}

Path Parameters

Name	Type	Description
CSV_PATH*	String	CSV file path that was received in 3rd API to get Report location

Headers

Name	Type	Description
YOUR_TOKEN*	String	Your authentication token

200: OK ok

The CSV contents of the reports

400: Bad Request Invalid Input Data

{
    "message": "string"
}

401: Unauthorized Unauthorized

{
    "message": "string"
}

500: Internal Server Error Internal Server Error

{
    "message": "string"
}

Example using cURL:

curl -X GET \
     --url "https://console.monogoto.io/https://console.monogoto.io /report-history/downloadReport/csv/{csvPath}" \
     -H "accept: application/json" \
     -H "Authorization: Bearer {YOUR_TOKEN}" \

Please note that in csvPath some symbols will need to be converted to numbers and letters:

/ - will be need to be replaced with %2F

# - will need to be replaced with %23

Example of csvPath:

/efs/reports/csv/2022/10/4/Report_September_report_#8d351.csv

Example after csvPath symbols were changed to code values:

%2Fefs%2Freports%2Fcsv%2F2022%2F10%2F4%2FReport_September_report_%238d351.csv

Example of request

curl -X GET \
     --url "https://console.monogoto.io/https://console.monogoto.io /report-history/downloadReport/csv/%2Fefs%2Freports%2Fcsv%2F2022%2F10%2F4%2FReport_September_report_%238d351.csv" \
     -H "accept: application/json" \
     -H "Authorization: Bearer eyJhb6IkpXVCJ9.eyJSb2xlIjoiVXN4lclByb2ZpbGVJZF9kZGM2MThhNC0wNTI1LTQ2MmUtYWN3NzhhMGQxYmbSI6Im4zgFkbWluIiwiQ3VzdG9tsbCwiVXNlcklkIjoiVklkXzg5Yj5Y2OGEyUtNDQThhLTEzZjA0MzJhZDE3YyINTAzgZmUtZGI51My00ZjRiLTktN2U5Yjc0ZWU1ZThlIiwiaWNzM3MjI5L2MDY3NTE2Mjl9.99aSLzP7kTgK6TZGW-xalrMu0GkW6viunt3XxbNng" \

Example of response to our request showing CSV file information:

Thing Name,IMSI,MSISDN,Roaming Partner,Data,SMS,MO SMS,MT SMS,Voice,MO VOICE,MT VOICE,Total Before Credit,Credit,Total
"ICCID 8912372646888991, 8912372646888991",1234567891011,[phone],Bite , 140.25 MB,,,,,,,,,0.9677
"ICCID 8912372646888991, 8912372646888991",1234567891011,[phone],,140.25 MB,,,,,,,0.9677,0.0000,0.9677
"ICCID 8912372646888992, 8912372646888992",1234567891012,[phone],OMNITEL , 64.34 MB,,,,,,,,,0.4504
"ICCID 8912372646888992, 8912372646888992",1234567891012,[phone],,64.34 MB,,,,,,,0.4504,0.0000,0.4504
"ICCID 8912372646888993, 8912372646888993",1234567891013,[phone],Bite , 28.9 MB, 2,,,,,,,,0.1994
"ICCID 8912372646888993, 8912372646888993",1234567891013,[phone],,28.9 MB,,,2,,,,0.1994,0.0000,0.1994