Skip to content
Browse all functions

1001fx account

AI

Arrays

Audio & video

Carbone documents

Charts

Code

Data & JSON

Data tables

Date & time

Files & PDF

Geo

Images

Knowledge bases (RAG)

Playground

Spreadsheet

Stripe

YouTube

Create a data table

datatables/createtable

createtable (Create a data table) is a 1001fx API function in the group Data tables: POST https://api.1001fx.com/datatables/createtable, 1 credit per call. It works as a ready-made module in Make or as a plain HTTP call.

1 credit per callHTTP APIMake

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.

Endpoint

POSThttps://api.1001fx.com/datatables/createtable
Header
X-API-KEY: YOURSECRETAPIKEY How to
Content type
application/json

Parameters

  • namestringrequired

    Name of the table, unique in the account (at most 64 characters).

    Example:
    processed_orders
  • columnsarray<object>optional

    Columns of the table. More can be added later.

    • namestringrequired

      Letters, digits and _, starting with a letter.

      Example:
      orderId
    • typeenumrequired

      string, number, boolean or date (ISO 8601).

      Values:
      string
      number
      boolean
      date
      Example:
      string
  • reuseExistingbooleanoptional

    Return the existing table with this name instead of an error.

    Default:
    false

Examples

Create a data table

Needs an API key of an account (not a test key).

Input

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

Output · HTTP 200

Response
{
  "statusCode": 200
}
Show curl command
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}'

Try createtable now

Run it in your browser or create a free account and get 100 credits every month.

Try it in the appGet your free API key

More in Data tables

Changelog

  • 1.0.001.11.2026created