Documentation: paygo_source_snapshots_ts
Time series data containing daily paygo account snapshots as reported directly from CRM data sources (e.g. Paygops, Angaza).
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.
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 |
|---|---|---|
|
snapshot_date * Day for which the snapshot is calculated.
|
date |
2021-05-03 |
|
account_external_id * ID for the specific account (e.g. paygo loan) associated with the device.
|
string |
C11223344 |
|
snapshot * For storing the snapshot.
|
jsonb |
{} |
|
account_uid organization_id + data_origin + account_external_id
|
string |
1_crm_C11223344 |
|
uid account_uid + snapshot_date
|
string |
1_crm_C11223344_2021-05-03 |
|
created_at Timestamp when row was inserted
|
datetime |
2021-05-03 6:23:55 |
|
updated_at Timestamp when row was updated
|
datetime |
2021-05-03 6:23:55 |
|
source_id References Source of data
|
integer |
1 |
|
import_id References Import of data
|
integer |
1 |
|
organization_id References Organization of data
|
integer |
1 |
|
custom Saves additional imported data out of standard structure
|
jsonb |
{ "some": "key" } |
|
data_origin Origin of the data, generic or name of the api
|
string |
generic |