Product Review ( 商品評價 ) - ec-yahoo/ntu-hackathon GitHub Wiki
Get review and rating information by product ot store
Table Name
ecstore.rnr.product_review
Parameters
| Keys | Description | Required | Example |
|---|---|---|---|
| targetType | Which type of reviews client queries? | true | store or product |
| storeId | Store ID | false | tw_auc_user1 |
| productId | product id | false | p1245665457 |
| productIds | product ids | false | tp1245665457,p09495497669 |
| rating | rating star or range. for bigger than queries use a trailing comma (e.g. ‘2,’ => rating >= 2); for less than queries use a comma in front (e.g. ‘,3’ => rating <= 3). for range star queries use comma separated digits (e.g. 2,4 => 2 <= rating <= 4) | false | 5 |
| anonymous | Whether display anonymous reviews | false | 0 |
| createTimeStart | review create time range starting from | false | 1474316760 |
| createTimeEnd | review create time range ends at | false | 1474316760 |
| hasImage | reviews having any images | false | 1 |
| start | start offset for pagination | false | 1 |
| count | number of reviews to get at once | false | 50 |
| sortBy | sorting param of response data | false | createTime or updateTime or rating |
| sortOrder | sorting order of response data | false | desc or asc |
Sample Query
select * from ecstore.rnr.product_review where targetType="product" and productId="p0084133288711" and start="1" and count="5"
Sample Response
{
"query": {
"count": 1,
"created": "2017-07-13T10:27:47Z",
"lang": "zh-TW",
"results": {
"Response": {
"Status": "ok",
"Result": {
"reviews": {
"total": 24,
"count": 5,
"review": [
{
"content": "太透明啦~~~~\n但還是好穿哦！",
"deactivated": false,
"id": "114912159253662351",
"replyCount": 0,
"transactionId": "154380308",
"cartId": "211733605",
"orderId": "YM1706260078523",
"replyStatus": 0,
"sellerReplyTime": "0",
"productTitle": "MIUSTAR 荷葉袖金線花刺繡領三角鏤空雪紡上衣(共2色)【NE2310ES】預購",
"orderStatus": 4,
"anonymous": 0,
"updateTimeByUser": 1499913844,
"productId": "p0084133288711",
"storeId": "miu-star",
"maskedUserId": "vm6a****",
"ecid": "Y8943505355",
"nickname": "Mini",
"profileImageUrl": "https://s.yimg.com/wm/modern/images/default_user_profile_pic_48.png",
"likes": 0,
"abuse": 0,
"rating": 4,
"images": [],
"createTime": 1499913844,
"updateTime": 1499913844,
"readOnly": 0,
"freezeTime": 1507564800,
"productSpecs": [
{
"productSpecId": 1,
"productSpecName": "白",
"quantity": 1
}
],
"storeName": "Miu-Star",
"storeIcon": "https://s.yimg.com/ut/api/res/1.2/fjWwlVKYmaAGyOlpuJCUfw--/YXBwaWQ9eXR3bWFsbDtoPTE0NDtxPTkwO3c9MTQ0/http://imgcld.zenfs.com:80/ps_image_prod/mthumb/miu-star-mthumb-2039xf3x0144x0144_m.jpg",
"orderImageUrl": "https://s.yimg.com/ut/api/res/1.2/6DgGGPKB4JnXiFDYCvV7Jw--/YXBwaWQ9eXR3bWFsbDtoPTYwMDtxPTkwO3c9NjAw/https://s.yimg.com/sw/ps_image_prod/myorder_snapshot/154380308-p0084133288711-1"
},
{
"content": "不錯",
"deactivated": false,
"id": "114912159253654743",
"replyCount": 0,
"transactionId": "154332401",
"cartId": "211680338",
"orderId": "YM1706260001657",
"replyStatus": 0,
"sellerReplyTime": "0",
"productTitle": "MIUSTAR 荷葉袖金線花刺繡領三角鏤空雪紡上衣(共2色)【NE2310ES】預購",
"orderStatus": 4,
"anonymous": 0,
"updateTimeByUser": 1499856937,
"productId": "p0084133288711",
"storeId": "miu-star",
"maskedUserId": "a750****",
"ecid": "Y3912415026",
"nickname": "Patty",
"profileImageUrl": "https://s.yimg.com/wm/modern/images/default_user_profile_pic_48.png",
"likes": 0,
"abuse": 0,
"rating": 4,
"images": [],
"createTime": 1499856937,
"updateTime": 1499856937,
"readOnly": 0,
"freezeTime": 1507737600,
"productSpecs": [
{
"productSpecId": 2,
"productSpecName": "豆粉",
"quantity": 1
}
],
"storeName": "Miu-Star",
"storeIcon": "https://s.yimg.com/ut/api/res/1.2/fjWwlVKYmaAGyOlpuJCUfw--/YXBwaWQ9eXR3bWFsbDtoPTE0NDtxPTkwO3c9MTQ0/http://imgcld.zenfs.com:80/ps_image_prod/mthumb/miu-star-mthumb-2039xf3x0144x0144_m.jpg",
"orderImageUrl": "https://s.yimg.com/ut/api/res/1.2/Mw7WD7tgSzBNEDhjdNKjcg--/YXBwaWQ9eXR3bWFsbDtoPTYwMDtxPTkwO3c9NjAw/https://s.yimg.com/sw/ps_image_prod/myorder_snapshot/154332401-p0084133288711-1"
},
{
"content": "材質很好，穿起來很秀氣。",
"deactivated": false,
"id": "115686215439603900",
"replyCount": 0,
"transactionId": "154117768",
"cartId": "211287898",
"orderId": "YM1706210054998",
"replyStatus": 0,
"sellerReplyTime": "0",
"productTitle": "MIUSTAR 荷葉袖金線花刺繡領三角鏤空雪紡上衣(共2色)【NE2310ES】預購",
"orderStatus": 4,
"anonymous": 0,
"updateTimeByUser": 1499832635,
"productId": "p0084133288711",
"storeId": "miu-star",
"maskedUserId": "mill****",
"ecid": "Y0301312612",
"nickname": "Y0301312612",
"profileImageUrl": "https://s.yimg.com/wm/modern/images/default_user_profile_pic_48.png",
"likes": 0,
"abuse": 0,
"rating": 5,
"images": [],
"createTime": 1499832635,
"updateTime": 1499832635,
"readOnly": 0,
"freezeTime": 1507132800,
"productSpecs": [
{
"productSpecId": 2,
"productSpecName": "豆粉",
"quantity": 1
}
],
"storeName": "Miu-Star",
"storeIcon": "https://s.yimg.com/ut/api/res/1.2/fjWwlVKYmaAGyOlpuJCUfw--/YXBwaWQ9eXR3bWFsbDtoPTE0NDtxPTkwO3c9MTQ0/http://imgcld.zenfs.com:80/ps_image_prod/mthumb/miu-star-mthumb-2039xf3x0144x0144_m.jpg",
"orderImageUrl": "https://s.yimg.com/ut/api/res/1.2/I1gRNXe4fyYaJiUO2lJ0PQ--/YXBwaWQ9eXR3bWFsbDtoPTYwMDtxPTkwO3c9NjAw/https://s.yimg.com/sw/ps_image_prod/myorder_snapshot/154117768-p0084133288711-1"
},
{
"content": "不錯~",
"deactivated": false,
"id": "115686215439589591",
"replyCount": 0,
"transactionId": "154081044",
"cartId": "211032617",
"orderId": "YM1706200088958",
"replyStatus": 0,
"sellerReplyTime": "0",
"productTitle": "MIUSTAR 荷葉袖金線花刺繡領三角鏤空雪紡上衣(共2色)【NE2310ES】預購",
"orderStatus": 4,
"anonymous": 1,
"updateTimeByUser": 1499741529,
"productId": "p0084133288711",
"storeId": "miu-star",
"maskedUserId": null,
"ecid": null,
"nickname": null,
"profileImageUrl": "https://s.yimg.com/qs/mall/yps/common/anonymous48x48.png",
"likes": 0,
"abuse": 0,
"rating": 4,
"images": [],
"createTime": 1499741529,
"updateTime": 1499741529,
"readOnly": 0,
"freezeTime": 1507132800,
"productSpecs": [
{
"productSpecId": 1,
"productSpecName": "白",
"quantity": 1
}
],
"storeName": "Miu-Star",
"storeIcon": "https://s.yimg.com/ut/api/res/1.2/fjWwlVKYmaAGyOlpuJCUfw--/YXBwaWQ9eXR3bWFsbDtoPTE0NDtxPTkwO3c9MTQ0/http://imgcld.zenfs.com:80/ps_image_prod/mthumb/miu-star-mthumb-2039xf3x0144x0144_m.jpg",
"orderImageUrl": "https://s.yimg.com/ut/api/res/1.2/.zSNCWWpBGz4wmnuOYV8Wg--/YXBwaWQ9eXR3bWFsbDtoPTYwMDtxPTkwO3c9NjAw/https://s.yimg.com/sw/ps_image_prod/myorder_snapshot/154081044-p0084133288711-1"
},
{
"content": "很漂亮，不過比想像中短",
"deactivated": false,
"id": "115334371718698069",
"replyCount": 0,
"transactionId": "154193388",
"cartId": "211426305",
"orderId": "YM1706220086009",
"replyStatus": 0,
"sellerReplyTime": "0",
"productTitle": "MIUSTAR 荷葉袖金線花刺繡領三角鏤空雪紡上衣(共2色)【NE2310ES】預購",
"orderStatus": 4,
"anonymous": 0,
"updateTimeByUser": 1499702697,
"productId": "p0084133288711",
"storeId": "miu-star",
"maskedUserId": "eati****",
"ecid": "Y1901825152",
"nickname": "轐梭",
"profileImageUrl": "https://s.yimg.com/wm/modern/images/default_user_profile_pic_48.png",
"likes": 0,
"abuse": 0,
"rating": 5,
"images": [],
"createTime": 1499702697,
"updateTime": 1499702697,
"readOnly": 0,
"freezeTime": 1507219200,
"productSpecs": [
{
"productSpecId": 2,
"productSpecName": "豆粉",
"quantity": 1
}
],
"storeName": "Miu-Star",
"storeIcon": "https://s.yimg.com/ut/api/res/1.2/fjWwlVKYmaAGyOlpuJCUfw--/YXBwaWQ9eXR3bWFsbDtoPTE0NDtxPTkwO3c9MTQ0/http://imgcld.zenfs.com:80/ps_image_prod/mthumb/miu-star-mthumb-2039xf3x0144x0144_m.jpg",
"orderImageUrl": "https://s.yimg.com/ut/api/res/1.2/iVU5pYeNTTB18eaRN79RSQ--/YXBwaWQ9eXR3bWFsbDtoPTYwMDtxPTkwO3c9NjAw/https://s.yimg.com/sw/ps_image_prod/myorder_snapshot/154193388-p0084133288711-1"
}
]
}
}
}
}
}
}