模拟淘宝请求从淘宝接口获取到的json数据如何解析sku

返回的数据有多个sku，如何将库存信息和价格信息的键名和sku（black，white这样的字符串）对应起来这是商品链接https$://item.taobao.com/item.htm?id=659530016794
这个字典里sku是用数字;20549:672896057;1627207:3327837;这样的键名表达的，而商品链接里面sku是black，white，黑色，白色这样的字符串，如何判断识别这个键名代表哪个sku字符串
下面是sku的价格信息

  "originalPrice": {
      ";20549:69326249;1627207:3331185;": {
          "price": "842.50"
      },
      ";20549:64797379;1627207:3331185;": {
          "price": "844.00"
      },
      "def": {
          "price": "836.00-944.00"
      },
      ";20549:72380707;1627207:3327837;": {
          "price": "937.00"
      },
      ";20549:225078235;1627207:3327837;": {
          "price": "943.00"
      },
      ";20549:672896055;1627207:3327837;": {
          "price": "938.50"
      },
      ";20549:229418985;1627207:3331185;": {
          "price": "840.00"
      },
      ";20549:473680452;1627207:3327837;": {
          "price": "942.00"
      },
      ";20549:672896057;1627207:3331185;": {
          "price": "840.50"
      },
      ";20549:418624880;1627207:3331185;": {
          "price": "839.00"
      },
      ";20549:407396361;1627207:3327837;": {
          "price": "941.00"
      },
      ";20549:672896053;1627207:3331185;": {
          "price": "836.50"
      },
      ";20549:103189693;1627207:3327837;": {
          "price": "938.00"
      },
      ";20549:418624880;1627207:3327837;": {
          "price": "939.00"
      },
      ";20549:407396361;1627207:3331185;": {
          "price": "841.00"
      },
      ";20549:225078235;1627207:3331185;": {
          "price": "843.00"
      },
      ";20549:64797379;1627207:3327837;": {
          "price": "944.00"
      },
      ";20549:229418985;1627207:3327837;": {
          "price": "940.00"
      },
      ";20549:59280855;1627207:3327837;": {
          "price": "936.00"
      },
      ";20549:72380707;1627207:3331185;": {
          "price": "837.00"
      },
      ";20549:69326249;1627207:3327837;": {
          "price": "942.50"
      },
      ";20549:473680452;1627207:3331185;": {
          "price": "842.00"
      },
      ";20549:103189693;1627207:3331185;": {
          "price": "838.00"
      },
      ";20549:59280855;1627207:3331185;": {
          "price": "836.00"
      },
      ";20549:672896053;1627207:3327837;": {
          "price": "936.50"
      },
      ";20549:672896057;1627207:3327837;": {
          "price": "940.50"
      },
      ";20549:672896055;1627207:3331185;": {
          "price": "838.50"
      }
  },

下面是sku的库存信息

 "dynStock": {
     "holdQuantity": 0,
     "sellableQuantity": 260,
     "sku": {
         ";20549:69326249;1627207:3331185;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:64797379;1627207:3331185;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:72380707;1627207:3327837;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:225078235;1627207:3327837;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:672896055;1627207:3327837;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:229418985;1627207:3331185;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:473680452;1627207:3327837;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:672896057;1627207:3331185;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:418624880;1627207:3331185;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:407396361;1627207:3327837;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:672896053;1627207:3331185;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:103189693;1627207:3327837;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:418624880;1627207:3327837;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:407396361;1627207:3331185;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:225078235;1627207:3331185;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:64797379;1627207:3327837;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:229418985;1627207:3327837;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:59280855;1627207:3327837;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:72380707;1627207:3331185;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:69326249;1627207:3327837;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:473680452;1627207:3331185;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:103189693;1627207:3331185;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:59280855;1627207:3331185;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:672896053;1627207:3327837;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:672896057;1627207:3327837;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         },
         ";20549:672896055;1627207:3331185;": {
             "holdQuantity": 0,
             "oversold": false,
             "sellableQuantity": 10,
             "stock": 10
         }
     },

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除
收藏举报

3条回答默认最新

CSDN专家-showbo 2021-11-11 18:23

关注

淘宝返回的数据是jsonp，需要替换下回调的相关信息后，用json_deocde转对象后遍历添加价格到库存里面。前面的一串数字键名称对应什么待研究。。先贴出来

<meta charset="utf-8">
<?php
$cookie="thw=cn; t=6ebd6eb7a9b120df58bf2093ede6b16a; ubn=p; enc=wc%2BKVvyT4b%2Bu%2BcatDRWhRsfSHlmTQ0fzmz%2FB7dHFhcZrEaKabs3hFxfTgOFFvufvCMcGlZ13uUUbhpeDdUXpOg%3D%3D; ali_apache_id=33.5.149.179.1619605199817.391975.4; x=e%3D1%26p%3D*%26s%3D0%26c%3D0%26f%3D0%26g%3D0%26t%3D0; UM_distinctid=17b4e23b65b63f-0c637435899954-376b4502-1fa400-17b4e23b65ca65; ucn=unzbmix; cna=oWf9Fid5YWgCASdIeX10aVIk; lgc=%5Cu6211%5Cu7231%5Cu4E00%5Cu4F117687; tracknick=%5Cu6211%5Cu7231%5Cu4E00%5Cu4F117687; mt=ci=106_1; hng=CN%7Czh-CN%7CCNY%7C156; miid=4067623771849081648; CNZZDATA1256793290=1567906222-1636258541-%7C1636269341; cookie2=4913ba4c059ec43f049a7758e9f2d6b4; _tb_token_=7ed5eeef55159; v=0; _samesite_flag_=true; cancelledSubSites=empty; dnk=%5Cu6211%5Cu7231%5Cu4E00%5Cu4F117687; xlly_s=1; sgcookie=E100IGvEMv%2FRPH4dSxqbL40r82MKwthoZiAY2uLrK%2BIz48fV%2BTqfqGzf2q5tsCiydOX3GMpWL8yuLV8ICUa6InAWNH%2FEbZ9lLBp6dIIrq5bpchw%3D; unb=1683510346; uc3=lg2=WqG3DMC9VAQiUQ%3D%3D&nk2=rUs%2BSxDQoytTTcUF&vt3=F8dCujuuSMTRA5I2Gag%3D&id2=Uoe8idbtvqvgnQ%3D%3D; csg=50084703; cookie17=Uoe8idbtvqvgnQ%3D%3D; skt=9309744b77f11045; existShop=MTYzNjM2MDczNg%3D%3D; uc4=nk4=0%40r7q4CAT3aXdah9eA%2FPHxPw2euVwei8A%3D&id4=0%40UO%2B6bxqoWbhMuyJacKSqqRrvPti7; _cc_=WqG3DMC9EA%3D%3D; _l_g_=Ug%3D%3D; sg=76f; _nk_=%5Cu6211%5Cu7231%5Cu4E00%5Cu4F117687; cookie1=BqR2IrBAXmaISH2hFOvjy7mnA1%2BMMgYmOC%2FtFs138mA%3D; _m_h5_tk=4c58c3ddb0bac6ae8f6c092ae39d2765_1636369027013; _m_h5_tk_enc=936e4d449985bf53ed1c66fc48137590; uc1=pas=0&existShop=true&cookie16=UIHiLt3xCS3yM2h4eKHS9lpEOw%3D%3D&cookie14=Uoe3cc1TvWpO9Q%3D%3D&cookie21=URm48syIZJwcbRltXU0bIA%3D%3D&cookie15=WqG3DMC9VAQiUQ%3D%3D; tfstk=cmBABdG1Sz4ciItRYsFufZZ_iSX1aPa9PmTiBuEanR5xJP0IJscOK9hcoSt61aER.; l=fBIKRJxeOtI-krQ9BO5ahurza77teIdbzsPzaNbMiIeca6shfh0cnNCd6kheddtjgTfqseKzYAkGMdE2llUT5x_r-ZEEOdq55299-bpU-L5..; isg=BGxsnInkIbcmOgvzBlSb1wRAPUqeJRDPAb3c_Masz5cj0Q7b7zP9Xewj9Znp2Ugn";
$referer="https://item.taobao.com/item.htm?id=659530016794";
$useragent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.81 Safari/537.36";

$url="https://detailskip.taobao.com/service/getData/1/p1/item/detail/sib.htm?itemId=659530016794&sellerId=1683510346&modules=dynStock,qrcode,viewer,price,duty,xmpPromotion,delivery,activity,fqg,zjys,couponActivity,soldQuantity,page,originalPrice,tradeContract&callback=onSibRequestSuccess";


$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_REFERER, $referer);//设置来源
curl_setopt($ch, CURLOPT_COOKIE, $cookie);//设置Cookie
curl_setopt($ch, CURLOPT_USERAGENT, $useragent);//设置user-agent
//https设置，不需要证书
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, FALSE);

curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

$content=curl_exec($ch);
curl_close($ch);

$content=str_replace("onSibRequestSuccess(","",$content);
$content=str_replace(");","",$content);

$data=json_decode($content,true);

$dynStocksku=$data['data']['dynStock']['sku'];
$originalPrice=$data['data']['originalPrice'];

foreach($originalPrice as $k=>$v){//将价格加到库存里面
  if(isset($dynStocksku[$k]))$dynStocksku[$k]['price']=$v['price'];
}
echo(json_encode($dynStocksku))
?>

本回答被题主选为最佳回答 , 对您是否有帮助呢?

查看更多回答(2条)

报告相同问题？

关注问题

模拟淘宝请求从淘宝接口获取到的json数据如何解析sku javascript php python
2021-11-11 17:38

回答 3 已采纳淘宝返回的数据是jsonp，需要替换下回调的相关信息后，用json_deocde转对象后遍历添加价格到库存里面。前面的一串数字键名称对应什么待研究。。先贴出来 <meta charset="u
如何从Go上的请求主体获取JSON http json
2017-11-08 18:07

回答 2 已采纳 TIL that http.Response.Body is a buffer, which means that once it has been read, it cannot be read
uniapp可以获取后端数据，如何将商品渲染到移动端页面上前端
2021-12-24 10:15

回答 2 已采纳 1、用箭头函数2、
API接口调用，获取淘宝天猫，拼多多，1688等平台商品详情，python采集爬虫数据
2022-09-19 14:03

古德猫宁的干货的博客 api网络爬虫数据
请教，怎么获取淘宝商品skuid 其他
2021-06-26 21:05

回答 1 已采纳可以试试这个方法： 1. 打开网页版的淘宝链接https://detail.tmall.com/item.htm?spm=a220m.1000858.1000725.1.50b53251kcDB8l
将数据从JSON数组放入Javascript数组 ajax javascript json php
2017-03-07 19:43

回答 1 已采纳 You need to use AJAX. Here are two options (you would use this in your store.js file) Using jQuer
python 批量写入数据进sql server时，报错Error converting data type nvarchar to numeric. python sqlserver
2022-08-20 22:51

回答 4 已采纳应该是excel某些数值列的数据有一些非数值数据导致的。你这里只对全局进行了nan替换，建议你在拼接sql前对sheet_data的所有数值列进行一次数据清洗，将异常值填充为默认值。
如何接入淘宝官方商家订单API接口？（管理淘宝商品详情店铺）
2024-03-08 11:39

API技术猿的博客 key=&secret=&num_iid=652874751412&is_promotion=1"url说明 https://api-gw.onebound.cn/平台/API类型/ 平台：淘宝，京东等， API类型:[item_search,item_get,item_search_shop等]因此，你需要定期查看淘宝开放平台...
Python网络爬虫如何跳过"This request has no response data aviliable"的网页 json python
2022-04-17 18:27

回答 1 已采纳在你出错的地方加个try，except，如果错误了直接return，
如何从Woocommerce中的订单商品获取产品sku [重复] php
2018-06-10 01:51

回答 1 已采纳 I think you're fiddling around on the actual template page ;-) In Wordpress we mainly use action h
JSON解码到MYSQL数据库 json mysql php
2016-07-16 11:36

回答 1 已采纳 The shape of your data complicates the database insertion a bit. Data that should go in the same r
python-selenium自动爬取京东手机端全部类别数据----“从祖爬到孙”
2021-10-01 13:15

小龙coding的博客 python-selenium自动爬取京东手机端全部类别数据----“从祖爬到孙”
使用php获取json模式的所有元素 json php
2016-05-13 04:06

回答 1 已采纳 You can get the properties out with a simple loop: foreach ($data->bodySchema->properties a
爬虫项目八：Python对天猫商品数据、评论数据爬取
2021-03-25 08:23

@lizhihang的博客文章目录前言一、商品数据1...爬取天猫商城商品数据，观察页面没有动态加载，但是页面会是不是出现登录界面，所以选择selenium登录的方式爬取商品数据，整个爬虫的过程中需要mitmdump拦截伪装，详情可看我主页文章淘宝 ...
Python爬虫实战 | 爬取拼多多商品的详情价格SKU数据
2023-12-13 09:05

大数据girl的博客 Charles通过构建代理服务，让本地请求都通过Charles的代理之后访问公网，从而实现了网络封包的截取和分析。虽然Charles可以支持HTTPS抓包，在分析移动端应用网络请求时也是一个不可或缺的工具，但是随着移动安全技术...
没有解决我的问题, 去提问

问题事件

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
系统已结题 11月20日
关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
已采纳回答 11月12日
关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
赞助了问题酬金 11月11日
关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
修改了问题 11月11日
展开全部

悬赏问题

¥15 高德地图点聚合中Marker的位置无法实时更新
¥15 DIFY API Endpoint 问题。
¥20 sub地址DHCP问题
¥15 delta降尺度计算的一些细节，有偿
¥15 Arduino红外遥控代码有问题
¥15 数值计算离散正交多项式
¥30 数值计算均差系数编程
¥15 redis-full-check比较两个集群的数据出错
¥15 Matlab编程问题
¥15 训练的多模态特征融合模型准确度很低怎么办

模拟淘宝请求从淘宝接口获取到的json数据如何解析sku

3条回答 默认 最新

问题事件

悬赏问题

3条回答默认最新