JSON output into Excel table

[Anonymous]

I have this flow in which I make a GET HTTP call to QuickBook's API to get a General Ledger report. I have managed with the help of some knowledgeable people, to get parts of the JSON output (but not all) into an excel table. I am looking to get all the transactions that appear on the JSON output. Here is how my flow looks like:

Initialize variables are used later in the apply to each step to get specific JSON output.

Here is my first expression in one of the loops:

Second expression in the other loop:

In the set variables, I use the variables initialized before to get specific values from the JSON output:

expression used in the set variable = items('Apply_to_each_2')?['ColData']?[0]?['value']. The others set variables have the same expression but with different numbers instead of the cero.

This is how the excel output looks like, I am missing some transactions and accounts:

I will share the JSON output on a comment below (too large). Any help will be appreciated, thanks!

[Anonymous]

Here is the schema, significantly cut down in order to avoid errors messages while posting here:

{

  "Columns": {

    "Column": [

      {

        "ColTitle": "Date",

        "ColType": "Date",

        "MetaData": [

          {

            "Name": "ColKey",

            "Value": "tx_date"

          }

        ]

      },

      {

        "ColTitle": "Num",

        "ColType": "String",

        "MetaData": [

          {

            "Name": "ColKey",

            "Value": "doc_num"

          }

        ]

      },

      {

        "ColTitle": "Account",

        "ColType": "String",

        "MetaData": [

          {

            "Name": "ColKey",

            "Value": "account_name"

          }

        ]

      },

      {

        "ColTitle": "Amount",

        "ColType": "Money",

        "MetaData": [

          {

            "Name": "ColKey",

            "Value": "subt_nat_amount"

          }

        ]

      },

      {

        "ColTitle": "Balance",

        "ColType": "Money",

        "MetaData": [

          {

            "Name": "ColKey",

            "Value": "rbal_nat_amount"

          }

        ]

      }

    ]

  },

  "Rows": {

    "Row": [

      {

        "Header": {

          "ColData": [

            {

              "value": "Checking",

              "id": "35"

            },

            {

              "value": ""

            },

            {

              "value": ""

            },

            {

              "value": ""

            },

            {

              "value": ""

            }

          ]

        },

        "Rows": {

          "Row": [

            {

              "ColData": [

                {

                  "value": "Beginning Balance"

                },

                {

                  "value": ""

                },

                {

                  "value": ""

                },

                {

                  "value": ""

                },

                {

                  "value": "2124.50"

                }

              ],

              "type": "Data"

            },

            {

              "ColData": [

                {

                  "value": "2021-10-30"

                },

                {

                  "value": ""

                },

                {

                  "value": "Checking",

                  "id": "35"

                },

                {

                  "value": "-23.50"

                },

                {

                  "value": "2101.00"

                }

              ],

              "type": "Data"

            }

          ]

        },

        "Summary": {

          "ColData": [

            {

              "value": "Total for Checking"

            },

            {

              "value": "-23.50"

            },

            {

              "value": ""

            },

            {

              "value": ""

            },

            {

              "value": ""

            }

          ]

        },

        "type": "Section"

      }

    ]

  }

}

[Anonymous]

This is my desired output for all transactions: