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?
Solved! Go to Solution.
The url is a link to a tableau database which requires login
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
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.
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.
Thanks @AndrewDataKim