Create record

Adds a record through the table Add record form.

POST https://cotlet.dev/api/v1/quickbase/records

write

Fills the table's Add record form and saves it. Fields are set by their label on the form; list_fields shows which ones exist and which are required. A value in the wrong format is rejected by Quickbase and nothing is saved. It reaches no one by itself and is undone with delete_record, so it does not wait for your OK. A Pipelines or notification rule in your app can still run on save, so a record can start work in the app.

Parameters

Parameters: create_record
NameTypeDescription
app string required string App name as it appears under My apps, e.g. 'Field Ops'.
table string required string Table name as it appears in the app's sidebar, e.g. 'Work orders'.
fields object required object Field label to value, as on the Add record form, e.g. {'Title': 'Replace pump seal'}.

Request

cURL
curl -X POST https://cotlet.dev/api/v1/quickbase/records \
  -H "Authorization: Bearer $COTLET_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"app":"Field Ops","table":"Work orders","fields":{"Title":"Replace pump seal","Site":"Plant North","Priority":"High"}}'
Python
result = client.call("quickbase", "create_record", {"app":"Field Ops","table":"Work orders","fields":{"Title":"Replace pump seal","Site":"Plant North","Priority":"High"}})
Node.js
const result = await cotlet.call('quickbase', 'create_record', {"app":"Field Ops","table":"Work orders","fields":{"Title":"Replace pump seal","Site":"Plant North","Priority":"High"}});
CLI
cotlet call quickbase create_record --data '{"app":"Field Ops","table":"Work orders","fields":{"Title":"Replace pump seal","Site":"Plant North","Priority":"High"}}'

Example response

JSON

{
  "record_id": 2318,
  "table": "Work orders",
  "fields": {
    "Title": "Replace pump seal",
    "Site": "Plant North",
    "Priority": "High",
    "Status": "Open"
  },
  "url": "https://yourcompany.quickbase.com/db/bq4k2xzab?a=dr&rid=2318"
}

Sign in once. Your agent does the rest.

Sign up and add the apps you need. Free 7-day trial with 2,000 credits, no card needed.