Read all rows in a table with pagination, filtering, and sorting.
Rows are returned as flat objects with column slugs as keys. The response
includes a columns map (slug → display name) so you can resolve human-readable
names. Cells with no value or in an errored state are omitted.
Supports CSV export via the format query parameter.
Whether to apply the table's saved filters and sort order (the same
ones shown in the Origami dashboard). Set to false to get all rows
unfiltered, in insertion order.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Origami API","colors":{"primary":"#fe7bcd","light":"#f865b0","dark":"#db2777"},"logo":{"light":"https://mintcdn.com/origamiagents/XHcb8BJCoB-coV4A/logo/light.svg?fit=max\u0026auto=format\u0026n=XHcb8BJCoB-coV4A\u0026q=85\u0026s=f373c14798a59bfb8cedc4284f55a0ca","dark":"https://mintcdn.com/origamiagents/XHcb8BJCoB-coV4A/logo/dark.svg?fit=max\u0026auto=format\u0026n=XHcb8BJCoB-coV4A\u0026q=85\u0026s=093cb5c8097b2da659e228d2550eea17"},"favicon":"https://mintcdn.com/origamiagents/mxZjiz8CSMmrStmV/favicon.svg?fit=max\u0026auto=format\u0026n=mxZjiz8CSMmrStmV\u0026q=85\u0026s=7cc57639b284f223ef20a2e7c68310c9","appearance":{"default":"light","strict":false},"navbar":{"links":[{"href":"mailto:hello@origamiagents.com","label":"Support"}],"primary":{"type":"button","label":"Dashboard","href":"https://origami.chat"}},"footer":{},"contextual":{"options":["copy","view","chatgpt","claude","cursor"],"display":"header"},"styling":{"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"origamiagents","hasAudioNarration":false,"actualSubdomain":"origamiagents","customDomains":["docs.origami.chat"],"gitSource":{"type":"github","owner":"origami-agents","repo":"mintlify-docs","deployBranch":"main","isPrivate":false,"contentDirectory":"","mountPath":"","label":""},"chroma":{"liveDeploymentHistoryId":"6a95e4f4a93e41658f2495e7","collectionId":"f921f926-53b2-4f04-9679-77c54a1d2ae7","schemaVersion":"v3","latestBuiltDeploymentHistoryId":"6a95e4f4a93e41658f2495e7"},"entitlements":{},"buildId":"6a95e4f4a93e41658f2495e7","clientVersion":"0.0.4067","searchFilterCounts":[{"language":"default","tag":"v3 API","count":129},{"language":"default","tag":"v2 API","count":79},{"language":"default","tag":"Account","count":59},{"language":"default","tag":"Send","count":39},{"language":"default","tag":"Leads","count":23},{"language":"default","tag":"Campaigns","count":22},{"language":"default","tag":"Webhooks","count":16},{"language":"default","tag":"People","count":14},{"language":"default","tag":"Guide","count":11},{"language":"default","tag":"API Reference","count":11}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"api-reference/tables/read-table-rows","slug":"/api-reference/tables/read-table-rows","pageMetadata":{"title":"Read table rows","description":"Read all rows in a table with pagination, filtering, and sorting.\n\nRows are returned as flat objects with column **slugs** as keys. The response\nincludes a `columns` map (slug → display name) so you can resolve human-readable\nnames. Cells with no value or in an errored state are omitted.\n\nSupports CSV export via the `format` query parameter.\n","deprecated":null,"version":null,"openapi":"/openapi-v1.yaml get /tables/{tableId}/rows","href":"/api-reference/tables/read-table-rows","autogeneratedByOpenApi":true},"description":{"compiledSource":"\"use strict\";\nconst {Fragment: _Fragment, jsx: _jsx, jsxs: _jsxs} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n code: \"code\",\n p: \"p\",\n strong: \"strong\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsxs(_Fragment, {\n children: [_jsx(_components.p, {\n children: \"Read all rows in a table with pagination, filtering, and sorting.\"\n }), \"\\n\", _jsxs(_components.p, {\n children: [\"Rows are returned as flat objects with column \", _jsx(_components.strong, {\n children: \"slugs\"\n }), \" as keys. The response\\nincludes a \", _jsx(_components.code, {\n children: \"columns\"\n }), \" map (slug → display name) so you can resolve human-readable\\nnames. Cells with no value or in an errored state are omitted.\"]\n }), \"\\n\", _jsxs(_components.p, {\n children: [\"Supports CSV export via the \", _jsx(_components.code, {\n children: \"format\"\n }), \" query parameter.\"]\n })]\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){return _jsx(_Fragment,{})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Read table rows","description":"Read all rows in a table with pagination, filtering, and sorting.\n\nRows are returned as flat objects with column **slugs** as keys. The response\nincludes a `columns` map (slug → display name) so you can resolve human-readable\nnames. Cells with no value or in an errored state are omitted.\n\nSupports CSV export via the `format` query parameter.\n","deprecated":null,"version":null,"openapi":"/openapi-v1.yaml get /tables/{tableId}/rows","href":"/api-reference/tables/read-table-rows","autogeneratedByOpenApi":true}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":[],"openApiReferenceData":{"operation":{"operationId":"getTableRows","summary":"Read table rows","description":"Read all rows in a table with pagination, filtering, and sorting.\n\nRows are returned as flat objects with column **slugs** as keys. The response\nincludes a `columns` map (slug → display name) so you can resolve human-readable\nnames. Cells with no value or in an errored state are omitted.\n\nSupports CSV export via the `format` query parameter.\n","tags":["Tables"],"parameters":["5fbeb91a-9a01-4251-be60-98950845faf6","c32b937f-33c5-4a96-ae12-0f1cddaec779","96e92154-468c-442b-ac39-833c857d0c15","07b092c5-63d6-46a6-91e0-3d70a9473887","e1732023-0708-436f-9b89-abdac37295df","f9643381-3371-4544-95fa-07c344c59640","328c3b49-9aa2-4942-af73-a76295d39d28","34903881-d07c-4557-8519-1629c37efe1e"],"responses":{"200":"fa1a40c7-ebf4-425b-8e7b-5d9e643c0787","400":"fe01ded5-83ab-4166-adf5-072940ffae24","401":"689625ee-5188-4932-97fd-a747cf41230e","402":"99dc9d82-76c3-40b2-b107-179897d6fab4","404":"64ebb7fa-7f0a-47c9-8a66-615e522799fb","429":"ecb599a6-fb66-446a-bcac-d4e3a158d13a","500":"f4e79ecd-ad64-4c64-ac2d-f21efe5ccad4"},"method":"get","type":"path","servers":["7c65050f-73b2-4171-a30b-095d147fbd73"],"security":["a469a3f7-fc19-43ae-a31d-59e03e274c51"],"path":"/tables/{tableId}/rows","baseUrlOptions":["https://origami.chat/api/v1"],"title":"Read table rows","codeSamples":[],"requiredOnlyExamples":false,"requestExampleType":"generated","responseExampleType":"generated"},"dependencies":{"parameters":{"5fbeb91a-9a01-4251-be60-98950845faf6":{"name":"tableId","in":"path","required":true,"schema":{"type":"string","format":"uuid","isRequired":true,"description":"The table UUID. Use `GET /tables` to list available tables.","uniqueKey":"","typeLabel":"string\u003cuuid>"},"description":"The table UUID. Use `GET /tables` to list available tables."},"c32b937f-33c5-4a96-ae12-0f1cddaec779":{"name":"page","in":"query","schema":{"type":"integer","default":0,"minimum":0,"description":"Zero-based page index.","uniqueKey":"","typeLabel":"integer"},"description":"Zero-based page index."},"96e92154-468c-442b-ac39-833c857d0c15":{"name":"pageSize","in":"query","schema":{"type":"integer","default":50,"minimum":1,"maximum":500,"description":"Number of rows per page (max 500).","uniqueKey":"","typeLabel":"integer"},"description":"Number of rows per page (max 500)."},"07b092c5-63d6-46a6-91e0-3d70a9473887":{"name":"filters","in":"query","schema":{"type":"string","description":"JSON-encoded array of filter objects. Each filter uses a column **slug**\n(from `GET /tables`), an `operator`, and a `value`.\n\nOperators: `contains`, `not_contains`, `equals`, `not_equals`,\n`is_empty`, `is_not_empty`, `greater_than`, `greater_than_or_equal`,\n`less_than`, `less_than_or_equal`.\n\nWhen provided, the table's default filters are **replaced** by these.\n","uniqueKey":"","typeLabel":"string"},"description":"JSON-encoded array of filter objects. Each filter uses a column **slug**\n(from `GET /tables`), an `operator`, and a `value`.\n\nOperators: `contains`, `not_contains`, `equals`, `not_equals`,\n`is_empty`, `is_not_empty`, `greater_than`, `greater_than_or_equal`,\n`less_than`, `less_than_or_equal`.\n\nWhen provided, the table's default filters are **replaced** by these.\n","example":"[{\"column\":\"website\",\"operator\":\"is_not_empty\",\"value\":\"\"}]"},"e1732023-0708-436f-9b89-abdac37295df":{"name":"sort","in":"query","schema":{"type":"string","description":"JSON-encoded sort object with a column **slug** and direction.\nWhen provided, the table's default sort is **replaced** by this.\n","uniqueKey":"","typeLabel":"string"},"description":"JSON-encoded sort object with a column **slug** and direction.\nWhen provided, the table's default sort is **replaced** by this.\n","example":"{\"column\":\"quality-score\",\"direction\":\"desc\"}"},"f9643381-3371-4544-95fa-07c344c59640":{"name":"columns","in":"query","schema":{"type":"string","description":"Comma-separated list of column slugs to include in the response.\nOmit to return all columns. Use slugs from `GET /tables`.\n","uniqueKey":"","typeLabel":"string"},"description":"Comma-separated list of column slugs to include in the response.\nOmit to return all columns. Use slugs from `GET /tables`.\n","example":"company-name,website,quality-score"},"328c3b49-9aa2-4942-af73-a76295d39d28":{"name":"defaults","in":"query","schema":{"type":"string","enum":["true","false"],"default":"true","description":"Whether to apply the table's saved filters and sort order (the same\nones shown in the Origami dashboard). Set to `false` to get all rows\nunfiltered, in insertion order.\n","uniqueKey":"","typeLabel":"enum\u003cstring>"},"description":"Whether to apply the table's saved filters and sort order (the same\nones shown in the Origami dashboard). Set to `false` to get all rows\nunfiltered, in insertion order.\n"},"34903881-d07c-4557-8519-1629c37efe1e":{"name":"format","in":"query","schema":{"type":"string","enum":["json","csv"],"default":"json","description":"Response format. Use `csv` for spreadsheet-compatible export.","uniqueKey":"","typeLabel":"enum\u003cstring>"},"description":"Response format. Use `csv` for spreadsheet-compatible export."}},"responses":{"fa1a40c7-ebf4-425b-8e7b-5d9e643c0787":{"description":"Rows retrieved successfully.","content":{"application/json":{"schema":{"type":"object","required":["columns","rows","total","page","pageSize"],"properties":{"columns":{"type":"object","additionalProperties":{"type":"string","uniqueKey":"columns.additionalProperties","typeLabel":"string"},"description":"Map of column slug → display name. Use this to resolve the slug keys\nin each row object to human-readable column names.\n","isRequired":true,"uniqueKey":"columns","typeLabel":"object"},"rows":{"type":"array","items":{"type":"object","required":["id"],"properties":{"id":{"type":"string","format":"uuid","description":"Row UUID.","isRequired":true,"uniqueKey":"rows.items.[INDEX].id","typeLabel":"string\u003cuuid>"}},"additionalProperties":true,"description":"Flat object with column **slugs** as keys. Values are strings, numbers,\nor arrays depending on column type. Cells with no value are omitted.\nUse the `columns` map in the response to resolve slugs to display names.\n","uniqueKey":"rows.items.[INDEX]","typeLabel":"object"},"isRequired":true,"uniqueKey":"rows","typeLabel":"object[]"},"total":{"type":"integer","description":"Total number of rows matching the query (before pagination).","isRequired":true,"uniqueKey":"total","typeLabel":"integer"},"page":{"type":"integer","description":"Current page index (zero-based).","isRequired":true,"uniqueKey":"page","typeLabel":"integer"},"pageSize":{"type":"integer","description":"Number of rows per page.","isRequired":true,"uniqueKey":"pageSize","typeLabel":"integer"}},"uniqueKey":"","typeLabel":"object"},"example":{"columns":{"company-name":"Company Name","website":"Website","ceo-email":"CEO Email"},"rows":[{"id":"a1b2c3d4-e5f6-7890-abcd-ef1234567890","company-name":"Acme Corp","website":"acme.com","ceo-email":"ceo@acme.com"}],"total":1234,"page":0,"pageSize":50},"examples":{"Example":{"title":"Example","value":{"columns":{"company-name":"Company Name","website":"Website","ceo-email":"CEO Email"},"rows":[{"id":"a1b2c3d4-e5f6-7890-abcd-ef1234567890","company-name":"Acme Corp","website":"acme.com","ceo-email":"ceo@acme.com"}],"total":1234,"page":0,"pageSize":50}}},"exampleType":"examples"},"text/csv":{"schema":{"type":"string","uniqueKey":"","typeLabel":"string"},"examples":{"Example":{"title":"Example","value":"\u003cstring>"}},"exampleType":"generated"}},"exampleType":"examples"},"fe01ded5-83ab-4166-adf5-072940ffae24":{"description":"Invalid query parameters.","content":{"application/json":{"schema":{"type":"object","required":["error","code"],"properties":{"error":{"type":"string","description":"Human-readable error message.","isRequired":true,"uniqueKey":"error","typeLabel":"string"},"code":{"type":"string","description":"Machine-readable error code.","isRequired":true,"uniqueKey":"code","typeLabel":"string"}},"additionalProperties":true,"uniqueKey":"","typeLabel":"object"},"examples":{"invalidFilters":{"title":"invalidFilters","value":{"error":"Invalid filters JSON","code":"INVALID_FILTERS"}},"invalidSort":{"title":"invalidSort","value":{"error":"Invalid sort JSON","code":"INVALID_SORT"}},"unknownColumn":{"title":"unknownColumn","value":{"error":"Unknown filter columns","code":"UNKNOWN_COLUMN","columns":["nonexistent-column"]}},"validationError":{"title":"validationError","value":{"error":"Invalid filter operator","code":"VALIDATION_ERROR","operators":["bad_operator"]}}},"exampleType":"examples"}},"exampleType":"examples"},"689625ee-5188-4932-97fd-a747cf41230e":{"description":"Missing, invalid, revoked, or expired API key.","content":{"application/json":{"schema":{"type":"object","required":["error","code"],"properties":{"error":{"type":"string","description":"Human-readable error message.","isRequired":true,"uniqueKey":"error","typeLabel":"string"},"code":{"type":"string","description":"Machine-readable error code.","isRequired":true,"uniqueKey":"code","typeLabel":"string"}},"additionalProperties":true,"uniqueKey":"","typeLabel":"object"},"example":{"error":"Invalid API key","code":"UNAUTHORIZED"},"examples":{"Example":{"title":"Example","value":{"error":"Invalid API key","code":"UNAUTHORIZED"}}},"exampleType":"examples"}},"exampleType":"examples"},"99dc9d82-76c3-40b2-b107-179897d6fab4":{"description":"Feature requires a plan upgrade.","content":{"application/json":{"schema":{"type":"object","required":["error","code"],"properties":{"error":{"type":"string","description":"Human-readable error message.","isRequired":true,"uniqueKey":"error","typeLabel":"string"},"code":{"type":"string","description":"Machine-readable error code.","isRequired":true,"uniqueKey":"code","typeLabel":"string"}},"additionalProperties":true,"uniqueKey":"","typeLabel":"object"},"example":{"error":"Subscription required","code":"SUBSCRIPTION_REQUIRED","hint":"Upgrade to a Growth or Business plan to use this feature."},"examples":{"Example":{"title":"Example","value":{"error":"Subscription required","code":"SUBSCRIPTION_REQUIRED","hint":"Upgrade to a Growth or Business plan to use this feature."}}},"exampleType":"examples"}},"exampleType":"examples"},"64ebb7fa-7f0a-47c9-8a66-615e522799fb":{"description":"Table not found or does not belong to this organization.","content":{"application/json":{"schema":{"type":"object","required":["error","code"],"properties":{"error":{"type":"string","description":"Human-readable error message.","isRequired":true,"uniqueKey":"error","typeLabel":"string"},"code":{"type":"string","description":"Machine-readable error code.","isRequired":true,"uniqueKey":"code","typeLabel":"string"}},"additionalProperties":true,"uniqueKey":"","typeLabel":"object"},"example":{"error":"Table not found","code":"NOT_FOUND"},"examples":{"Example":{"title":"Example","value":{"error":"Table not found","code":"NOT_FOUND"}}},"exampleType":"examples"}},"exampleType":"examples"},"ecb599a6-fb66-446a-bcac-d4e3a158d13a":{"description":"Rate limit exceeded.","headers":{"X-RateLimit-Limit-IP":{"schema":{"type":"integer"},"description":"IP bucket: maximum requests allowed in the window."},"X-RateLimit-Remaining-IP":{"schema":{"type":"integer"},"description":"IP bucket: requests remaining in the current window."},"X-RateLimit-Reset-IP":{"schema":{"type":"integer"},"description":"IP bucket: Unix timestamp when the window resets."},"X-RateLimit-Limit-Global":{"schema":{"type":"integer"},"description":"Organization bucket: maximum requests allowed in the window."},"X-RateLimit-Remaining-Global":{"schema":{"type":"integer"},"description":"Organization bucket: requests remaining in the current window."},"X-RateLimit-Reset-Global":{"schema":{"type":"integer"},"description":"Organization bucket: Unix timestamp when the window resets."},"X-RateLimit-Limit-Insert":{"schema":{"type":"integer"},"description":"Insert bucket: maximum requests allowed in the window (write routes only)."},"X-RateLimit-Remaining-Insert":{"schema":{"type":"integer"},"description":"Insert bucket: requests remaining in the current window."},"X-RateLimit-Reset-Insert":{"schema":{"type":"integer"},"description":"Insert bucket: Unix timestamp when the window resets."}},"content":{"application/json":{"schema":{"type":"object","required":["error","code"],"properties":{"error":{"type":"string","description":"Human-readable error message.","isRequired":true,"uniqueKey":"error","typeLabel":"string"},"code":{"type":"string","description":"Machine-readable error code.","isRequired":true,"uniqueKey":"code","typeLabel":"string"}},"additionalProperties":true,"uniqueKey":"","typeLabel":"object"},"example":{"error":"Rate limit exceeded","code":"RATE_LIMITED"},"examples":{"Example":{"title":"Example","value":{"error":"Rate limit exceeded","code":"RATE_LIMITED"}}},"exampleType":"examples"}},"exampleType":"examples"},"f4e79ecd-ad64-4c64-ac2d-f21efe5ccad4":{"description":"Unexpected server error.","content":{"application/json":{"schema":{"type":"object","required":["error","code"],"properties":{"error":{"type":"string","description":"Human-readable error message.","isRequired":true,"uniqueKey":"error","typeLabel":"string"},"code":{"type":"string","description":"Machine-readable error code.","isRequired":true,"uniqueKey":"code","typeLabel":"string"}},"additionalProperties":true,"uniqueKey":"","typeLabel":"object"},"example":{"error":"Internal server error","code":"INTERNAL_ERROR"},"examples":{"Example":{"title":"Example","value":{"error":"Internal server error","code":"INTERNAL_ERROR"}}},"exampleType":"examples"}},"exampleType":"examples"}},"security":{"a469a3f7-fc19-43ae-a31d-59e03e274c51":{"apiKey":{"type":"http","scheme":"bearer","bearerFormat":"og_live_*","description":"API key with `og_live_` prefix. Create keys in **Settings → API Keys**.\n\nPass in the `Authorization` header:\n```\nAuthorization: Bearer og_live_abc123...\n```\n","scopes":[]}}},"servers":{"7c65050f-73b2-4171-a30b-095d147fbd73":{"url":"https://origami.chat/api/v1","description":"Production"}},"processedSecurityOptions":[{"schemes":[{"scheme":{"type":"http","scheme":"bearer","bearerFormat":"og_live_*","description":"API key with `og_live_` prefix. Create keys in **Settings → API Keys**.\n\nPass in the `Authorization` header:\n```\nAuthorization: Bearer og_live_abc123...\n```\n","scopes":[]},"schema":{"title":"Bearer Auth","type":"string","isRequired":true,"description":"API key with `og_live_` prefix. Create keys in **Settings → API Keys**.\n\nPass in the `Authorization` header:\n```\nAuthorization: Bearer og_live_abc123...\n```\n","format":"bearer","typeLabel":"string\u003cbearer>","deprecated":false},"schemeName":"apiKey","name":"Authorization"}],"title":"apiKey"}]},"originalFileLocation":"openapi-v1.yaml"},"subdomain":"origamiagents","siteName":"Origami API","title":"Read table rows - Origami API","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-08-25T18:43:17.489Z","originalFileLocation":"api-reference/tables/read-table-rows.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"light\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Read all rows in a table with pagination, filtering, and sorting. Rows are returned as flat objects with column slugs as keys. The response includes a columns map (slug → display name) so you can resolve human-readable names. Cells with no value or in an errored state are omitted. Supports CSV export via the format query parameter.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Origami API\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/origamiagents/zjsdEZpGw8t3MGzV/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/origamiagents/zjsdEZpGw8t3MGzV/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/origamiagents/zjsdEZpGw8t3MGzV/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/origamiagents/zjsdEZpGw8t3MGzV/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/origamiagents/zjsdEZpGw8t3MGzV/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/origamiagents/zjsdEZpGw8t3MGzV/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/origamiagents/zjsdEZpGw8t3MGzV/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/origamiagents/zjsdEZpGw8t3MGzV/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/origamiagents/zjsdEZpGw8t3MGzV/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Read table rows - Origami API\">\u003cmeta data-mint-head property=\"og:description\" content=\"Read all rows in a table with pagination, filtering, and sorting. Rows are returned as flat objects with column slugs as keys. The response includes a columns map (slug → display name) so you can resolve human-readable names. Cells with no value or in an errored state are omitted. Supports CSV export via the format query parameter.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Origami API\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.origami.chat/api-reference/tables/read-table-rows\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://origamiagents.mintlify.app/_mintlify/api/og/v2?division=Tables\u0026amp;title=Read+table+rows\u0026amp;description=Read+all+rows+in+a+table+with+pagination%2C+filtering%2C+and+sorting.%0A%0ARows+are+returned+as+flat+objects+with+column+**slugs**+as+keys.+The+response%0Aincludes+a+%60col\u0026amp;theme=e0ce817f1c64e26a408cc8e3\u0026amp;signature=3cda35f4d7a535a3bd417a518bad231781af3f5b4684a66046b5da620c29284c\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Read table rows - Origami API\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Read all rows in a table with pagination, filtering, and sorting. Rows are returned as flat objects with column slugs as keys. The response includes a columns map (slug → display name) so you can resolve human-readable names. Cells with no value or in an errored state are omitted. Supports CSV export via the format query parameter.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://origamiagents.mintlify.app/_mintlify/api/og/v2?division=Tables\u0026amp;title=Read+table+rows\u0026amp;description=Read+all+rows+in+a+table+with+pagination%2C+filtering%2C+and+sorting.%0A%0ARows+are+returned+as+flat+objects+with+column+**slugs**+as+keys.+The+response%0Aincludes+a+%60col\u0026amp;theme=e0ce817f1c64e26a408cc8e3\u0026amp;signature=3cda35f4d7a535a3bd417a518bad231781af3f5b4684a66046b5da620c29284c\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/origamiagents/zjsdEZpGw8t3MGzV/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Origami API\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#fe7bcd\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.origami.chat/api-reference/tables/read-table-rows\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/api-reference/tables/read-table-rows.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.origami.chat/#organization\",\"name\":\"Origami API\",\"url\":\"https://docs.origami.chat\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/origamiagents/XHcb8BJCoB-coV4A/logo/light.svg?fit=max\u0026auto=format\u0026n=XHcb8BJCoB-coV4A\u0026q=85\u0026s=f373c14798a59bfb8cedc4284f55a0ca\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.origami.chat#website\",\"name\":\"Origami API\",\"url\":\"https://docs.origami.chat\",\"publisher\":{\"@id\":\"https://docs.origami.chat/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.origami.chat/api-reference/tables/read-table-rows#webpage\",\"url\":\"https://docs.origami.chat/api-reference/tables/read-table-rows\",\"name\":\"Read table rows\",\"description\":\"Read all rows in a table with pagination, filtering, and sorting. Rows are returned as flat objects with column slugs as keys. The response includes a columns map (slug → display name) so you can resolve human-readable names. Cells with no value or in an errored state are omitted. Supports CSV export via the format query parameter.\",\"dateModified\":\"2026-08-25T18:43:17.489Z\",\"isPartOf\":{\"@id\":\"https://docs.origami.chat#website\"},\"breadcrumb\":{\"@id\":\"https://docs.origami.chat/api-reference/tables/read-table-rows#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.origami.chat/api-reference/tables/read-table-rows#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Data API (v1)\",\"item\":\"https://docs.origami.chat/api-reference/tables/list-tables\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tables\",\"item\":\"https://docs.origami.chat/api-reference/tables/list-tables\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Read table rows\",\"item\":\"https://docs.origami.chat/api-reference/tables/read-table-rows\"}]},{\"@type\":[\"TechArticle\",\"APIReference\"],\"@id\":\"https://docs.origami.chat/api-reference/tables/read-table-rows#apireference\",\"headline\":\"Read table rows\",\"name\":\"Read table rows\",\"description\":\"Read all rows in a table with pagination, filtering, and sorting. Rows are returned as flat objects with column slugs as keys. The response includes a columns map (slug → display name) so you can resolve human-readable names. Cells with no value or in an errored state are omitted. Supports CSV export via the format query parameter.\",\"url\":\"https://docs.origami.chat/api-reference/tables/read-table-rows\",\"mainEntityOfPage\":{\"@id\":\"https://docs.origami.chat/api-reference/tables/read-table-rows#webpage\"},\"dateModified\":\"2026-08-25T18:43:17.489Z\",\"publisher\":{\"@id\":\"https://docs.origami.chat/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.origami.chat#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Origami API\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"Origami API","nav":{"global":null,"tabs":[{"tab":"Guides","pages":[{"title":"Guides","href":""}]},{"tab":"v3 API","pages":[{"title":"v3 API","href":"/v3/overview"}]},{"tab":"v2 API","pages":[{"title":"v2 API","href":"/agents"}]},{"tab":"Webhooks","pages":[{"title":"Webhooks","href":"/webhooks/overview"}]},{"tab":"Deprecated","groups":[{"group":"Migration","pages":[{"title":"Migrate from v2 to v3","href":"/api-v2-to-v3-migration"},{"title":"Migrating from v1 to v2","href":"/api-v1-to-v2-migration"}]},{"group":"Data API (v1)","pages":[{"group":"Tables","pages":[{"title":"List tables","description":"Returns all tables in the organization with column metadata.\nThe API key scopes to the org; no workspace ID needed.\n\nThe typical workflow is: list tables → find the one you want by name → note its\ninput columns → use the `tableId` and column slugs in `POST /tables/{tableId}/rows`.\n","deprecated":null,"version":null,"openapi":"/openapi-v1.yaml get /tables","href":"/api-reference/tables/list-tables"},{"title":"Read table rows","deprecated":null,"version":null,"openapi":"/openapi-v1.yaml get /tables/{tableId}/rows","href":"/api-reference/tables/read-table-rows"}]},{"group":"Rows","pages":[{"title":"Insert rows","description":"Insert rows into an existing table. Returns a batch ID immediately; poll\n`GET /batches/{batchId}` for enrichment progress and results.\n\n**Column matching:** Field names in each row object are matched to **input** columns\nby **slug** (exact match). Only columns with `kind: \"input\"` are accepted;\nenrichment and score columns are populated automatically. Use `GET /tables` to\ndiscover available column slugs and their kinds.\n\n**Enrichment:** By default (`enrich: true`), all auto-trigger enrichment columns run\nimmediately after insertion. Set `enrich: false` to insert data without triggering enrichment.\n\n**Credits:** Credit shortfalls do not fail the insert synchronously; they surface later\nin the batch's `failures.insufficientCredits` (poll `GET /batches/{batchId}`).\n\n**Deduplication \u0026 exclusion lists** apply automatically; the same table-level rules\nfrom the UI are enforced. Duplicate or excluded rows are inserted but may not enrich.\n\n**Limits:**\n- Maximum **100 rows** per request.\n- Free-plan tables are capped at **30 rows** total.\n","deprecated":null,"version":null,"openapi":"/openapi-v1.yaml post /tables/{tableId}/rows","href":"/api-reference/rows/insert-rows"}]},{"group":"Batches","pages":[{"title":"Get batch","deprecated":null,"version":null,"openapi":"/openapi-v1.yaml get /batches/{batchId}","href":"/api-reference/batches/get-batch"}]},{"group":"Credits","pages":[{"title":"Get credit balance","deprecated":null,"version":null,"openapi":"/openapi-v1.yaml get /credits","href":"/api-reference/credits/get-credit-balance"}]}]}]}]},"basePath":"","title":"Read table rows - Origami API","buildId":"dpl_9VVk5y1P8k1ATeJguVngy9Q3cmbD","deploymentId":"dpl_9VVk5y1P8k1ATeJguVngy9Q3cmbD","dynamics":["c2aa737661","2b790eda92","b0f84f53ff","a9bb46feb3"],"chunks":["OpenApiReferenceProvider-DX1Meug0.js","utils-B_OMIQVC.js","cloneDeep-izs3Hzxb.js","_Uint8Array-BVIqJ90l.js","isObjectLike-C8vmzPEN.js","isArray-Dcu1dQ5t.js","utils-ChxhRPMa.js","toString-BX-iyh8G.js","isSymbol-CSH9U2Gm.js","addUniqueKeysToSchema-CuKvD8Iv.js","snippetPresets-C5d7p2hp.js","style-to-object-BY3JEAdk.js","v4-DIgz8zy6.js","ApiExamples-CfHcE8m4.js","isEqual-BfaiBbcl.js","usePlaygroundInputsStore-C1zZV314.js","shallow-CmQhqCJn.js","getApiPlaygroundDisplay-YRo9s1O7.js","CodeSnippet-RN1MTdfk.js","CodeSnippets-DKLPHxJA.js","Page-BAvA99GL.js","getPastedJson-bz0M41mU.js","icon-CsmhpPrv.js","MethodPill-CNGsVE77.js","DuplicateIcon-DilfU_Z2.js","createIcon-BdsYzQck.js","DynamicMarkdown-CbqEDjbV.js","SectionHeading-O6hXpFCN.js","axios-vUo_bRtp.js","Markdown-nKm-uidQ.js","clsx-ClVdStUn.js","lib-DuNMoZ05.js","lib-B8HbPgcC.js","html-void-elements-mCSPHezU.js","dist-CIQkMg3R.js","katex-YMM-FMeD.js","marked.esm-CZWythHk.js","AssistantPageLink-ImrFS4Fy.js"]}