Convert incoming data from json into 2d array

Question

I have a JSON file being pulled from google sheets. It reads my data by rows. The picture above shows the google sheet So far I've been able to get it into a 1-dimensional array but I can't get it to sort into a 2d array.

[ 'Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday Event 1', 'Monday event 1', 'Tuesday event 1', 'Wedneday event 1', 'Thursday event 1', 'Friday event 1', 'Saturday event 1', 'Sunday Event 2', 'Monday event 2', 'Tuesday event 2', 'Wedneday event 2', 'event 2', 'Friday event 2', 'Saturday event 2', 'Sunday Event 3', 'Monday event 3', 'Tuesday event 3', 'Wedneday event 3', 'event 3', 'Friday event 3', 'Saturday event 3', 'Sunday Event 4', 'Monday event 4', 'Tuesday event 4', 'Wedneday event 4', 'event 4', 'Friday event 4', 'Saturday event 4', 'Monday event 5', 'Tuesday event 5', 'Wedneday event 5', 'event 5', 'Friday event 5', 'Saturday event 5', 'Monday event 6', 'Tuesday event 6', 'Wedneday event 6', 'event 6', 'Friday event 6', 'Saturday event 6', 'Monday event 7', 'Tuesday event 7', 'Wedneday event 7', 'Friday event 7', 'Saturday event 7', 'Monday event 8', 'Wedneday event 8', 'Friday event 8', 'Saturday event 8', 'Monday event 9', 'Wedneday event 9', 'Friday event 9', 'Saturday event 9', 'Monday event 10', 'Wedneday event 10', 'Friday event 10', 'Saturday event 10', 'Monday event 11', 'Friday event 11', 'Saturday event 11', 'Monday event 12', 'Friday event 12', 'Saturday event 12', 'Monday event 13', 'Friday event 13', 'Saturday event 13', 'Monday event 14', 'Saturday event 14', 'Monday event 15', 'Saturday event 15', 'Saturday event 16', 'Saturday event 17', 'Saturday event 18', 'Saturday event 19', 'Saturday event 20', 'Saturday event 21' ]

so basically i want a 2d array to have the data [[sunday][sundayevent1]] [[sunday][sundayevent2]... [[saturday][saturdayevent20]][[saturday][saturdayevent21]

here is how im importing as a 1d array...

var day = []
function getEvent() {
  fetch(url, settings)
      .then(res => res.json())
      .then((json) => {
        for (var i = 0; i < json.feed.entry.length; i++) {
          day[i] = json.feed.entry[i].gs$cell.inputValue
        }
        console.log(day)
  })
}

json.feed.entry[i].gs$cell.inputValue is each value of each individual cell and like I said it reads top-left cell to the right sorry if I am asking a dumb question but for whatever reason, I'm not able to get the answer myself right now so I thought I would give stack overflow a try...

var day = [[],[]]
for (var i = 0; i < json.feed.entry.length; i++) {
          var mydata = json.feed.entry[i].gs$cell.inputValue
          var row = json.feed.entry[i].gs$cell.row
          var col = jston.feed.entry[i].gs$cell.col
          day[row][col] = mydata
        }

I've tried this too and even though I have the row and column from the table it still won't make a proper 2 array

Convert incoming data from json into 2d array

Answers (1)

Related Questions