sku_idstringrequired
Product SKU ID (required), e.g. "669ddd44e05f3700011067ed"
https://api.sandbase.ai/v1/api/xiaohongshu/app-v2/product-review-overviewReturns product review statistics and feedback details for a specific item on Xiaohongshu (RED), filtered by SKU identifier and tab type.
[
{
"data": {
"code": 0,
"data": {
"avgScore": "4.7",
"avgScoreColorInEightDigit": "FF2442",
"avgScoreDesc": "Excellent",
"avgScoreLevel": 0,
"comment_type": "1",
"expireFlagMap": {
"badReviewTag": 2,
"goods_review": 2,
"newdetail_review": 0,
"pingjiabiaoqian": 1,
"pingjiaerjiyegaiban": 0
},
"filterStrategyList": [
{
"name": "With images",
"type": 0
},
{
"name": "Styles",
"type": 1
}
],
"purchaseHistoryCount": 652,
"review_sub_title": "",
"reviews": [
{
"reviewInfo": {
"anonymous": false,
"content": "很透亮 透本甲 需要自己修一下甲型",
"createTimeDesc": "21/04/2026",
"create_time_desc": "21/04/2026",
"itemScore": 0,
"newSkuScore": 0,
"order_id": "",
"package_review_id": ""
},
"translateFlag": true,
"userInfo": {
"anonymous": false,
"avatar": "https://sns-avatar-qc.xhscdn.com/avatar/1040g2jo31bs9nu4dgk005pkcbam0u1d3rg3thc8?imageView2/2/w/80/format/jpg",
"name": "小狗乖乖",
"userId": "a313d0e5066666a6cda2ce22c696f",
"visitorFlag": false
}
},
{
"reviewInfo": {
"anonymous": false,
"content": "晚上拍的,跟自然光不一样但还是很好看的",
"createTimeDesc": "23/03/2026",
"create_time_desc": "23/03/2026",
"itemScore": 0,
"newSkuScore": 0,
"order_id": "",
"package_review_id": ""
},
"translateFlag": true,
"userInfo": {
"anonymous": false,
"avatar": "https://sns-avatar-qc.xhscdn.com/avatar/1040g2jo3240hufpcn0005n1bgj8hdkd698p5mb0?imageView2/2/w/80/format/jpg",
"name": "之之不是吱吱",
"userId": "a84c75019fa016beb8f86bbe8b441",
"visitorFlag": false
}
}
],
"scoreDesc": "评分",
"scoreToCnt": {
"1": 0,
"2": 0,
"3": 2,
"4": 69,
"5": 742
},
"sortStrategyList": [
{
"name": "Default",
"type": 0
},
{
"name": "Latest",
"type": 1
}
],
"total": 813
},
"debug_id": "6c0cb34b",
"debug_info": "gAAAAABqhsw2FabONoB858F4ocoIMLvqMI5dSTUUYMjMpr7mcxiBrKc-6wtdgytdMxuqaoNBKrQuVKEP4eDzVYXazOcQUDc4whcmyTpLeytp4OFpcHNVqRw1R40WhmMIIzJTWLaB-hE-_X7Nxwn2Xr6-K4TLiW8hXrzucDCg7mmLKCPE3XnS_AbcboLTOB8szUy2U9GN5XRk2S6LGEm36lixMzVIQDWUslWfqR6M8_rmD3jUBYsRgspVOaaJz_gbAmhHqWWeVCOXaU8SCqNFIoGDVfbApCspTl3L09DWdmwh1qHuwbTXupZSnn26-LhRLOiVareoE5_jvqOnXW85bcXFlSzVFTvcbxoXQt64bvptWt4mfct6wvfWhZkF0K_SLMRQGZcGgEjkgZ_wsF9_3ryYXyTWCgYpm9p9Hi1ryJis727YvWbhtPMJYmAL4HpaOEiQGr2HLeYC",
"msg": "ok",
"success": true
}
}
]Select an example to load its inputs and result into the playground.
Returns review statistics for one Xiaohongshu (RED) product SKU, including the average score, a count of reviews per star rating, and a short list of recent reviews. It needs a sku_id and takes an optional tab value.
curl -X POST "https://api.sandbase.ai/v1/api/xiaohongshu/app-v2/product-review-overview" \
-H "Authorization: Bearer $SANDBASE_API_KEY" \
-H "Content-Type: application/json" \
-d '{"sku_id": "669ddd44e05f3700011067ed"}'
The result is returned in outputs[0].data.
| Name | Type | Required | Description |
|---|---|---|---|
sku_id | string | Yes | Product SKU ID (required), e.g. "669ddd44e05f3700011067ed" |
tab | integer | No | Tab type, default 2 |
Real response for the request above, trimmed: lists keep their first item and long strings are cut.
{
"code": 0,
"data": {
"avgScore": "4.7",
"avgScoreColorInEightDigit": "FF2442",
"avgScoreDesc": "Excellent",
"avgScoreLevel": 0,
"comment_type": "1",
"expireFlagMap": {
"badReviewTag": 2,
"goods_review": 2,
"newdetail_review": 0,
"pingjiabiaoqian": 1,
"pingjiaerjiyegaiban": 0,
"review_tag_generic_filter": 0
},
"filterStrategyList": [
{
"name": "With images",
"type": 0
}
],
"purchaseHistoryCount": 333,
"review_sub_title": "",
"reviews": [
{
"reviewInfo": {
"anonymous": false,
"content": "很透亮 透本甲 需要自己修一下甲型",
"createTimeDesc": "21/04/2026",
"create_time_desc": "21/04/2026",
"itemScore": 0,
"newSkuScore": 0,
"order_id": "",
"package_review_id": ""
},
"translateFlag": true,
"userInfo": {
"anonymous": false,
"avatar": "https://sns-avatar-qc.xhscdn.com/avatar/1040g2jo325t6skhg56005pkcbam0u1d36tj26qg…",
"name": "噜噜狗",
"userId": "af4c0846adcc77e2b9f975a414336",
"visitorFlag": false
}
}
],
"scoreDesc": "评分",
"scoreToCnt": {
"1": 0,
"2": 0,
"3": 0,
"4": 71,
"5": 747
}
},
"debug_id": "d210d3cc",
"debug_info": "gAAAAABq6ZFpt0ODLPUVxslgz08ZeUu6K3c0jyja05FaaypbWjMxgBaSw9VC6QO7MlHF12utWRpMO3vS…",
"msg": "ok",
"success": true
}
| Field | Meaning |
|---|---|
data.avgScore | Average review score for the SKU, returned as a string such as 4.7. |
data.avgScoreDesc | Text label for the average score, such as Excellent. |
data.total | Total number of reviews for the SKU. |
data.scoreToCnt | Count of reviews for each star rating. Keys 1 to 5 are star values. |
data.purchaseHistoryCount | Purchase count shown for the SKU. |
data.reviews[].reviewInfo.content | Text of the review. |
data.reviews[].reviewInfo.createTimeDesc / data.reviews[].reviewInfo.create_time_desc | Review date as a DD/MM/YYYY string. |
data.reviews[].userInfo.name / data.reviews[].userInfo.userId | Display name and ID of the reviewer. |
data.filterStrategyList[].name | Names of the review filters, such as With images and Styles. Each has a numeric type. |
data.sortStrategyList[].name | Names of the review sort options, such as Default and Latest. Each has a numeric type. |
sku_id is a 24-character hex string, for example 669ddd44e05f3700011067ed. Find SKUs with Xiaohongshu (RED) Product Search or Xiaohongshu (RED) Product Detail.tab defaults to 2. The request above did not set it.reviews list in this response is a short sample. Call Xiaohongshu (RED) Product Reviews to read the reviews themselves.$0.01 per successful call. Failed calls are not charged. It is included in the daily free quota of each organization.
Start building
Platform API endpoint with unified authentication and usage tracking.
# The quoted heredoc keeps Unicode and shell metacharacters unchanged.
result=$(curl --fail-with-body --silent \
-X POST "https://api.sandbase.ai/v1/api/xiaohongshu/app-v2/product-review-overview" \
-H "Authorization: Bearer $SANDBASE_API_KEY" \
-H "Content-Type: application/json" \
--data-binary @- <<'SANDBASE_JSON'
{
"tab": 2,
"sku_id": "669ddd44e05f3700011067ed"
}
SANDBASE_JSON
)
printf '%s\n' "$result"Set your SandBase API key in your server environment. Requests use Bearer authentication.
export SANDBASE_API_KEY="YOUR_API_KEY"Keep your key on the server. Do not expose it in browser code.
sku_idstringrequiredProduct SKU ID (required), e.g. "669ddd44e05f3700011067ed"
tabintegerTab type, default 2
Default: 2
Saved example response for this API; no live request is made when viewing it.
[
{
"data": {
"code": 0,
"data": {
"avgScore": "4.7",
"avgScoreColorInEightDigit": "FF2442",
"avgScoreDesc": "Excellent",
"avgScoreLevel": 0,
"comment_type": "1",
"expireFlagMap": {
"badReviewTag": 2,
"goods_review": 2,
"newdetail_review": 0,
"pingjiabiaoqian": 1,
"pingjiaerjiyegaiban": 0
},
"filterStrategyList": [
{
"name": "With images",
"type": 0
},
{
"name": "Styles",
"type": 1
}
],
"purchaseHistoryCount": 652,
"review_sub_title": "",
"reviews": [
{
"reviewInfo": {
"anonymous": false,
"content": "很透亮 透本甲 需要自己修一下甲型",
"createTimeDesc": "21/04/2026",
"create_time_desc": "21/04/2026",
"itemScore": 0,
"newSkuScore": 0,
"order_id": "",
"package_review_id": ""
},
"translateFlag": true,
"userInfo": {
"anonymous": false,
"avatar": "https://sns-avatar-qc.xhscdn.com/avatar/1040g2jo31bs9nu4dgk005pkcbam0u1d3rg3thc8?imageView2/2/w/80/format/jpg",
"name": "小狗乖乖",
"userId": "a313d0e5066666a6cda2ce22c696f",
"visitorFlag": false
}
},
{
"reviewInfo": {
"anonymous": false,
"content": "晚上拍的,跟自然光不一样但还是很好看的",
"createTimeDesc": "23/03/2026",
"create_time_desc": "23/03/2026",
"itemScore": 0,
"newSkuScore": 0,
"order_id": "",
"package_review_id": ""
},
"translateFlag": true,
"userInfo": {
"anonymous": false,
"avatar": "https://sns-avatar-qc.xhscdn.com/avatar/1040g2jo3240hufpcn0005n1bgj8hdkd698p5mb0?imageView2/2/w/80/format/jpg",
"name": "之之不是吱吱",
"userId": "a84c75019fa016beb8f86bbe8b441",
"visitorFlag": false
}
}
],
"scoreDesc": "评分",
"scoreToCnt": {
"1": 0,
"2": 0,
"3": 2,
"4": 69,
"5": 742
},
"sortStrategyList": [
{
"name": "Default",
"type": 0
},
{
"name": "Latest",
"type": 1
}
],
"total": 813
},
"debug_id": "6c0cb34b",
"debug_info": "gAAAAABqhsw2FabONoB858F4ocoIMLvqMI5dSTUUYMjMpr7mcxiBrKc-6wtdgytdMxuqaoNBKrQuVKEP4eDzVYXazOcQUDc4whcmyTpLeytp4OFpcHNVqRw1R40WhmMIIzJTWLaB-hE-_X7Nxwn2Xr6-K4TLiW8hXrzucDCg7mmLKCPE3XnS_AbcboLTOB8szUy2U9GN5XRk2S6LGEm36lixMzVIQDWUslWfqR6M8_rmD3jUBYsRgspVOaaJz_gbAmhHqWWeVCOXaU8SCqNFIoGDVfbApCspTl3L09DWdmwh1qHuwbTXupZSnn26-LhRLOiVareoE5_jvqOnXW85bcXFlSzVFTvcbxoXQt64bvptWt4mfct6wvfWhZkF0K_SLMRQGZcGgEjkgZ_wsF9_3ryYXyTWCgYpm9p9Hi1ryJis727YvWbhtPMJYmAL4HpaOEiQGr2HLeYC",
"msg": "ok",
"success": true
}
}
]Explore more
| API | Price | Response |
|---|---|---|
Xiaohongshu | $0.01 per call | JSON |
Xiaohongshu | $0.01 per call | JSON |
Xiaohongshu | $0.01 per call | JSON |
Xiaohongshu | $0.01 per call | JSON |
Xiaohongshu | $0.01 per call | JSON |
Xiaohongshu | $0.01 per call | JSON |
Questions
Send a POST request to https://api.sandbase.ai/v1/api/xiaohongshu/app-v2/product-review-overview with your SandBase API key in the Authorization header (Bearer) and the parameters as a JSON body. You can also try it in the Playground on this page without writing code.
$0.01 per call. Every organization gets 100 free calls per UTC day, shared across eligible SandBase APIs including this one; after that each call is billed at this price from your SandBase balance. There is no subscription.
Required: sku_id (string). Optional: tab (integer). The Parameters table and the Playground on this page list every field.
A JSON response returned in the same HTTP request (synchronous). The README on this page includes a sample response.
No. Xiaohongshu (RED) Product Review Overview runs through SandBase, so one SandBase API key covers this endpoint and every other API and model in the catalog. You do not need to apply for Xiaohongshu API access separately.