Create a data table

Creates a data table for the account of the API key: a small table you can read and write from Make, n8n, Power Automate, Zapier or the API – the same table on every platform. Columns have a type (string, number, boolean, date). Every row gets id, createdAt and updatedAt. Up to 20 tables per account, 1,000 rows and 1 MB per table. With reuseExisting an existing table of that name is returned instead of an error.

{
  "name": "processed_orders",
  "columns": [
    {
      "name": "orderId",
      "type": "string"
    },
    {
      "name": "total",
      "type": "number"
    }
  ],
  "reuseExisting": true
}

{
  "statusCode": 200
}

curl -X POST 'https://api.1001fx.com/datatables/createtable' \
  -H 'X-API-KEY: YOURSECRETAPIKEY' \
  -H 'Content-Type: application/json' \
  -d '{"name":"processed_orders","columns":[{"name":"orderId","type":"string"},{"name":"total","type":"number"}],"reuseExisting":true}'