爱回收 item_get_inquir - 获取询价项接口对接全攻略：从入门到精通

import requestsimport hashlibimport hmacimport timeimport pandas as pdimport logging# 日志配置logging.basicConfig(
    level=logging.INFO,
    format="%(asctime)s - %(levelname)s - %(message)s",
    handlers=[logging.FileHandler("aihuishou_item_get_inquir.log"), logging.StreamHandler()])# 配置（替换为你的信息）APP_ID = "你的app_id"APP_SECRET = "你的app_secret"API_URL = "https://open.aihuishou.com/api/v2/item_get_inquir"def generate_sign(params: dict, secret: str) -> str:
    """生成爱回收接口签名（HMAC-SHA256）"""
    # 1. 筛选非空参数，排除sign
    filtered_params = {k: v for k, v in params.items() if v and k != "sign"}
    # 2. 按参数名ASCII升序排序
    sorted_params = sorted(filtered_params.items(), key=lambda x: x[0])
    # 3. 拼接字符串
    param_str = "&".join([f"{k}={v}" for k, v in sorted_params])
    # 4. 添加密钥
    param_str += f"&secret={secret}"
    # 5. HMAC-SHA256加密
    sign = hmac.new(secret.encode("utf-8"), param_str.encode("utf-8"), hashlib.sha256).hexdigest().lower()
    return signdef standardize_inquir_data(raw_data: dict) -> dict:
    """标准化询价数据，统一输出格式"""
    price_info = raw_data.get("price_info", {})
    recycle_info = raw_data.get("recycle_info", {})

    return {
        "设备型号": raw_data.get("device_info", {}).get("model", ""),
        "存储容量": raw_data.get("device_info", {}).get("storage", ""),
        "成色": raw_data.get("device_info", {}).get("condition", ""),
        "基准价(元)": price_info.get("base_price", 0),
        "成色折扣": price_info.get("condition_discount", 1.0),
        "功能扣减(元)": price_info.get("function_deduction", 0),
        "市场系数": price_info.get("market_coefficient", 1.0),
        "最终报价(元)": price_info.get("final_price", 0),
        "回收方式": recycle_info.get("recycle_type", ""),
        "报价有效期": recycle_info.get("valid_time", ""),
        "请求时间": time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())
    }def aihuishou_item_get_inquir(
    device_type: str,
    brand: str,
    model: str,
    storage: str,
    condition: str,
    function_status: str = "正常",
    repair_history: str = "无") -> dict:
    """调用爱回收item_get_inquir接口获取询价项"""
    # 1. 构建请求参数
    timestamp = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())
    params = {
        "app_id": APP_ID,
        "timestamp": timestamp,
        "version": "v2",
        "device_type": device_type,
        "brand": brand,
        "model": model,
        "storage": storage,
        "condition": condition,
        "function_status": function_status,
        "repair_history": repair_history    }
    # 2. 生成签名
    params["sign"] = generate_sign(params, APP_SECRET)
    # 3. 发送POST请求
    try:
        response = requests.post(API_URL, data=params, verify=True)
        response.raise_for_status()
        result = response.json()
        if result.get("code") != 0:
            logging.error(f"接口返回错误：{result.get('msg')}")
            return {"success": False, "error_msg": result.get("msg"), "data": {}}
        # 4. 标准化数据
        standard_data = standardize_inquir_data(result.get("data", {}))
        return {
            "success": True,
            "data": standard_data,
            "error_msg": ""
        }
    except requests.exceptions.RequestException as e:
        logging.error(f"请求异常：{str(e)}")
        return {"success": False, "error_msg": str(e), "data": {}}# 调用示例if __name__ == "__main__":
    result = aihuishou_item_get_inquir(
        device_type="手机",
        brand="苹果",
        model="iPhone 14 Pro",
        storage="256GB",
        condition="九成新",
        function_status="正常"
    )
    if result["success"]:
        print("爱回收询价结果：")
        print(result["data"])
        df = pd.DataFrame([result["data"]])
        df.to_excel("aihuishou_inquir_result.xlsx", index=False)
    else:
        print(f"获取失败：{result['error_msg']}")