Upload

The upload endpoint allows you to overwrite or create a new upload in a collection. If the collection or upload does not exist, it will automatically be created.
Overwriting data is generally safe due to processing. The platform has built-in hooks to notify integrations of changes to a collection. Integrations will then rescan current data, and update accordingly. This allows API integrations to safely wipe data and provide bulk uploads instead of managing each row.
However, if you want to only append data to existing uploads - see inserts.
Parameters
Key
Type
REQUIRED
​
collection
String (Collection Name)
upload
String (Upload Name)
data
Array of data rows
Data Row
Key
Type
Row 0
Array of strings representing the headers
Row N
Array of Any representing each row
Example
The example below uploads data with 5 columns and n rows. You will notice the first row contains the headers.
If the collection or upload does not exist, it will automatically be created.
curl -X POST \
  v1/data/upload\
  -H 'Authorization: Basic <Your Base64 Encoded Token>'\
  -d '{
    "collection" : "Collection 1",
    "upload"     : "Upload 1",
    "data"       : [
        ["User Code","Date","Tasks","KPI"],
        ["001","2020-12-01",1,50],
        ["002","2020-12-01",1,50],
        ...etc
    ]
}'
Success Response
The response returns current information on the collection. The stats property will detail how many uploads are in the collection, and what size the sum of the data is.
{
    "status": "success",
    "data": {
        "collection": "My Collection",
        "upload": "Upload 1",
        "stats": {
            "uploads": 1,
            "size": 258,
            "rows": 4
        }
    },
    "hash": "925e88d80a1fa85e4a13749f20aa79c9",
    "response_time": 0.7646100521087646
}

Last modified 1yr ago

Key	Type
REQUIRED
collection	String (Collection Name)
upload	String (Upload Name)
data	Array of data rows

Key	Type
Row 0	Array of strings representing the headers
Row N	Array of Any representing each row