数据接口API

点击获取APKEY

正常 (重构版)淘宝客订单查询API


请求链接: http://api.web.21ds.cn/taoke/tbkOrderDetailsGet
请求实例: http://api.web.21ds.cn/taoke/tbkOrderDetailsGet?apkey=登录后即可显示&end_time=2019-04-23 12:28:22&start_time=2019-04-05 12:18:22&tbname=xxxxxx (注:此实例中的密钥为登录用户的真实密钥,不登录不显示,请妥善保管,切勿泄露!)
注意事项:如调用接口时数据返回异常,则需对接口中的【中文】进行Urlencode编码,然后再试。
今日调用统计: 暂无统计
会员限制: 付费会员 (新用户注册立刻送7天V1付费会员)
频率说明: 不同会员级别调用频率不同,具体可见会员升级页面介绍。会员升级传送门
使用说明: 非模拟登录接口,此接口直接对接淘宝API,用于获取传入淘宝帐号下的所有淘客订单,淘宝帐号授权有效期为30天,过期需重新授权登录,否则可能获取不到淘客订单!
必看注意:为保障接口安全及使用效率,调用本站接口前需先 添加IP白名单 (IP地址测试),若IP不固定且无服务器,可通过“优惠推荐”中的链接购买阿里云服务器来调用接口。禁止以插件(包括但不仅限于浏览器插件及手机插件)形式使用接口,禁止将接口重新打包销售或转卖,一经发现,将做帐号封禁处理。
优惠推荐:高性能云服务器2折起,普惠上云,仅需234元/年 >立即抢购<<-

使用说明

原订单数据格式:

{"code": 200,"data": [{"adzone_id": "xxxx","adzone_name": "test","alimama_rate": "0.00","alimama_share_fee": "0.00","click_time": "2019-05-15 18:23:26","flow_source": "--","income_rate": "4.50","item_category_name": "食品-零食/特产","item_id": "xxxx","item_img": "//img.alicdn.com/bao/uploaded/i2/628189716/O1CN01leSoTT2xxxxxxx53dJ_!!0-item_pic.jpg","item_link": "http://item.taobao.com/item.htm?id=xxxxxx","item_num": "1","item_price": "59.80","item_title": "休闲零食小吃整箱","order_type": "聚划算","pub_id": "xxxx","pub_share_fee": "0.00","pub_share_pre_fee": "0.00","pub_share_rate": "100.00","refund_tag": "0","seller_nick": "xxxx","seller_shop_title": "xxxx","site_id": "xxxx","site_name": "xxxx","subsidy_fee": "0.00","subsidy_rate": "0.00","subsidy_type": "--","terminal_type": "无线","tk_create_time": "2019-05-15 18:23:59","tk_order_role": "2","tk_status": "13","tk_total_rate": "4.50","total_commission_fee": "0.00","total_commission_rate": "4.50","trade_id": "xxxx","trade_parent_id": "xxxx"}],"has_pre": "false","position_index": "155xxx06_wgzRlYoWsn2|155xxx839_wNvb3quM6I2","has_next": "false","page_no": "1","page_size": "20","msg": "获取成功"}

重构版订单数据格式:

{"code":200,"data":{"list":[{"adzone_id":xxxx,"adzone_name":"拉新活动","alimama_rate":"0.00","alimama_share_fee":"0.00","alipay_total_price":"36.90","click_time":"2019-10-14 21:38:27","deposit_price":"0.00","flow_source":"--","income_rate":"2.10","item_category_name":"玩具/童车/益智/积木/模型","item_id":xxxxx,"item_img":"//img.alicdn.com/bao/upxxxxx287.jpg","item_link":"http://item.taobao.com/item.htm?id=xxxxxx","item_num":1,"item_price":"79.80","item_title":"磁力xxxxx装益智","order_type":"天猫","pay_price":"36.90","pub_id":xxxxxx,"pub_share_fee":"0.77","pub_share_pre_fee":"0.77","pub_share_rate":"100.00","refund_tag":0,"seller_nick":"好xxx店","seller_shop_title":"好xxxx店","site_id":xxxxxx,"site_name":"喵有券","subsidy_fee":"0.00","subsidy_rate":"0.00","subsidy_type":"--","tb_deposit_time":"--","tb_paid_time":"2019-10-14 21:43:33","terminal_type":"无线","tk_commission_fee_for_media_platform":"0.00","tk_commission_pre_fee_for_media_platform":"0.00","tk_commission_rate_for_media_platform":"0.00","tk_create_time":"2019-10-14 21:43:37","tk_deposit_time":"--","tk_earning_time":"2019-10-25 17:42:23","tk_order_role":2,"tk_paid_time":"2019-10-14 21:43:43","tk_status":3,"tk_total_rate":"2.10","total_commission_fee":"0.77","total_commission_rate":"2.10","trade_id":"664xxxxxx7","trade_parent_id":"664xxxxxx47"}],"has_pre":false,"position_index":"15xxxx4_N5AHPxxx6352|157xxxx17_N4uxxxxPZJ2","has_next":false,"page_no":1,"page_size":20},"msg":"success"}

变更说明:

将原接口中的订单列表移到了list下,将list字段放在data列表下,并将原接口中的订单位点、页码、每页数量等数据一起放到data列表下,与list同层级

请求参数

参数类型请求参数参考值是否必须说明
apkeyStringxxxxxxx用户中心 - 基础设置 中查看APKEY密钥(*必要
query_typeNumber1查询时间类型,1:按照订单淘客创建时间查询,2:按照订单淘客付款时间查询,3:按照订单淘客结算时间查询
position_indexString2222_334666位点,除第一页之外,都需要传递;前端原样返回。
page_sizeNumber20页大小,默认20,1~100
member_typeNumber推广者角色类型,2:二方,3:三方,不传,表示所有角色
tk_statusNumber淘客订单状态,12-付款,13-关闭,14-确认收货,3-结算成功;不传,表示所有状态
end_timeString2019-04-23 12:28:22订单查询结束时间,订单开始时间至订单结束时间,中间时间段日常要求不超过3个小时,但如618、双11、年货节等大促期间预估时间段不可超过20分钟,超过会提示错误,调用时请务必注意时间段的选择,以保证亲能正常调用!
start_timeString2019-04-05 12:18:22订单查询开始时间
jump_typeString1跳转类型,当向前或者向后翻页必须提供,-1: 向前翻页,1:向后翻页
page_noString1第几页,默认1,1~100
order_sceneNumber1场景订单场景类型,1:常规订单,2:渠道订单,3:会员运营订单,默认为1
tbnameStringxxxxxx在本平台授权的淘客账号所对应的用户名,见“会员中心”-“账号授权”-“淘宝授权”列表页

返回参数

返回参数类型参数说明扩展说明
dataJson返回数据
 ├ listJson订单列表
 ├  ├ tb_paid_timeString订单在淘宝拍下付款的时间
 ├  ├ tk_paid_timeString订单付款的时间该时间同步淘宝,可能会略晚于买家在淘宝的订单创建时间
 ├  ├ pay_priceString买家确认收货的付款金额(不包含运费金额)
 ├  ├ pub_share_feeString结算预估收入=结算金额*提成以买家确认收货的付款金额为基数,预估您可能获得的收入。因买家退款、您违规推广等原因,可能与您最终收入不一致。最终收入以月结后您实际收到的为准
 ├  ├ trade_idString买家通过购物车购买的每个商品对应的订单编号,此订单编号并未在淘宝买家后台透出
 ├  ├ tk_order_roleString二方:佣金收益的第一归属者; 三方:从其他淘宝客佣金中进行分成的推广者
 ├  ├ tk_earning_timeString订单确认收货后且商家完成佣金支付的时间
 ├  ├ adzone_idString推广位管理下的推广位名称对应的ID,同时也是pid=mm_1_2_3中的“3”这段数字
 ├  ├ pub_share_rateString从结算佣金中分得的收益比率
 ├  ├ refund_tagString维权标签,0 含义为非维权 1 含义为维权订单
 ├  ├ subsidy_rateString平台给与的补贴比率,如天猫、淘宝、聚划算等
 ├  ├ tk_total_rateString提成=收入比率*分成比率。指实际获得收益的比率
 ├  ├ item_category_nameString商品所属的根类目,即一级类目的名称
 ├  ├ seller_nickString掌柜旺旺
 ├  ├ pub_idString推广者的会员id
 ├  ├ alimama_rateString推广者赚取佣金后支付给阿里妈妈的技术服务费用的比率
 ├  ├ subsidy_typeString平台出资方,如天猫、淘宝、或聚划算等
 ├  ├ item_imgString商品图片
 ├  ├ pub_share_pre_feeString付款预估收入=付款金额*提成。指买家付款金额为基数,预估您可能获得的收入。因买家退款等原因,可能与结算预估收入不一致
 ├  ├ alipay_total_priceString买家拍下付款的金额(不包含运费金额)
 ├  ├ item_titleString商品标题
 ├  ├ site_nameString媒体管理下的对应ID的自定义名称
 ├  ├ item_numString商品数量
 ├  ├ subsidy_feeString补贴金额=结算金额*补贴比率
 ├  ├ alimama_share_feeString技术服务费=结算金额*收入比率*技术服务费率。推广者赚取佣金后支付给阿里妈妈的技术服务费用
 ├  ├ trade_parent_idString买家在淘宝后台显示的订单编号
 ├  ├ order_typeString订单所属平台类型,包括天猫、淘宝、聚划算等
 ├  ├ tk_create_timeString订单创建的时间,该时间同步淘宝,可能会略晚于买家在淘宝的订单创建时间
 ├  ├ flow_sourceString产品类型
 ├  ├ terminal_typeString成交平台
 ├  ├ click_timeString通过推广链接达到商品、店铺详情页的点击时间
 ├  ├ tk_statusString订单状态已付款:指订单已付款,但还未确认收货 已收货:指订单已确认收货,但商家佣金未支付 已结算:指订单已确认收货,且商家佣金已支付成功 已失效:指订单关闭/订单佣金小于0.01元,订单关闭主要有:1)买家超时未付款; 2)买家付款前,买家/卖家取消了订单;3)订单付款后发起售中退款成功;3:订单结算,12:订单付款, 13:订单失效,14:订单成功
 ├  ├ item_priceString商品单价
 ├  ├ item_idString商品id
 ├  ├ adzone_nameString推广位管理下的自定义推广位名称
 ├  ├ total_commission_rateString佣金比率
 ├  ├ item_linkString商品链接
 ├  ├ site_idString媒体管理下的ID,同时也是pid=mm_1_2_3中的“2”这段数字
 ├  ├ seller_shop_titleString店铺名称
 ├  ├ income_rateString订单结算的佣金比率+平台的补贴比率
 ├  ├ total_commission_feeString佣金金额=结算金额*佣金比率
 ├  ├ tk_commission_pre_fee_for_media_String预估专项服务费内容场景专项技术服务费,内容推广者在内容场景进行推广需要支付给阿里妈妈专项的技术服务费用。专项服务费=付款金额*专项服务费率。
 ├  ├ tk_commission_fee_for_media_platString结算专项服务费内容场景专项技术服务费,内容推广者在内容场景进行推广需要支付给阿里妈妈专项的技术服务费用。专项服务费=结算金额*专项服务费率。
 ├  ├ tk_commission_rate_for_media_plaString专项服务费率内容场景专项技术服务费率,内容推广者在内容场景进行推广需要按结算金额支付一定比例给阿里妈妈作为内容场景专项技术服务费,用于提供与内容平台实现产品技术对接等服务。
 ├  ├ special_idString会员运营id
 ├  ├ relation_idString渠道关系id
 ├  ├ tk_deposit_timeString预售时期,用户对预售商品支付定金的付款时间,可能略晚于在淘宝付定金时间
 ├  ├ tb_deposit_timeString预售时期,用户对预售商品支付定金的付款时间
 ├  ├ deposit_priceString预售时期,用户对预售商品支付的定金金额
 ├ has_preString是否还有上一页
 ├ position_indexString位点字段,由调用方原样传递
 ├ has_nextString是否还有下一页
 ├ page_noString页码
 ├ page_sizeString页大小

Json返回示例

{"code":200,"data":{"list":[{"adzone_id":xxxx,"adzone_name":"拉新活动","alimama_rate":"0.00","alimama_share_fee":"0.00","alipay_total_price":"36.90","click_time":"2019-10-14 21:38:27","deposit_price":"0.00","flow_source":"--","income_rate":"2.10","item_category_name":"玩具/童车/益智/积木/模型","item_id":xxxxx,"item_img":"//img.alicdn.com/bao/upxxxxx287.jpg","item_link":"http://item.taobao.com/item.htm?id=xxxxxx","item_num":1,"item_price":"79.80","item_title":"磁力xxxxx装益智","order_type":"天猫","pay_price":"36.90","pub_id":xxxxxx,"pub_share_fee":"0.77","pub_share_pre_fee":"0.77","pub_share_rate":"100.00","refund_tag":0,"seller_nick":"好xxx店","seller_shop_title":"好xxxx店","site_id":xxxxxx,"site_name":"喵有券","subsidy_fee":"0.00","subsidy_rate":"0.00","subsidy_type":"--","tb_deposit_time":"--","tb_paid_time":"2019-10-14 21:43:33","terminal_type":"无线","tk_commission_fee_for_media_platform":"0.00","tk_commission_pre_fee_for_media_platform":"0.00","tk_commission_rate_for_media_platform":"0.00","tk_create_time":"2019-10-14 21:43:37","tk_deposit_time":"--","tk_earning_time":"2019-10-25 17:42:23","tk_order_role":2,"tk_paid_time":"2019-10-14 21:43:43","tk_status":3,"tk_total_rate":"2.10","total_commission_fee":"0.77","total_commission_rate":"2.10","trade_id":"664xxxxxx7","trade_parent_id":"664xxxxxx47"}],"has_pre":false,"position_index":"15xxxx4_N5AHPxxx6352|157xxxx17_N4uxxxxPZJ2","has_next":false,"page_no":1,"page_size":20},"msg":"success"}

code/http_status说明

code/http_status说明
200数据获取成功
-1数据获取失败
401IP没有添加白名单
429访问次数超限
403关键参数丢失
405请求方式不对