Data Usage
You can retrieve a SIMs data usage in multiple ways, these are documented below.
API Flow
To get the data usage per sim the following api calls can be used. This data is refreshed every 6 hours (or every 30 minutes for IOT connections).
These endpoints list multiple sims and follow AutoQueryable Syntax
/api/sim/api/company/{companyId}/sim/api/company/{companyId}/account/{accountid}/sim
This endpoint shows a single sim:
/api/sim/{serialNumber}
All the above endpoints contain a dataUsageMb field with the sims currently known data usage.
SFTP Flow
This feed can be set up by contacting your Account Manager.
For IoT connections, we provide a CDR-like file (in CSV format) via our SFTP site.
These files are a proxy for RADIUS information received from the network. They are delivered every 30 minutes and contain all session records from the previous period.
The file name is in the format: SessionCDR_{accountId}_{date}_{lastRowId}.csv with content in the structure:
| Name | Type | Description | Restrictions / Notes |
|---|---|---|---|
| SessionRowID | int | Unique identifier for the row | Primary key |
| Msisdn | string | Mobile number | Max length 20 |
| SIMSerial | string | SIM serial number | Max length 40 |
| SessionId | int | Identifier for the session | |
| SessionStartUTC | DateTime | Session started (UTC) | |
| Imsi | string? | International Mobile Subscriber ID | Max length 25 |
| Imei | string? | International Mobile Equipment ID | Max length 100 |
| RecordDateUtc | DateTime | Record created (UTC) | |
| RecordType | string | Type of record | Start, Stop, Interim |
| AccessPointName | string? | APN used during the session | Max length 30 |
| OutgoingDataVolume | long | Bytes sent during session | |
| IncomingDataVolume | long | Bytes received during session | |
| TotalDataVolume | long | Total data volume (sent+received) | |
| IpAddress | string? | IP address | Max length 30 |
| MobileCountryCode | string? | Country code of the mobile network | Max length 5 |
| MobileNetworkCode | string? | Network code of the mobile network | Max length 5 |
| RatType | int? | Radio access technology type |
Usage Notes
To monitor daily usage, you need to:
- Track all SessionIds associated with each MSISDN.
- Aggregate usage based on the unique SessionRowID, e.g., summing
TotalDataVolumeper MSISDN or per session.
This ensures accurate reporting, even if a single MSISDN has multiple sessions during the day.
Data Model
Although both the MSISDN and SessionId can be repeated multiple times in each file the hierarchy is MSISDN can have multiple SessionIds which can have multiple SessionRowIDs.