Issues writing query results in table to Google Sheets

💬 Queries and Resources
1

I am pulling invoice data from an app a customer is using with their Rest API. I am getting the data fine and populating the results into table1 in my new app.

I have tried adding a Form that is populated with the results from table1 and then firing my append query to send the rows to Google Sheets. I have also just tried a button that triggers my append query with the source data being everything from table1.

But I keep getting "Request included an invalid value. Supported cell values are string, bool and numbers. If you are appending a cell that contains an array or JSON object make sure to cast it as a string."

I've gone through as many Community Topics as I can find that are close to my issue. I was first getting errors due to not having all of the columns in Google Sheets to allow for all of the query data, even though I am only trying to pull in a about 10 of the rows. I have configured ALL of the table columns as strings and I still get the error.

Any ideas what I am screwing up? I know how to convert the Unix date timestamps to the right format and was doing it before sending to Google Sheets, but just trying to eliminate all breakpoints so just sending the string of numbers over and figured I would convert in Google Sheets, if needed. Thanks!

Here is some of the relevant info needed:

image
image2620×1210 204 KB

image
image1012×1106 59 KB

image
image982×2470 283 KB

image
image2774×1246 323 KB

image
image2772×1484 302 KB

2

I also tried not touching anything in the table data after the default setup, keeping every single value it gets back from the source system, leaving the JSON data values. At that point, I had this in my VALUES TO APPEND field:

{{ table1.data.map(row => Object.assign(row,{location:JSON.stringify(row.location), job:JSON.stringify(row.job),customer:JSON.stringify(row.customer), vendor:JSON.stringify(row.vendor),contract:JSON.stringify(row.contract), assignedOffice:JSON.stringify(row.assignedOffice),paymentTerms:JSON.stringify(row.paymentTerms),taxAmount:JSON.stringify(row.taxAmount),totalPaidAmount:JSON.stringify(row.totalPaidAmount)}))}}**

Since then I have just removed all of the column values I don't need to try and simply it. Banging my head against the wall :slight_smile:

3

Hi @MikeIke ,
I can try to help you debug this. Can you take a snapshot of your form component and also provide me with the data from your form component from the view state after you have filled out the form?

  1. right click on your form component and click on "Vew state"
  2. expand the "data" property

Thanks very much