Python实现将JSON中的ITEM数据导出到本地Excel中

import requests
from requests.auth import HTTPBasicAuth
import json
import pandas as pd

# URL
url = "http://***"
# SAP 登录凭证
username = "***"
password = "***"

# 构造请求头
headers = {
    "Accept": "application/json",
    "Content-Type": "application/json"
}

# 构造POST请求的JSON数据
payload = JSON数据

# 发送POST请求
response = requests.post(
    url,
    headers=headers,
    auth=HTTPBasicAuth(username, password),
    data=json.dumps(payload)  # 将Python字典转换为JSON字符串
)

# 检查响应状态码
if response.status_code == 201:  # 201表示创建成功
    print("Data created successfully!")
    print("Response Data:", response.json())

else:
    print(f"Failed to create data. Status code: {response.status_code}")
    print("Response Text:", response.text)
    data = response.text
    # 解析JSON字符串
    parsed_data = json.loads(data)

    # 提取所有ITEM数据（支持多个ITABLE条目）
    all_items = []
    for itable in parsed_data["ITABLE"]:
        all_items.extend(itable["ITEM"])

    # 转换为DataFrame
    df = pd.DataFrame(all_items)

    # 导出到Excel
    excel_path = "D:\item_data.xlsx"
    df.to_excel(excel_path, index=False, engine="openpyxl")

    print(f"数据已成功导出到 {excel_path}")