Documentation: test
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.
Required | Type | p14n | Blurred | Autogenerated | Example | |
---|---|---|---|---|---|---|
float_column floating around, something in between 3 or 4 or even more. But it MUST be given! Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
✓ | float | ⤫ | ⤫ | ⤫ |
3.14 |
uid organization_id + something_uid; A nice description of the column. This here is the external uid provided by the one who is uploading the data. It is build from organization_id and something_uid. This description is required. Otherwise nobody will know what it is. I should be well written and explaining everything. Must be unique to the data source! |
⤫ | string | ⤫ | ⤫ | ✓ |
The UUID - 12434534 |
int_column Here we store a number if you provide us one. Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error. |
⤫ | integer | ⤫ | ⤫ | ⤫ |
5 |
bool_column A simple yes or no is enough. But we need to know. |
⤫ | boolean | ⤫ | ⤫ | ⤫ |
true |
time_column give us a timestamp so we know when it happened |
⤫ | datetime | ⤫ | ⤫ | ⤫ |
2021-02-22 12:34:56 +0000 |
name_column Name of customer. It will not be stored plainly but hashed - so that different names are different, but the the personal information is gone. e.g. Jack Smith as jasdm213mn5, Jacky Smith as oqmq123 |
⤫ | string | ✓ | ⤫ | ⤫ |
pater paul stored as fe42o3p2 |
personal_column Something personal. |
⤫ | string | ⤫ | ⤫ | ⤫ |
Personal Text |
something_uid int_column; Referencing something, stored in another table. Used for joining. Build as int_column. |
⤫ | string | ⤫ | ⤫ | ✓ |
somecrayzyuid12423 |
enum_column A column which can only store predefined values |
⤫ | enum: a, b, c | ⤫ | ⤫ | ⤫ |
b |
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 |
last_import_id Id of the last import which updated the record |
⤫ | integer | ⤫ | ⤫ | ✓ |
337 |
last_source_id Id of the last Source which updated the record |
⤫ | integer | ⤫ | ⤫ | ✓ |
33 |