Simple Filter

Simple filter by one column

The simple filter lets you filter results by one or more values for a single column, using {column}/{value} URL path segments. It cannot be combined with the advanced filter, but the default filter parameters still apply.

This shorthand is only available on the legacy route (/{siteId}/{channelId}/{column}/{value}), which is deprecated and requires an X-Destination-Id header. The v2 route (/sites/{siteId}/channels/{channelId}/destinations/{destinationId}/products) has no path-segment equivalent — for the same result on v2, use the advanced filter with the IN operator instead.

URL example

/{siteId}/{channelId}/{column}/{value}
/{siteId}/{channelId}/{column}/{value1},{value2},{value3},{valueN}

SQL equivalent

SELECT * FROM data WHERE id IN [1,2,3] LIMIT 100

Demo request

curl --location \
--request GET 'https://export-api.productsup.com/522103/302481/id/32f1ce5593d13cb2a36cb57b943eb2b3,4dc968a1445369fcdfe3d74e7aa045ee' \
--header 'X-EA-Auth-Token: kx0g3jwi0121jwj12j1x' \
--header 'X-Destination-Id: 154110'

v2 equivalent

curl --location -g \
--request GET 'https://export-api.productsup.com/sites/522103/channels/302481/destinations/154110/products?filters[0][criteria][0][column]=id&filters[0][criteria][0][operator]=IN&filters[0][criteria][0][value][]=32f1ce5593d13cb2a36cb57b943eb2b3&filters[0][criteria][0][value][]=4dc968a1445369fcdfe3d74e7aa045ee' \
--header 'X-EA-Auth-Token: kx0g3jwi0121jwj12j1x'

Sample JSON response

[
    {
        "color": "White",
        "countryCode": "MN",
        "email": "dallin80@hayes.com",
        "id": "32f1ce5593d13cb2a36cb57b943eb2b3",
        "name": "Reymundo Marvin Jr."
    },
    {
        "color": "DarkRed",
        "countryCode": "SZ",
        "email": "gwen.botsford@kiehn.biz",
        "id": "4dc968a1445369fcdfe3d74e7aa045ee",
        "name": "Prof. Elna Crist"
    }
]