Search Stores ( 搜尋商店 ) - ec-yahoo/ntu-hackathon GitHub Wiki
Usage
Search store by keyword
Table name
ecstore.store.search_stores
Parameters
| Key | Type | Required | Description | Example |
|---|---|---|---|---|
| keyword | string | false | Key word used to search | 東京 |
| start | string | false | Pagination index, start from 1 | 1 |
| count | string | false | Limit number of return items | 20 |
Sample Query
select * from ecstore.store.search_stores WHERE keyword="東京"
Sample response
{
"query": {
"count": 1,
"created": "2017-07-17T08:16:06Z",
"lang": "en-US",
"results": {
"Response": {
"Status": "ok",
"Result": {
"stores": {
"store": [{
"storeId": "tokyozakka",
"storeName": "東京生活雜貨店",
"description": "在這個網站，向台灣介紹有關日本的商品。所謂「島島島」之名、就是想把「台灣、日本南西諸島、太平洋南邊之島的很酷衣・食•住的文化事物概念傳達出去的生活化品牌」",
"isSuperior": "0",
"itemCount": "241",
"storeRatingScore": "10.0",
"storeRatingCount": "1",
"smallImageUrl": "https://s.yimg.com/ut/api/res/1.2/cm_ZInAfJ8vp.WTg7pfOIg--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/tokyozakka-psBanner-0829xf3x0300x0060-m.jpg",
"largeImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/tokyozakka-psBanner-0829xf3x0300x0060-m.jpg",
"smallMainImageUrl": "https://s.yimg.com/ut/api/res/1.2/cm_ZInAfJ8vp.WTg7pfOIg--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/tokyozakka-psBanner-0829xf3x0300x0060-m.jpg",
"largeMainImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/tokyozakka-psBanner-0829xf3x0300x0060-m.jpg"
}, {
"storeId": "tokyomasamune",
"storeName": "東京正宗",
"description": "人手一台拍立得~紀錄值得珍藏的每一刻專賣: 拍立得、LOMO相機、 紙膠帶、文具、日本生活雜貨玩具網拍專線： 02-27773036轉12",
"isSuperior": "0",
"itemCount": "1456",
"storeRatingScore": "9.6",
"storeRatingCount": "197",
"smallImageUrl": "https://s.yimg.com/ut/api/res/1.2/AluK7pOxt2SF_PJezjE2Cg--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/tokyomasamune-psBanner-1943xf3x0300x0060-m.jpg",
"largeImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/tokyomasamune-psBanner-1943xf3x0300x0060-m.jpg",
"smallMainImageUrl": "https://s.yimg.com/ut/api/res/1.2/AluK7pOxt2SF_PJezjE2Cg--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/tokyomasamune-psBanner-1943xf3x0300x0060-m.jpg",
"largeMainImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/tokyomasamune-psBanner-1943xf3x0300x0060-m.jpg"
}, {
"storeId": "his_aime",
"storeName": "東京企劃",
"description": "♥信箱:[email protected],週一-五出貨(9-17點,12-13點休息)♥出貨庫存:04-23020802♥帳款相關:02-77229966",
"isSuperior": "0",
"itemCount": "134",
"storeRatingScore": "9.5",
"storeRatingCount": "982",
"smallImageUrl": "https://s.yimg.com/ut/api/res/1.2/8d.XDQRzLzzYvRPoGgWffw--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/his_aime-psBanner-8954xf3x0300x0060-m.jpg",
"largeImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/his_aime-psBanner-8954xf3x0300x0060-m.jpg",
"smallMainImageUrl": "https://s.yimg.com/ut/api/res/1.2/8d.XDQRzLzzYvRPoGgWffw--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/his_aime-psBanner-8954xf3x0300x0060-m.jpg",
"largeMainImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/his_aime-psBanner-8954xf3x0300x0060-m.jpg"
}, {
"storeId": "jl8856099",
"storeName": "東京鐵架 yo-life",
"description": "以工廠直營與消費者角度生產研發DIY家具，提供外銷精品，打造空間的魔法師--創造需求.滿足需求 堅-堅固 實-實惠 精-精品 美-美觀",
"isSuperior": "0",
"itemCount": "233",
"storeRatingScore": "9.2",
"storeRatingCount": "31",
"smallImageUrl": "https://s.yimg.com/ut/api/res/1.2/zz24ou8p1LFL2TwdyWGBFQ--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/jl8856099-psBanner-8517xf3x0300x0060-m.jpg",
"largeImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/jl8856099-psBanner-8517xf3x0300x0060-m.jpg",
"smallMainImageUrl": "https://s.yimg.com/ut/api/res/1.2/zz24ou8p1LFL2TwdyWGBFQ--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/jl8856099-psBanner-8517xf3x0300x0060-m.jpg",
"largeMainImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/jl8856099-psBanner-8517xf3x0300x0060-m.jpg"
}, {
"storeId": "mayuki0920",
"storeName": "東京著衣",
"description": "清涼一夏↘288★馬來貘聯名系列新上市★全館萊爾富$99免運",
"isSuperior": "0",
"itemCount": "2898",
"storeRatingScore": "9.1",
"storeRatingCount": "6328",
"smallImageUrl": "https://s.yimg.com/ut/api/res/1.2/qY0RGCw.GsrCJCXtEmWJPg--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/mayuki0920-psBanner-3364xf3x0300x0060-m.jpg",
"largeImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/mayuki0920-psBanner-3364xf3x0300x0060-m.jpg",
"smallMainImageUrl": "https://s.yimg.com/ut/api/res/1.2/qY0RGCw.GsrCJCXtEmWJPg--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/mayuki0920-psBanner-3364xf3x0300x0060-m.jpg",
"largeMainImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/mayuki0920-psBanner-3364xf3x0300x0060-m.jpg"
}, {
"storeId": "ok2016city",
"storeName": "Tokyo Shop",
"description": "本賣場全部商品都是國外直購，請放心購買。將最夯最hot流行服飾，全館滿699免運 !",
"isSuperior": "0",
"itemCount": "4747",
"storeRatingScore": "9.1",
"storeRatingCount": "14",
"smallImageUrl": "https://s.yimg.com/ut/api/res/1.2/S2heLVJ7jsDKpRyD4wvzdw--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/ok2016city-psBanner-4860xf3x0300x0060-m.jpg",
"largeImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/ok2016city-psBanner-4860xf3x0300x0060-m.jpg",
"smallMainImageUrl": "https://s.yimg.com/ut/api/res/1.2/S2heLVJ7jsDKpRyD4wvzdw--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/ok2016city-psBanner-4860xf3x0300x0060-m.jpg",
"largeMainImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/ok2016city-psBanner-4860xf3x0300x0060-m.jpg"
}, {
"storeId": "melodyhome",
"storeName": "東京戀人",
"description": "初夏新體驗 新品專區 任一件65折滿千再折 100元",
"isSuperior": "0",
"itemCount": "1251",
"storeRatingScore": "9.0",
"storeRatingCount": "244",
"smallImageUrl": "https://s.yimg.com/ut/api/res/1.2/15v48SkZ_ea_msU.2qtIvg--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/melodyhome-psBanner-5156xf3x0300x0060-m.jpg",
"largeImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/melodyhome-psBanner-5156xf3x0300x0060-m.jpg",
"smallMainImageUrl": "https://s.yimg.com/ut/api/res/1.2/15v48SkZ_ea_msU.2qtIvg--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/melodyhome-psBanner-5156xf3x0300x0060-m.jpg",
"largeMainImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/melodyhome-psBanner-5156xf3x0300x0060-m.jpg"
}, {
"storeId": "tokyocolor",
"storeName": "東京color",
"description": "嚴選日本優質好物，美容家電、美妝、生活用品..等，生活中的各類商品盡在東京color，滿足你的需求。",
"isSuperior": "0",
"itemCount": "74",
"storeRatingScore": "9.0",
"storeRatingCount": "5",
"smallImageUrl": "https://s.yimg.com/ut/api/res/1.2/A86IaSTk2TI2wCKOECmEtA--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/tokyocolor-psBanner-4869xf3x0300x0060-m.jpg",
"largeImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/tokyocolor-psBanner-4869xf3x0300x0060-m.jpg",
"smallMainImageUrl": "https://s.yimg.com/ut/api/res/1.2/A86IaSTk2TI2wCKOECmEtA--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/tokyocolor-psBanner-4869xf3x0300x0060-m.jpg",
"largeMainImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/tokyocolor-psBanner-4869xf3x0300x0060-m.jpg"
}, {
"storeId": "ametokyobrand",
"storeName": "Ame Tokyo Brand",
"description": "▼感謝光臨我們的賣場 ♫ 2016夏裝登場!!★來自日本當地流行零時差的商品空運來台，享受更多的潮流好物購物樂趣▼敬請安心選購( ◠‿◠ )♫‧*‥*‧.﹐﹐♪",
"isSuperior": "0",
"itemCount": "345",
"storeRatingScore": "8.6",
"storeRatingCount": "18",
"smallImageUrl": "https://s.yimg.com/ut/api/res/1.2/PKXHQCkKxQtt58SjBHNPSw--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/ametokyobrand-psBanner-9938xf3x0300x0060-m.jpg",
"largeImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/ametokyobrand-psBanner-9938xf3x0300x0060-m.jpg",
"smallMainImageUrl": "https://s.yimg.com/ut/api/res/1.2/PKXHQCkKxQtt58SjBHNPSw--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/ametokyobrand-psBanner-9938xf3x0300x0060-m.jpg",
"largeMainImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/ametokyobrand-psBanner-9938xf3x0300x0060-m.jpg"
}, {
"storeId": "tokyoef",
"storeName": "東京衣服",
"description": "舒淇 許瑋甯 隋棠 陳意涵...等名人愛用禮服品牌，全館現貨",
"isSuperior": "0",
"itemCount": "296",
"storeRatingScore": "8.5",
"storeRatingCount": "3",
"smallImageUrl": "https://s.yimg.com/ut/api/res/1.2/wSFQx2XHvK2wGJgSau5KAA--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/tokyoef-psBanner-7120xf3x0300x0060-m.jpg",
"largeImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/tokyoef-psBanner-7120xf3x0300x0060-m.jpg",
"smallMainImageUrl": "https://s.yimg.com/ut/api/res/1.2/wSFQx2XHvK2wGJgSau5KAA--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/tokyoef-psBanner-7120xf3x0300x0060-m.jpg",
"largeMainImageUrl": "https://imgcld.zenfs.com/ps_image_prod/psBanner/tokyoef-psBanner-7120xf3x0300x0060-m.jpg"
}],
"total": 18,
"start": 1,
"count": 10
}
}
}
}
}
}