# createtable: Create a data table

> 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.

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. Tables per account by plan (Free 1, Starter 10, Business 50, Enterprise 500), up to 1,000 rows and 1 MB per table. With reuseExisting an existing table of that name is returned instead of an error.

- Group: Data tables
- Endpoint: `POST https://api.1001fx.com/datatables/createtable`
- Authentication: header `X-API-KEY: YOURSECRETAPIKEY`
- Content type: application/json
- Credits: 1 credit per call
- Ready-made in: Make
- Docs: https://1001fx.com/functions/createtable

## Parameters

- `name` (string, required) – Name: Name of the table, unique in the account (at most 64 characters).
- `columns` (array<object>, optional) – Columns: Columns of the table. More can be added later.
  - `name` (string, required) – Name: Letters, digits and _, starting with a letter.
  - `type` (enum, required, one of `string`, `number`, `boolean`, `date`) – Type: string, number, boolean or date (ISO 8601).
- `reuseExisting` (boolean, optional, default `false`) – Reuse existing: Return the existing table with this name instead of an error.

## Example: Create a data table

```bash
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}'
```