Unable To Read CSV text

MIT App Inventor Help
1

Hi,

I am trying to make login scheme based-on google sheets but despite making a carbon copy of the steps I am still getting the above "cannot parse text argument" error.

At this point I am breaking down the problem to just understand how "list from csv row text" works.
So I have this very simple blocks that simply read from the csv file I exported, yet it returns the same error.

blocks
blocks1702×5004 961 KB

Here's my code

And here's my csv
data.csv (1.1 KB)

Appreciate if anyone who knows the problem point me to the right path, thanks!

2

Please show the error in full, and tell us when exactly it occurs

3

WhatsApp Image 2022-07-10 at 4.00.56 PM
WhatsApp Image 2022-07-10 at 4.00.56 PM757×1600 49.4 KB

This is the error, so i can't unable to "log in"

4

Your query returns the header row AND the query data, so you have a csv table not a csv row.

You will need to use the list from csv table block to make the responseContent an AI2 list, then remove the first item in that list to have just the data.

5

I did, but still error and unable to read. what's the ssolution?

6

Can you share your aia project, I will take a look.

8

SIAGA.aia (3.3 MB)
this is the AIA, glad if you could help :smiley:

9

It works for me

If I enter a NIP from your spreadsheet, the tinydb tag values are filled

10

Works also for me, used a NIP from dpreadsheet to test it