Africa Minigrids Program
Nigeria Banner

Documentation: paygo_source_snapshots_ts

Time series data containing daily paygo account snapshots as reported directly from CRM data sources (e.g. Paygops, Angaza).
Pour importer des données dans ce format, vous pouvez utiliser notre API. -> Documentation de l'API
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.
Vous pouvez également nous fournir des fichiers au format xlsx, csv ou json. -> Exemple CSV
Nom de la ligne Type Exemple

snapshot_date *

Day for which the snapshot is calculated.

  • * requis
date

2021-05-03

account_external_id *

ID for the specific account (e.g. paygo loan) associated with the device.

  • * requis
string

C11223344

snapshot *

For storing the snapshot.

  • * requis
jsonb

{}

account_uid

organization_id + data_origin + account_external_id

  • Généré automatiquement
string

1_crm_C11223344

created_at

Timestamp when row was inserted

  • Généré automatiquement
datetime

2021-05-03 6:23:55

updated_at

Timestamp when row was updated

  • Généré automatiquement
datetime

2021-05-03 6:23:55

source_id

References Source of data

  • Généré automatiquement
integer

1

import_id

References Import of data

  • Généré automatiquement
integer

1

organization_id

References Organization of data

  • Généré automatiquement
integer

1

custom

Saves additional imported data out of standard structure

  • Généré automatiquement
jsonb

{ "some": "key" }

data_origin

Origin of the data, generic or name of the api

  • Généré automatiquement
string

generic

last_import_id

Id of the last import which updated the record

  • Généré automatiquement
integer

337

last_source_id

Id of the last Source which updated the record

  • Généré automatiquement
integer

33