How can I post array object from Posman to Google Sheets

Ask the Experts and Postman Tips
,
1

Hello

I’m new to postman and coding.

I am trying to post array object from Postman to google sheets.
This way I can send a single object.

{
    "OwnerSerno": 79930,
    "OwnerType": 2,
    "InConsumption": [
        {
            "pd": 20210101000000,
            "cn": 357.0750000000,
            "ml": 10350,
            "st": 4,
            "ri": 0E-10,
            "rc": 23.8050000000
        }]}

However, when there is more than one object in this way, I cannot send it.

{
    "OwnerSerno": 79930,
    "OwnerType": 2,
    "InConsumption": [
        {
            "pd": 20210101000000,
            "cn": 357.0750000000,
            "ml": 10350,
            "st": 4,
            "ri": 0E-10,
            "rc": 23.8050000000
        },
        {
            "pd": 20210101010000,
            "cn": 349.8300000000,
            "ml": 10350,
            "st": 4,
            "ri": 0E-10,
            "rc": 27.9450000000
        },
        {
            "pd": 20210101020000,
            "cn": 342.5850000000,
            "ml": 10350,
            "st": 4,
            "ri": 0E-10,
            "rc": 26.9100000000
        }]}

My app script code is like this;



var wbook =SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/*********************/edit#gid=58651529");

var sheet =wbook.getSheetByName('GetOwnerConsumptions');

function doPost(e){
  var action = e.parameter.action;

  if(action == 'getHourly'){
    return getHourly(e);
  }
}

function getHourly(e){
  var meter = JSON.parse(e.postData.contents);
  sheet.appendRow([meter.pd, meter.cn, meter.ml, meter.st, meter.ri, meter.rc]);
 

  return ContentService.createTextOutput("Success").setMimeType(ContentService.MimeType.TEXT);
}

Is it possible for you to help with this? Thanks!