---
title: "Find products in the eCommerce system, using the provided CEQL search expression. The search expression in CEQL is the WHERE clause in a typical SQL query, but without the WHERE keyword.  If no search expression is provided, all records will be retrieved"
method: GET
path: "/products"
tags: ["products"]
---

# Find products in the eCommerce system, using the provided CEQL search expression. The search expression in CEQL is the WHERE clause in a typical SQL query, but without the WHERE keyword.  If no search expression is provided, all records will be retrieved

`GET /products`

## Query parameters

- `where` string
- `pageSize` integer
- `nextPage` string
- `fields` string

## Headers

- `Authorization` string, required

## Response `200`

OK - Everything worked as expected

## Other responses

- `400` — Bad Request - Often due to a missing request parameter
- `401` — Unauthorized - An invalid element token, user secret and/or org secret provided
- `403` — Forbidden - Access to the resource by the provider is forbidden
- `404` — Not found - The requested resource is not found
- `405` — Method not allowed - Incorrect HTTP verb used, e.g., GET used when POST expected
- `406` — Not acceptable - The response content type does not match the 'Accept' header value
- `409` — Conflict - If a resource being created already exists
- `415` — Unsupported media type - The server cannot handle the requested Content-Type
- `500` — Server error - Something went wrong on the Cloud Elements server
- `502` — Provider server error - Something went wrong on the Provider or Endpoint's server

---

[API](https://skmtc.net/cloud-elements/apis/ecwid.md) · [All operations](https://skmtc.net/cloud-elements/apis/ecwid/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/cloud-elements/ecwid/versions/6c2a6ade2a5b/schema)