Looker · JSON Structure

Looker Write Query Structure

Type: object Properties: 16

AnalyticsBI PlatformBusiness IntelligenceData AnalyticsData Visualization

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

Properties

model view fields pivots fill_fields filters filter_expression sorts limit column_limit total row_total subtotals dynamic_fields vis_config query_timezone

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

JSON Structure

{
  "$schema": "https://json-structure.org/draft/2020-12/schema",
  "name": "WriteQuery",
  "type": "object",
  "properties": {
    "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"
    }
  }
}

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-write-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 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.