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:
{
"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.