This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to find a solution to read data directly form Google Drive/ Box. For example I have excel file stored in that location click here and I want to read it by alreryx directly because later on I am going to automate the workflow in the Server from local with some schedule. Though my company use Box as cloud service. So I have to configure every thing for Box.
So I am playing around with the Google Sheets API right now and I was looking at the documentation. Those last two look like the scope you may need to set that up. Here is @TaraM's documentation on the Google Sheets API Credentials setup.
From what I can tell, the spreadsheet needs to be a Google Sheet in order for you to use the API to view it. I didn't see .xlsx files that I'd dropped in my drive show up until I opened them in Sheets first. When you open them with Sheets it creates a duplicate sheets version.
Hi, I also observed it. So I think there is no direct way to read the data from csv or xlsx. Thank you for your time. Even I have to configure it for Box cloud storage. So I will continue testing the whole process for Box If I can do something. If it does not work then it should be improved in alteryx, in upcoming version. I often read data from Box using R package called boxr or SDK Box in python which works really well.
Do you know if this has been addressed. I was able to setup connectivity if it's saved as a Google Sheet. However, I am unable to see the file if it was uploaded as an Excel File. Appreciate any input.