Querying

All data in Micro is queried through a single endpoint:

POST /v2/prism/query/{teamId}/{objectType}

The request body contains a query object that describes what to fetch.

Select

select is required. Pass an array of property slugs to return.

{
  "query": {
    "select": ["full_name", "email", "title"]
  }
}

Use dot notation to traverse relationships:

{
  "query": {
    "select": ["full_name", "company.name", "company.primary_domain"]
  }
}

Filter

filter is an array of conditions. Each condition is { slug: { operator: value } }.

{
  "query": {
    "select": ["full_name", "email"],
    "filter": [
      { "labels": { "in": ["investor"] } },
      { "last_interaction_date": { ">=": "2024-01-01" } }
    ]
  }
}

Operators

Operator	Types	Description
=	all	Exact match
!=	all	Not equal
< > <= >=	number, date	Comparison
in	string, select	Value is in the array
not_in	string, select	Value is not in the array
begins_with	string	Starts with value
ends_with	string	Ends with value
like_regex	string	Matches regex pattern
not_contains	string	Does not contain value
exists	any	Field has a value
not_exists	any	Field has no value

Combining filters

By default filters are combined with AND. Use combinator to switch to OR:

{
  "query": {
    "select": ["full_name"],
    "filter": [
      { "labels": { "in": ["investor"] } },
      { "labels": { "in": ["founder"] } }
    ],
    "combinator": "OR"
  }
}

Sort

sort is an array of { slug: direction } objects. Earlier items in the array take priority.

{
  "query": {
    "select": ["full_name", "last_interaction_date"],
    "sort": [
      { "last_interaction_date": "desc" },
      { "full_name": "asc" }
    ]
  }
}

Pagination

Use limit to set page size (default: 25, max: 250) and page to paginate.

{
  "query": {
    "select": ["full_name"],
    "limit": 100,
    "page": 2
  }
}

The response is an array. Use page to fetch the next set of results:

[
  {
    "id": "c1a2b3c4-...",
    "properties": {
      "full_name": "Sarah Chen",
      "email": "sarah@example.com"
    }
  }
]

App context

Pass crm_id to scope results to a specific CRM app (e.g. your fundraising pipeline vs. your investor network):

{
  "query": {
    "select": ["full_name", "stage"],
    "crm_id": "your-crm-uuid"
  }
}