# insertrows: Insert rows into a data table

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

Inserts one or more rows (array of objects, keys = column names) into a data table. Values are converted to the column type (e.g. "49.90" for a number column). Unknown columns are an error unless ignoreUnknownColumns is set. Returns the new rows with id, createdAt and updatedAt. Parallel calls on the same table can overwrite each other (last write wins): in Make, process bundles one after another for writing functions.

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

## Parameters

- `table` (string, required) – Table: ID or name of the data table.
- `rows` (array<object>, required) – Rows: Array of objects, keys are column names.
- `ignoreUnknownColumns` (boolean, optional, default `false`) – Ignore unknown columns: Skip keys that are not columns of the table instead of an error.

## Example: Insert rows into a data table

```bash
curl -X POST 'https://api.1001fx.com/datatables/insertrows' \
  -H 'X-API-KEY: YOURSECRETAPIKEY' \
  -H 'Content-Type: application/json' \
  -d '{"table":"processed_orders","rows":[{"orderId":"A-17","total":49.9}]}'
```