Problem to listview data from google sheet in emulator

[fortress868]

When I run the program, this message display.

I already changed the last part of URL to "export?format=csv" and share to all viewers with the link.

Do I miss something on the blocks? Can anyone help?

[ABG]

@fortress868

Do I miss something

You missed showing us what arrived in responseContent.

[fortress868]

Do you mean this?

[Taifun]

well, if this is the response content, then, as you can see yourself, this is not a table in csv format... and therefore the list from csv table block is not able to convert it into a list...
something is not correct with your url...

you might want to use this solution by @TIMAI2

METRIC RAT AI2 - Google Sheets for AppInventor

Taifun

[TIMAI2]

Try using a gviz query in your url instead of plain old output=csv

• Use gviz to get and query google sheet data

If that doesn't work, create a new spreadsheet.

[fortress868]

I used a new sheet, and the url as follow

https://docs.google.com/spreadsheets/d/1yqgqTtaVwb6Il4lK0Jw7DfmA1k-AM515PJM76n2v5eE/export?format=csv

but it still shows the same message. is the link wrong?
do i need to write programming codes before using google sheet?

[TIMAI2]

If you click on the link above, does it offer to download / or download a csv file to your computer ?

[fortress868]

Yes, it download a csv file to my computer

[dora_paz]

Works fine for me

[fortress868]

Do you just display the global name on listview?
Do you need to write scripts on google sheet?

[TIMAI2]

Have you tried the gviz query method as posted above? This has fixed things for others.

[dora_paz]

I only tested to get data from spreadsheet and show it in listview

[fortress868]

I changed the link to

https://docs.google.com/spreadsheets/d/1yqgqTtaVwb6Il4lK0Jw7DfmA1k-AM515PJM76n2v5eE/gviz/tq?tqx=out:csv&tq=SELECT *

but it still not working. why?

[dora_paz]

Try this , for me works fine with both links
spreadsheet1.aia (2.7 KB)

[fortress868]

I download your blocks and run, just display the error message again "cannot parse the text .... to csv list table ...."
what happen with my app inventor?

[dora_paz]

Now I see the problem, you are using emulator. Try to use Companion or download an alternative emulator like MemuPlay and use the Connect->Companion dialog to connect to a copy of the Companion on an emulator.

[fortress868]

Yes, it works on Companion, thanks.