This is a result for self-practice of crawler by RMarkdown.
library(httr)
url <- "http://ecshweb.pchome.com.tw/search/v3.3/all/results?q=sony&page=1&sort=rnk/dc"
res = GET(url)
res_json = content(res)
raw=data.frame(do.call(rbind,res_json$prods))library(knitr)
kable(raw)| Id | cateId | picS | picB | name | describe | price | originPrice | author | brand | publishDate | sellerId | isPChome | isNC17 | couponActid |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DGBQ1I-A900567F7 | DGBQ36 | /items/DGBQ1IA900567F7/000002_1478319535.jpg | /items/DGBQ1IA900567F7/000001_1493949966.jpg | SONY ILCE-5000 單機身 中文平輸 | 送專用電SONY A5000L 單機身 中文平輸 | 8990 | 8990 | 1 | 0 | list() | ||||
| DYAD3I-19008NLJ7 | DYAD3I | /items/DYAD3I19008NLJ7/000002_1514513698.jpg | /items/DYAD3I19008NLJ7/000001_1519613616.jpg | SONY XPERIA XZ-山茶花粉 | ★下殺超低價SONY XPERIA XZ-山茶花粉 | 9499 | 9499 | 1 | 0 | list() | ||||
| DYAD4X-A9008PYG1 | DYAD4X | /items/DYAD4XA9008PYG1/000002_1516870630.jpg | /items/DYAD4XA9008PYG1/000001_1520301467.jpg | SONY XPERIA XA2 | ▼上櫃週年慶↘感恩回饋▼送小夜燈★結帳現折驚喜價SONY XPERIA XA2 | 10990 | 10990 | 1 | 0 | list() | ||||
| DCAIDH-A90084GL6 | DCAIDH | /items/DCAIDHA90084GL6/000002_1495000387.jpg | /items/DCAIDHA90084GL6/000001_1495000387.jpg | SONY SRS-XB10 可攜式防潑灑藍牙喇叭 | ★新品上市★SONY SRS-XB10 可攜式防潑灑藍牙喇叭(公司貨) | 1790 | 1790 | 1 | 0 | list() | ||||
| DPAD06-A9008BPFP | DPAD06 | /items/DPAD06A9008BPFP/000002_1520821299.jpg | /items/DPAD06A9008BPFP/000001_1520821299.jpg | SONY 55型 4K+HDR 液晶電視 KD-55X7000E | SONY 55吋 4K HDR連網液晶電視 KD-55X7000E★超極真影像晶片★極瞬流線影像240Hz★低音反射箱型喇叭 | 33155 | 33155 | 1 | 0 | list() | ||||
| DYAD4Z-A9008QR8K | DYAD4Z | /items/DYAD4ZA9008QR8K/000002_1517890041.jpg | /items/DYAD4ZA9008QR8K/000001_1520505681.jpg | SONY XPERIA XA2 Ultra | ★送64G卡+行電+LED夜燈SONY XPERIA XA2 Ultra | 14990 | 14990 | 1 | 0 | list() | ||||
| DYAD3N-A90080QZV | DYAD3N | /items/DYAD3NA90080QZV/000002_1491547112.jpg | /items/DYAD3NA90080QZV/000001_1491547112.jpg | SONY XPERIA XA1 | ◤送玻璃保貼+TYPE-C線+立架◢Sony Xperia XA1 (3G/32G) 八核心5吋智慧機 | 5580 | 5580 | 1 | 0 | list() | ||||
| DYAD21-A9008RA37 | DYAD21 | /items/DYAD21A9008RA37/000002_1517477450.jpg | /items/DYAD21A9008RA37/000001_1519180567.jpg | SONY XPERIA XZ Premium | ★熱銷旗艦★SONY XPERIA XZ Premium | 16990 | 16990 | 1 | 0 | list() | ||||
| DGAD81-A9008JJ4S | DGAD81 | /items/DGAD81A9008JJ4S/000002_1510563174.jpg | /items/DGAD81A9008JJ4S/000001_1520820851.jpg | SONY DSC-RX10M4 (公司貨) | 奢華全配▼大光圈高放大倍率變焦SONY DSC-RX10M4 (公司貨) | 52980 | 52980 | 1 | 0 | list() | ||||
| DYAD21-A900860NX | DYAD21 | /items/DYAD21A900860NX/000002_1496636920.jpg | /items/DYAD21A900860NX/000001_1520562872.jpg | SONY XPERIA XZ Premium☆ | 加送保護套+保貼Sony Xperia XZ Premium G8142 5.5吋雙卡雙待八核機 | 16990 | 16990 | 1 | 0 | list() | ||||
| DYAD4V-A9008G6UF | DYAD4V | /items/DYAD4VA9008G6UF/000002_1506928728.png | /items/DYAD4VA9008G6UF/000001_1519382369.jpg | SONY XPERIA XA1 Plus | ★贈保護套★SONY XPERIA XA1 Plus | 7888 | 7888 | 1 | 0 | list() | ||||
| DYAD4J-A9008E39C | DYAD4J | /items/DYAD4JA9008E39C/000002_1505215868.jpg | /items/DYAD4JA9008E39C/000001_1520218941.jpg | SONY XPERIA XZ1 | ★贈玻璃貼＋保護套★ SONY XPERIA XZ1 | 15380 | 15380 | 1 | 0 | list() | ||||
| DGBJA8-A90084NVG | DGBJA8 | /items/DGBJA8A90084NVG/000002_1495159305.png | /items/DGBJA8A90084NVG/000001_1495159305.png | SONY PS4 無線立體聲耳機 | SONY 無線立體聲耳罩耳機CECHYA-0083(支援7.1聲道) | 2980 | 2980 | 1 | 0 | list() | ||||
| DGBQ1H-A9006LHR6 | DGBQ2Z | /items/DGBQ1HA9006LHR6/000002_1476841352.jpg | /items/DGBQ1HA9006LHR6/000001_1513043766.jpg | SONY A6000 16-50mm 變焦鏡組ILCE-6000L | 送MASSA-UV保護鏡▼32G電充組SONY A6000 16-50mm 變焦鏡組ILCE-6000L 公司貨 | 18800 | 18800 | 1 | 0 | list() | ||||
| DPAE03-A9007MIYA | DPAE03 | /items/DPAE03A9007MIYA/000002_1479376516.jpg | /items/DPAE03A9007MIYA/000001_1520650867.jpg | SONY MP-CL1A 行動微型投影機 | ▼每日強檔‧瘋殺特賣▼新一代SONY MP-CL1A 行動微型投影機 | 10900 | 10900 | 1 | 0 | list() | ||||
| QAAC0K-A9008J408 | QAAC0K | /items/QAAC0KA9008J408/000002_1510210423.jpg | /items/QAAC0KA9008J408/000001_1510210423.jpg | 【SONY福利品】SONY Xperia Tablet Z 16G WIFI平板電腦 | 【門市拆封福利品】SONY Xperia Tablet Z 平板電腦(SGP311) | 4690 | 4690 | 1 | 0 | list() | ||||
| DGBJA8-A9007T4US | DGBJA8 | /items/DGBJA8A9007T4US/000002_1487915756.jpg | /items/DGBJA8A9007T4US/000001_1487915756.jpg | SONY 3D環繞無線耳機(CECHYA-0090) | SONY PS4原廠 3D環繞音效 7.1虛擬聲道 無線耳罩耳機組 CECHYA-0090 | 4980 | 4980 | 1 | 0 | list() | ||||
| DYAD21-A90087SGF | DYAD21 | /items/DYAD21A90087SGF/000002_1498199580.jpg | /items/DYAD21A90087SGF/000001_1519612015.jpg | SONY XPERIA XZ Premium☆ | ★贈玻璃貼＋保護套★SONY XPERIA XZ Premium | 16990 | 16990 | 1 | 0 | list() | ||||
| DYAQ9M-A9008FAQ6 | DYAQ9M | /items/DYAQ9MA9008FAQ6/000002_1505970732.jpg | /items/DYAQ9MA9008FAQ6/000001_1510717627.jpg | SONY Hi-Res 無線藍牙降噪耳罩式耳機 WH-1000XM2 | SONY Hi-Res 無線藍牙降噪耳罩式耳機 WH-1000XM2 | 10900 | 10900 | 1 | 0 | list() | ||||
| DGAD01-A90054RYV | DGAD81 | /items/DGAD01A90054RYV/000002_1505097691.jpg | /items/DGAD01A90054RYV/000001_1516844725.jpg | SONY DSC-RX100M3(公司貨) | ★64G超狂三電組SONY DSC-RX100M3 數位相機 (公司貨) | 22980 | 22980 | 1 | 0 | list() |