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.
on 08-15-201605:14 PM - edited on 03-11-201909:32 AM by SydneyF
Did you know that you can connect to a Dropbox or Box.com account from Alteryx on your desktop?
As long as your install the desktop client for each service you will be able to read and write to each of the accounts.
To download the desktop client for box.com click on your name/username, select “Get Box Sync”, and then click the “Box Sync” download button:
To download the desktop client for dropbox click on your name/username, “install”, and then click the “Free Download” button to start your download:
You will have to run through the install wizards for each program and one of the processes during install is to choose an installation path. Make sure that you choose a path that you have permissions to both read and write files as this is key to connecting to the services with Alteryx. Once the install has completed and both (or one) of the services are running you should see them active in your “Favorites” section of a windows explorer window as well as on the task bar:
If you were to access either of those services in the windows explorer window you will be able to see the install path for each. That install path is what you would use in your input or output tool in order to read and/or write to either Dropbox or Box.com.
In both Dropbox and Box.com I have uploaded a file “AddressData.yxdb” via their respective web interfaces as an example:
An input tool can now be used to path to each of the directories on your machine where dropbox and box.com were installed and you will be able to see and read the files into Alteryx:
You can then do any processing you need to on your file and then write back to each service. Box.com will let you overwrite the file you are reading in as long as you have a Block Until Done tool somewhere between input and output; the file is locked while it is being read. The nice thing about box.com is that they provide version information when you do overwrite an existing file. This version information allows you to download or replace the current version with previous versions:
Dropbox will allow you to write back to its service, however you cannot overwrite an existing file. Dropbox puts a lock on files being accessed so in order to overwrite or “update” an existing file, you will have to rename the file in the output tool from “AddressData.yxdb” to “AddressData2.yxdb” for example.