Xiaohongshu (RED) Product Review Overview

API docs
https://api.sandbase.ai/v1/api/xiaohongshu/app-v2/product-review-overview

Returns product review statistics and feedback details for a specific item on Xiaohongshu (RED), filtered by SKU identifier and tab type.

Price
$0.01USD / call
Method
POST
Response
JSON
Parameters
1 required · 1 optional
100 free calls / dayFirst 100 calls per day free (shared per organization) · Resets at 00:00 UTC. Pay per call after that.

Playground

Input
Product SKU ID (required), e.g. "669ddd44e05f3700011067ed"
Tab type, default 2
OutputExample
Responseoutputs · 3.1 KB · 98 lines
[
  {
    "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
    }
  }
]

Examples

Select an example to load its inputs and result into the playground.

API README

Xiaohongshu (RED) Product Review Overview API

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.

Use cases

  • Show the average score and star distribution of a SKU on a product dashboard.
  • Compare the share of 4 and 5 star reviews across competing SKUs.
  • Sample the latest review text and dates for a SKU to check buyer feedback.
  • Read the filter and sort options offered for a SKU's review list.

Request

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.

Parameters

NameTypeRequiredDescription
sku_idstringYesProduct SKU ID (required), e.g. "669ddd44e05f3700011067ed"
tabintegerNoTab type, default 2

Example response

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
}

Response fields

FieldMeaning
data.avgScoreAverage review score for the SKU, returned as a string such as 4.7.
data.avgScoreDescText label for the average score, such as Excellent.
data.totalTotal number of reviews for the SKU.
data.scoreToCntCount of reviews for each star rating. Keys 1 to 5 are star values.
data.purchaseHistoryCountPurchase count shown for the SKU.
data.reviews[].reviewInfo.contentText of the review.
data.reviews[].reviewInfo.createTimeDesc / data.reviews[].reviewInfo.create_time_descReview date as a DD/MM/YYYY string.
data.reviews[].userInfo.name / data.reviews[].userInfo.userIdDisplay name and ID of the reviewer.
data.filterStrategyList[].nameNames of the review filters, such as With images and Styles. Each has a numeric type.
data.sortStrategyList[].nameNames of the review sort options, such as Default and Latest. Each has a numeric type.

Notes

Pricing

$0.01 per successful call. Failed calls are not charged. It is included in the daily free quota of each organization.

Explore more

Related APIs

All APIs
APIPriceResponse
Xiaohongshu$0.01 per callJSON
Xiaohongshu$0.01 per callJSON
Xiaohongshu$0.01 per callJSON
Xiaohongshu$0.01 per callJSON
Xiaohongshu$0.01 per callJSON
Xiaohongshu$0.01 per callJSON

Questions

FAQ

How do I use the Xiaohongshu (RED) Product Review Overview API?

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.

How much does the Xiaohongshu (RED) Product Review Overview API cost?

$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.

What parameters does the Xiaohongshu (RED) Product Review Overview API accept?

Required: sku_id (string). Optional: tab (integer). The Parameters table and the Playground on this page list every field.

What does the Xiaohongshu (RED) Product Review Overview API return?

A JSON response returned in the same HTTP request (synchronous). The README on this page includes a sample response.

Do I need a Xiaohongshu developer account or API key?

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.