Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How I am able to read data from google drive / box using alteryx?

DataPsycho
7 - Meteor

Hi,

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.

9 REPLIES 9
Treyson
13 - Pulsar
13 - Pulsar

Ah @DataPsycho! I am jealous of that name!

 

I know that if you had this file on Google Sheets, there are connectors for that.

 

Here is the link for the specifics and the download links are at the bottom.

 

https://help.alteryx.com/10.5/DataSources/GoogleSheets.htm

 

Here is also a great post by @JordanB about how to go about setting all of that up.

 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-How-to-Guide-to-Google-Sheets/ta-p/20354

Treyson Marks
Senior Analytics Engineer
DataPsycho
7 - Meteor

But I think its about reading data form google sheets. But is it work same for Excel, csv or txt also?

Treyson
13 - Pulsar
13 - Pulsar

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.

 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-to-Create-Google-API-Credentials/ta-p/11...

 

Google Sheets API, v4

Scopes
https://www.googleapis.com/auth/driveView and manage the files in your Google Drive
https://www.googleapis.com/auth/drive.fileView and manage Google Drive files and folders that you have opened or created with this app
https://www.googleapis.com/auth/drive.readonlyView the files in your Google Drive
https://www.googleapis.com/auth/spreadsheetsView and manage your spreadsheets in Google Drive
https://www.googleapis.com/auth/spreadsheets.readonlyView your Google Spreadsheets
Treyson Marks
Senior Analytics Engineer
DataPsycho
7 - Meteor

Hi @Treyson,

Thank you for all the resources. I will read those and try to find the solution I need and will share my findings.

Thanks Again.

Caleb
7 - Meteor

Hey @DataPsycho,

 

I just went through this stuff last week, let me know if you want to connect or need any help figuring it out!

 

Thanks,

 

Caleb

DataPsycho
7 - Meteor

Hi, I was busy doing other stuffs so I could not read those document so much. But so far I saw it about reading from google sheet. Will it be the same If I want to read excel?

Caleb
7 - Meteor

@DataPsycho

 

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.

 

I hope that helps!

 

Caleb

DataPsycho
7 - Meteor

@Caleb,

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.

melissa_m
8 - Asteroid

Hi All,

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.

 

Thanks!

 

Labels