Json response

[nikhilfsoft]

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())}]}

[SidneyAllen]

@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.