Get Store ( 取得商店資訊 ) - ec-yahoo/ntu-hackathon GitHub Wiki

Usage

Get information of a store

Table Name

ecstore.store.get_store

Parameters

Keys	Description	Required	Example
storeId	Store ID	true	hanshin

Sample Query

select * from ecstore.store.get_store where storeId="hanshin"

Sample Response

url : https://partner.yql.yahoo.com/v1/public/yql?q=select%20*%20from%20ecstore.store.get_store%20where%20storeId%3D%22hanshin%22&format=json

{
 "query": {
  "count": 1,
  "created": "2017-07-13T09:25:47Z",
  "lang": "en-US",
  "results": {
   "Response": {
    "Status": "ok",
    "Result": {
     "store": {
      "storeId": "hanshin",
      "storeName": "漢神百貨",
      "shortcutName": "漢神百貨",
      "isOpen": 1,
      "shortDescription": "▌漢神巨蛋同慶 ▌7/11-7/24 全店滿1000以上送150折價券 ▌全館免運◀萬件專櫃正品網路直購，提供值得信賴、24小時不打烊購物殿堂。部份食品含運。",
      "largeImageUrl": "https://s.yimg.com/ut/api/res/1.2/hLecEjK5HmbdWjaRH_bbag--/YXBwaWQ9eXR3bWFsbDtoPTYwO3E9ODE7dz0zMDA-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/hanshin-psBanner-7714xf3x0300x0060-m.jpg",
      "smallImageUrl": "https://s.yimg.com/ut/api/res/1.2/kSXDq.sOqnr6pC12_wdnSA--/YXBwaWQ9eXR3bWFsbDtoPTM3O3E9Nzg7dz0xODU-/http://imgcld.zenfs.com:80/ps_image_prod/psBanner/hanshin-psBanner-7714xf3x0300x0060-m.jpg",
      "iconUrl": "https://s.yimg.com/ut/api/res/1.2/Cp4ET1D5Gv.ZkBuQdawYbw--/YXBwaWQ9eXR3bWFsbDtoPTE0NDtxPTkwO3c9MTQ0/http://imgcld.zenfs.com:80/ps_image_prod/mthumb/hanshin-mthumb-5039xf3x0144x0144_m.jpg",
      "announcement": "▌7/11 - 7/24 全店滿1000以上送150電子折價券 ▌\n▌全館5萬件商品，24小時不打烊 ▌\n\n《客服電話》0800-384-888 ｜07-550-0379｜ 週一~週五 10:00~17:30\n《客服信箱》[email protected]\n《配送服務》台灣本島免運費，部份食品含運",
      "openDate": 1322450103,
      "isSuperior": 0,
      "collectionCount": 157355,
      "storeDisplayInfo": {
       "showAnnouncement": 1,
       "showStoreFAQ": 1,
       "showProductQandA": 1,
       "homeBrowseMode": "image",
       "homeBrowseSortOrder": "desc",
       "homeBrowseSortBy": "sc_salerank",
       "searchBrowseMode": "image",
       "searchBrowseSortOrder": "desc",
       "searchBrowseSortBy": "createtime"
      },
      "storeEvaluation": {
       "shippingVelocity": "1.6",
       "replyVelocity": "0.5",
       "shortRate": "0.3"
      },
      "ratingScore": {
       "ratingAverage": 9.4,
       "quality": 9.4,
       "service": 9.4,
       "deliver": 9.4
      },
      "pageView": 626800
     }
    }
   }
  }
 }
}