通过关键字搜索接口,可以通过输入关键字,获取到所有同类商品ID等信息

通过关键字搜索接口,可以通过输入关键字,获取到所有同类商品ID等信息
item_search-按关键字“女装”搜索淘宝同类商品
 

点击输入关键字

部分返回数据展示

Result Object:

---------------------------------------

{

"items": {

"page": "1",

"real_total_results": 1732515,

"total_results": 1732515,

"page_size": 44,

"pagecount": 100,

"data_from": "fu",

"item": [

{

"title": "半高领打底衫女莫代尔内搭肌理感长袖T恤女装春秋冬修身显瘦上衣",

"pic_url": "//g-search2.alicdn.com/img/bao/uploaded/i4/i3/2213109297249/O1CN01mCQCNp23Q5siS4W3g_!!2213109297249.png",

"promotion_price": "29.90",

"price": "29.90",

"sales": 20000,

"num_iid": "695633843387",

"area": "浙江 杭州",

"seller_nick": "岱仙儿",

"seller_id": "2213109297249",

"shop_name": "萱萱菇凉",

"detail_url": "https://item.taobao.com/item.htm?id=695633843387"

},

{

"title": "优衣库大师T【UNIQLO U系列新品】女装圆领T恤短袖444517/455758",

"pic_url": "//g-search3.alicdn.com/img/bao/uploaded/i4/i3/196993935/O1CN01Qe5KUI1ewHLLgVhEm_!!0-item_pic.jpg",

"promotion_price": "59.00",

"price": "59.00",

"sales": 20000,

"num_iid": "701267495923",

"area": "上海",

"seller_nick": "优衣库官方旗舰店",

"seller_id": "196993935",

"shop_name": "优衣库官方旗舰店",

"detail_url": "https://item.taobao.com/item.htm?id=701267495923"

},

{

"title": "优衣库 女装 柔滑弹力棉质圆领T恤(长袖上衣打底衫) 455721UNIQLO",

"pic_url": "//g-search3.alicdn.com/img/bao/uploaded/i4/i3/196993935/O1CN018GSAfG1ewHLFjTBe9_!!0-item_pic.jpg",

"promotion_price": "99.00",

"price": "99.00",

"sales": 20000,

"num_iid": "689917053479",

"area": "上海",

"seller_nick": "优衣库官方旗舰店",

"seller_id": "196993935",

"shop_name": "优衣库官方旗舰店",

"detail_url": "https://item.taobao.com/item.htm?id=689917053479"

},

{

"title": "ZR真维斯短袖t恤女夏季全棉2023女装 墨绿色半袖宽松纯棉体恤上衣",

"pic_url": "//g-search2.alicdn.com/img/bao/uploaded/i4/i4/2207243640843/O1CN01TO23QU1I68hy22GRe_!!2207243640843.jpg",

"promotion_price": "58.70",

"price": "58.70",

"sales": 10000,

"num_iid": "697358703503",

"area": "湖北 武汉",

"seller_nick": "真维斯官方outlets店",

"seller_id": "2207243640843",

"shop_name": "真维斯官方outlets店",

"detail_url": "https://item.taobao.com/item.htm?id=697358703503"

},

{

"title": "正肩短袖u领t恤女装夏季2023年新款纯棉修身低圆领基础款爆款上衣",

"pic_url": "//g-search3.alicdn.com/img/bao/uploaded/i4/i2/2626577608/O1CN01Hz0p4z264W5KCxOXe_!!2626577608.jpg",

"promotion_price": "29.90",

"price": "29.90",

"sales": 10000,

"num_iid": "704390184609",

"area": "广东 广州",

"seller_nick": "韩妮彩o",

"seller_id": "2626577608",

"shop_name": "韩妮彩o",

"detail_url": "https://item.taobao.com/item.htm?id=704390184609"

},

{

"title": "白衬衫女长袖职业春秋夏季短袖宽松工作服正装大码工装女装白衬衣",

"pic_url": "//g-search3.alicdn.com/img/bao/uploaded/i4/i2/3937219703/O1CN01cOtoTI2LY1nhFOQby_!!3937219703-0-C2M.jpg",

"promotion_price": "16.90",

"price": "16.90",

"sales": 8000,

"num_iid": "643340192499",

"area": "浙江 杭州",

"seller_nick": "天天特卖工厂店",

"seller_id": "3937219703",

"shop_name": "天天特卖工厂店",

"detail_url": "https://item.taobao.com/item.htm?id=643340192499"

},

{

"title": "日系蓝色条纹衬衫2023年新款秋冬内搭打底上衣外套春季女装衬衣女",

"pic_url": "//g-search3.alicdn.com/img/bao/uploaded/i4/i3/2931329020/O1CN01aoAevw2GVDIfDPRYd_!!0-item_pic.jpg",

"promotion_price": "35.98",

"price": "35.98",

"sales": 7000,

"num_iid": "685612946371",

"area": "广东 广州",

"seller_nick": "俏系旗舰店",

"seller_id": "2931329020",

"shop_name": "俏系旗舰店",

"detail_url": "https://item.taobao.com/item.htm?id=685612946371"

},

{

"title": "大码女装纯欲风方领T恤夏季新款显瘦修身不规则短袖胖mm打底上衣",

"pic_url": "//g-search3.alicdn.com/img/bao/uploaded/i4/i2/223860089/O1CN01ttOfAv1CWo0Imwamf_!!0-item_pic.jpg",

"promotion_price": "35.80",

"price": "35.80",

"sales": 7000,

"num_iid": "669601937204",

"area": "广东 广州",

"seller_nick": "可爱多逍遥159",

"seller_id": "223860089",

"shop_name": "万艾肖地依舍",

"detail_url": "https://item.taobao.com/item.htm?id=669601937204"

},

{

"title": "NOME诺米女装短袖t恤女经典小圆领小众撞色夏季新款百搭辣妹上衣D",

"pic_url": "//g-search2.alicdn.com/img/bao/uploaded/i4/i1/2200645565495/O1CN01SMbmmL1qSlCmXxxHL_!!0-item_pic.jpg",

"promotion_price": "99.00",

"price": "99.00",

"sales": 6000,

"num_iid": "707837337618",

"area": "广东 广州",

"seller_nick": "nome家居旗舰店",

"seller_id": "2200645565495",

"shop_name": "NOME家居旗舰店",

"detail_url": "https://item.taobao.com/item.htm?id=707837337618"

},

{

"title": "ZARA春季新款 女装 短袖圆领棉质 T 恤 3641312 806",

"pic_url": "//g-search3.alicdn.com/img/bao/uploaded/i4/i4/2228361831/O1CN01u2H6Zb1POe0vbRNOj_!!0-item_pic.jpg",

"promotion_price": "59.00",

"price": "59.00",

"sales": 0,

"num_iid": "700380872445",

"area": "上海",

"seller_nick": "zara官方旗舰店",

"seller_id": "2228361831",

"shop_name": "ZARA官方旗舰店",

"detail_url": "https://item.taobao.com/item.htm?id=700380872445"

},
 

名称类型必须描述
keyString调用key(必须以GET方式拼接在URL中)
secretString调用密钥
api_nameStringAPI接口名称(包括在请求地址中)[item_search,item_get,item_search_shop等]
cacheString[yes,no]默认yes,将调用缓存的数据,速度比较快
result_typeString[json,jsonu,xml,serialize,var_export]返回数据格式,默认为json,jsonu输出的内容中文可以直接阅读
langString[cn,en,ru]翻译语言,默认cn简体中文
versionStringAPI版本

请求参数
请求参数:q=女装&start_price=0&end_price=0&page=1&cat=0&discount_only=&sort=&page_size=&seller_info=&nick=&ppath=&imgid=&filter=
参数说明:q:搜索关键字
cat:分类ID
start_price:开始价格
end_price:结束价格
sort:排序[bid,_bid,bid2,_bid2,_sale,_credit]
(bid:总价,bid2:商品价格,sale:销量,credit信用,加_前缀为从大到小排序)
page:页数

 

①等值连接 需要了解所有订单中订购的商品信息商品名称、购买价格和购买数量)和订单日期。 使用SELECT FROM JOIN ON关键字(截图) ②自身连接 需要了解不低于“三星SGH-C178”价格的商品号、商品名称和商品单价,查询后的结果要求按商品单价升序排列。 使用SELECT FROM JOIN ON、ORDER BY 关键字 ③外连接 左外连接: 需要了解所有商品类别以及其对应商品信息,如果该商品类别没有对应的商品也需要显示其类别信息。 右外连接: 需要了解所有订单所订购的商品信息和订单日期 使用SELECT FROM LEFT/RIGHT OUTER JOIN ON 关键字(截图) ④使用GROUP BY分组后筛选查询 需要了解订单总额大于5000的订单信息,并按升序排列。 使用SELECT FROM GROUP BY HAVING、ORDER BY关键字 (截图) ⑤使用IN或NOT IN的子查询 需要了解和“摩托罗拉W380”为同类商品商品号、商品名称和类别号。 使用SELECT FROM IN 关键字 ⑥使用比较运算符的子查询 需要了解购买了“红双喜牌乒乓球拍的订单号、订单时间和订单总金额” ⑦使用EXISTS的子查询 针对EMPLOYEES表中的每一名员工,在ORDER表中查找处理过订单并且送货模式为“邮寄”的所有订单信息。 使用SELECT FROM AND EXISTS (截图) ⑧UPDATE语句中的子查询商品中类别名称为“家用电器”的商品折扣修改为0.8。 使用UPDATE WHERE命令完成
06-11
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值