Productsup

Get all product data (v2 — recommended)

Retrieves all product data for the specified site, channel, and destination. Destination ID is part of the URL — no `X-Destination-Id` header required. **Authentication required**: `X-EA-Auth-Token` header. **Response format**: controlled by the `Accept` header. - `Accept: application/vnd.api+json` → JSON:API envelope with `data` and `meta` - `Accept: application/json` (or omitted) → legacy raw array

GET
/sites/{siteId}/channels/{channelId}/destinations/{destinationId}/products

Authorization

ApiKeyAuth
X-EA-Auth-Token<token>

Authentication token configured in the destination settings. Must match api_system_integrator_auth_token value in pds_destination_settings table. Token must consist only of alphanumeric characters, hyphens (-), and underscores (_).

In: header

Path Parameters

siteId*integer

Site ID to query data from

channelId*integer

Channel ID for site-channel combination to query data from

destinationId*integer

Destination ID to authenticate and query data for

Query Parameters

limit?integer

Limit the total number of products returned (equivalent to LIMIT in SQL)

Default100
Range1 <= value
offset?integer

Offset into the result set (equivalent to OFFSET in SQL)

Default0
Range0 <= value
orderBy?string

Sort results by the specified column (equivalent to ORDER BY in SQL)

groupBy?string

Group results by a certain column (equivalent to GROUP BY in SQL)

mode?string

Top-level logical operator applied across all filter groups

Default"AND"
Value in"AND" | "OR"
filters?array<>

Advanced filter groups. Encoded as PHP/Symfony bracket notation in the query string.

Example (price > 100 AND stock > 0):

filters[0][criteria][0][column]=price&filters[0][criteria][0][operator]=%3E&filters[0][criteria][0][value]=100
&filters[0][criteria][1][column]=stock&filters[0][criteria][1][operator]=%3E&filters[0][criteria][1][value]=0
&filters[0][mode]=AND

Response Body

curl -X GET "https://export-api.productsup.com/sites/12345/channels/67890/destinations/154110/products?limit=100&offset=0&orderBy=price&groupBy=category&mode=AND"
[
  {
    "id": 1,
    "name": "My Product Name",
    "price": 29.99,
    "color": "Blue",
    "category": "Electronics"
  }
]

{
  "error": "Authentication token is required"
}

{
  "error": "Token is not authorized for this destination"
}

{
  "message": "No exported data"
}