Get Rows

Retrieves all rows from a specified base.

This endpoint retrieves all rows 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

Headers:

X-API-Key: Your API key

Path Parameters:

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

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 each row 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' \
  --header 'X-API-Key: {your-api-key}'

With Metadata (expand=true)

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

Response:

Standard Response (expand=false or not specified)

{
  "rows": [
    {
      "id": "sr_3jmrE5ybf7SQBTbm",
      "cells": {
        "Company": "Cognosys",
        "Category": "AI",
        "Funding": "2000000"
      }
    },
    {
      "id": "sr_8GcEsHhHxvpEJnYh",
      "cells": {
        "Company": "Coinbase",
        "Category": "Finance",
        "Funding": "1900000000"
      }
    }
  ]
}

Expanded Response (expand=true)

If expand=true, each cell in every row 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 an array of row objects, each containing an id and cells object with 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.
This endpoint retrieves all rows in the specified base.