Productsup

Get all product data (legacy)

**Deprecated** — use `/sites/{siteId}/channels/{channelId}/destinations/{destinationId}/products` instead. **Authentication required**: `X-EA-Auth-Token` and `X-Destination-Id` headers.

GET
/{siteId}/{channelId}

Authorization

ApiKeyAuth DestinationId
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

X-Destination-Id<token>

Legacy only. Required when using the legacy /{siteId}/{channelId} routes. On v2 routes, the destination ID is part of the URL path and this header is not needed.

In: header

Path Parameters

siteId*integer

Site ID to query data from

channelId*integer

Channel ID for site-channel combination to query data from

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/12345/67890?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"
}