Productsup
Filtering

Group By

Use groupBy to return unique values for a specific column.

Group by filtering

The parameter groupBy allows for simple filtering on values per column. It will return unique values for the column on which is grouped.

URL Example

/sites/{siteId}/channels/{channelId}/destinations/{destinationId}/products?groupBy=countryCode

SQL Equivalent

SELECT * FROM data GROUP BY countryCode LIMIT 100

Demo Request

curl --location \
--request GET 'https://export-api.productsup.com/sites/522103/channels/302481/destinations/154110/products?groupBy=countryCode' \
--header 'X-EA-Auth-Token: kx0g3jwi0121jwj12j1x'

Sample JSON Response

[
    {
        "color": "Aqua",
        "countryCode": "AD",
        "email": "romaguera.stephon@hotmail.com",
        "id": "956d0602a040bb681c73aa31c2d2eb80",
        "name": "Lupe Dooley"
    },
    {
        "color": "Orchid",
        "countryCode": "AE",
        "email": "forest.waters@hotmail.com",
        "id": "78a10711c1a908cd8e6cfd8a30cecfbf",
        "name": "Prof. Dejah Padberg"
    },
    {
        "color": "Gray",
        "countryCode": "AF",
        "email": "mthiel@hotmail.com",
        "id": "b429cd881d508952e1d2547e4442ab28",
        "name": "Anissa Rogahn"
    },
    {
        "color": "Gold",
        "countryCode": "AG",
        "email": "schowalter.sydni@yost.info",
        "id": "510d7590932074bd32275933037f01d3",
        "name": "Obie Adams"
    },
    ...
]

How is this guide?

Pagination

Paginate over the total product set using limit and offset parameters.

Simple Filter

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

On this page

Group by filtering
URL Example
SQL Equivalent
Demo Request