Not returning spreadsheet data from the server

[enuchi]

Not returning spreadsheet data from the server

[stukennedy]

So after much trial and error, it seems that the getSheetContents function although it logs out the data correctly, somehow doesn't evaluate the data when returning from the method.
To make it work, I had to map through the rows and cells of the data.
So this method works:

const getSheetContents = () => {
  const data = getActiveDocument()
    .getActiveSheet()
    .getDataRange()
    .getValues();
  return (data || []).map(row => row.map(cell => `${cell}`));
};

Seems odd to have to do this. Have I missed something here?

[enuchi]

It is strange but I know that there are restrictions on the types allowed in a server response. Does it work if you stringify data before returning it?

[stukennedy]

yes doing JSON.parse(JSON.stringify(data)) does the trick.
Strange one ... I'll close this, seeing as it's nothing to do with your library.

Excellent job BTW:
I've used it to build a free tool for Remote musicians who are out of work with COVID-19
A Google Form inputting to a Google Sheet, and then a React app as a search page on the spreadsheet.
This is an excellent approach ... I'd usually use Google Firebase or AWS, but being able to make forms and sheets so quickly makes this a great option for simple webapps.

[enuchi]

Great, glad it's fixed. That is weird. Anyway, adding this link to the scripts docs that talks about allowed types, in case it helps other people reading this:

https://developers.google.com/apps-script/guides/html/reference/run#parameters

[enuchi]

And happy to hear this is helpful to you and others right now!