Filtering & sorting

"whereClause": {
  "_and": [
    { "status": { "_in": ["issued", "paid"] } },
    { "_or": [
      { "grand_total": { "amount": { "_gte": 1000 } } },
      { "issuer": { "name": { "_ilike": "%anthropic%" } } }
    ] },
    { "_not": { "deleted_at": { "_is_null": false } } }
  ]
}

// raw whereClause — invoices whose issuer is US-registered
"whereClause": { "issuer": { "registry_country": { "_eq": "US" } } }

// curated filters — identical result, type-gated
{ "field": "issuer.name", "operator": "contains", "value": "Anthropic" }

// invoices that have AT LEAST ONE line item over 100 units
"whereClause": { "invoice_items": { "_some": { "quantity": { "_gt": 100 } } } }

// invoices where EVERY line item is tax-exempt
"whereClause": { "invoice_items": { "_every": { "tax_rate": { "_eq": 0 } } } }

// invoices with NO matched bank transaction (unreconciled)
"whereClause": { "invoice_transactions": { "_none": {} } }

curl -X POST https://api.wellapp.ai/v1/records/query \
  -H "Authorization: Bearer $WELL_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "root": "invoices",
    "filters": [
      { "field": "status",            "operator": "in",  "value": ["issued","paid"], "conjunction": "and" },
      { "field": "issuer.name",       "operator": "contains", "value": "Anthropic" },
      { "field": "grand_total.amount","operator": "gte", "value": 1000 }
    ],
    "orderBy": { "field": "issued_at", "direction": "desc" },
    "limit": 50
  }'

// invoices, newest issuer first
"orderBy": { "field": "issuer.name", "direction": "asc" }
// -> Hasura order_by: { issuer: { name: asc } }