Get Sub Categories ( 取得分類子目錄 ) - ec-yahoo/ntu-hackathon GitHub Wiki

Usage

Get Sub Categories

Table Name

ecstore.category.get_sub_categories

Parameters

Keys	Description	Required	Example
categoryId	categoryId	true	152983414

Sample Query

select * from ecstore.category.get_sub_categories where categoryId="152983414"

Sample Response

url : https://partner.yql.yahoo.com/v1/public/yql?q=select%20*%20from%20ecstore.category.get_sub_categories%20where%20categoryId%3D%22152983414%22&format=json

{
 "query": {
  "count": 1,
  "created": "2017-07-13T08:51:37Z",
  "lang": "en-US",
  "results": {
   "Response": {
    "Status": "ok",
    "Result": {
     "subCategories": {
      "category": [
       {
        "categoryId": "2144867915",
        "name": "SONY單眼",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144867916",
        "name": "SONY鏡頭",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144867909",
        "name": "Canon單眼",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144867910",
        "name": "Canon鏡頭",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144867913",
        "name": "Nikon單眼",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144867912",
        "name": "Nikon鏡頭",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144909072",
        "name": "SIGMA鏡頭",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144909073",
        "name": "TAMRON鏡頭",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144909075",
        "name": "Zeiss鏡頭",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "152983439",
        "name": "OLYMPUS單眼",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144909068",
        "name": "OLYMPUS鏡頭",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144403422",
        "name": "SAMSUNG單眼",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "979264031",
        "name": "Panasonic單眼",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144909074",
        "name": "Tokina鏡頭",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144909069",
        "name": "Panasonic鏡頭",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144403419",
        "name": "Fujifilm單眼",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144403421",
        "name": "SIGMA單眼",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "152983442",
        "name": "其他單眼",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144909067",
        "name": "其他鏡頭",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144909071",
        "name": "SAMSUNG鏡頭",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "152983440",
        "name": "PENTAX單眼",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144909070",
        "name": "PENTAX鏡頭",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       },
       {
        "categoryId": "2144909076",
        "name": "Leica鏡頭",
        "level": 3,
        "isLink": 0,
        "isLeaf": 1,
        "isAdult": 0,
        "displayMode": "both",
        "parentCategoryId": "152983414"
       }
      ]
     }
    }
   }
  }
 }
}