淘宝API buyer_cart_list - 获取购物车的商品列表

该博客介绍了如何使用淘宝API获取买家购物车中的商品列表,详细展示了Result Object的结构,包括商品ID、图片URL、商品标题、价格、数量、卖家信息等关键信息。

淘宝API_buyer_cart_list - 获取购物车的商品列表
在这里插入图片描述
Result Object:

{
“items”: {
“item”: [
{
“cart_id”: “1622722345644”,
“num_iid”: “571164485434”,
“pic_url”: “//img.alicdn.com/bao/uploaded/i1/2264215206/O1CN018XRdff1oKOTnb4HLo_!!2264215206.jpg”,
“title”: “全包围丝圈汽车脚垫专用于朗动科沃兹福睿斯新朗逸福克斯英朗思域”,
“detail_url”: “//detail.tmall.com/item.htm?id=571164485434”,
“promotion_price”: 0,
“price”: 768,
“num”: 1,
“sku”: {
“颜色分类”: “包门槛【咖色+咖】包门槛 内侧增高 休息区覆盖 长踏板”
},
“is_tmall”: true,
“seller_info”: {
“shop_type”: “B”,
“title”: “雅菲尔百祥专卖店”,
“sid”: 114494964,
“user_num_id”: “2264215206”,
“zhuy”: “//store.taobao.com/shop/view_shop.htm?user_number_id=2264215206”
}
},
{
“cart_id”: “1453167665115”,
“num_iid”: “601977446456”,
“pic_url”: “//img.alicdn.com/bao/uploaded/i1/776622845/O1CN01VJ6M631Wt3MwRirsq_!!776622845.jpg”,
“title”: “冬季珊瑚绒四件套法兰绒双面被套法莱绒加厚宝宝牛奶绒床裙水晶绒”,
“detail_url”: “//detail.tmall.com/item.htm?id=601977446456”,
“promotion_price”: 0,
“price”: 599,
“num”: 1,
“sku”: {
“适用床尺寸”: “四件套:1.8m床裙款(适用200x230cm被子)加厚.”,
“颜色分类”: “欧美风情”
},
“is_tmall”: true,
“seller

select l.*, concat(e.FLD_T_00039,'-',l.CODE) as PJTNAME, -- 项目名称, p.NAME as PHASENAME, -- 阶段名称 u1.TRUENAME as CREATOR, -- 创建人 u2.TRUENAME as MANAGER, -- 项目经理 u3.TRUENAME as SALESNAME, -- 业务员 e.FLD_U_00286 as PDTOWNER, -- 产品负责人ID e.FLD_U_00043 as SALESID, -- 业务员ID e.FLD_T_00287 as PDTNAME, -- 标准化产品名称 e.FLD_S_00253 as PJTCAT, -- 风机开发项目类别ID b1.NAME as PJTCATNAME, -- 风机开发项目类别 e.FLD_T_00039 as CLIENT, -- 客户名称 e.FLD_T_00257 as SUPSHARE, -- 我司供货份额 e.FLD_S_00292 as UPGRADE, -- 是否升级平台项目ID b2.NAME as UPGRADENAME, -- 是否升级平台项目 e.FLD_D_00259 as SAMPLEDATE, -- 首次交样日期 e.FLD_T_00289 as PDTMODEL, -- 产品型号 e.FLD_D_00261 as ORDERDATE, -- 首批订单下达日期 e.FLD_T_00288 as BONUMBER, -- 商机编号 e.FLD_S_00318 as MOTORCATE, -- 电机类别(电机) e.FLD_S_00295 as ELECTCONTROL, -- 是否带电控 e.FLD_S_00296 as PJTNAMESERIES, -- 项目名称(系列) e.FLD_S_00293 as MOTORDEVCATE, -- 电机开发类别 e.FLD_S_00319 as NEEDMOTOR, -- 是否需要电机 e.FLD_U_00297 as STRUCTENGINEER, -- 结构工程师 e.FLD_U_00298 as ELECTENGINEER, -- 电磁工程师 e.FLD_U_00300 as SOFTENGINEER, -- 软件工程师 e.FLD_U_00302 as TECHNICIAN, -- 技术员 e.FLD_U_00305 as ELECTSAMMAKER, -- 电子打样员 -- as PACKDESIGNER -- 包装设计师 e.FLD_U_00308 as PALNMAN, -- 计划员 e.FLD_U_00309 as BUYER, -- 采购工程师 e.FLD_U_00311 as SQE, -- SQE e.FLD_U_00313 as CERTIFIEDENGINEER, -- 认证工程师 e.FLD_U_00299 as HARDWAREENGINEER, -- 硬件工程师 e.FLD_U_00301 as NEWPDTCRAFT, -- 新品工艺 e.FLD_U_00303 as DRAFTSMAN, -- 绘图员 e.FLD_U_00304 as SAMPLEMALER, -- 打样员 -- 新品质量代表 e.FLD_U_00310 as RELTESTENGINEER, -- 可靠性试验工程师, e.FLD_U_00312 as MOLDENGINEER -- 模具工程师 from t_lc94_lc94 l left join t_lc94_ext e on e.OBJECTID = l.ID left join t_lc_phase p on l.PHASEID = p.ID left join t_obj_rlt r ON l.PROJECTID = r.SRCID AND r.SRCTYPE='PJT' AND r.DESTTYPE='WF1' left join t_sys_user u1 on u1.ID = l.CREATORID left join t_sys_user u2 on u2.ID = e.FLD_U_00286 left join t_sys_user u3 on u3.ID = e.FLD_U_00043 left join t_obj_baseitem b1 on b1.ID = e.FLD_S_00253 left join t_obj_baseitem b2 on b2.ID = e.FLD_S_00292 这里 那些人员我查询出来的只是ID,我还要把对应的人名从t_sys_user里查出来,要怎么做
最新发布
08-09
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值