AccountingTransaction
Accounting Transactions

GET /accountingTransactions

Changed on

Gets an accounting transaction summary report for a business.

Request

  • Base URL
    https://api.railz.ai
  • Auth
    HTTP bearer

Query parameters

businessNamestring required
Example:Railz

Unique business name identifier.

serviceName'freshbooks' | 'quickbooks' | 'quickbooksDesktop' | 'xero' | 'oracleNetsuite' | 'sageBusinessCloud' | 'sageIntacct' | 'dynamicsBusinessCentral' | 'myob' | 'zohoBooks' required

Name of accounting service provider.

startDatestring

Date from which the report data begins in the format: YYYY-MM-DD.

endDatestring

Date from which the report data ends in the format: YYYY-MM-DD.

offsetnumber

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

limitnumber
Example:100

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

orderBystring

Response

countnumber required

Example response

{
  "meta": {
    "reportId": [
      "5fad8a342a88364234392fb5",
      "5fad8a342a88364234392fb6"
    ],
    "serviceName": "xero",
    "businessName": "Railz",
    "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": [
    {
      "postedDate": "2020-11-25",
      "type": "invoice",
      "isReconciled": true,
      "currencyRate": 1.13,
      "isSplitTransaction": true,
      "subTotal": 300.5,
      "taxAmount": 10.5,
      "totalAmount": 311,
      "memo": "Transaction reference",
      "sourceModifiedDate": "2021-03-09T10:18:29.985Z",
      "id": "1045",
      "isPosting": true,
      "transactionNumber": "INV-001",
      "entityRef": {
        "id": "233",
        "name": "Railz Inc."
      },
      "trackingCategoryRef": {
        "id": "4040",
        "name": "Region",
        "option": "East",
        "optionId": "40401"
      },
      "accountRef": {
        "id": "1334",
        "name": "Account Receivable",
        "section": "Assets",
        "subSection": "Current Assets",
        "group": "Cash And Cash Equivalents",
        "subGroup": "Cash And Cash Equivalents"
      },
      "currencyRef": {
        "id": "CAD",
        "name": "Canadian Dollar",
        "symbol": "\tUSD,CAD"
      }
    }
  ],
  "count": 1
}

Changes

    • info

      api tag AccountingTransaction added

    • breaking

      removed the enum value wave from the query request parameter serviceName

    • breaking

      the response property /// became optional for the status

    • breaking

      the response property /// became optional for the status

    • breaking

      the response property // became optional for the status

    • breaking

      the response property // became optional for the status

    • breaking

      the // response's property type changed from object to no type for status

    • breaking

      the // response's property type changed from object to no type for status

    • breaking

      the / response's property type changed from string to array for status

    • breaking

      the / response's property type changed from string to array for status

    • breaking

      removed the required property /// from the response with the status

    • breaking

      removed the required property /// from the response with the status

    • warning

      removed the optional property /// from the response with the status

    • warning

      removed the optional property /// from the response with the status

    • warning

      removed the optional property /// from the response with the status

    • warning

      removed the optional property /// from the response with the status

    • warning

      removed the optional property /// from the response with the status

    • warning

      removed the optional property /// from the response with the status

    • warning

      added the new dynamics365Finance enum value to the / response property for the response status

    • warning

      added the new dynamics365Finance enum value to the / response property for the response status

    • warning

      added the new dynamicsBusinessCentral enum value to the / response property for the response status

    • warning

      added the new dynamicsBusinessCentral enum value to the / response property for the response status

    • warning

      added the new freshbooks enum value to the / response property for the response status

    • warning

      added the new freshbooks enum value to the / response property for the response status

    • warning

      added the new myob enum value to the / response property for the response status

    • warning

      added the new myob enum value to the / response property for the response status

    • warning

      added the new oracleNetsuite enum value to the / response property for the response status

    • warning

      added the new oracleNetsuite enum value to the / response property for the response status

    • warning

      added the new quickbooks enum value to the / response property for the response status

    • warning

      added the new quickbooks enum value to the / response property for the response status

    • warning

      added the new quickbooksDesktop enum value to the / response property for the response status

    • warning

      added the new quickbooksDesktop enum value to the / response property for the response status

    • warning

      added the new sageBusinessCloud enum value to the / response property for the response status

    • warning

      added the new sageBusinessCloud enum value to the / response property for the response status

    • warning

      added the new sageIntacct enum value to the / response property for the response status

    • warning

      added the new sageIntacct enum value to the / response property for the response status

    • warning

      added the new wave enum value to the / response property for the response status

    • warning

      added the new wave enum value to the / response property for the response status

    • warning

      added the new xero enum value to the / response property for the response status

    • warning

      added the new xero enum value to the / response property for the response status

    • warning

      added the new zohoBooks enum value to the / response property for the response status

    • warning

      added the new zohoBooks enum value to the / response property for the response status

    • info

      added the new enum value myob to the query request parameter serviceName

    • info

      added the new enum value zohoBooks to the query request parameter serviceName

    • info

      added the optional property /// to the response with the status

    • info

      added the optional property /// to the response with the status

    • info

      added to the // response property allOf list for the response status

    • info

      added to the // response property allOf list for the response status

    • info

      response property data/items/trackingCategoryRef deprecated

    • info

      response property data/items/trackingCategoryRef deprecated