Documentation: customers

All our Customers
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

external_id *

Identifies the customer in the context of the data_origin. Can be a fixed ID in another database system or any other way to identify the customer, but note that this information is not encrypted, if you use national id numbers or phone numbers pseudonymize them first.

  • * required
string

6574

uid

organization_id + data_origin + external_id; ID for the specific customer

  • auto-generated
string

1

name

The full name of the customer (p14)

  • p14n
string

John Smith - stored as 7c6e6899401b76f23d4eaf4931975872f1b5d9ae026b8b8213a25cf7812d936b

address

The customers address (p14)

  • p14n
string

Some Street 123, Example Village - stored as 452a20d7b82bd6ad82f0bf482f382bfe55f90dcb140e1e79d38b15a4450770d7

birth_year

year of purchaser birth, for demographic analysis

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

 integer

2000

country

A two-letter country code according to ISO 3166-1 alpha-2

 string

UG

email

The customers email address (p14)

  • p14n
string

test@example.com - stored as b37645e1cc4bc50636c11a9a19566f2ae56764333789159dacb171580c42e49b

former_electricity_source

e.g. none, solar, genset

 string

genset

gender

The customers gender, e.g. male, female, other, or unknown (null)

 enum: M, F, O

M

household_size

The number of residents in customers household (only if residential use)

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

 integer

4

identification_type

type of customer identification, eg. national ID, passport, driver license

 string

national ID

identification_number

The identification number of the customers ID document

  • p14n
string

7b1a3d34a3fcbad23308a5da7b49f9f3f7a67d2d

phone

The customers primary phone number (p14)

  • p14n
string

+2560123456789 - stored as a6bff03207824aac531aa0ecfbc5d4597ba4e90c230b35afe60061045bf83f23

phone_2

The customers secondary phone number (p14)

  • p14n
string

+2560123456789 - stored as a6bff03207824aac531aa0ecfbc5d4597ba4e90c230b35afe60061045bf83f23

profession

Profession of customer

 string

farmer

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