How to Parse Nested Json

Getting Started
,
1

Hi

I am extracting bank summary from Xero, it is working, however not able to parse accurately. I am new to Make.com - can anyone advise me how to do? I tried with Parse Json but don’t know seems I am making mistakes. I am attaching my output bundle JSON.

[
{
“header”: [
{ “value”: “Bank Accounts” },
{ “value”: “Opening Balance” },
{ “value”: “Cash Received” },
{ “value”: “Cash Spent” },
{ “value”: “Closing Balance” }
],
“sections”: [
[
{ “value”: “Term Insurance 2”, “id”: “35c3237f-1258-4818-a11b-cf612777169c” },
{ “value”: “-178113.06” },
{ “value”: “2134.16”, “id”: “35c3237f-1258-4818-a11b-cf612777169c” },
{ “value”: “0.00”, “id”: “35c3237f-1258-4818-a11b-cf612777169c” },
{ “value”: “-175978.90” }
],
[
{ “value”: “Term Insurance 3”, “id”: “88a6b7a1-e380-4dbe-a40b-b32415c48055” },
{ “value”: “-265903.60” },
{ “value”: “2122.83”, “id”: “88a6b7a1-e380-4dbe-a40b-b32415c48055” },
{ “value”: “0.00”, “id”: “88a6b7a1-e380-4dbe-a40b-b32415c48055” },
{ “value”: “-263780.77” }
]
],
“summary”: [
{ “value”: “Total” },
{ “value”: “-11974560.03” },
{ “value”: “127737.29” },
{ “value”: “131954.69” },
{ “value”: “-11978777.43” }
]
}
]

I am expecting an output as below

Bank Accounts Opening Balance Cash Received Cash Spent Closing Balance
Term Insurance 2 -178113.06 2134.16 0.00 -175978.90
Term Insurance 3 -265903.60 2122.83 0.00 -263780.77

If someone can show me how to parse would be grateful as I am learning now? I tried other spots and videos but no success.

2

Hey Dhilip,

when I run that through parse JSON, I get essentially the output you described. Four arrays - one for the headers, one for each row bellow and one for a summary at the bottom. Do you need it in a different format? Or trying to get something specific?

1 Like
3

Thanks @Stoyan_Vatov Can you share me the workflow how to do that? Whatever you did is ok, I wanted to learn how to implement it?