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.
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.

  • * required
date

2021-05-03

account_external_id *

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

  • * required
string

C11223344

snapshot *

For storing the snapshot.

  • * required
jsonb

{}

account_uid

organization_id + data_origin + account_external_id

  • auto-generated
string

1_crm_C11223344

created_at

Timestamp when row was inserted

  • auto-generated
datetime

2021-05-03 6:23:55

updated_at

Timestamp when row was updated

  • auto-generated
datetime

2021-05-03 6:23:55

source_id

References Source of data

  • auto-generated
integer

1

import_id

References Import of data

  • auto-generated
integer

1

organization_id

References Organization of data

  • auto-generated
integer

1

custom

Saves additional imported data out of standard structure

  • auto-generated
jsonb

{ "some": "key" }

data_origin

Origin of the data, generic or name of the api

  • auto-generated
string

generic

last_import_id

Id of the last import which updated the record

  • auto-generated
integer

337

last_source_id

Id of the last Source which updated the record

  • auto-generated
integer

33