public-api L1单条消息详情

{
    "code": 200,
    "message": "SUCCESS",
    "data": {
        "theme_id": "eade767f-8b20-4072-a5bf-b671c93ce0ba",
        "session_id": "6450d7be-4154-45f8-bafb-a4519c2fc2c4",
        "message_id": "e258ba42-d20a-4837-87cf-e9d6dc1257ef",
        "question": "23年7月小紫瓶销售额是多少？",
        "rewritten_question": "23年7月小紫瓶销售额是多少？",
        "answer": {
            "action": "query",
            "explain": "查询2023年7月期间，系列名称包含“小紫瓶”的商品总销售额。",
            "thoughts": "The user is asking for the sales revenue of the '小紫瓶' series in July 2023. I need to filter the data for the specified series and date range, then sum the sales revenue.",
            "query": "SELECT SUM(`订单公司零售额`) AS `销售额` FROM `销售表` WHERE `系列` LIKE '%小紫瓶%' AND `成交日期` >= '2023-07-01' AND `成交日期` <= '2023-07-31'"
        },
        "sql": "SELECT SUM(`订单公司零售额`) AS `销售额` FROM `销售表` WHERE `系列` LIKE '%小紫瓶%' AND `成交日期` >= '2023-07-01' AND `成交日期` <= '2023-07-31'",
        "card": {
            "dimensions": [],
            "metrics": [
                {
                    "name": "销售额",
                    "formatType": "NUMBER"
                }
            ],
            "viz_config": null
        },
        "table": [
            {
                "table_id": "l1332d5da34154206bf23152",
                "table_name": "销售表"
            }
        ],
        "recommended_cards": [
            {
                "card_id": "p3316b9dbf8ed4b479500962",
                "card_name": "用户访问次数",
                "page_id": "sfaa1c3306db24e2e8ba1d14",
                "page_name": "BI平台用户行为分析",
                "recommend_id": "ab5dc6e4-83df-4100-a026-40750abe126d",
                "relevance_score": 6.466653,
                "is_relevant_feedback": false
            }
        ],
        "user_info": {
            "user_id": "Y2hlbm1pbmd6aG91",
            "username": "陈铭洲"
        },
        "feedback": {
            "is_collected": false,
            "vote": {
                "vote_type": null,
                "comment": null
            }
        },
        "answer_status": "success",
        "created_at": "2025-01-06 16:04:01",
        "task_context": {
            "stage": "finished",
            "history": [
                {
                    "stage": "intent_recognition",
                    "content": {
                        "rewritten_question": "23年7月小紫瓶销售额是多少？",
                        "intent": "write query"
                    },
                    "end_time": "2025-01-06 16:04:04"
                },
                {
                    "stage": "knowledge_search",
                    "content": {
                        "knowledge": []
                    },
                    "end_time": "2025-01-06 16:04:07"
                },
                {
                    "stage": "choose_table",
                    "content": {
                        "tables": [
                            {
                                "table_id": "l1332d5da34154206bf23152",
                                "table_name": "销售表"
                            }
                        ]
                    },
                    "end_time": "2025-01-06 16:04:08"
                },
                {
                    "stage": "reply_generation",
                    "content": {
                        "thought": "The user is asking for the sales revenue of the '小紫瓶' series in July 2023. I need to filter the data for the specified series and date range, then sum the sales revenue."
                    },
                    "end_time": "2025-01-06 16:04:14"
                }
            ]
        },
        "query_status": "success",
        "query_result": {
            "columns": [
                {
                    "name": "销售额",
                    "fdType": "DOUBLE",
                    "seqNo": 0
                }
            ],
            "preview": [
                [
                    "2706.058367607085"
                ]
            ]
        },
        "query_context": null
    }
}