Flattening JSON

Decided to go the JavaScript route. It’s not pretty but it seems to works.

JavaScript:

const json = '[{"items": {"item1": {"1": "i1_1","2": "i1_2"}, "item2": {"1": "i2_1","4": "i2_2","6": "i2_3"}, "item3": {"5": "i3_1"}}}]';

var myArr1 = JSON.parse(json);

var items = [];
var i = 0;

for(a in myArr1) {
    var myArr2 = myArr1[a];

    for(b in myArr2) {
        var myArr3 = myArr2[b];

        var key1;

        for (key1 in myArr3) {
            var myArr4 = myArr3[key1];
            
            var key2;

            for(key2 in myArr4) {
                var k = key1 + "_" + key2;
                var v = myArr4[key2];

                var item = "\"" + k + "\":\"" + v + "\"";

                items[i] = item;

                i++;
            }
        }
    }
}

console.log(JSON.parse("[{ \"items\":{" + items.toString().replace("'", "") + "}}]"));

Output:

[ { items:
     { item1_1: 'i1_1',
       item1_2: 'i1_2',
       item2_1: 'i2_1',
       item2_4: 'i2_2',
       item2_6: 'i2_3',
       item3_5: 'i3_1' } } ]

Would still be interested in a native SnapLogic Mapper solution if anyone has any ideas.