通过API更新Grafana仪表板遇400错误请求，寻求排查帮助

我正在编写脚本通过API更新Grafana仪表板，但发送JSON payload时始终收到400错误，提示JSON格式存在问题。我已经对照API文档调整了payload结构，但问题依旧。这是我第一次通过API更新Grafana仪表板，不确定哪里出错了，希望能帮忙定位问题原因。

我怀疑问题出在JSON payload的结构上，但刚接触程序化更新仪表板的流程，找不到具体问题点，求指点。

发送的JSON payload #

{
    "dashboard": {
        "id": 765,
        "panels": [
            {
                "alert": {
                    "alertRuleTags": {},
                    "conditions": [
                        {
                            "evaluator": {
                                "params": [
                                    70,
                                    5
                                ],
                                "type": "within_range"
                            },
                            "operator": {
                                "type": "and"
                            },
                            "query": {
                                "params": [
                                    "B",
                                    "24h",
                                    "now-12h"
                                ]
                            },
                            "reducer": {
                                "params": [],
                                "type": "last"
                            },
                            "type": "query"
                        }
                    ],
                    "executionErrorState": "keep_state",
                    "for": "5m",
                    "frequency": "1m",
                    "handler": 1,
                    "message": "",
                    "name": "XX",
                    "noDataState": "keep_state",
                    "notifications": []
                },
                "aliasColors": {},
                "bars": false,
                "dashLength": 10,
                "dashes": false,
                "datasource": "1",
                "fieldConfig": {
                    "defaults": {
                        "custom": {},
                        "links": []
                    },
                    "overrides": []
                },
                "fill": 1,
                "fillGradient": 0,
                "gridPos": {
                    "h": 9,
                    "w": 6,
                    "x": 0,
                    "y": 0
                },
                "hiddenSeries": false,
                "id": 4,
                "legend": {
                    "avg": false,
                    "current": false,
                    "max": false,
                    "min": false,
                    "show": true,
                    "total": false,
                    "values": false
                },
                "lines": true,
                "linewidth": 1,
                "nullPointMode": "null",
                "options": {
                    "alertThreshold": true
                },
                "percentage": false,
                "pluginVersion": "7.3.5",
                "pointradius": 2,
                "points": false,
                "renderer": "flot",
                "seriesOverrides": [],
                "spaceLength": 10,
                "stack": false,
                "steppedLine": false,
                "targets": [
                    {
                        "alias": "",
                        "groupBy": [
                            {
                                "params": [
                                    "1s"
                                ],
                                "type": "time"
                            }
                        ],
                        "hide": false,
                        "measurement": "",
                        "orderByTime": "ASC",
                        "policy": "default",
                        "refId": "A",
                        "resultFormat": "time_series",
                        "select": [
                            [
                                {
                                    "params": [
                                        ""
                                    ],
                                    "type": "field"
                                },
                                {
                                    "params": [],
                                    "type": "last"
                                }
                            ]
                        ],
                        "tags": [
                            {
                                "key": "",
                                "operator": "=",
                                "value": ""
                            },
                            {
                                "condition": "AND",
                                "key": "source",
                                "operator": "=",
                                "value": "file"
                            }
                        ]
                    },
                    {
                        "alias": "",
                        "groupBy": [
                            {
                                "params": [
                                    "1s"
                                ],
                                "type": "time"
                            }
                        ],
                        "hide": false,
                        "measurement": "telemetry",
                        "orderByTime": "ASC",
                        "policy": "default",
                        "refId": "B",
                        "resultFormat": "time_series",
                        "select": [
                            [
                                {
                                    "params": [
                                        ""
                                    ],
                                    "type": "field"
                                },
                                {
                                    "params": [],
                                    "type": "last"
                                }
                            ]
                        ],
                        "tags": [
                            {
                                "key": "",
                                "operator": "=",
                                "value": ""
                            },
                            {
                                "condition": "AND",
                                "key": "source",
                                "operator": "=",
                                "value": "file"
                            }
                        ]
                    }
                ],
                "thresholds": [
                    {
                        "colorMode": "critical",
                        "fill": true,
                        "line": true,
                        "op": "gt",
                        "value": 3,
                        "yaxis": "left"
                    },
                    {
                        "colorMode": "critical",
                        "fill": true,
                        "line": true,
                        "op": "lt",
                        "value": 5,
                        "yaxis": "left"
                    }
                ],
                "timeFrom": null,
                "timeRegions": [],
                "timeShift": null,
                "title": "",
                "tooltip": {
                    "shared": true,
                    "sort": 0,
                    "value_type": "individual"
                },
                "type": "graph",
                "xaxis": {
                    "buckets": null,
                    "mode": "time",
                    "name": null,
                    "show": true,
                    "values": []
                },
                "yaxes": [
                    {
                        "format": "volt",
                        "label": null,
                        "logBase": 1,
                        "max": "30",
                        "min": "0",
                        "show": true
                    },
                    {
                        "format": "short",
                        "label": null,
                        "logBase": 1,
                        "max": null,
                        "min": null,
                        "show": true
                    }
                ],
                "yaxis": {
                    "align": false,
                    "alignLevel": null
                }
            }
        ],
        "uid": "o-XW-FgSk",
        "version": 12
    },
    "overwrite": true,
    "message": "Testing"
}

发起POST请求的Python函数 #

def post_request_grafana(endpoint, data):
    logging.basicConfig(level=logging.INFO)
    auth_token = "redacted"
    headers = {
        "Authorization": f"Bearer {auth_token}",
        "Content-Type": "application/json",
        "Accept": "application/json"
    }
    try:
        r = requests.post(endpoint, headers=headers, json=data)
        r.raise_for_status()
        
        logging.info(f"Successfully posted data to {endpoint}.")
        return r.json() 
    except requests.exceptions.RequestException as err:
        logging.error(f"Error posting to Grafana: {err}")

排查建议 #

• 确认API端点正确性：更新仪表板的正确端点是/api/dashboards/db，不要用错其他端点
• 清理无效空字段：payload中存在大量空值字段（如measurement: ""、key: ""），部分字段可能不允许为空，建议删除或补充有效值
• 校验JSON语法：用Python内置的json.tool工具（执行python -m json.tool your_payload.json）检查是否有语法错误
• 获取详细错误信息：在异常捕获中添加logging.error(f"Response content: {r.text}")，Grafana的400错误通常会返回具体的字段错误描述
• 版本号检查：确保version字段是当前仪表板的最新版本，或者开启overwrite: true后，版本号不能低于现有版本
• 数据源ID格式：datasource: "1"若为数据源ID，建议改为数字类型datasource: 1，部分版本的Grafana对类型要求严格

内容的提问来源于stack exchange，提问作者Caspernoah23426