Google Apps Script to Output a JSON Array into a rows

Question

sorry I just learned the app script and my english is not good. on the Google app script, based on the example of json array, how do I get itemA and itemC output?

{
    "items":[
        {
            "itemA":123,
            "itemB":"qwe",
            "itemC":"asd"
        },
        {
            "itemA":456,
            "itemB":"rty",
            "itemC":"fgh"
        },
        {
            "itemA":789,
            "itemB":"uio",
            "itemC":"jkl"
        }
    ]
}

I want the output like this :

123, asd
456, fgh
789, jkl

I really appreciate all your help.

Antoni · Accepted Answer · 2020-06-24 07:59:18Z

3

This script gives the output you want.
Happy?

var json = {
  "items": [{
      "itemA": 123,
      "itemB": "qwe",
      "itemC": "asd"
    },
    {
      "itemA": 456,
      "itemB": "rty",
      "itemC": "fgh"
    },
    {
      "itemA": 789,
      "itemB": "uio",
      "itemC": "jkl"
    }
  ]
}
var output_text = "";
json.items.forEach(function(item) {
  output_text += item.itemA + ", " + item.itemC + "\n";
});
console.log(output_text);

edited Jun 24, 2020 at 7:59

answered Jun 23, 2020 at 18:19

Antoni

3766 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

TheMaster Over a year ago

delete deletes in-place. If the intent is modifying the original object, forEach is better suited for the iteration.

Kolimondi Over a year ago

@Antoni, thank you for your answer, please check update of my question

Kishan · Accepted Answer · 2020-06-24 10:52:32Z

0

Try the following code:

let obj = {
    "items":[
        {
            "itemA":123,
            "itemB":"qwe",
            "itemC":"asd"
        },
        {
            "itemA":456,
            "itemB":"rty",
            "itemC":"fgh"
        },
        {
            "itemA":789,
            "itemB":"uio",
            "itemC":"jkl"
        }
    ]
};

function genOutput() {
  var output = obj.items.map( item => [item.itemA,item.itemC] );
  console.log( output );
};

Run function genOutput, you will get the following output:

[ [ 123, 'asd' ], [ 456, 'fgh' ], [ 789, 'jkl' ] ]

answered Jun 24, 2020 at 10:52

Kishan

1,82014 silver badges19 bronze badges

Collectives™ on Stack Overflow

Google Apps Script to Output a JSON Array into a rows

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related