---
updatedAt: 2025-09-02T07:17:19.000Z
agentTools:
  projectIndex: https://jamaibase.readme.io/llms.txt
---

# List rows in a table.

Permissions: `organization.MEMBER` OR `project.MEMBER`.

# OpenAPI definition

```json
{
  "openapi": "3.1.0",
  "info": {
    "title": "JamAI Base API",
    "license": {
      "name": "Apache 2.0",
      "url": "https://www.apache.org/licenses/LICENSE-2.0.html"
    },
    "version": "0.1.0",
    "x-logo": {
      "url": "https://www.jamaibase.com/favicon.svg"
    }
  },
  "servers": [
    {
      "url": "https://api.jamaibase.com"
    }
  ],
  "paths": {
    "/api/v1/gen_tables/{table_type}/{table_id}/rows": {
      "get": {
        "tags": [
          "Generative Table (V1)"
        ],
        "summary": "List rows in a table.",
        "description": "Permissions: `organization.MEMBER` OR `project.MEMBER`.",
        "operationId": "list_rows_api_v1_gen_tables__table_type___table_id__rows_get",
        "deprecated": true,
        "parameters": [
          {
            "name": "table_type",
            "in": "path",
            "required": true,
            "schema": {
              "$ref": "#/components/schemas/TableType",
              "description": "Table type."
            },
            "description": "Table type."
          },
          {
            "name": "table_id",
            "in": "path",
            "required": true,
            "schema": {
              "type": "string",
              "description": "Table ID or name.",
              "title": "Table Id"
            },
            "description": "Table ID or name."
          },
          {
            "name": "offset",
            "in": "query",
            "required": false,
            "schema": {
              "type": "integer",
              "minimum": 0,
              "description": "Item offset for pagination. Defaults to 0.",
              "default": 0,
              "title": "Offset"
            },
            "description": "Item offset for pagination. Defaults to 0."
          },
          {
            "name": "limit",
            "in": "query",
            "required": false,
            "schema": {
              "type": "integer",
              "maximum": 100,
              "exclusiveMinimum": 0,
              "description": "Number of rows to return (min 1, max 100). Defaults to 100.",
              "default": 100,
              "title": "Limit"
            },
            "description": "Number of rows to return (min 1, max 100). Defaults to 100."
          },
          {
            "name": "order_descending",
            "in": "query",
            "required": false,
            "schema": {
              "type": "boolean",
              "description": "Whether to sort by descending order. Defaults to True.",
              "default": true,
              "title": "Order Descending"
            },
            "description": "Whether to sort by descending order. Defaults to True."
          },
          {
            "name": "columns",
            "in": "query",
            "required": false,
            "schema": {
              "anyOf": [
                {
                  "type": "array",
                  "items": {
                    "type": "string"
                  }
                },
                {
                  "type": "null"
                }
              ],
              "description": "A list of column names to include in the response. Default is to return all columns.",
              "title": "Columns"
            },
            "description": "A list of column names to include in the response. Default is to return all columns."
          },
          {
            "name": "search_query",
            "in": "query",
            "required": false,
            "schema": {
              "type": "string",
              "maxLength": 10000,
              "description": "A string to search for within row data as a filter. The string is interpreted as both POSIX regular expression and literal string. Defaults to \"\" (no filter). It will be combined other filters using `AND`.",
              "default": "",
              "title": "Search Query"
            },
            "description": "A string to search for within row data as a filter. The string is interpreted as both POSIX regular expression and literal string. Defaults to \"\" (no filter). It will be combined other filters using `AND`."
          },
          {
            "name": "float_decimals",
            "in": "query",
            "required": false,
            "schema": {
              "type": "integer",
              "minimum": 0,
              "description": "Number of decimals for float values. Defaults to 0 (no rounding).",
              "default": 0,
              "title": "Float Decimals"
            },
            "description": "Number of decimals for float values. Defaults to 0 (no rounding)."
          },
          {
            "name": "vec_decimals",
            "in": "query",
            "required": false,
            "schema": {
              "type": "integer",
              "description": "Number of decimals for vectors. If its negative, exclude vector columns. Defaults to 0 (no rounding).",
              "default": 0,
              "title": "Vec Decimals"
            },
            "description": "Number of decimals for vectors. If its negative, exclude vector columns. Defaults to 0 (no rounding)."
          },
          {
            "name": "Authorization",
            "in": "header",
            "required": true,
            "schema": {
              "type": "string",
              "description": "User PAT or service key.",
              "title": "Authorization"
            },
            "description": "User PAT or service key."
          },
          {
            "name": "X-USER-ID",
            "in": "header",
            "required": false,
            "schema": {
              "type": "string",
              "description": "User ID. Can be omitted if PAT is used as token.",
              "default": "",
              "title": "X-User-Id"
            },
            "description": "User ID. Can be omitted if PAT is used as token."
          },
          {
            "name": "X-PROJECT-ID",
            "in": "header",
            "required": false,
            "schema": {
              "type": "string",
              "description": "Project ID. Can be omitted if PAT is used as token.",
              "default": "",
              "title": "X-Project-Id"
            },
            "description": "Project ID. Can be omitted if PAT is used as token."
          }
        ],
        "responses": {
          "200": {
            "description": "Successful Response",
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/Page_dict_str__Any__"
                }
              }
            }
          },
          "422": {
            "description": "Validation Error",
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/HTTPValidationError"
                }
              }
            }
          }
        }
      }
    }
  },
  "components": {
    "schemas": {
      "HTTPValidationError": {
        "properties": {
          "detail": {
            "items": {
              "$ref": "#/components/schemas/ValidationError"
            },
            "type": "array",
            "title": "Detail"
          }
        },
        "type": "object",
        "title": "HTTPValidationError"
      },
      "Page_dict_str__Any__": {
        "properties": {
          "items": {
            "items": {
              "additionalProperties": true,
              "type": "object"
            },
            "type": "array",
            "title": "Items",
            "description": "List of items paginated items.",
            "default": [],
            "examples": [
              []
            ]
          },
          "offset": {
            "type": "integer",
            "title": "Offset",
            "description": "Number of skipped items.",
            "default": 0,
            "examples": [
              0
            ]
          },
          "limit": {
            "type": "integer",
            "title": "Limit",
            "description": "Number of items per page.",
            "default": 0,
            "examples": [
              0
            ]
          },
          "total": {
            "type": "integer",
            "title": "Total",
            "description": "Total number of items.",
            "default": 0,
            "examples": [
              0
            ]
          },
          "end_cursor": {
            "anyOf": [
              {
                "type": "string"
              },
              {
                "type": "null"
              }
            ],
            "title": "End Cursor",
            "description": "Opaque cursor token for the last item in this page. Pass it as `after=<end_cursor>` to request the page that follows the current window."
          }
        },
        "type": "object",
        "title": "Page[dict[str, Any]]"
      },
      "TableType": {
        "type": "string",
        "enum": [
          "action",
          "knowledge",
          "chat"
        ],
        "title": "TableType"
      },
      "ValidationError": {
        "properties": {
          "loc": {
            "items": {
              "anyOf": [
                {
                  "type": "string"
                },
                {
                  "type": "integer"
                }
              ]
            },
            "type": "array",
            "title": "Location"
          },
          "msg": {
            "type": "string",
            "title": "Message"
          },
          "type": {
            "type": "string",
            "title": "Error Type"
          }
        },
        "type": "object",
        "required": [
          "loc",
          "msg",
          "type"
        ],
        "title": "ValidationError"
      }
    },
    "securitySchemes": {
      "Authentication": {
        "type": "http",
        "scheme": "bearer"
      }
    }
  },
  "security": [
    {
      "Authentication": []
    }
  ]
}
```