Select your language

Data Protection Update - July 2026

We’ve upgraded how sensitive data is protected. Prospect now uses a personal vault instead of the previous encryption key. Your vault gives you secure, private access to protected organization data. Click the Vault icon in the top menu to complete the setup. Nous avons amélioré la protection des données sensibles. Prospect utilise désormais un coffre personnel au lieu de l’ancienne clé de chiffrement. Votre coffre vous donne un accès sécurisé et privé aux données protégées de votre organisation. Cliquez sur l’icône Coffre dans le menu supérieur pour finaliser la configuration.
08.07.2026 10:35

Dashboard Update - July 2026

We’ve updated the dashboards. If you experience loading or display issues, please clear your cookies and browser cache. Nous avons mis à jour les tableaux de bord. Si vous constatez des problèmes d’affichage, veuillez vidervos cookies et le cache de votre navigateur.
08.07.2026 10:34

Documentation: payments_ts

Payment time series data for SHS Accounts or Meter Accounts
To import data in this format you can use our API. -> Api Documentation
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.
You can also supply us with files in xlsx, csv or json format. -> Example CSV
Row Name Type Example

payment_external_id *

ID for the specific payment as tracked by the data provider (source)

  • * required
string

ABC-123

paid_at *

date payment was made (including time if available)

  • * required
datetime

2022-07-30 14:45:32.876Z

amount *

amount of payment, in whatever currency is specified

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

  • * required
float

150.5

currency *

currency in which payment was made according to ISO code https://en.wikipedia.org/wiki/List_of_circulating_currencies

  • * required
string

ZMW

account_origin *

The table where we find the matching account_uid

  • * required
enum: meters, shs, installations, grids

meters

account_external_id *

external id for the specific account (e.g. paygo loan) associated with the shs or meter

  • * required
string

1234abcd

last_source_id

Id of the last Source which updated the record

  • auto-generated
integer

33

last_import_id

Id of the last import which updated the record

  • auto-generated
integer

337

data_origin

Origin of the data, generic or name of the api

  • auto-generated
string

generic

custom

Saves additional imported data out of standard structure

  • auto-generated
jsonb

{ "some": "key" }

organization_id

References Organization of data

  • auto-generated
integer

1

import_id

References Import of data

  • auto-generated
integer

1

source_id

References Source of data

  • auto-generated
integer

1

updated_at

Timestamp when row was updated

  • auto-generated
datetime

2021-05-03 6:23:55

created_at

Timestamp when row was inserted

  • auto-generated
datetime

2021-05-03 6:23:55

account_uid

organization_id + data_origin + account_external_id

  • auto-generated
string

1-generic-1234abcd

days_active

information from shs table, is calculated

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 float

7.2

reverted_at

datetime of when payment was reverted

 datetime

2022-07-30 14:48:20.876Z

provider_transaction_id

data validation, was transaction actually done

 string

12345X

provider_category

high level category of the payment, like bank transfer, cash, mobile money, app, other

 enum: mobile money, bank transfer, other, cash, payment gateway, crm wallet

mobile money

provider_name

who provided payment for particular payment (e.g. airtel, cash, MTN)

 string

MTN

purchase_quantity

amount of units of the item purchased

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 float

3.0

purchase_unit

unit of the purchase, e.g. 'wh', 'pcs', 'days'

 string

days

purchase_item

item or rate which was purchased with the payment, e.g. 'Energy', 'TV', 'Uptime'

 string

Uptime

paid_until

date payment is valid until

 datetime

2022-07-30 14:45:32.876Z

purpose

e.g.: Paygo payment, Loan repayment, cash purchase, tariff payment, etc.

 string

Paygo Payment

uid

account_origin + account_uid + payment_external_id + paid_at

  • auto-generated
string

meters-1-generic-1234abcd-ABC-123-2022-07-30 14:45:32.876Z

Progress