Csv row to google sheet with apps script

MIT App Inventor Help
1

hi

issue with :
var data2 = eval("["+ e.parameters.csvdata1 +"]");

issue with :

var data2 = eval("["+ e.parameters.csvdata1 +"]");

in a post https://sites.google.com/view/metricrat-ai2/guides/export-csv-data-multiple-data-to-google-sheetI found this instruction line that allowed me to convert a csv format line to a table
it worked.
a few weeks later I use this same instruction it works randomly
what can explain this? an evolution of script apps?
however I tested the script without the application and everything suggests that it comes from the application and yet I have verified that I am sending the data

maybe there are other ways of doing this ...

2

Try with json.parse:

var data2 = JSON.parse(e.parameter.csvdata1);
3

from the data I send, i.e. lists that have been transformed into csv line
I tried without the application this
var data2 = JSON.parse("dog","mouse","cat","house")

it doesn't work

4

Perhaps like this (in google apps script):

var data2 = JSON.parse(JSON.stringify(["dog","mouse","cat","house"]));

data[0] returns dog, data[1] returns mouse, etc.

5

i tried this :

var u = e.parameters.csvm ;

var data2 = JSON.parse(JSON.stringify([u]));

before i have tried ;

var data2 = JSON.parse(JSON.stringify([e.parameters.csvm]));

it doesn't work

6

Did you try it without the square brackets > [ ] ?

What "exactly" is in your e.parameters.csvm? > what are you sending?

Are you using POST or GET ?

7

yes i tried without and i get an error

i'm sending csv row like : "dog","mouse","cat","house"

i use post and get as it often advised

8

This works with POST:

image
image714×303 32.2 KB 

function doPost(e) {

var data = e.postData.contents.split(",") ;

var ss = SpreadsheetApp.getActive();
var sh = ss.getSheetByName('Sheet1');

sh.appendRow(data);

return ContentService.createTextOutput(data) ;

}

image

https://developers.google.com/apps-script/guides/web

https://www.tutorialrepublic.com/faq/how-to-convert-comma-separated-string-into-an-array-in-javascript.php

9

I will try but I am in doubt, will it also work if my data looks like an array or list of list ?

volvo, green,10000
ford, red, 18000
toyota, blue, 14000

10

In that case I would do it like this:

Convert the csv table string to a list, and then POST the list.

image
image866×291 36.6 KB

function doPost(e) {

var data = JSON.parse(e.postData.contents) ;

var ss = SpreadsheetApp.getActive();
var sh = ss.getSheetByName('Sheet1');

for (var i=0;i<data.length;i++) {
sh.appendRow(data[i]);
}

return ContentService.createTextOutput("Success") ;

}

image

Export CSV data (multiple data) to Google Sheet

1 Like
11

Hi

thanks for your answer
i tried this but it doesn't work
do you use apps script ?
in my script JSON isn't blue

12

Yes, using google apps script
Check your script syntax and your csv table data input

13

for now I only use the script and the blocks given as an example without the app

14

So you are using Postman or curl for the POST request ? You cannot run a POST request in the browser.

15

not at all
for the moment I especially check that the scripts work and the solutions that I find that and where I am offered generally work without problem
that's why I'm going to review this solution that worked so well a few weeks ago
https://sites.google.com/view/metricrat-ai2/guides/export-csv-data-multiple-data-to-google-sheet#h.p_iX3Q4_7RXUZw

16

var data2 = eval("["+ e.parameters.csvdata1 +"]");Blockquote

no this instruction is not obsolete
I do not create my lists like in the post and I made the fatal mistake of using block like this

blocks (12)
blocks (12)950×60 11.6 KB

with this one below it works
blocks (13)
blocks (13)1008×60 13.4 KB

thank you for your support Tim

17

This is exactly why we ask people to show their relevant blocks :weary:

1 Like