csvRead issue from google sheet file

Ui.Vision
1

Hello everyone, I have a test im trying to do with csvRead and i keep getting an error and not sure whats wrong.
Here is the error log * [info]

  • [error]

Line 9: E325: csv file ‘https://script.google.com/macros/s/AKfycbyAsjAebhPXeGxA25pmuSmEn8vh-d_Oo3MQTE-oiFFvIcTB4N60-NLFbYZTaYi5MQIhVQ/exec’ does not exist

here is the macro json line of code I have
{
“Command”: “csvRead”,
“Target”: “link (I cant post it for new user limit)”,
“Value”: “”,
“Description”: “Read all rows from the Sheet as CSV”
},
{
“Command”: “while”,
“Target”: “"${!csvReadStatus}" == "OK"”,
“Value”: “”,
“Description”: “Loop through each row”
},
The csv file is open ive tested it (you can open it as its just a test file)

Ive tried opening the file in incognito browser and it downloads it just fine. But for some reason the csvRead is having an error with it? Can anyone assist me with this

2

Hi, just to clarify: Do you want to use csvRead with a link to a Google Doc Sheet as input?

3

Yes exactly. Either via direct link to google sheet or through a google app link

4

@admin Is this something that can be fixed/added? Also I noticed that the versions are different via chrome and edge, Edge is 9.5.1 and chrome is 9.5.3 is this normal? As this also changes the error message I get

5

Hi, currently csvRead can only read from csv files that are either added to the extension or on your local hard-drive/network drive.

If you want to process CSV files that are on Google Drive, you can automate the file download with Ui.Vision and then use the csvRead command.

6

Thanks for asking: We do our releases in stages. Ui.Vision for Chrome has been updated first. Edge and Firefox will follow in a few days. Then we also update the RPA source code.