latestOpenAPI 3.0.02026-08-10233809957.8 KB

5cdfae3fa1fa

Accounting Transactions2

Aging Reports4

Attachments4

Balance Sheets2

Bank Accounts1

Bank Accounts (Accounting)2

Bank Accounts (Banking)1

Bank Assets (Banking)1

Bank Reconciliation (Accuracy Score)2

Bank Transactions2

Bank Transactions (Accounting)5

Bank Transactions (Banking)1

Bank Transfers2

Bank Transfers (Accounting)2

Benchmarking2

Bill Credit Notes4

Bill Payment Requests3

Bill Payments6

Bills7

Budgets1

Business Valuations2

Businesses12

Cashflow Statements2

Chart of Accounts7

Commerce Disputes2

Commerce Orders2

Commerce Products2

Commerce Transactions2

Connections4

Contacts1

Credit Ratings2

Credit Scores2

Customers10

Data9

Deposits4

Estimates4

Expenses2

File Upload1

Financial Benchmarking1

Financial Forecasts2

Financial Fraud Risk2

Financial Ratios2

Financial Statements3

Income Statements2

Inventory6

Invoice Credit Notes4

Invoice Payments6

Invoices6

Journal Entries8

Journals3

Payment Methods1

Payroll Transactions1

Portfolio Metrics2

Probability of Default2

Purchase Orders4

Refunds4

Reports10

Sandbox2

Tax Authority1

Tax Benchmarking1

Tax Rates3

Tracking Categories4

Trial Balances2

Vendors11

Visualizations16

Bank Transactions (Accounting)

List Bank Transactions

Supported for:

xero myob zohoBooks

get/v2/accounting/bankTransactions

Query parameters

connectionUuidstring required

Unique connection identifier.

startDatestring

The start date of the Transaction report frequency in the format: YYYY-MM-DD.

endDatestring

The end date of the Transaction report frequency in the format: YYYY-MM-DD.

offsetnumber

The offset is the position in the dataset of a particular record.

limitnumber

This is the size of the results set you would like (default: 100).

orderBystring

Response

Example response

{
  "meta": {
    "connectionUuid": "CON-396d5daa-26b2-4979-89b6-cafb2c298155",
    "businessName": "Railz",
    "serviceName": "xero",
    "reportId": [
      "5fad8a342a88364234392fb5",
      "5fad8a342a88364234392fb6"
    ],
    "startDate": "2020-11-25T01:02:03Z",
    "endDate": "2020-11-30T01:02:03Z",
    "createdAt": "2020-11-25T01:02:03Z",
    "updatedAt": "2020-11-30T01:02:03Z"
  },
  "data": [
    {
      "id": "25",
      "postedDate": "2020-11-30T01:02:03Z",
      "transactionType": "payment",
      "bankAccountRef": {
        "id": "145",
        "name": "Example account"
      },
      "currency": "CAD",
      "currencyRate": 1.13,
      "totalAmount": 322,
      "lines": {
        "id": "8a3fdcc9-83eb-4fdd-83e0-52ec1b40b072",
        "description": "Railz store",
        "taxRateRef": {
          "id": "12"
        },
        "taxAmount": 20.5,
        "amount": 322,
        "accountRef": {
          "id": "145",
          "name": "Example account"
        },
        "trackingCategoryRefs": [
          {
            "id": "4040",
            "name": "Region",
            "type": "class"
          }
        ]
      },
      "memo": "Example memo.",
      "sourceModifiedDate": "2021-03-09T10:18:29.985Z",
      "entityRef": {
        "type": "customer",
        "id": "130",
        "name": "ABC Inc"
      },
      "transactionDirection": "incoming"
    }
  ]
}