Query records

Use POST /v2/prism/{teamId}/{objectType}/query for typed filters and explicit field selection. Read metadata first so your query uses property slugs that exist in the workspace.

curl --request POST \
  "https://developers.micro.so/v2/prism/${MICRO_TEAM_ID}/contact/query" \
  --header "content-type: application/json" \
  --header "x-api-key: ${MICRO_API_KEY}" \
  --data '{
    "query": {
      "select": ["full_name", "email", "organization.name", "last_updated_at"],
      "filter": [{"email": {"exists": true}}],
      "sort": [{"last_updated_at": "desc"}],
      "combinator": "AND",
      "limit": 25
    }
  }'

select limits returned properties; top-level id is always included. Dot notation selects through relationships. Each filter entry maps a property slug to a comparator and value. Multiple entries follow combinator. Sort entries map a slug to asc or desc. Check property metadata before relying on a slug or comparator. The maximum page size is 50.

For simple lists, GET /v2/prism/{teamId}/{objectType} accepts select, sort, limit, cursor, and include_total. Prefer POST queries for typed comparisons and complex filters.

See Pagination before processing more than one page.