Work with all values from a sheets output dynamically

How To
,
1

Hi,

I really lost hours now to somehow handle the output from a sheets (get range) module dynamically.

this is the result with over 350 key/value items within a single bundle. The length of that output may differ from case to case, so that I need to have a dynamic handling.

Bildschirmfoto 2025-01-01 um 13.39.53
Bildschirmfoto 2025-01-01 um 13.39.531140×1850 276 KB

But whatever I do, I either need to take any value seperatly by hand, or I will always get just 1 single value.

To me the reason seems to be, that the output is not an array and whatever I try with the array aggregator module or the iterator module the output keeps the same.

And on top of this I would need the result from sheet as a complex array like with the following structure

[
  { "ID": "0", "Value": "Verkäufer-SKU" },
  { "ID": "1", "Value": "Aktion aufzeichnen" },
  { "ID": "2", "Value": "Produkttyp" },
  { "ID": "3", "Value": "Artikelname" },
  ...
]

How can this be done?