Upsert SQL chart as code

Upserts an SQL chart from code representation

POST /api/v1/projects/{projectUuid}/sqlCharts/{slug}/code

Error

A valid request URL is required to generate request examples

200

{
  "results": {
    "charts": [
      {
        "data": {
          "name": "<string>",
          "projectUuid": "<string>",
          "organizationUuid": "<string>",
          "uuid": "<string>",
          "pinnedListUuid": "<string>",
          "pinnedListOrder": 123,
          "slug": "<string>",
          "updatedAt": "2023-11-07T05:31:56Z",
          "chartConfig": {
            "type": "big_number",
            "config": {
              "comparisonField": "<string>",
              "conditionalFormattings": [
                {
                  "rules": [
                    {
                      "values": [
                        123
                      ],
                      "id": "<string>",
                      "includeNull": true
                    }
                  ],
                  "color": "<string>",
                  "target": {
                    "fieldId": "<string>"
                  },
                  "textStyle": {
                    "underline": true,
                    "italic": true,
                    "bold": true
                  },
                  "darkColor": "<string>"
                }
              ],
              "comparisonLabel": "<string>",
              "flipColors": true,
              "showComparison": true,
              "showTableNamesInLabel": true,
              "showBigNumberLabel": true,
              "selectedField": "<string>",
              "label": "<string>"
            }
          },
          "spaceUuid": "<string>",
          "dashboardUuid": "<string>",
          "verification": {
            "verifiedAt": "2023-11-07T05:31:56Z",
            "verifiedBy": {
              "lastName": "<string>",
              "firstName": "<string>",
              "userUuid": "<string>"
            }
          },
          "spaceName": "<string>",
          "colorPaletteUuid": "<string>",
          "tableName": "<string>",
          "metricQuery": {
            "tableCalculations": [
              {
                "displayName": "<string>",
                "name": "<string>",
                "sql": "<string>",
                "format": {
                  "round": 123,
                  "currency": "<string>",
                  "prefix": "<string>",
                  "suffix": "<string>",
                  "custom": "<string>"
                },
                "index": 123
              }
            ],
            "limit": 123,
            "sorts": [
              {
                "descending": true,
                "fieldId": "<string>",
                "pivotValues": [
                  {
                    "value": "<string>",
                    "reference": "<string>"
                  }
                ],
                "nullsFirst": true
              }
            ],
            "filters": {
              "tableCalculations": {
                "or": [
                  {
                    "id": "<string>",
                    "target": {
                      "fieldId": "<string>"
                    },
                    "includeNull": true,
                    "values": [
                      "<unknown>"
                    ],
                    "settings": "<unknown>",
                    "disabled": true,
                    "required": true,
                    "caseSensitive": true
                  }
                ],
                "id": "<string>"
              },
              "metrics": {
                "or": [
                  {
                    "id": "<string>",
                    "target": {
                      "fieldId": "<string>"
                    },
                    "includeNull": true,
                    "values": [
                      "<unknown>"
                    ],
                    "settings": "<unknown>",
                    "disabled": true,
                    "required": true,
                    "caseSensitive": true
                  }
                ],
                "id": "<string>"
              },
              "dimensions": {
                "or": [
                  {
                    "id": "<string>",
                    "target": {
                      "fieldId": "<string>"
                    },
                    "includeNull": true,
                    "values": [
                      "<unknown>"
                    ],
                    "settings": "<unknown>",
                    "disabled": true,
                    "required": true,
                    "caseSensitive": true
                  }
                ],
                "id": "<string>"
              }
            },
            "metrics": [
              "<string>"
            ],
            "dimensions": [
              "<string>"
            ],
            "exploreName": "<string>",
            "metadata": {
              "hasADateDimension": {
                "name": "<string>",
                "label": "<string>",
                "table": "<string>"
              }
            },
            "pivotDimensions": [
              "<string>"
            ],
            "timezone": "<string>",
            "dimensionOverrides": {},
            "metricOverrides": {},
            "customDimensions": [
              {
                "id": "<string>",
                "name": "<string>",
                "table": "<string>",
                "type": "bin",
                "dimensionId": "<string>",
                "binType": "fixed_number",
                "binNumber": 123
              }
            ],
            "additionalMetrics": [
              {
                "sql": "<string>",
                "table": "<string>",
                "name": "<string>",
                "label": "<string>",
                "description": "<string>",
                "hidden": true,
                "round": 123,
                "index": 123,
                "filters": [
                  {
                    "id": "<string>",
                    "target": {
                      "fieldRef": "<string>"
                    },
                    "includeNull": true,
                    "values": [
                      "<unknown>"
                    ],
                    "settings": "<unknown>",
                    "disabled": true,
                    "required": true,
                    "caseSensitive": true
                  }
                ],
                "baseDimensionName": "<string>",
                "uuid": "<string>",
                "percentile": 123,
                "distinctKeys": [
                  "<string>"
                ],
                "formatOptions": {
                  "round": 123,
                  "currency": "<string>",
                  "prefix": "<string>",
                  "suffix": "<string>",
                  "custom": "<string>"
                },
                "generationType": "periodOverPeriod",
                "baseMetricId": "<string>",
                "timeDimensionId": "<string>",
                "periodOffset": 123
              }
            ]
          },
          "tableConfig": {
            "columnOrder": [
              "<string>"
            ]
          },
          "dashboardName": "<string>",
          "colorPalette": [
            "<string>"
          ],
          "resolvedColorPalette": {
            "source": {
              "type": "config"
            },
            "paletteName": "<string>",
            "paletteUuid": "<string>",
            "darkColors": [
              "<string>"
            ],
            "colors": [
              "<string>"
            ]
          },
          "oldUuid": "<string>",
          "spacePath": "<string>",
          "spaceSlug": "<string>",
          "description": "<string>",
          "parameters": {},
          "updatedByUser": {
            "userUuid": "<string>",
            "firstName": "<string>",
            "lastName": "<string>"
          },
          "deletedAt": "2023-11-07T05:31:56Z",
          "deletedBy": {
            "lastName": "<string>",
            "firstName": "<string>",
            "userUuid": "<string>"
          },
          "pivotConfig": {
            "columns": [
              "<string>"
            ]
          }
        }
      }
    ],
    "dashboards": [
      {
        "data": {
          "name": "<string>",
          "projectUuid": "<string>",
          "organizationUuid": "<string>",
          "uuid": "<string>",
          "pinnedListUuid": "<string>",
          "pinnedListOrder": 123,
          "slug": "<string>",
          "updatedAt": "2023-11-07T05:31:56Z",
          "versionUuid": "<string>",
          "spaceUuid": "<string>",
          "dashboardVersionId": 123,
          "verification": {
            "verifiedAt": "2023-11-07T05:31:56Z",
            "verifiedBy": {
              "lastName": "<string>",
              "firstName": "<string>",
              "userUuid": "<string>"
            }
          },
          "tiles": [
            {
              "uuid": "<string>",
              "type": "saved_chart",
              "x": 123,
              "y": 123,
              "h": 123,
              "w": 123,
              "properties": {
                "savedChartUuid": "<string>",
                "chartSlug": "<string>",
                "chartName": "<string>",
                "belongsToDashboard": true,
                "hideTitle": true,
                "title": "<string>"
              },
              "tabUuid": "<string>"
            }
          ],
          "filters": {
            "tableCalculations": [
              {
                "id": "<string>",
                "target": {
                  "tableName": "<string>",
                  "fieldId": "<string>",
                  "isSqlColumn": true
                },
                "includeNull": true,
                "values": [
                  "<unknown>"
                ],
                "settings": "<unknown>",
                "disabled": true,
                "required": true,
                "caseSensitive": true,
                "lockedTabUuids": [
                  "<string>"
                ],
                "requiredGroupId": "<string>",
                "singleValue": true,
                "label": "<string>",
                "tileTargets": {}
              }
            ],
            "metrics": [
              {
                "id": "<string>",
                "target": {
                  "tableName": "<string>",
                  "fieldId": "<string>",
                  "isSqlColumn": true
                },
                "includeNull": true,
                "values": [
                  "<unknown>"
                ],
                "settings": "<unknown>",
                "disabled": true,
                "required": true,
                "caseSensitive": true,
                "lockedTabUuids": [
                  "<string>"
                ],
                "requiredGroupId": "<string>",
                "singleValue": true,
                "label": "<string>",
                "tileTargets": {}
              }
            ],
            "dimensions": [
              {
                "id": "<string>",
                "target": {
                  "tableName": "<string>",
                  "fieldId": "<string>",
                  "isSqlColumn": true
                },
                "includeNull": true,
                "values": [
                  "<unknown>"
                ],
                "settings": "<unknown>",
                "disabled": true,
                "required": true,
                "caseSensitive": true,
                "lockedTabUuids": [
                  "<string>"
                ],
                "requiredGroupId": "<string>",
                "singleValue": true,
                "label": "<string>",
                "tileTargets": {}
              }
            ]
          },
          "spaceName": "<string>",
          "views": 123,
          "firstViewedAt": "<string>",
          "tabs": [
            {
              "order": 1,
              "name": "<string>",
              "uuid": "<string>",
              "hidden": true
            }
          ],
          "colorPaletteUuid": "<string>",
          "spacePath": "<string>",
          "spaceSlug": "<string>",
          "description": "<string>",
          "parameters": {},
          "updatedByUser": {
            "userUuid": "<string>",
            "firstName": "<string>",
            "lastName": "<string>"
          },
          "config": {
            "isDateZoomDisabled": true,
            "requiredFiltersNote": "<string>",
            "dateZoomConfig": {
              "tileTargets": {},
              "controls": [
                {
                  "name": "<string>",
                  "uuid": "<string>",
                  "hidden": true
                }
              ]
            },
            "dateZoomGranularities": [],
            "parameterOrder": [
              "<string>"
            ],
            "pinnedParameters": [
              "<string>"
            ],
            "isAddFilterDisabled": true
          },
          "deletedAt": "2023-11-07T05:31:56Z",
          "deletedBy": {
            "lastName": "<string>",
            "firstName": "<string>",
            "userUuid": "<string>"
          }
        }
      }
    ],
    "spaces": [
      {
        "data": {
          "name": "<string>",
          "projectUuid": "<string>",
          "organizationUuid": "<string>",
          "uuid": "<string>",
          "inheritParentPermissions": true,
          "pinnedListUuid": "<string>",
          "pinnedListOrder": 123,
          "slug": "<string>",
          "parentSpaceUuid": "<string>",
          "path": "<string>",
          "appCount": 123,
          "childSpaceCount": 123,
          "dashboardCount": 123,
          "chartCount": 123,
          "deletedBy": {
            "lastName": "<string>",
            "firstName": "<string>",
            "userUuid": "<string>"
          },
          "deletedAt": "2023-11-07T05:31:56Z"
        }
      }
    ],
    "dataApps": [
      {
        "data": {
          "name": "<string>",
          "uuid": "<string>"
        }
      }
    ],
    "sqlCharts": [
      {
        "data": {
          "spacePath": "<string>",
          "spaceSlug": "<string>",
          "description": "<string>",
          "name": "<string>",
          "projectUuid": "<string>",
          "slug": "<string>",
          "oldUuid": "<string>",
          "uuid": "<string>"
        }
      }
    ]
  },
  "status": "ok"
}

{
  "error": {
    "name": "<string>",
    "statusCode": 123,
    "data": "<unknown>",
    "message": "<string>"
  },
  "status": "error"
}

Path Parameters

projectUuid · string · required

slug · string · required

Body

application/json

Construct a type with the properties of T except for those in type K.

name · string · required

limit · number<double> · required

slug · string · required

version · number<double> · required

spaceSlug · string · required

sql · string · required

chartKind · enum<string> · required

Available options: line, horizontal_bar, vertical_bar, scatter, area, mixed, pie, table, big_number, funnel, custom, treemap, gauge, map, sankey, data_app_viz

config · any · required

This AnyType is an alias for any The goal is to make it easier to identify any type in the codebase without having to eslint-disable all the time These are only used on legacy any types, don't use it for new types. This is added on a separate file to avoid circular dependencies.

updatedAt · string<date-time>

contentType · enum<string>

Available options: sql_chart

downloadedAt · string<date-time>

description · string | null

spaceNames · object

Construct a type with a set of properties K of type T

Show child attributes

force · boolean

publicSpaceCreate · boolean

skipSpaceCreate · boolean

Response

200

application/json

Success

results · object · required

Show child attributes

status · enum<string> · required

Available options: ok