Productsup
Filtering

Simple Filter

Filter results on one or more values for a single column.

Simple filter by one column

The simple filter functionality allows filtering results on one or more values for a single column. It cannot be combined with the advanced filter, but the default filter parameters still apply.

URL Example

/sites/{siteId}/channels/{channelId}/destinations/{destinationId}/products/id/1,2,3

# Parameter description
/sites/{siteId}/channels/{channelId}/destinations/{destinationId}/products/{column}/{value}
/sites/{siteId}/channels/{channelId}/destinations/{destinationId}/products/{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/sites/522103/channels/302481/destinations/154110/products/id/32f1ce5593d13cb2a36cb57b943eb2b3,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"
    }
]

How is this guide?

Group By

Use groupBy to return unique values for a specific column.

Advanced Filter

Create complex filters with multiple criteria, limit, offset, and order.

On this page

Simple filter by one column
URL Example
SQL Equivalent
Demo Request