---
title: "Export products"
method: GET
path: "/social-intelligence/products/export"
tags: ["Social Intelligence"]
---

# Export products

`GET /social-intelligence/products/export`

Export the product list in one call — same filters as GET /products, but without pagination. Returns JSON rows by default; pass `format=csv` for a downloadable file.

Capped at 1000 rows for most customers; `truncated: true` in the JSON response means the cap clipped the result. Consumes one of the shop's daily exports, a quota shared with portal exports.

## Query parameters

- `format` string — Output format. `json` returns rows; `csv` returns a downloadable file.
- `search` string, nullable
- `category` string, nullable
- `subcategory` string, nullable
- `sort_by` string, nullable — gmv28d, unitsSold, rating, creators, videos
- `sort_order` string

## Response `200`

Successful Response

- SiExportResponse — JSON form of an SI export. `format=csv` returns a CSV file instead.
  - `data` unknown[], required — Export rows, one object per record.
    - unknown
  - `row_count` integer, required
  - `row_limit` integer, nullable, required — Per-request row cap applied. Null when the customer is uncapped.
  - `truncated` boolean, required — True when the row cap clipped the result — there is more data than was returned. Narrow the filters and export again rather than treating the rows as the complete set.
  - `columns` string[], required — Column order used by the CSV form.

## Other responses

- `422` — Validation Error

---

[API](https://skmtc.dev/reacherapp/apis/reacher-data-api.md) · [All operations](https://skmtc.dev/reacherapp/apis/reacher-data-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/reacherapp/reacher-data-api/revisions/d4fe3e380424/schema)