datatables/insertrows
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.
https://api.1001fx.com/datatables/insertrowsX-API-KEY: YOURSECRETAPIKEY How toapplication/jsontablestringrequiredID or name of the data table.
rowsarray<object>requiredArray of objects, keys are column names.
ignoreUnknownColumnsbooleanoptionalSkip keys that are not columns of the table instead of an error.
Needs an API key of an account (not a test key).
Input
{
"table": "processed_orders",
"rows": [
{
"orderId": "A-17",
"total": 49.9
}
]
}Output · HTTP 200
{
"statusCode": 200
}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}]}'Run it in your browser or create a free account and get 100 credits every month.