Xero Accounting Endpoint: BalanceSheetTable

Overview

The Xero BalanceSheetTable endpoint provides closing balance sheet values as at a given date.

Note this endpoint is an alternate format of the BalanceSheet endpoint. It provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.

It is a function that accepts a series of parameters.

Parameters

The BalanceSheetTable endpoint is a function that accepts the following parameters.

Date: A date field that determines the date for which to produce values.; If omitted, it will use the last date of the last calendar month.

PaymentsOnly: A true/false field that determines if only payments are included.; If omitted, it will be set to False.

StandardLayout: A true/false field that determines if the values are produced only for accounts that are in the accounts endpoint.; If omitted, it will be set to True.

Fields

The following fields are available for the BalanceSheet endpoint.

DataFileID: A guid field that provides the id of the xero data file as setup in OdataLink.

DataFileName: A text field provides the name of the xero data file as setup in OdataLink.

DataFileCode: A text field provides the code of the xero data file as setup in OdataLink.

Date: A date field that indicates the date used to produce the values.; This will match the Date entered as parameter.

PaymentsOnly: A true/false field that indicates if only payments are included.; This will match the PaymentsOnly entered as parameter.

StandardLayout: A table field that indicates if values are produced only for accounts that are in the accounts endpoint.; This will match the StandardLayout entered as parameter.

LineType

A text field that indicates the type of line.

Possible values are:

Header: Indicates the row contains a header.
Detail: Indicates the row contains the value of a given account.
Total: Indicates the row contains a calculated value.

AccountID: A GUID field that provides the id of the account.; This field can be used to link to the Accounts endpoints.; This field will be set to null for rows whose LineType is not set to Detail.