JSONarraytoGoogleSpreadSheets

var C_OBJECT_FIELD_DELIMETER = ' > ';
var C_DEFALUT = '';


function getObjectFields_(obj, keyprefix) {
  var fields = []; 
  if (typeof keyprefix === "undefined") { keyprefix = ''; }
  var type = '';
  for (var key in obj)
  {
    type = typeof obj[key];
    if (Array.isArray(obj[key]))
    {
      // if array lenght is 1 and first element is object      
      if (obj[key].length === 1 && typeof obj[key][0] === 'object')
      {
        fields = fields.concat(getObjectFields_(obj[key][0], keyprefix + key + C_OBJECT_FIELD_DELIMETER));          
      }
      else
      {
       fields.push(keyprefix + key); 
      }
    }
    else if (type === 'object')
    {
      fields = fields.concat(getObjectFields_(obj[key], keyprefix + key + C_OBJECT_FIELD_DELIMETER));
    }
    else
    {
      fields.push(keyprefix + key);
    }            
  }
  return fields;  
}


function getObjectAsRow_(obj, fields)
{
  fields = fields || getObjectFields_(obj); 
  var row = [];  
  for (var i = 0, l = fields.length; i < l; i++)
  {
    var keys = fields[i].split(C_OBJECT_FIELD_DELIMETER);
    row.push(getObjectField_(obj, keys));    
  }  
  return row;    
}


function getObjectField_(obj, keys)
{
  var node = obj;
  var key = '';
  
  for (var i = 0, l = keys.length; i < l; i++)
  {
    key = keys[i]
    
    if (Array.isArray(node)) 
    { 
      if (node.length === 1 && typeof node[0] === 'object')
      {
        node = node[0][key];         
      }
      else if (node.length === 1)
      {
        node = '';       
      }
      else
      {
        if (node.length === 1) { node = node[0]; }
        else { node = JSON.stringify(node); }
      }
    }
    else if (node === null)
    {
      return C_DEFALUT;
    }
    else if (typeof node === 'object')
    {
      if (key in node)
      {
        node = node[key];  
      } 
      else
      {
        return C_DEFALUT; 
      }           
    }
    else
    {
      return node;       
    }
  }  
  if (Array.isArray(node)) 
  {    
    if (node.length === 1) 
     { node = node[0]; 
      }
    else if (node.length === 0) { 
      
      return ''; 
      
                                }
    
    else { return JSON.stringify(node); 
         }   
         }
  
  
  
  //node = getDateFromText_(node);  // return date if possible 
  

  
  // check node is string > 50000 chars
  if (typeof node === 'string')
  {
    if (node.length > 1000) 
   { node = node.substring(0, 50000); }         
  }
  
  // check node is date and convert it to "Google date" = spreadhseet format
  if (node instanceof Date) 

  { 
  node ; 
  }

  return node;  
  
  
  
}


function getGoogleDate_( D ) 

{ 
   //var D = JSdate ;
   //var Null = new Date(Date.UTC(1899,11,30,0,0,0,0)) ; // the starting value for Google
  
   return (D)  ;
}


function getJsonArrayAsTable(jsonArray)
{
  json = JSON.parse(jsonArray);
  return  getObjectsAsTable_(json)
}

function getObjectsAsTable_(objArray, fields, hideHeaders)
{
  fields = fields || getObjectFields_(objArray[0]);     
  var result = [];
  if (!hideHeaders) { result.push(fields); }
  
  var addObjRow_ = function(obj) { result.push(getObjectAsRow_(obj, fields)); }
  objArray.forEach(addObjRow_);
  
  return result;
  
}



function getDateFromText_(text)
{
  if (text instanceof Date && !isNaN(text.valueOf())) return text;  
  var t = new Date(text);
  if (!t.getFullYear() || t.getFullYear() === 1970) { return text; }

  return t
    
}


function getTextAsJson(JsonText, valuesArray)
{
  var node = JSON.parse(JsonText);  
  for (var i = 0, l = valuesArray.length; i < l; i++)
  {
    node = node[valuesArray[i]];     
  }    
  return node;    
}