Query

metricsAccountInsightMetric[]

Possible values: [account:balance:sum, account:balance:min, account:balance:max, account:balance:range, account:balance:oldest, account:balance:latest, account:balance:average, account:transaction:count, account:transaction:amount:sum, account:transaction:amount:min, account:transaction:amount:max, account:transaction:amount:range, account:transaction:amount:oldest, account:transaction:amount:latest, account:transaction:amount:average, account:transaction:amount:average:day, account:transaction:amount:average:week, account:transaction:amount:average:month, account:transaction:amount:average:year, account:transaction:created:range:day, account:transaction:created:range:week, account:transaction:created:range:month, account:transaction:created:range:year, account:transaction:created:oldest, account:transaction:created:latest]

dimensionsAccountInsightDimension[]

Possible values: [account:id, account:name, account:nickname, account:number, account:type, account:subtype, account:currency, account:connection:id, account:dataholder:id, account:transaction:id, account:transaction:amount, account:transaction:external_id, account:transaction:status, account:transaction:type, account:transaction:subtype, account:transaction:description, account:transaction:code, account:transaction:created, account:transaction:created:date, account:transaction:created:day, account:transaction:created:week, account:transaction:created:month, account:transaction:created:year, account:transaction:currency, account:transaction:third-party:name, account:transaction:business:category, account:transaction:business:subcategory, account:transaction:budget:category, account:transaction:budget:subcategory, account:transaction:frequency]

metricFilterClauses object[]

Array [

filters object[]

Array [

metricAccountInsightMetricFilter

Possible values: [account:balance, account:balance:sum, account:balance:range, account:transaction:amount, account:transaction:amount:sum, account:transaction:amount:range]

operatorOperator

Possible values: [BETWEEN, GREATER_THAN, LESS_THAN, NOT_EQUALS, EQUALS]

valuenumber

maxnumber

minnumber

]

]

dimensionFilterClauses object[]

Array [

filters object[]

Array [

dimensionAccountInsightDimension

Possible values: [account:id, account:name, account:nickname, account:number, account:type, account:subtype, account:currency, account:connection:id, account:dataholder:id, account:transaction:id, account:transaction:amount, account:transaction:external_id, account:transaction:status, account:transaction:type, account:transaction:subtype, account:transaction:description, account:transaction:code, account:transaction:created, account:transaction:created:date, account:transaction:created:day, account:transaction:created:week, account:transaction:created:month, account:transaction:created:year, account:transaction:currency, account:transaction:third-party:name, account:transaction:business:category, account:transaction:business:subcategory, account:transaction:budget:category, account:transaction:budget:subcategory, account:transaction:frequency]

operatorOperator

Possible values: [BETWEEN, GREATER_THAN, LESS_THAN, NOT_EQUALS, EQUALS]

valuestring

maxstring

minstring

quantityinteger

quantityDemarcationDemarcation

Possible values: [DAY, WEEK, MONTH, YEAR]

offsetinteger

offsetDemarcationDemarcation

Possible values: [DAY, WEEK, MONTH, YEAR]

]

]

orderBy object[]

Array [

fieldAccountInsightDimension

Possible values: [account:id, account:name, account:nickname, account:number, account:type, account:subtype, account:currency, account:connection:id, account:dataholder:id, account:transaction:id, account:transaction:amount, account:transaction:external_id, account:transaction:status, account:transaction:type, account:transaction:subtype, account:transaction:description, account:transaction:code, account:transaction:created, account:transaction:created:date, account:transaction:created:day, account:transaction:created:week, account:transaction:created:month, account:transaction:created:year, account:transaction:currency, account:transaction:third-party:name, account:transaction:business:category, account:transaction:business:subcategory, account:transaction:budget:category, account:transaction:budget:subcategory, account:transaction:frequency]

sortSort

Possible values: [ASC, DESC]

]

limitinteger

Possible values: >= 1

pageinteger

Possible values: >= 1

Query

{
  "metrics": [
    "account:balance:sum"
  ],
  "dimensions": [
    "account:id"
  ],
  "metricFilterClauses": [
    {
      "filters": [
        {
          "metric": "account:balance",
          "operator": "BETWEEN",
          "value": 0,
          "max": 0,
          "min": 0
        }
      ]
    }
  ],
  "dimensionFilterClauses": [
    {
      "filters": [
        {
          "dimension": "account:id",
          "operator": "BETWEEN",
          "value": "string",
          "max": "string",
          "min": "string",
          "quantity": 0,
          "quantityDemarcation": "DAY",
          "offset": 0,
          "offsetDemarcation": "DAY"
        }
      ]
    }
  ],
  "orderBy": [
    {
      "field": "account:id",
      "sort": "ASC"
    }
  ],
  "limit": 0,
  "page": 0
}