Empty array - Google apps script

Question

I must get a value in a json data like in following link: Value in json data (sorry because I can't emb image). I need to get value of "DT sau CK" and I see that it's value is an empty array [ ]. My function is:

function test () {
  api_url = 'https://my url....'
  var result = UrlFetchApp.fetch(api_url);  
  var data = JSON.parse(result);
  var dtt = data['chart']['data'][2]['value'];
  if (dtt == false || dtt.length == 0) {
    dtt = 0;
  } else {
    dtt = data['chart']['data'][2]['value'];
  }
  return Number(dtt)
}

My if "dtt.length == 0" for an emty array. I want it to give me value/number 0 but it always return another number 157548000, something like that, maybe by api_url/server. But i want to get a number "0" result as i saw an empty array. Can anyone help me, thanks a lot and sorry for my bad English.

You should add a sample of result to your question. The error must lie in the datastructure or how you access it. — try-catch-finally
– try-catch-finally, Commented Nov 20, 2015 at 6:19

Riël · Accepted Answer · 2015-11-20 21:12:33Z

1

Maybe you can add this to replace empty arrays with '0':

chart.data.forEach(function (item) {
 if (item.value.length===0) {
   item.value=0;
  }
});

answered Nov 20, 2015 at 21:12

Riël

1,3353 gold badges17 silver badges33 bronze badges

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

Comments

Musaddiq · Accepted Answer · 2020-08-23 12:33:30Z

0

I faced same issue recently, the solution is to just delete empty/extra columns.

answered Aug 23, 2020 at 12:33

Musaddiq

397 bronze badges

Collectives™ on Stack Overflow

Empty array - Google apps script

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related