XeroAPI
Json response
I am having hard time parsing Json response from Trial balances and Journals API. Is there any python library or function available to format Json response from Trial Balances or Journals API into a neat structured dataframe?
For reference the Json response from Trial Balances look something like this:
{'reports': [{'fields': [], 'report_date': '20 April 2021', 'report_id': 'TrialBalance', 'report_name': 'Trial Balance', 'report_title': None, 'report_titles': ['Trial Balance', 'Demo Company (AU)', 'As at 10 April 2021'], 'report_type': 'TrialBalance', 'rows': [{'cells': [{'attributes': None, 'value': 'Account'}, {'attributes': None, 'value': 'Debit'}, {'attributes': None, 'value': 'Credit'}, {'attributes': None, 'value': 'YTD Debit'}, {'attributes': None, 'value': 'YTD Credit'}], 'row_type': <RowType.HEADER: 'Header'>, 'rows': None, 'title': None}, {'cells': None, 'row_type': <RowType.SECTION: 'Section'>, 'rows': [{'cells': [{'attributes': [{'id': 'account', 'value': '1335b8b2-4d63-4af8-937f-04087ae2e36e'}], 'value': 'Interest Income (270)'}, {'attributes': [{'id': 'account', 'value': '1335b8b2-4d63-4af8-937f-04087ae2e36e'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '1335b8b2-4d63-4af8-937f-04087ae2e36e'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '1335b8b2-4d63-4af8-937f-04087ae2e36e'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '1335b8b2-4d63-4af8-937f-04087ae2e36e'}], 'value': '97.05'}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': 'e2bacdc6-2006-43c2-a5da-3c0e5f43b452'}], 'value': 'Sales (200)'}, {'attributes': [{'id': 'account', 'value': 'e2bacdc6-2006-43c2-a5da-3c0e5f43b452'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': 'e2bacdc6-2006-43c2-a5da-3c0e5f43b452'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': 'e2bacdc6-2006-43c2-a5da-3c0e5f43b452'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': 'e2bacdc6-2006-43c2-a5da-3c0e5f43b452'}], 'value': '53378.32'}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}], 'title': 'Revenue'}, {'cells': None, 'row_type': <RowType.SECTION: 'Section'>, 'rows': [{'cells': [{'attributes': [{'id': 'account', 'value': 'd392fe47-c99d-499e-a200-46709dd6b6e7'}], 'value': 'Advertising (400)'}, {'attributes': [{'id': 'account', 'value': 'd392fe47-c99d-499e-a200-46709dd6b6e7'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': 'd392fe47-c99d-499e-a200-46709dd6b6e7'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': 'd392fe47-c99d-499e-a200-46709dd6b6e7'}], 'value': '4102.91'}, {'attributes': [{'id': 'account', 'value': 'd392fe47-c99d-499e-a200-46709dd6b6e7'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '959af5f4-9925-44e8-b283-7ddf4b427238'}], 'value': 'Bank Fees (404)'}, {'attributes': [{'id': 'account', 'value': '959af5f4-9925-44e8-b283-7ddf4b427238'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '959af5f4-9925-44e8-b283-7ddf4b427238'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '959af5f4-9925-44e8-b283-7ddf4b427238'}], 'value': '331.50'}, {'attributes': [{'id': 'account', 'value': '959af5f4-9925-44e8-b283-7ddf4b427238'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': 'ff09eac3-5b17-44fb-9eea-e2e9375e91b4'}], 'value': 'Cleaning (408)'}, {'attributes': [{'id': 'account', 'value': 'ff09eac3-5b17-44fb-9eea-e2e9375e91b4'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': 'ff09eac3-5b17-44fb-9eea-e2e9375e91b4'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': 'ff09eac3-5b17-44fb-9eea-e2e9375e91b4'}], 'value': '465.00'}, {'attributes': [{'id': 'account', 'value': 'ff09eac3-5b17-44fb-9eea-e2e9375e91b4'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '6db51cfa-0326-4e63-a743-c78c4d99aba4'}], 'value': 'Consulting & Accounting ' '(412)'}, {'attributes': [{'id': 'account', 'value': '6db51cfa-0326-4e63-a743-c78c4d99aba4'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '6db51cfa-0326-4e63-a743-c78c4d99aba4'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '6db51cfa-0326-4e63-a743-c78c4d99aba4'}], 'value': '98.00'}, {'attributes': [{'id': 'account', 'value': '6db51cfa-0326-4e63-a743-c78c4d99aba4'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '18e27517-81e0-437c-bc21-fbba8e30d6bb'}], 'value': 'Entertainment (420)'}, {'attributes': [{'id': 'account', 'value': '18e27517-81e0-437c-bc21-fbba8e30d6bb'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '18e27517-81e0-437c-bc21-fbba8e30d6bb'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '18e27517-81e0-437c-bc21-fbba8e30d6bb'}], 'value': '277.20'}, {'attributes': [{'id': 'account', 'value': '18e27517-81e0-437c-bc21-fbba8e30d6bb'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': 'c4a9d449-ef04-43a7-9af8-49c6558b361e'}], 'value': 'Freight & Courier ' '(425)'}, {'attributes': [{'id': 'account', 'value': 'c4a9d449-ef04-43a7-9af8-49c6558b361e'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': 'c4a9d449-ef04-43a7-9af8-49c6558b361e'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': 'c4a9d449-ef04-43a7-9af8-49c6558b361e'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': 'c4a9d449-ef04-43a7-9af8-49c6558b361e'}], 'value': '9.09'}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '94882296-5acf-4350-8c5b-82bc9370ab78'}], 'value': 'General Expenses (429)'}, {'attributes': [{'id': 'account', 'value': '94882296-5acf-4350-8c5b-82bc9370ab78'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '94882296-5acf-4350-8c5b-82bc9370ab78'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '94882296-5acf-4350-8c5b-82bc9370ab78'}], 'value': '1085.05'}, {'attributes': [{'id': 'account', 'value': '94882296-5acf-4350-8c5b-82bc9370ab78'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '1b83b470-95ae-4b0b-a84e-8c407d5ea2ae'}], 'value': 'Legal expenses (441)'}, {'attributes': [{'id': 'account', 'value': '1b83b470-95ae-4b0b-a84e-8c407d5ea2ae'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '1b83b470-95ae-4b0b-a84e-8c407d5ea2ae'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '1b83b470-95ae-4b0b-a84e-8c407d5ea2ae'}], 'value': '4090.91'}, {'attributes': [{'id': 'account', 'value': '1b83b470-95ae-4b0b-a84e-8c407d5ea2ae'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '42a56c1a-6141-4bf2-913d-916dc1a35cfd'}], 'value': 'Light, Power, Heating ' '(445)'}, {'attributes': [{'id': 'account', 'value': '42a56c1a-6141-4bf2-913d-916dc1a35cfd'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '42a56c1a-6141-4bf2-913d-916dc1a35cfd'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '42a56c1a-6141-4bf2-913d-916dc1a35cfd'}], 'value': '1044.73'}, {'attributes': [{'id': 'account', 'value': '42a56c1a-6141-4bf2-913d-916dc1a35cfd'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '005f380d-4a9c-497f-b9d7-817f0f02790e'}], 'value': 'Motor Vehicle Expenses ' '(449)'}, {'attributes': [{'id': 'account', 'value': '005f380d-4a9c-497f-b9d7-817f0f02790e'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '005f380d-4a9c-497f-b9d7-817f0f02790e'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '005f380d-4a9c-497f-b9d7-817f0f02790e'}], 'value': '938.04'}, {'attributes': [{'id': 'account', 'value': '005f380d-4a9c-497f-b9d7-817f0f02790e'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '8ab9d684-f897-4168-b5d1-2279bf74bb82'}], 'value': 'Office Expenses (453)'}, {'attributes': [{'id': 'account', 'value': '8ab9d684-f897-4168-b5d1-2279bf74bb82'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '8ab9d684-f897-4168-b5d1-2279bf74bb82'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '8ab9d684-f897-4168-b5d1-2279bf74bb82'}], 'value': '1540.37'}, {'attributes': [{'id': 'account', 'value': '8ab9d684-f897-4168-b5d1-2279bf74bb82'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': 'b18eaea6-4d11-462c-ac30-7975108b5859'}], 'value': 'Printing & Stationery ' '(461)'}, {'attributes': [{'id': 'account', 'value': 'b18eaea6-4d11-462c-ac30-7975108b5859'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': 'b18eaea6-4d11-462c-ac30-7975108b5859'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': 'b18eaea6-4d11-462c-ac30-7975108b5859'}], 'value': '66.00'}, {'attributes': [{'id': 'account', 'value': 'b18eaea6-4d11-462c-ac30-7975108b5859'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': 'ee30a086-d381-4bd6-ba47-7af927d25825'}], 'value': 'Purchases (300)'}, {'attributes': [{'id': 'account', 'value': 'ee30a086-d381-4bd6-ba47-7af927d25825'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': 'ee30a086-d381-4bd6-ba47-7af927d25825'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': 'ee30a086-d381-4bd6-ba47-7af927d25825'}], 'value': '763.64'}, {'attributes': [{'id': 'account', 'value': 'ee30a086-d381-4bd6-ba47-7af927d25825'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': 'f5f05ee3-f9cd-4bf9-9423-ed81de96b537'}], 'value': 'Rent (469)'}, {'attributes': [{'id': 'account', 'value': 'f5f05ee3-f9cd-4bf9-9423-ed81de96b537'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': 'f5f05ee3-f9cd-4bf9-9423-ed81de96b537'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': 'f5f05ee3-f9cd-4bf9-9423-ed81de96b537'}], 'value': '5573.86'}, {'attributes': [{'id': 'account', 'value': 'f5f05ee3-f9cd-4bf9-9423-ed81de96b537'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': 'b3742a53-0f64-4765-b5cc-3ece843b2e91'}], 'value': 'Subscriptions (485)'}, {'attributes': [{'id': 'account', 'value': 'b3742a53-0f64-4765-b5cc-3ece843b2e91'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': 'b3742a53-0f64-4765-b5cc-3ece843b2e91'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': 'b3742a53-0f64-4765-b5cc-3ece843b2e91'}], 'value': '120.00'}, {'attributes': [{'id': 'account', 'value': 'b3742a53-0f64-4765-b5cc-3ece843b2e91'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '266f40cc-5aa1-4f6c-b078-eb615171d6de'}], 'value': 'Telephone & Internet ' '(489)'}, {'attributes': [{'id': 'account', 'value': '266f40cc-5aa1-4f6c-b078-eb615171d6de'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '266f40cc-5aa1-4f6c-b078-eb615171d6de'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '266f40cc-5aa1-4f6c-b078-eb615171d6de'}], 'value': '239.56'}, {'attributes': [{'id': 'account', 'value': '266f40cc-5aa1-4f6c-b078-eb615171d6de'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '25717024-5b50-4320-93b7-280c0614a613'}], 'value': 'Travel - National ' '(493)'}, {'attributes': [{'id': 'account', 'value': '25717024-5b50-4320-93b7-280c0614a613'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '25717024-5b50-4320-93b7-280c0614a613'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '25717024-5b50-4320-93b7-280c0614a613'}], 'value': '682.14'}, {'attributes': [{'id': 'account', 'value': '25717024-5b50-4320-93b7-280c0614a613'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': 'c4f12f09-846e-4f6f-b39c-dff3be3e49a7'}], 'value': 'Wages and Salaries ' '(477)'}, {'attributes': [{'id': 'account', 'value': 'c4f12f09-846e-4f6f-b39c-dff3be3e49a7'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': 'c4f12f09-846e-4f6f-b39c-dff3be3e49a7'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': 'c4f12f09-846e-4f6f-b39c-dff3be3e49a7'}], 'value': '40200.00'}, {'attributes': [{'id': 'account', 'value': 'c4f12f09-846e-4f6f-b39c-dff3be3e49a7'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}], 'title': 'Expenses'}, {'cells': None, 'row_type': <RowType.SECTION: 'Section'>, 'rows': [{'cells': [{'attributes': [{'id': 'account', 'value': '3dd5c80d-e109-4313-8c61-41648e33704f'}], 'value': 'Accounts Receivable ' '(610)'}, {'attributes': [{'id': 'account', 'value': '3dd5c80d-e109-4313-8c61-41648e33704f'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '3dd5c80d-e109-4313-8c61-41648e33704f'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '3dd5c80d-e109-4313-8c61-41648e33704f'}], 'value': '25056.55'}, {'attributes': [{'id': 'account', 'value': '3dd5c80d-e109-4313-8c61-41648e33704f'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '13918178-849a-4823-9a31-57b7eac713d7'}], 'value': 'Business Bank Account ' '(090)'}, {'attributes': [{'id': 'account', 'value': '13918178-849a-4823-9a31-57b7eac713d7'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '13918178-849a-4823-9a31-57b7eac713d7'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '13918178-849a-4823-9a31-57b7eac713d7'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '13918178-849a-4823-9a31-57b7eac713d7'}], 'value': '17849.87'}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '26028d3a-f981-44d6-a9ed-a522198870f8'}], 'value': 'Business Savings ' 'Account (091)'}, {'attributes': [{'id': 'account', 'value': '26028d3a-f981-44d6-a9ed-a522198870f8'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '26028d3a-f981-44d6-a9ed-a522198870f8'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '26028d3a-f981-44d6-a9ed-a522198870f8'}], 'value': '6878.28'}, {'attributes': [{'id': 'account', 'value': '26028d3a-f981-44d6-a9ed-a522198870f8'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '75bbcb81-6b3d-4ca9-8522-3b582cb5c21a'}], 'value': 'Computer Equipment ' '(720)'}, {'attributes': [{'id': 'account', 'value': '75bbcb81-6b3d-4ca9-8522-3b582cb5c21a'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '75bbcb81-6b3d-4ca9-8522-3b582cb5c21a'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '75bbcb81-6b3d-4ca9-8522-3b582cb5c21a'}], 'value': '1969.99'}, {'attributes': [{'id': 'account', 'value': '75bbcb81-6b3d-4ca9-8522-3b582cb5c21a'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '2d69b4ee-37d4-4f67-b950-32cbdd5765ed'}], 'value': 'Office Equipment (710)'}, {'attributes': [{'id': 'account', 'value': '2d69b4ee-37d4-4f67-b950-32cbdd5765ed'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '2d69b4ee-37d4-4f67-b950-32cbdd5765ed'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '2d69b4ee-37d4-4f67-b950-32cbdd5765ed'}], 'value': '7050.00'}, {'attributes': [{'id': 'account', 'value': '2d69b4ee-37d4-4f67-b950-32cbdd5765ed'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '24d010bf-5e4b-42dd-9aa3-a5484dd0686f'}], 'value': 'Less Accumulated ' 'Depreciation on Office ' 'Equipment (711)'}, {'attributes': [{'id': 'account', 'value': '24d010bf-5e4b-42dd-9aa3-a5484dd0686f'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '24d010bf-5e4b-42dd-9aa3-a5484dd0686f'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '24d010bf-5e4b-42dd-9aa3-a5484dd0686f'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '24d010bf-5e4b-42dd-9aa3-a5484dd0686f'}], 'value': '825.00'}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}], 'title': 'Assets'}, {'cells': None, 'row_type': <RowType.SECTION: 'Section'>, 'rows': [{'cells': [{'attributes': [{'id': 'account', 'value': '8e9c5166-d3fe-4e21-827a-f42753568e80'}], 'value': 'Accounts Payable (800)'}, {'attributes': [{'id': 'account', 'value': '8e9c5166-d3fe-4e21-827a-f42753568e80'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '8e9c5166-d3fe-4e21-827a-f42753568e80'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '8e9c5166-d3fe-4e21-827a-f42753568e80'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '8e9c5166-d3fe-4e21-827a-f42753568e80'}], 'value': '8507.78'}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '66e60a82-99d8-47d1-956b-5baea404acba'}], 'value': 'GST (820)'}, {'attributes': [{'id': 'account', 'value': '66e60a82-99d8-47d1-956b-5baea404acba'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '66e60a82-99d8-47d1-956b-5baea404acba'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '66e60a82-99d8-47d1-956b-5baea404acba'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '66e60a82-99d8-47d1-956b-5baea404acba'}], 'value': '1564.50'}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '305b05b3-01f3-4f47-a45d-edfa66ea03e7'}], 'value': 'Historical Adjustment ' '(840)'}, {'attributes': [{'id': 'account', 'value': '305b05b3-01f3-4f47-a45d-edfa66ea03e7'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '305b05b3-01f3-4f47-a45d-edfa66ea03e7'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '305b05b3-01f3-4f47-a45d-edfa66ea03e7'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '305b05b3-01f3-4f47-a45d-edfa66ea03e7'}], 'value': '19212.21'}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '4d111d55-1c71-46b4-8cbc-d8b54d8d54c5'}], 'value': 'PAYG Withholdings ' 'Payable (825)'}, {'attributes': [{'id': 'account', 'value': '4d111d55-1c71-46b4-8cbc-d8b54d8d54c5'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '4d111d55-1c71-46b4-8cbc-d8b54d8d54c5'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '4d111d55-1c71-46b4-8cbc-d8b54d8d54c5'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '4d111d55-1c71-46b4-8cbc-d8b54d8d54c5'}], 'value': '9042.00'}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}, {'cells': [{'attributes': [{'id': 'account', 'value': '37441137-cfe3-4c2b-a569-ef75e6b66ae4'}], 'value': 'Rounding (860)'}, {'attributes': [{'id': 'account', 'value': '37441137-cfe3-4c2b-a569-ef75e6b66ae4'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': '37441137-cfe3-4c2b-a569-ef75e6b66ae4'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': '37441137-cfe3-4c2b-a569-ef75e6b66ae4'}], 'value': '0.09'}, {'attributes': [{'id': 'account', 'value': '37441137-cfe3-4c2b-a569-ef75e6b66ae4'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}], 'title': 'Liabilities'}, {'cells': None, 'row_type': <RowType.SECTION: 'Section'>, 'rows': [{'cells': [{'attributes': [{'id': 'account', 'value': 'e2eda5d3-a80f-45ff-af4c-74472fd904d4'}], 'value': 'Retained Earnings ' '(960)'}, {'attributes': [{'id': 'account', 'value': 'e2eda5d3-a80f-45ff-af4c-74472fd904d4'}, {'id': 'fromDate', 'value': ''}, {'id': 'toDate', 'value': '6/30/2020'}], 'value': ''}, {'attributes': [{'id': 'account', 'value': 'e2eda5d3-a80f-45ff-af4c-74472fd904d4'}, {'id': 'fromDate', 'value': ''}, {'id': 'toDate', 'value': '6/30/2020'}], 'value': '0.00'}, {'attributes': [{'id': 'account', 'value': 'e2eda5d3-a80f-45ff-af4c-74472fd904d4'}, {'id': 'fromDate', 'value': ''}, {'id': 'toDate', 'value': '6/30/2020'}], 'value': '7912.00'}, {'attributes': [{'id': 'account', 'value': 'e2eda5d3-a80f-45ff-af4c-74472fd904d4'}, {'id': 'fromDate', 'value': ''}, {'id': 'toDate', 'value': '6/30/2020'}], 'value': ''}], 'row_type': <RowType.ROW: 'Row'>, 'title': None}], 'title': 'Equity'}, {'cells': None, 'row_type': <RowType.SECTION: 'Section'>, 'rows': [{'cells': [{'attributes': None, 'value': 'Total'}, {'attributes': None, 'value': '0.00'}, {'attributes': None, 'value': '0.00'}, {'attributes': None, 'value': '110485.82'}, {'attributes': None, 'value': '110485.82'}], 'row_type': <RowType.SUMMARYROW: 'SummaryRow'>, 'title': None}], 'title': ''}], 'updated_date_utc': datetime.datetime(2021, 4, 20, 23, 17, 13, 915000, tzinfo=tzutc())}]}
@nikhilfsoft - we don't have any helper functions to format the JSON from reports in different ways.
This is the actual JSON returned from Xero's API. If you have time to contribute code to create this functionality for the community, we'd be happy to review a PR or discuss via this issue.
