Xero · Example Payload
Xero Getreporttrialbalance Example
AccountingBank FeedsFinanceFinancial ServicesInvoicingPayrollSmall Business
Xero Getreporttrialbalance Example is an example object payload from Xero, with 6 top-level fields. It illustrates the shape of data this provider's APIs accept or return.
Top-level fields
operationIdmethodpathsummaryrequestExamplesresponseExamples
Example Payload
{
"operationId": "getReportTrialBalance",
"method": "GET",
"path": "/Reports/TrialBalance",
"summary": "Xero Retrieves report for trial balance",
"requestExamples": [],
"responseExamples": [
{
"status": "200",
"contentType": "application/json",
"example": {
"Id": "0b3ee35e-b97c-4b3c-b7e2-9a465233e329",
"Status": "OK",
"ProviderName": "Java Public Example",
"DateTimeUTC": "/Date(1556129558740)/",
"Reports": [
{
"ReportName": "Trial Balance",
"ReportType": "TrialBalance",
"ReportTitles": [
"Trial Balance",
"Dev Evangelist - Sid Test 1 (US-2016-06)",
"As at 24 April 2019"
],
"ReportDate": "24 April 2019",
"UpdatedDateUTC": "/Date(1556129558724)/",
"Fields": [],
"Rows": [
{
"RowType": "Header",
"Cells": [
{
"Value": "Account"
},
{
"Value": "Debit"
},
{
"Value": "Credit"
},
{
"Value": "YTD Debit"
},
{
"Value": "YTD Credit"
}
]
},
{
"RowType": "Section",
"Title": "Revenue",
"Rows": [
{
"RowType": "Row",
"Cells": [
{
"Value": "Big Expense (002)",
"Attributes": [
{
"Value": "da962997-a8bd-4dff-9616-01cdc199283f",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "da962997-a8bd-4dff-9616-01cdc199283f",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "da962997-a8bd-4dff-9616-01cdc199283f",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "da962997-a8bd-4dff-9616-01cdc199283f",
"Id": "account"
}
]
},
{
"Value": "80.00",
"Attributes": [
{
"Value": "da962997-a8bd-4dff-9616-01cdc199283f",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "Sales (400)",
"Attributes": [
{
"Value": "02439bca-5fdc-4b62-b281-0bdf9f16fd5b",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "02439bca-5fdc-4b62-b281-0bdf9f16fd5b",
"Id": "account"
}
]
},
{
"Value": "200.00",
"Attributes": [
{
"Value": "02439bca-5fdc-4b62-b281-0bdf9f16fd5b",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "02439bca-5fdc-4b62-b281-0bdf9f16fd5b",
"Id": "account"
}
]
},
{
"Value": "1020.22",
"Attributes": [
{
"Value": "02439bca-5fdc-4b62-b281-0bdf9f16fd5b",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "Sales-35325 (1302)",
"Attributes": [
{
"Value": "3f50db14-1fe6-450b-bfe8-b2d894f18c62",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "3f50db14-1fe6-450b-bfe8-b2d894f18c62",
"Id": "account"
}
]
},
{
"Value": "1000.00",
"Attributes": [
{
"Value": "3f50db14-1fe6-450b-bfe8-b2d894f18c62",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "3f50db14-1fe6-450b-bfe8-b2d894f18c62",
"Id": "account"
}
]
},
{
"Value": "1000.00",
"Attributes": [
{
"Value": "3f50db14-1fe6-450b-bfe8-b2d894f18c62",
"Id": "account"
}
]
}
]
}
]
},
{
"RowType": "Section",
"Title": "Expenses",
"Rows": [
{
"RowType": "Row",
"Cells": [
{
"Value": "Foobar14043 (123)",
"Attributes": [
{
"Value": "d1602f69-f900-4616-8d34-90af393fa368",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "d1602f69-f900-4616-8d34-90af393fa368",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "d1602f69-f900-4616-8d34-90af393fa368",
"Id": "account"
}
]
},
{
"Value": "40.00",
"Attributes": [
{
"Value": "d1602f69-f900-4616-8d34-90af393fa368",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "d1602f69-f900-4616-8d34-90af393fa368",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "MyExp51937 (1231239)",
"Attributes": [
{
"Value": "90f10e0a-a043-46fe-b87e-630e9a951dae",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "90f10e0a-a043-46fe-b87e-630e9a951dae",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "90f10e0a-a043-46fe-b87e-630e9a951dae",
"Id": "account"
}
]
},
{
"Value": "80.00",
"Attributes": [
{
"Value": "90f10e0a-a043-46fe-b87e-630e9a951dae",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "90f10e0a-a043-46fe-b87e-630e9a951dae",
"Id": "account"
}
]
}
]
}
]
},
{
"RowType": "Section",
"Title": "Assets",
"Rows": [
{
"RowType": "Row",
"Cells": [
{
"Value": "Accounts Receivable (120)",
"Attributes": [
{
"Value": "31ae5bb4-611c-4f89-a369-86e4d56e90b6",
"Id": "account"
}
]
},
{
"Value": "1190.00",
"Attributes": [
{
"Value": "31ae5bb4-611c-4f89-a369-86e4d56e90b6",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "31ae5bb4-611c-4f89-a369-86e4d56e90b6",
"Id": "account"
}
]
},
{
"Value": "36555.04",
"Attributes": [
{
"Value": "31ae5bb4-611c-4f89-a369-86e4d56e90b6",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "31ae5bb4-611c-4f89-a369-86e4d56e90b6",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "Business Wells Fargo (088)",
"Attributes": [
{
"Value": "6f7594f2-f059-4d56-9e67-47ac9733bfe9",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "6f7594f2-f059-4d56-9e67-47ac9733bfe9",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "6f7594f2-f059-4d56-9e67-47ac9733bfe9",
"Id": "account"
}
]
},
{
"Value": "7639.04",
"Attributes": [
{
"Value": "6f7594f2-f059-4d56-9e67-47ac9733bfe9",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "6f7594f2-f059-4d56-9e67-47ac9733bfe9",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "Generic Cash Clearing (8003)",
"Attributes": [
{
"Value": "f4be973a-25fc-48d0-a7df-7f719f239729",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "f4be973a-25fc-48d0-a7df-7f719f239729",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "f4be973a-25fc-48d0-a7df-7f719f239729",
"Id": "account"
}
]
},
{
"Value": "1443.00",
"Attributes": [
{
"Value": "f4be973a-25fc-48d0-a7df-7f719f239729",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "f4be973a-25fc-48d0-a7df-7f719f239729",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "Generic Credit Card Clearing (8002)",
"Attributes": [
{
"Value": "a10867ac-0bc4-4aa5-af00-b9e5b207c6c3",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "a10867ac-0bc4-4aa5-af00-b9e5b207c6c3",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "a10867ac-0bc4-4aa5-af00-b9e5b207c6c3",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "a10867ac-0bc4-4aa5-af00-b9e5b207c6c3",
"Id": "account"
}
]
},
{
"Value": "96.49",
"Attributes": [
{
"Value": "a10867ac-0bc4-4aa5-af00-b9e5b207c6c3",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "Generic Inventory (1400)",
"Attributes": [
{
"Value": "7422f1b6-619f-488c-89e1-91bdde20216c",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "7422f1b6-619f-488c-89e1-91bdde20216c",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "7422f1b6-619f-488c-89e1-91bdde20216c",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "7422f1b6-619f-488c-89e1-91bdde20216c",
"Id": "account"
}
]
},
{
"Value": "160.00",
"Attributes": [
{
"Value": "7422f1b6-619f-488c-89e1-91bdde20216c",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "My Savings (090)",
"Attributes": [
{
"Value": "7e5e243b-9fcd-4aef-8e3a-c70be1e39bfa",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "7e5e243b-9fcd-4aef-8e3a-c70be1e39bfa",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "7e5e243b-9fcd-4aef-8e3a-c70be1e39bfa",
"Id": "account"
}
]
},
{
"Value": "219.92",
"Attributes": [
{
"Value": "7e5e243b-9fcd-4aef-8e3a-c70be1e39bfa",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "7e5e243b-9fcd-4aef-8e3a-c70be1e39bfa",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "Payment Wall Clearing Account (8001)",
"Attributes": [
{
"Value": "bc06840c-12c5-4e22-bb57-fef4d64bac10",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "bc06840c-12c5-4e22-bb57-fef4d64bac10",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "bc06840c-12c5-4e22-bb57-fef4d64bac10",
"Id": "account"
}
]
},
{
"Value": "1.00",
"Attributes": [
{
"Value": "bc06840c-12c5-4e22-bb57-fef4d64bac10",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "bc06840c-12c5-4e22-bb57-fef4d64bac10",
"Id": "account"
}
]
}
]
}
]
},
{
"RowType": "Section",
"Title": "Liabilities",
"Rows": [
{
"RowType": "Row",
"Cells": [
{
"Value": "Accounts Payable (200)",
"Attributes": [
{
"Value": "e9132ee7-4dcf-4fad-b76c-86e212af645a",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "e9132ee7-4dcf-4fad-b76c-86e212af645a",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "e9132ee7-4dcf-4fad-b76c-86e212af645a",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "e9132ee7-4dcf-4fad-b76c-86e212af645a",
"Id": "account"
}
]
},
{
"Value": "9223.00",
"Attributes": [
{
"Value": "e9132ee7-4dcf-4fad-b76c-86e212af645a",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "Deferred Revenue (2300)",
"Attributes": [
{
"Value": "f22cd74e-f59d-4f38-a08d-07e14df28c24",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "f22cd74e-f59d-4f38-a08d-07e14df28c24",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "f22cd74e-f59d-4f38-a08d-07e14df28c24",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "f22cd74e-f59d-4f38-a08d-07e14df28c24",
"Id": "account"
}
]
},
{
"Value": "1854.24",
"Attributes": [
{
"Value": "f22cd74e-f59d-4f38-a08d-07e14df28c24",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "Rounding (260)",
"Attributes": [
{
"Value": "f0072999-8f7c-4b01-bce9-bd9352f98e02",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "f0072999-8f7c-4b01-bce9-bd9352f98e02",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "f0072999-8f7c-4b01-bce9-bd9352f98e02",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "f0072999-8f7c-4b01-bce9-bd9352f98e02",
"Id": "account"
}
]
},
{
"Value": "0.01",
"Attributes": [
{
"Value": "f0072999-8f7c-4b01-bce9-bd9352f98e02",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "Sales Tax (220)",
"Attributes": [
{
"Value": "af0be362-45fe-4730-a8af-634c2fb93f4d",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "af0be362-45fe-4730-a8af-634c2fb93f4d",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "af0be362-45fe-4730-a8af-634c2fb93f4d",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "af0be362-45fe-4730-a8af-634c2fb93f4d",
"Id": "account"
}
]
},
{
"Value": "1578.35",
"Attributes": [
{
"Value": "af0be362-45fe-4730-a8af-634c2fb93f4d",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "Suspense (250)",
"Attributes": [
{
"Value": "5ec2f302-cd60-4f8b-a915-9229dd45e6fa",
"Id": "account"
}
]
},
{
"Value": "10.00",
"Attributes": [
{
"Value": "5ec2f302-cd60-4f8b-a915-9229dd45e6fa",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "5ec2f302-cd60-4f8b-a915-9229dd45e6fa",
"Id": "account"
}
]
},
{
"Value": "41.00",
"Attributes": [
{
"Value": "5ec2f302-cd60-4f8b-a915-9229dd45e6fa",
"Id": "account"
}
]
},
{
"Value": "",
"Attributes": [
{
"Value": "5ec2f302-cd60-4f8b-a915-9229dd45e6fa",
"Id": "account"
}
]
}
]
},
{
"RowType":
# --- truncated at 32 KB (37 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/xero/refs/heads/main/examples/xero-getreporttrialbalance-example.json