post_chart_data

{
  "type": "object",
  "properties": {
    "datasource": {
      "type": "object",
      "required": [
        "id"
      ],
      "properties": {
        "id": {
          "type": "integer",
          "format": "int32",
          "description": "Datasource id"
        },
        "type": {
          "type": "string",
          "description": "Datasource type",
          "enum": [
            "druid",
            "table"
          ]
        }
      }
    },
    "force": {
      "type": "boolean",
      "description": "Should the queries be forced to load from the source. Default: `false`"
    },
    "queries": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "annotation_layers": {
            "type": "array",
            "description": "Annotation layers to apply to chart",
            "items": {
              "type": "object",
              "required": [
                "name",
                "show",
                "showMarkers",
                "value"
              ],
              "properties": {
                "annotationType": {
                  "type": "string",
                  "description": "Type of annotation layer",
                  "enum": [
                    "FORMULA",
                    "INTERVAL",
                    "EVENT",
                    "TIME_SERIES"
                  ]
                },
                "color": {
                  "type": "string",
                  "description": "Layer color"
                },
                "descriptionColumns": {
                  "type": "array",
                  "description": "Columns to use as the description. If none are provided, all will be shown.",
                  "items": {
                    "type": "string"
                  }
                },
                "hideLine": {
                  "type": "boolean",
                  "description": "Should line be hidden. Only applies to line annotations"
                },
                "intervalEndColumn": {
                  "type": "string",
                  "description": "Column containing end of interval. Only applies to interval layers"
                },
                "name": {
                  "type": "string",
                  "description": "Name of layer"
                },
                "opacity": {
                  "type": "string",
                  "description": "Opacity of layer",
                  "enum": [
                    "",
                    "opacityLow",
                    "opacityMedium",
                    "opacityHigh"
                  ]
                },
                "overrides": {
                  "type": "object",
                  "description": "which properties should be overridable"
                },
                "show": {
                  "type": "boolean",
                  "description": "Should the layer be shown"
                },
                "showMarkers": {
                  "type": "boolean",
                  "description": "Should markers be shown. Only applies to line annotations."
                },
                "sourceType": {
                  "type": "string",
                  "description": "Type of source for annotation data",
                  "enum": [
                    "",
                    "line",
                    "NATIVE",
                    "table"
                  ]
                },
                "style": {
                  "type": "string",
                  "description": "Line style. Only applies to time-series annotations",
                  "enum": [
                    "dashed",
                    "dotted",
                    "solid",
                    "longDashed"
                  ]
                },
                "timeColumn": {
                  "type": "string",
                  "description": "Column with event date or interval start date"
                },
                "titleColumn": {
                  "type": "string",
                  "description": "Column with title"
                },
                "value": {
                  "description": "For formula annotations, this contains the formula. For other types, this is the primary key of the source object.",
                  "type": "object"
                },
                "width": {
                  "type": "number",
                  "format": "float",
                  "description": "Width of annotation line"
                }
              }
            }
          },
          "applied_time_extras": {
            "type": "object",
            "description": "A mapping of temporal extras that have been applied to the query"
          },
          "apply_fetch_values_predicate": {
            "type": "boolean",
            "description": "Add fetch values predicate (where clause) to query if defined in datasource"
          },
          "columns": {
            "type": "array",
            "description": "Columns which to select in the query.",
            "items": {
              "type": "string"
            }
          },
          "datasource": {
            "type": "object"
          },
          "druid_time_origin": {
            "type": "string",
            "description": "Starting point for time grain counting on legacy Druid datasources. Used to change e.g. Monday/Sunday first-day-of-week. This field is deprecated and should be passed to `extras` as `druid_time_origin`."
          },
          "extras": {
            "description": "Extra parameters to add to the query.",
            "type": "object"
          },
          "filters": {
            "type": "array",
            "items": {
              "type": "object",
              "required": [
                "col",
                "op"
              ],
              "properties": {
                "col": {
                  "type": "string",
                  "description": "The column to filter."
                },
                "op": {
                  "type": "string",
                  "description": "The comparison operator.",
                  "enum": [
                    "==",
                    "!=",
                    ">",
                    "<",
                    ">=",
                    "<=",
                    "LIKE",
                    "ILIKE",
                    "IS NULL",
                    "IS NOT NULL",
                    "IN",
                    "NOT IN",
                    "REGEX",
                    "IS TRUE",
                    "IS FALSE"
                  ]
                },
                "val": {
                  "description": "The value or values to compare against. Can be a string, integer, decimal or list, depending on the operator.",
                  "type": "object"
                }
              }
            }
          },
          "granularity": {
            "type": "string",
            "description": "Name of temporal column used for time filtering. For legacy Druid datasources this defines the time grain."
          },
          "granularity_sqla": {
            "type": "string",
            "description": "Name of temporal column used for time filtering for SQL datasources. This field is deprecated, use `granularity` instead."
          },
          "groupby": {
            "type": "array",
            "items": {
              "type": "string",
              "description": "Columns by which to group the query."
            }
          },
          "having": {
            "type": "string",
            "description": "HAVING clause to be added to aggregate queries using AND operator. This field is deprecated and should be passed to `extras`."
          },
          "having_filters": {
            "type": "array",
            "description": "HAVING filters to be added to legacy Druid datasource queries. This field is deprecated and should be passed to `extras` as `having_druid`.",
            "items": {
              "type": "object",
              "required": [
                "col",
                "op"
              ],
              "properties": {
                "col": {
                  "type": "string",
                  "description": "The column to filter."
                },
                "op": {
                  "type": "string",
                  "description": "The comparison operator.",
                  "enum": [
                    "==",
                    "!=",
                    ">",
                    "<",
                    ">=",
                    "<=",
                    "LIKE",
                    "ILIKE",
                    "IS NULL",
                    "IS NOT NULL",
                    "IN",
                    "NOT IN",
                    "REGEX",
                    "IS TRUE",
                    "IS FALSE"
                  ]
                },
                "val": {
                  "description": "The value or values to compare against. Can be a string, integer, decimal or list, depending on the operator.",
                  "type": "object"
                }
              }
            }
          },
          "is_rowcount": {
            "type": "boolean",
            "description": "Should the rowcount of the actual query be returned"
          },
          "is_timeseries": {
            "type": "boolean",
            "description": "Is the `query_object` a timeseries."
          },
          "metrics": {
            "type": "array",
            "description": "Aggregate expressions. Metrics can be passed as both references to datasource metrics (strings), or ad-hoc metricswhich are defined only within the query object. See `ChartDataAdhocMetricSchema` for the structure of ad-hoc metrics.",
            "items": {
              "type": "object"
            }
          },
          "order_desc": {
            "type": "boolean",
            "description": "Reverse order. Default: `false`"
          },
          "orderby": {
            "type": "array",
            "description": "Expects a list of lists where the first element is the column name which to sort by, and the second element is a boolean.",
            "items": {
              "type": "object"
            }
          },
          "post_processing": {
            "type": "array",
            "description": "Post processing operations to be applied to the result set. Operations are applied to the result set in sequential order.",
            "items": {
              "type": "object"
            }
          },
          "result_type": {
            "type": "object"
          },
          "row_limit": {
            "type": "integer",
            "format": "int32",
            "description": "Maximum row count (0=disabled). Default: `config[\"ROW_LIMIT\"]`"
          },
          "row_offset": {
            "type": "integer",
            "format": "int32",
            "description": "Number of rows to skip. Default: `0`"
          },
          "time_offsets": {
            "type": "array",
            "items": {
              "type": "string"
            }
          },
          "time_range": {
            "type": "string",
            "description": "A time rage, either expressed as a colon separated string `since : until` or human readable freeform. Valid formats for `since` and `until` are: \n- ISO 8601\n- X days/years/hours/day/year/weeks\n- X days/years/hours/day/year/weeks ago\n- X days/years/hours/day/year/weeks from now\n\nAdditionally, the following freeform can be used:\n\n- Last day\n- Last week\n- Last month\n- Last quarter\n- Last year\n- No filter\n- Last X seconds/minutes/hours/days/weeks/months/years\n- Next X seconds/minutes/hours/days/weeks/months/years\n"
          },
          "time_shift": {
            "type": "string",
            "description": "A human-readable date/time string. Please refer to [parsdatetime](https://github.com/bear/parsedatetime) documentation for details on valid values."
          },
          "timeseries_limit": {
            "type": "integer",
            "format": "int32",
            "description": "Maximum row count for timeseries queries. Default: `0`"
          },
          "timeseries_limit_metric": {
            "description": "Metric used to limit timeseries queries by.",
            "type": "object"
          },
          "url_params": {
            "type": "object",
            "description": "Optional query parameters passed to a dashboard or Explore view"
          },
          "where": {
            "type": "string",
            "description": "WHERE clause to be added to queries using AND operator.This field is deprecated and should be passed to `extras`."
          }
        }
      }
    },
    "result_format": {
      "type": "object"
    },
    "result_type": {
      "type": "object"
    }
  }
}