Productsup

Get filtered product data (legacy)

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

GET
/{siteId}/{channelId}/{column}/{value}

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

column*string

Column name to filter on

value*string

A single string that may contain comma-separated values. The server splits on commas and combines the values with OR (equivalent to an SQL IN clause).

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)

Response Body

curl -X GET "https://export-api.productsup.com/12345/67890/color/blue,red,green?limit=100&offset=0&orderBy=price&groupBy=category"
[
  {
    "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"
}