Zoho · Schema

GetQueryTableDetailsResponse

AnalyticsCollaborationCRMCustomer ServiceEmailFinanceHuman ResourcesProject ManagementZoho

Properties

Name	Type	Description
status	string
summary	string
data	object

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://raw.githubusercontent.com/api-evangelist/zoho/main/json-schema/zoho-get-query-table-details-response-schema.json",
  "title": "GetQueryTableDetailsResponse",
  "x-generated": "2026-10-04",
  "x-method": "derived",
  "x-generator": "derive-json-schema.py",
  "x-source": "openapi/zoho-metadata-apis-api-openapi.yml#/components/schemas/GetQueryTableDetailsResponse",
  "type": "object",
  "properties": {
    "status": {
      "type": "string"
    },
    "summary": {
      "type": "string"
    },
    "data": {
      "type": "object",
      "properties": {
        "viewId": {
          "type": "string"
        },
        "viewName": {
          "type": "string"
        },
        "viewDesc": {
          "type": "string"
        },
        "sqlQuery": {
          "type": "string"
        },
        "workspaceId": {
          "type": "string"
        },
        "orgId": {
          "type": "string"
        },
        "createdTime": {
          "type": "string",
          "format": "date-time"
        },
        "createdBy": {
          "type": "string"
        },
        "createdByName": {
          "type": "string"
        },
        "createdByZuId": {
          "type": "string"
        },
        "lastDesignModifiedTime": {
          "type": "string",
          "format": "date-time"
        },
        "lastDesignModifiedBy": {
          "type": "string"
        },
        "lastDesignModifiedByName": {
          "type": "string"
        },
        "lastDesignModifiedByZuId": {
          "type": "string"
        },
        "involvedViews": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "viewId": {
                "type": "string"
              },
              "viewName": {
                "type": "string"
              },
              "viewType": {
                "type": "string"
              }
            }
          }
        },
        "columns": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "columnId": {
                "type": "string"
              },
              "columnName": {
                "type": "string"
              },
              "dataType": {
                "type": "string"
              },
              "dataTypeId": {
                "type": "integer"
              },
              "dataTypeName": {
                "type": "string"
              },
              "columnIndex": {
                "type": "integer"
              },
              "columnDesc": {
                "type": "string"
              },
              "columnMaxSize": {
                "type": "integer"
              },
              "isNullable": {
                "type": "boolean"
              },
              "defaultValue": {
                "type": "string"
              },
              "pkTableName": {
                "type": "string"
              },
              "pkColumnName": {
                "type": "string"
              },
              "formulaDisplayName": {
                "type": "string"
              },
              "currencyFormat": {
                "type": "string"
              },
              "thousandSeparator": {
                "type": "string"
              },
              "decimalSeparator": {
                "type": "string"
              },
              "decimalPlaces": {
                "type": "integer"
              },
              "dateFormat": {
                "type": "string"
              },
              "isHidden": {
                "type": "boolean"
              },
              "sortedOrder": {
                "type": "integer"
              },
              "sortedIndex": {
                "type": "integer"
              }
            }
          }
        }
      }
    }
  }
}

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.

All 92 tools →

Call it yourself

curl for this page

This JSON Schema

curl "https://apis.io/api/v1/json-schemas/zoho-get-query-table-details-response"

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.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.