Looker · JSON Structure

Looker Query Structure

Type: object Properties: 22

AnalyticsBI PlatformBusiness IntelligenceData AnalyticsData Visualization

Query is a JSON Structure definition published by Looker, describing 22 properties. It conforms to the https://json-structure.org/draft/2020-12/schema meta-schema.

Properties

id model view fields pivots fill_fields filters filter_expression sorts limit column_limit total row_total subtotals dynamic_fields vis_config query_timezone client_id slug share_url url has_table_calculations

Meta-schema: https://json-structure.org/draft/2020-12/schema

JSON Structure

{
  "$schema": "https://json-structure.org/draft/2020-12/schema",
  "name": "Query",
  "type": "object",
  "properties": {
    "id": {
      "type": "integer"
    },
    "model": {
      "type": "string"
    },
    "view": {
      "type": "string"
    },
    "fields": {
      "type": "array"
    },
    "pivots": {
      "type": "array"
    },
    "fill_fields": {
      "type": "array"
    },
    "filters": {
      "type": "object"
    },
    "filter_expression": {
      "type": "string"
    },
    "sorts": {
      "type": "array"
    },
    "limit": {
      "type": "string"
    },
    "column_limit": {
      "type": "string"
    },
    "total": {
      "type": "boolean"
    },
    "row_total": {
      "type": "string"
    },
    "subtotals": {
      "type": "array"
    },
    "dynamic_fields": {
      "type": "string"
    },
    "vis_config": {
      "type": "object"
    },
    "query_timezone": {
      "type": "string"
    },
    "client_id": {
      "type": "string"
    },
    "slug": {
      "type": "string"
    },
    "share_url": {
      "type": "string"
    },
    "url": {
      "type": "string"
    },
    "has_table_calculations": {
      "type": "boolean"
    }
  }
}

Work with this as data

Every JSON Structure 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 json structure

4 MCP tools reach this

find_json_structuresBrowse and filter every JSON Structure 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 Structure

curl "https://apis.io/api/v1/json-structures/looker-query-structure"

All json structure

curl "https://apis.io/api/v1/json-structures?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no email required.

GitHub Google LinkedIn

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