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

Update a data table

datatables/updatetable

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

1 credit per callHTTP APIMake

Renames a data table, adds columns or removes columns (their values are deleted).

Endpoint

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

Parameters

  • tablestringrequired

    ID or name of the data table.

    Example:
    processed_orders
  • namestringoptional

    Optional new name.

    Example:
    orders_2026
  • addColumnsarray<object>optional
    • 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
  • removeColumnsarray<string>optional

    Names of columns to remove, with their values.

Examples

Update a data table

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

Input

Expects a json body
{
  "table": "processed_orders",
  "addColumns": [
    {
      "name": "paid",
      "type": "boolean"
    }
  ]
}

Output · HTTP 200

Response
{
  "statusCode": 200
}
Show curl command
curl -X POST 'https://api.1001fx.com/datatables/updatetable' \
  -H 'X-API-KEY: YOURSECRETAPIKEY' \
  -H 'Content-Type: application/json' \
  -d '{"table":"processed_orders","addColumns":[{"name":"paid","type":"boolean"}]}'

Try updatetable 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