GSConnected extension list from csv table error

[Shanmuga_Nathan]

how to set the Data as list, as it gives the following error

[TIMAI2]

How to show raw responseContent from your app when debugging

Many developers often get stuck when trying to handle the response content from an online server after making a GET request using the web component. Those trying to help often ask to see the raw responseContent being returned. When using companion this can be copied and pasted to the community for those trying to help to use with debugging. This is how you might return that information / data to a label. BLOCKS [image] DATA Do It Result: ""Name","Date of Birth","Age" "Adah","06/04/1999","2…

[Shanmuga_Nathan]

I know this one, but my sheet is private, so I use the Gsconnected extension, in that extension how to convert and how to add each column to a list

[TIMAI2]

Well, if you show what is coming back, we can help you find a solution.....

[Shanmuga_Nathan]

18/05/2022 13:10:54	c7534e1d0b38ea0f	email1
18/05/2022 13:11:12	c7534e1d0b38ea0f	email2
18/05/2022 13:41:58	519b0fa7be4f9da3	email3	hell
18/05/2022 13:39:19	519b0fa7be4f9da3	email4	HO
18/05/2022 13:38:32	519b0fa7be4f9da3	email5	ed
18/05/2022 13:38:23	Row data inserted to row 3	email6	HELLO 123
18/05/2022 13:37:57	Row data inserted to row 3	email7	HELLO 1234
18/05/2022 13:38:04	Row data inserted to row 3	email8	HELLO 123

above is my spreadsheet data.

see that it says it is not a list. It's a string, how to make it as "list"

[TIMAI2]

For many functions in the script, data comes back from the extension as a stringified json array, you have to use the parse block provided in the extension to convert it to an AI2 list.

[Shanmuga_Nathan]

Yes brother, this works fine and output is correct.