list_all_orders
Read-onlyIdempotent
Fetch all e-commerce orders, filterable by connection ID, customer, email, state, and external date, with sorting and pagination.
Instructions
🟢 READ-ONLY · Ecom Orders · GET /ecomOrders
List all orders
Fetches data. Makes no changes to your ActiveCampaign account.
List all existing e-commerce order resources.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Number of results per page (ActiveCampaign default 20, max 100). | |
| offset | No | Zero-based offset into the result set for pagination. | |
| orders | No | Sort order as an object, e.g. {"email":"ASC"} → orders[email]=ASC. | |
| filters | No | Field filters as an object, e.g. {"name":"ecom"} → filters[name]=ecom. | |
| orders_email | No | Order by email. Accepted values are ASC or DESC. Sent to ActiveCampaign as "orders[email]". | |
| orders_state | No | Order by state. Accepted values are ASC or DESC. Sent to ActiveCampaign as "orders[state]". | |
| filters_email | No | Filter by the customer email address. Sent to ActiveCampaign as "filters[email]". | |
| filters_state | No | Filter by the state of the order. 0 = Pending, 1 = Completed, 2 = Abandoned, 3 = Recovered, 4 = Waiting (Customer checked out but payment is not yet completed) Sent to ActiveCampaign as "filters[state]". | |
| orders_customerid | No | Order by customer ID. Accepted values are ASC or DESC. Sent to ActiveCampaign as "orders[customerid]". | |
| orders_externalid | No | Order by external ID. Accepted values are ASC or DESC. Sent to ActiveCampaign as "orders[externalid]". | |
| filters_customerid | No | Filter by the customer id Sent to ActiveCampaign as "filters[customerid]". | |
| filters_externalid | No | Filter by the external id of the order. Sent to ActiveCampaign as "filters[externalid]". | |
| orders_connectionid | No | Order by connection ID. Accepted values are ASC or DESC. Sent to ActiveCampaign as "orders[connectionid]". | |
| filters_connectionid | No | Filter by the connection id. Must be greater than 0. Sent to ActiveCampaign as "filters[connectionid]". | |
| orders_externalcheckoutid | No | Order by external checkout ID. Accepted values are ASC or DESC. Sent to ActiveCampaign as "orders[externalcheckoutid]". | |
| filters_externalcheckoutid | No | Filter by the external checkout id Sent to ActiveCampaign as "filters[externalcheckoutid]". | |
| orders_external_created_date | No | Order by external created date. Accepted values are ASC or DESC. Sent to ActiveCampaign as "orders[external_created_date]". | |
| filters_external_created_date | No | Filter by the external created date Sent to ActiveCampaign as "filters[external_created_date]". |