Properties
| Name | Type | Description |
|---|---|---|
| cursor | string | Opaque cursor from the previous response. Scans page in least-recently-updated-first order and reflect concurrent writes: a record updated mid-scan can be returned again, so deduplicate by id. |
| limit | integer | |
| query | object |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://artifacts.apis.io/clay953f/json-schema/clay953f-structured-query-request-schema.json",
"title": "StructuredQueryRequest",
"x-generated": "2026-11-04",
"x-method": "derived",
"x-generator": "derive-json-schema.py",
"x-source": "openapi/clay953f-tables-api-openapi.yml#/components/schemas/StructuredQueryRequest",
"additionalProperties": false,
"properties": {
"cursor": {
"description": "Opaque cursor from the previous response. Scans page in least-recently-updated-first order and reflect concurrent writes: a record updated mid-scan can be returned again, so deduplicate by id.",
"type": "string"
},
"limit": {
"default": 50,
"maximum": 100,
"minimum": 1,
"type": "integer"
},
"query": {
"$ref": "#/$defs/StructuredQuery"
}
},
"required": [
"query"
],
"type": "object",
"$defs": {
"AggregateSelect": {
"additionalProperties": false,
"properties": {
"as": {
"minLength": 1,
"type": "string"
},
"field": {
"minLength": 1,
"type": "string"
},
"fn": {
"enum": [
"count",
"sum",
"avg",
"max",
"min"
],
"type": "string"
},
"path": {
"$ref": "#/$defs/NestedPath"
}
},
"required": [
"fn",
"field",
"as"
],
"type": "object"
},
"FieldSelect": {
"additionalProperties": false,
"properties": {
"as": {
"type": "string"
},
"field": {
"minLength": 1,
"type": "string"
},
"path": {
"$ref": "#/$defs/NestedPath"
},
"table": {
"type": "string"
}
},
"required": [
"field"
],
"type": "object"
},
"FilterAnd": {
"additionalProperties": false,
"properties": {
"and": {
"items": {
"$ref": "#/$defs/FilterExpression"
},
"maxItems": 10,
"minItems": 1,
"type": "array"
}
},
"required": [
"and"
],
"type": "object"
},
"FilterExpression": {
"anyOf": [
{
"$ref": "#/$defs/FilterPredicate"
},
{
"$ref": "#/$defs/FilterAnd"
},
{
"$ref": "#/$defs/FilterOr"
},
{
"$ref": "#/$defs/FilterNot"
}
]
},
"FilterNot": {
"additionalProperties": false,
"properties": {
"not": {
"$ref": "#/$defs/FilterExpression"
}
},
"required": [
"not"
],
"type": "object"
},
"FilterOr": {
"additionalProperties": false,
"properties": {
"or": {
"items": {
"$ref": "#/$defs/FilterExpression"
},
"maxItems": 10,
"minItems": 1,
"type": "array"
}
},
"required": [
"or"
],
"type": "object"
},
"FilterPredicate": {
"additionalProperties": false,
"properties": {
"field": {
"minLength": 1,
"type": "string"
},
"op": {
"enum": [
"=",
"!=",
">",
">=",
"<",
"<=",
"contains",
"not_contains",
"starts_with",
"ends_with",
"in",
"not_in",
"is_empty",
"is_not_empty"
],
"type": "string"
},
"path": {
"$ref": "#/$defs/NestedPath"
},
"value": {
"anyOf": [
{
"type": "string"
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"items": {
"anyOf": [
{
"type": "string"
},
{
"type": "number"
}
]
},
"type": "array"
}
]
}
},
"required": [
"field",
"op"
],
"type": "object"
},
"NestedPath": {
"items": {
"minLength": 1,
"type": "string"
},
"maxItems": 5,
"minItems": 1,
"type": "array"
},
"StructuredQuery": {
"additionalProperties": false,
"properties": {
"field_mode": {
"enum": [
"names",
"ids"
],
"type": "string"
},
"filter": {
"$ref": "#/$defs/FilterExpression"
},
"group_by": {
"items": {
"minLength": 1,
"type": "string"
},
"maxItems": 5,
"type": "array"
},
"join": {
"items": {
"additionalProperties": false,
"properties": {
"on": {
"additionalProperties": false,
"properties": {
"left": {
"minLength": 1,
"type": "string"
},
"right": {
"minLength": 1,
"type": "string"
}
},
"required": [
"left",
"right"
],
"type": "object"
},
"table": {
"minLength": 1,
"type": "string"
},
"type": {
"default": "inner",
"enum": [
"inner",
"left"
],
"type": "string"
}
},
"required": [
"table",
"on"
],
"type": "object"
},
"maxItems": 4,
"type": "array"
},
"order_by": {
"description": "Custom sort. Queries with a custom order_by do not support cursor pagination.",
"items": {
"additionalProperties": false,
"properties": {
"direction": {
"default": "asc",
"enum": [
"asc",
"desc"
],
"type": "string"
},
"field": {
"minLength": 1,
"type": "string"
}
},
"required": [
"field"
],
"type": "object"
},
"maxItems": 3,
"type": "array"
},
"select": {
"items": {
"anyOf": [
{
"$ref": "#/$defs/AggregateSelect"
},
{
"$ref": "#/$defs/FieldSelect"
}
]
},
"maxItems": 20,
"type": "array"
},
"tables": {
"items": {
"additionalProperties": false,
"properties": {
"alias": {
"type": "string"
},
"id": {
"minLength": 1,
"type": "string"
}
},
"required": [
"id"
],
"type": "object"
},
"maxItems": 5,
"minItems": 1,
"type": "array"
}
},
"required": [
"tables"
],
"type": "object"
}
}
}Work with this as data
Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/clay953f-structured-query-request"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.