Skip to main content
POST
/
v6
/
banks
/
transactions
/
query
/
summary
Query transaction summary
curl --request POST \
  --url https://sandbox.tight.com/v6/banks/transactions/query/summary \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "groupBy": "REVIEW_STATUS",
  "filter": {
    "search": "<string>",
    "date": {
      "equal": "2023-12-25",
      "notEqual": "2023-12-25",
      "greaterThan": "2023-12-25",
      "greaterThanEqual": "2023-12-25",
      "lessThan": "2023-12-25",
      "lessThanEqual": "2023-12-25"
    },
    "amount": {
      "equal": 123,
      "notEqual": 123,
      "greaterThan": 123,
      "greaterThanEqual": 123,
      "lessThan": 123,
      "lessThanEqual": 123
    },
    "description": {
      "equal": "<string>",
      "notEqual": "<string>",
      "greaterThan": "<string>",
      "greaterThanEqual": "<string>",
      "lessThan": "<string>",
      "lessThanEqual": "<string>",
      "contain": "<string>"
    },
    "notes": {
      "equal": "<string>",
      "notEqual": "<string>",
      "greaterThan": "<string>",
      "greaterThanEqual": "<string>",
      "lessThan": "<string>",
      "lessThanEqual": "<string>",
      "contain": "<string>"
    },
    "status": {
      "in": [
        "ACTIVE"
      ],
      "notIn": [
        "ACTIVE"
      ],
      "equal": "ACTIVE",
      "notEqual": "ACTIVE",
      "greaterThan": "ACTIVE",
      "greaterThanEqual": "ACTIVE",
      "lessThan": "ACTIVE",
      "lessThanEqual": "ACTIVE"
    },
    "reviewStatus": {
      "in": [
        "RECONCILIATION_DISCREPANCY"
      ],
      "notIn": [
        "RECONCILIATION_DISCREPANCY"
      ],
      "equal": "RECONCILIATION_DISCREPANCY",
      "notEqual": "RECONCILIATION_DISCREPANCY",
      "greaterThan": "RECONCILIATION_DISCREPANCY",
      "greaterThanEqual": "RECONCILIATION_DISCREPANCY",
      "lessThan": "RECONCILIATION_DISCREPANCY",
      "lessThanEqual": "RECONCILIATION_DISCREPANCY"
    },
    "type": {
      "in": [
        "EXPENSE"
      ],
      "notIn": [
        "EXPENSE"
      ]
    },
    "bankAccount": {
      "id": {
        "in": [
          "<string>"
        ],
        "notIn": [
          "<string>"
        ]
      }
    },
    "vendor": {
      "id": {
        "in": [
          "<string>"
        ]
      }
    },
    "classSegments": {
      "id": {
        "in": [
          "<string>"
        ]
      }
    },
    "customer": {
      "id": {
        "in": [
          "<string>"
        ]
      }
    },
    "category": {
      "id": {
        "in": [
          "<string>"
        ]
      }
    },
    "glAccount": {
      "id": {
        "in": [
          "<string>"
        ]
      }
    }
  }
}
'
{
  "result": "SUCCESS",
  "data": {
    "count": 123,
    "total": 123,
    "data": [
      {
        "value": "<string>",
        "displayName": "<string>",
        "count": 123,
        "total": 123
      }
    ]
  }
}

Authorizations

Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, see Authentication for more detail.

Body

application/json
groupBy
enum<string>
required

Groupings for items in the response.

Available options:
REVIEW_STATUS,
STATUS,
TYPE
filter
object

Filter for items in the response.

Response

Success

result
enum<string>

The result of the action performed.

Available options:
SUCCESS,
FAILURE
data
object

The data generated by the action performed.