Homelogologo
Homelogologo
Ottogrid
DocsAPIAPI ReferenceGet Row

Get Row

Retrieves a specific row from a specified base. You can optionally include additional metadata for each cell by using the expand query parameter.

Endpoint:
GET https://api.ottogrid.ai/api/v1/bases/{baseId}/rows/{rowId}

Headers:

Path Parameters:

  • baseId: The ID of the base containing the row. This is available in the URL of the table.

  • rowId: The ID of the specific row you want to retrieve (e.g., "sr_3jmrE5ybf7SQBTbm")

Query Parameters

  • expand (optional): Boolean flag to include cell metadata in the response. Defaults to false if not specified.

    • If expand=true, each cell in the response will include additional metadata: sources, additionalDetails, and confidenceScore.

Example API Request:

Without Metadata (Default)

curl --request GET \
  --url 'https://api.ottogrid.ai/api/v1/bases/yAezy9VH/rows/sr_3jmrE5ybf7SQBTbm' \
  --header 'X-API-Key: {your-api-key}'

With Metadata (expand=true):

curl --request GET \
  --url 'https://api.ottogrid.ai/api/v1/bases/yAezy9VH/rows/sr_3jmrE5ybf7SQBTbm?expand=true' \
  --header 'X-API-Key: {your-api-key}'

Response:

Standard Response (expand=false or not specified)

{
  "id": "sr_3jmrE5ybf7SQBTbm",
  "cells": {
    "Company": "Cognosys",
    "Category": "AI",
    "Funding": "2000000"
  }
}

Expanded Response (expand=true)

If expand=true, each cell will include additional metadata. Here’s an example response:

{
    "rows": [
        {
            "id": "sr_csiDrzkYGfcWqJP6",
            "cells": {
                "Company URL": {
                    "value": "https://www.cognosys.ai/",
                    "metadata": {
                        "sources": [
                            "[cognosys](https://www.cognosys.ai/)",
                            "[cogno-sys](https://cogno-sys.com/)",
                            "[co](http://www.cognosys.co.uk/)",
                            "[cognosys](https://cognosys.co/)"
                        ],
                        "confidenceScore": 85,
                        "additionalDetails": "There are multiple companies associated with the name 'Cognosys'. The URL provided is for CognosysAI, which focuses on AI-powered workflow automation. Other entities include Cognosys Technologies Private Limited (https://cogno-sys.com/), Cognosys Ltd. (http://www.cognosys.co.uk/), and Cognosys (Pty) Ltd. (https://cognosys.co/). Please specify which entity you are interested in for more accurate information."
                    }
                },
                "Company": {
                    "value": "Cognosys"
                }
            }
        },

Notes:

  • The response includes a single row object with its id and cells containing column-value pairs.

  • If expand=true, each cell includes:

    • sources: An array of URLs related to the cell's information, or null if no sources are available.

    • additionalDetails: Extra context or reasoning for the cell’s content, or null if unavailable.

    • confidenceScore: A numerical score representing the confidence level of the cell's content, or null if unavailable.

  • If the specified row doesn't exist, you'll receive a 404 error response.