Alteryx Designer Desktop Discussions

yany · ‎06-20-2017

I want to create an analytic app which downloads a .csv file.

The URL I am using gives a "download window" when it is opened:

I have tried using the Connectors -> Download tool, but instead of downloading the correct worksheet, it downloads this:

<!DOCTYPE html><html><head><meta charset="UTF-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><title>Tableau Server Sign In</title><script src="/console-polyfill.js?7ha0cv5eqnfqirpqfxwohwipb9"></script><script src="/jquery.js?7ha0cv5eqnfqirpqfxwohwipb9"></script><script src="/underscore.js?7ha0cv5eqnfqirpqfxwohwipb9"></script><script>// This is needed to hide any spinners the parent frame might be using
try {
window.parent.postMessage('tableau.completed'	'*');
} catch (e) {
}
// See return value for documentation
window.EmbeddedAuthHelper = (function(window	$	_) {

// This function corrects a bug caused by $.param	which replaces spaces with '+' characters
// TODO: Write a test that attempts to access the web authoring page of a view that has a space in its name
// (i.e. "Sheet 1") via a redirect after authentication
function param() {
return $.param.apply($	arguments).replace(/\+/g	'%20');
}

// Simple implementation for the inverse of $.param() for flat objects
var deparam = (function () { // Initialize the deparam() method
function toPrimitive(str) {
if (str === 'undefined') return undefined;
if (str === 'null') return null;
if (str === 'true') return true;
if (str === 'false') return false;
if (str === 'NaN') return NaN;

....

Can someone please help me out?

yany · ‎06-20-2017

The url is a link to a tableau database which requires login

andrewdatakim · ‎06-20-2017

Hi @yany,

If you are using Tableau Server it should be pretty straightforward. The URL you will be building should look like this http://*MyTableauServerName*/views/*WorkbookName*/*DashboardName*.csv . It will download the file to your normal downloads folder. You may want to reroute it if you are looking to place it somewhere different. From here you will just need to use a directory tool if you want to move it or read from it. Let me know if it still isn't working for you.

Regards,

Andrew

yany · ‎06-20-2017

Thanks @AndrewDataKim,

I am using the correct URL; however, it requires to login.

I have entered my user id and password in the DOWNLOAD tool, but it still doesn't work.

andrewdatakim · ‎06-20-2017

Hi @yany,

The permissions definitely adds a layer of complexity. I would suggest tabcmd instead https://onlinehelp.tableau.com/current/server/en-us/tabcmd_cmd.htm , if you have the permissions on your server. Scroll down this documentation about halfway to the export section. You will need to use the workflow events or cmd tool to get it running, but this from my experience is easier to set up. You will just need to know what version of Tableau Server you are on and you can download the Tabcmd tool from https://www.tableau.com/support/esdalt on the right side (server download side). Let me know if you have any questions.

yany · ‎06-20-2017

Thanks @AndrewDataKim

Alteryx Designer Desktop Discussions

Download from URL