Skip to main content
POST
/
graphql#ListReportQueries
List report queries
curl --request POST \
  --url 'https://clarus-api.com/graphql#ListReportQueries' \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --header 'X-Clarus-Subdomain: <api-key>' \
  --data '
{
  "query": "query($filter: ReportQueryFilterType) { report_queries { all(filter: $filter) { edges { node { id name description graphql created_at updated_at } } } } }"
}
'
{
  "data": {
    "report_queries": {
      "all": {
        "edges": [
          {
            "node": {
              "id": "1",
              "name": "Stock Balance Report",
              "description": "Shows current stock balances by location",
              "graphql": "query { stock_balances { all { edges { node { id } } } } }",
              "created_at": "2026-01-10T10:00:00Z",
              "updated_at": "2026-01-10T10:00:00Z"
            }
          }
        ]
      }
    }
  }
}

​
Query Structure

query($filter: ReportQueryFilterType) {
  report_queries {
    all(filter: $filter) {
      edges {
        node {
          id
          name
          description
          graphql
          created_at
          updated_at
        }
      }
    }
  }
}

​
Filter Argument

All filters are passed inside the filter argument. Each filter field accepts an input object with operators: 
{
  "filter": {
    "name": {
      "ilike": "stock"
    }
  }
}

​
Available Filters

FilterInput TypeOperatorsDescription
nameStringInputTypeeq, ilike, like, in, betweenReport query name
descriptionStringInputTypeeq, ilike, like, in, betweenReport query description

​
Filter Operators

Input TypeOperators
StringInputTypeeq (exact), ilike (case-insensitive partial), like (case-sensitive partial), in (array match), between (range)
IntegerInputTypeeq, gt, gteq, lt, lteq, between
DatetimeInputTypeeq, from, to, between
BooleanInputTypeeq (required)
IdInputTypeeq, gt, gteq, lt, lteq, in, filled
More fields and filters available via GraphQL introspection.

Authorizations

​
Authorization
string
header
required

OAuth 2.0 authentication. Use the client credentials or authorization code flow to obtain an access token.

​
X-Clarus-Subdomain
string
header
required

The subdomain/tenant name identifying which tenant's data to access. Required for all API requests.

Body

application/json
​
query
string<textarea>
required

GraphQL query string

Example:

"query($filter: ReportQueryFilterType) { report_queries { all(filter: $filter) { edges { node { id name description graphql created_at updated_at } } } } }"

​
variables
object

Query variables including the filter object

Example:
{
  "filter": { "name": { "ilike": "stock" } }
}

Response

Successful GraphQL response

​
data
object

Query result data

​
errors
object[]

GraphQL errors, if any