Vapi · Schema
JSONQueryOnCallTableWithNumberTypeColumn
Artificial IntelligenceVoiceAgentsReal-TimeCPaaS
Properties
| Name | Type | Description |
|---|---|---|
| type | string | This is the type of query. Only allowed type is "vapiql-json". |
| table | string | This is the table that will be queried. |
| filters | array | This is the filters to apply to the insight. The discriminator automatically selects the correct filter type based on column and operator. |
| column | string | This is the column that will be queried in the selected table. Available columns depend on the selected table. Number Type columns are columns where the rows store Number data |
| operation | string | This is the aggregation operation to perform on the column. When the column is a number type, the operation must be one of the following: - average - sum - min - max |
| name | string | This is the name of the query. It will be used to label the query in the insight board on the UI. |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "#/components/schemas/JSONQueryOnCallTableWithNumberTypeColumn",
"title": "JSONQueryOnCallTableWithNumberTypeColumn",
"type": "object",
"properties": {
"type": {
"type": "string",
"description": "This is the type of query. Only allowed type is \"vapiql-json\".",
"example": "vapiql-json",
"enum": [
"vapiql-json"
]
},
"table": {
"type": "string",
"description": "This is the table that will be queried.",
"enum": [
"call"
]
},
"filters": {
"type": "array",
"description": "This is the filters to apply to the insight.\nThe discriminator automatically selects the correct filter type based on column and operator.",
"items": {
"oneOf": [
{
"$ref": "#/components/schemas/FilterStringTypeColumnOnCallTable"
},
{
"$ref": "#/components/schemas/FilterStringArrayTypeColumnOnCallTable"
},
{
"$ref": "#/components/schemas/FilterNumberTypeColumnOnCallTable"
},
{
"$ref": "#/components/schemas/FilterNumberArrayTypeColumnOnCallTable"
},
{
"$ref": "#/components/schemas/FilterDateTypeColumnOnCallTable"
},
{
"$ref": "#/components/schemas/FilterStructuredOutputColumnOnCallTable"
}
]
}
},
"column": {
"type": "string",
"enum": [
"cost",
"duration",
"averageModelLatency",
"averageVoiceLatency",
"averageTranscriberLatency",
"averageTurnLatency",
"averageEndpointingLatency",
"artifact.structuredOutputs[OutputID]"
],
"description": "This is the column that will be queried in the selected table.\nAvailable columns depend on the selected table.\nNumber Type columns are columns where the rows store Number data",
"example": "duration"
},
"operation": {
"type": "string",
"enum": [
"average",
"sum",
"min",
"max"
],
"description": "This is the aggregation operation to perform on the column.\nWhen the column is a number type, the operation must be one of the following:\n- average\n- sum\n- min\n- max",
"example": "sum"
},
"name": {
"type": "string",
"description": "This is the name of the query.\nIt will be used to label the query in the insight board on the UI.",
"example": "Total Calls"
}
},
"required": [
"type",
"table",
"column",
"operation"
]
}
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/vapi-jsonqueryoncalltablewithnumbertypecolumn"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"
Discovery needs no key. Ratings and market analysis are Pro.
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.