Add Rows

Adds new rows to a specified base.

Endpoint:
POST https://api.ottogrid.ai/api/v1/bases/{baseId}/add-rows

Headers:

X-API-Key: Your API key

Path Parameters:

baseId: The ID of the base you want to add rows to. This is available in the URL of the table.

Request Body:

Parameter	Type	Default	Description
`rows`	Array	Required	An array of rows, where each row contains column-value pairs.
`expand`	Boolean	`false`	If `true`, webhook responses for processed rows will include additional metadata such as sources, confidence scores, and additional details. If omitted or `false`, webhooks return the standard response.

Example API Request:

curl --request POST \
  --url 'https://api.ottogrid.ai/api/v1/bases/nnNxwQDD/add-rows' \
  --header 'Content-Type: application/json' \
  --header 'X-API-Key: {your-api-key}' \
  --data '{
    "rows": [
      {
        "cells": {
          "AI Startup": "Cognosys"
        }
      }
    ]
  }'

Response:

{
  "rows": [
    {
      "id": "sr_cUePSxKBbECfBSqK",
      "cells": {
        "AI Startup": "Cognosys",
        "Website": "",
        "Estimated ARR": "",
        "Funding Stage": "",
        "CEO": "",
        "Recent News": "",
        "CTO": ""
      }
    }
  ]
}

Notes:

For AI Columns, if you send in a value to the cell, it will NOT rerun and overwrite the value. If you dont send in a key-value pair for that column, or send in an ““ (an empty string) as a value, the cell will run and generate a new value for that cell.
The cells object in the request body should contain key-value pairs where the key is the column name and the value is the cell value.
The response includes the newly created row with its assigned ID and all cells, including empty ones for columns not specified in the request.
Webhook Metadata Expansion (expand=true):
- If enabled, webhook responses for row.sheet.processed events will include:
  - Sources – References from which the data was retrieved.
  - Confidence Score – A numerical score indicating the reliability of the result.
  - Additional Details – Extra context or reasoning behind the retrieved data.
- If omitted or set to false, webhooks will return the standard response without metadata.