---
title: "Query and filter orders with various criteria"
method: POST
path: "/api/gpt/query_orders"
---

# Query and filter orders with various criteria

`POST /api/gpt/query_orders`

## Request

- Base URL: `https://datapulse.app`
- URL: `https://datapulse.app/api/gpt/query_orders`
- Auth: HTTP bearer

## Request body

- object
  - `startDate` string
  - `endDate` string
  - `status` 'paid' | 'pending' | 'refunded' | 'partially_refunded'
  - `minTotal` number
  - `maxTotal` number
  - `limit` integer
  - `offset` integer
  - `sortBy` 'processedAt' | 'totalPrice'
  - `sortOrder` 'asc' | 'desc'

## Response `200`

Order list

---

[API](https://skmtc.dev/ask-ai-data-connector/apis/ask-ai-data-connector-analytics-api.md) · [All operations](https://skmtc.dev/ask-ai-data-connector/apis/ask-ai-data-connector-analytics-api/llms.txt) · [OpenAPI document](https://skmtc.dev/ask-ai-data-connector/apis/ask-ai-data-connector-analytics-api/revisions/090956a39888?raw)