Cannot parse text argument to "list from csv table" as a CSV-formatted table

Hi,
I know this topic has already been discussed, but I do not find the solution to my problem.
I can retrieve datas from a csv document internally uploaded in the app ; this works.
But when a save the same file in google drive or in dropbox, I can't get the content.

The app builder here tells me "Cannot parse text argument to "list from csv table" as a CSV-formatted table".
Here are my blocks :
image

Here is the design :

Here my csv doc (just for testing) :
image

And here, I have put the responsecontent in the third Label to eventually see what's wrong :

Thanks for your help :wave:

Your fuzzy Dropbox responseContent definitely does not look like Comma Separated Values (CSV).

Work on your Dropbox web request.

Blockquote @ABG Work on your Dropbox web request

I've tried but to be honnest I don't know how to do.
The same structure with google drive address of my csv-doc gives the same kind of responsecontent.

Here's my current collection of download examples ...

Well ...
I've noticed a error, that I have corrected (columns instead of rows)
I have put in the program retrieval of a doc in google drive
and I have tried to add some labels so it becomes clearer what is what
... but I still have the message "Cannot parse text argument to "list from csv table" as a CSV-formatted table" and it obviously doesn't retrieve anything (though I don't have the big amount of text previously displayed).

image
image

Here's my current collection of download examples ...

thank you, I go exploring :slight_smile:

In each of the web Got Text events, capture your responseContent for debugging BEFORE trying to convert it to a table. Don't give the event an excuse to die prematurely before you can capture the response.

Also check the sharing settings on your Dropbox file online ...

In each of the web Got Text events, capture your responseContent for debugging BEFORE trying to convert it to a table. Don't give the event an excuse to die prematurely before you can capture the response.

I needed a wile to understand :joy:
ok, done : now I have for each ResponseContent (dropbox and google drive) the same kind of <!DOCTYPE ... text as before though there's much more for dropbox then for google drive (do you need me to make a hundred pics to show you the exact content ?)

Also check the sharing settings on your Dropbox file online ...

I made right-click and share link
or I could open it in dropbox : image

google drive : share > everyone having the links can access (free translation from french)

I don't understand how to find the ID of the sheet as demonstrated here
image

In a Google Sheet, the file ID is the longest piece of text between slashes (/) in the URL.
It's long because Google has a LOT of them.

https://docs.google.com/spreadsheets/d/1z9Xg8vykhS5veSY8kIGImeQI-iJTjX-uQLPUThzP-2s/edit?usp=sharing
that part ?

I made it so : image

And I get : "Error 1101 : unable to get a response with the specified URL"

Google sheet problem solved !!
instead of simply copying the link https://docs.google.com/spreadsheets/d/1z9Xg8vykhS5veSY8kIGImeQI-iJTjX-uQLPUThzP-2s/edit?usp=sharing
I had to change the end of the link to convert it in a csv file, as shown here https://groups.google.com/g/mitappinventortest/c/Xtrwf7u2Qo4
so, it becomes : https://docs.google.com/spreadsheets/d/1z9Xg8vykhS5veSY8kIGImeQI-iJTjX-uQLPUThzP-2s/export?format=csv

I guess the dropbox problem is similar (some kind of anything in the late extentions of the sharelink name... but what ??) ... does anyone have an idea about it ?

Thank you for your patience and help @ABG :slight_smile: :smiley:

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.