Skip to main content
POST
/
v6
/
banks
/
transactions
/
query
Query transactions
curl --request POST \
  --url https://sandbox.tight.com/v6/banks/transactions/query \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "cursor": "<string>",
  "limit": 123,
  "sort": {
    "orderBy": "DATE",
    "direction": "ASC",
    "start": "<string>"
  },
  "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": {
      "expand": true,
      "id": {
        "in": [
          "<string>"
        ],
        "notIn": [
          "<string>"
        ]
      }
    },
    "vendor": {
      "expand": true,
      "id": {
        "in": [
          "<string>"
        ]
      }
    },
    "classSegments": {
      "expand": true,
      "id": {
        "in": [
          "<string>"
        ]
      }
    },
    "customer": {
      "expand": true,
      "id": {
        "in": [
          "<string>"
        ]
      }
    },
    "category": {
      "expand": true,
      "id": {
        "in": [
          "<string>"
        ]
      }
    },
    "glAccount": {
      "expand": true,
      "id": {
        "in": [
          "<string>"
        ]
      }
    },
    "rule": {
      "expand": true
    },
    "reconciliationMatch": {
      "expand": true,
      "id": {
        "equal": "<string>"
      }
    },
    "conversation": {
      "expand": true
    },
    "invoice": {
      "expand": true,
      "lineItems": {
        "expand": true
      }
    },
    "bill": {
      "expand": true,
      "lineItems": {
        "expand": true
      }
    },
    "payroll": {
      "expand": true,
      "lineItems": {
        "expand": true
      }
    }
  }
}
'
{
  "result": "SUCCESS",
  "data": [
    {
      "id": "btxn_158998869",
      "type": "EXPENSE",
      "date": "2025-06-26",
      "amount": -273479,
      "displayName": "Gusto",
      "description": "WITHDRAWAL ACH GUSTO TAXID: 4001",
      "notes": "June Payroll",
      "status": "ACTIVE",
      "reviewStatus": "RECONCILED",
      "apiName": "GUSTO",
      "iconUrl": "https://cdn.sandbox.tight.com/icons/integrations/gusto.png",
      "apiSourceId": "QeXqN7XJT50dwE4S19ZgVv4nnhLvjX7",
      "bankAccount": {
        "id": "bka_7542850",
        "name": "Business Checking",
        "displayName": "Business Checking *1687"
      },
      "classSegments": [
        {
          "id": "cls_593051",
          "label": {
            "id": "cll_4521",
            "name": "Region",
            "requiredness": "REQUIRED"
          },
          "name": "Mid Atlantic",
          "child": {
            "id": "cls_593054",
            "label": {
              "id": "cll_4522",
              "name": "Location",
              "requiredness": "NOT_REQUIRED"
            },
            "name": "Washington DC"
          }
        },
        {
          "id": "cls_594913",
          "label": {
            "id": "cll_4523",
            "name": "Job Code",
            "requiredness": "NOT_REQUIRED"
          },
          "name": "7050 – Interior Finishes"
        }
      ],
      "customer": {
        "id": "cus_4852707",
        "name": "Abigail Adams",
        "email": "abigail@tight.com"
      },
      "vendor": {
        "id": "vnd_28868401",
        "name": "Gusto"
      },
      "category": {
        "id": "ctg_58932890",
        "name": "Wages",
        "iconUrl": "https://cdn.sandbox.tight.com/icons/expenseCategories/payroll.svg"
      },
      "suggestedCategories": [
        {
          "id": "ctg_58932891"
        },
        {
          "id": "ctg_58932892"
        }
      ],
      "glAccount": {
        "id": "gla_38560327",
        "name": "Officer(s) Salaries and Wages",
        "accountNo": "60210",
        "type": "EXPENSE",
        "iconUrl": "https://cdn.sandbox.tight.com/icons/glAccountTypes/expense.png"
      },
      "invoiceItem": {
        "id": "<string>",
        "description": "<string>"
      },
      "reconciliationMatch": {
        "id": "<string>",
        "amount": 123,
        "date": "2025-06-28",
        "description": "<string>",
        "apiName": "UNIT",
        "apiInstitutionId": "<string>"
      },
      "matchingBankTransaction": {
        "id": "<string>",
        "amount": 123,
        "date": "2025-06-28",
        "description": "<string>",
        "apiName": "UNIT",
        "apiInstitutionId": "<string>"
      },
      "conversation": {
        "id": "<string>",
        "readStatus": "UNREAD"
      },
      "rule": {
        "id": "<string>",
        "transactionSource": "<string>"
      },
      "attachments": [
        {
          "id": "att_894321",
          "url": "https://files.example.com/attachment/receipt1.pdf",
          "fileName": "receipt1.pdf",
          "fileSize": "24.5 KB",
          "createdDateTime": "2026-03-26T15:37:21.111153145",
          "iconUrl": "https://cdn.sandbox.tight.com/icons/attachments/pdf.svg"
        },
        {
          "id": "att_894322",
          "url": "https://files.example.com/attachment/receipt2.pdf",
          "fileName": "receipt2.pdf",
          "fileSize": "156.2 KB",
          "createdDateTime": "2026-03-25T15:37:21.111215444",
          "iconUrl": "https://cdn.sandbox.tight.com/icons/attachments/pdf.svg"
        }
      ],
      "tax": {},
      "children": [],
      "customData": {
        "empty": false,
        "object": true,
        "nodeType": "OBJECT",
        "embeddedValue": false,
        "array": false,
        "null": false,
        "missingNode": false,
        "valueNode": false,
        "container": true,
        "string": false,
        "float": false,
        "number": false,
        "pojo": false,
        "integralNumber": false,
        "floatingPointNumber": false,
        "short": false,
        "int": false,
        "long": false,
        "double": false,
        "bigDecimal": false,
        "bigInteger": false,
        "textual": false,
        "boolean": false,
        "binary": false
      }
    }
  ],
  "cursor": {
    "after": "<string>",
    "before": "<string>"
  }
}

Authorizations

Authorization
string
header
required

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

Body

application/json
cursor
string | null

Cursor from the previous paginated response

limit
integer<int32>

Page size, i.e. number of items to return per page

Required range: x <= 250
sort
object

Sort order for the items in the response.

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.

cursor
object

Cursor to be used in your subsequent paginated request. Only populated if there are more pages available.