Add Rows

Adds new rows to a specified base.

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

Headers:

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:

{
  "rows": [
    {
      "cells": {
        "Column Name": "Value"
      }
    }
  ]
}

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.