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
}
]
}
}Query transaction summary for the authenticated user
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
}
]
}
}Bearer authentication header of the form Bearer <token>, see Authentication for more detail.