Homelogologo
Homelogologo
Ottogrid
DocsAPIAPI ReferenceUpdate Rows

Update Rows

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

Headers:

Path Parameters:

  • baseId: The ID of the base you want to update rows in.

Request Body:

{
  "rows": [
    {
      "id": "Row ID",
      "cells": {
        "Column Name": "Updated Value"
      }
    }
  ]
}

Example API Request:

curl --request POST \
  --url 'https://api.ottogrid.ai/api/v1/bases/yAezy9VH/update-rows' \
  --header 'Content-Type: application/json' \
  --header 'X-API-Key: {your-api-key}' \
  --data '{ 
    "rows": [ 
      { 
        "id": "sr_xycvEFkU6n3uo8HP", 
        "cells": { 
          "Company": "Cognosys" 
        } 
      } 
    ] 
  }'

Response:

{
  "rows": [
    {
      "id": "sr_xycvEFkU6n3uo8HP",
      "cells": {
        "Company": "Cognosys",
        "Category": "AI",
        "Funding": "2000000"
      }
    }
  ],
  "errors": []
}

Notes:

  • The rows array in the request body should contain objects with id and cells properties.

  • The id is the unique identifier for the row you want to update.

  • The cells object should contain key-value pairs where the key is the column name and the value is the updated cell value.

  • The response includes the updated rows and any errors that occurred during the update process.