Can anybody please share the tech document for SmartSheet - Tableau Web Connector?
Here is the Help Article that goes through the Smartsheet for Tableau Integration. The integration is built on the Tableau Web Data Connector (WDC) technology.
Operating system requirements can be found in Tableau’s tech specs.
Is this the information you're looking for?
Hello, I am at the step "Log in using your Smartsheet credentials." but don't know where to login. The Web Data Connector starting screen shows the form that I need to type in the URL. However, if I type "app.smarsheet.com" then the error occurs "The URL points to a website, not a Web Data Connector. Please help!
Hi @Hai Dao Le
Can you post a screen capture of the step that you are at (while blocking sensitive data)?
Here's more Documentation that may help:
Hello, I attach here the screen shot. After logging in, it shows the Smartsheet website, not data tables as expected. (I am using Macbook)
It looks like you may not have the Smartsheet data connector installed, or you may not be selecting it properly.
The first step is to install the Smartsheet Tableau Connector on the computer you would like to connect to Smartsheet from. I would recommend reviewing the Tableau documentation, here.
Once that's installed, these are the steps to follow within Tableau:
Thanks, I clicked to the link (Smartsheet Tableau Connector) but nothing in it to download.
My apologies! I just recognized you're using a Mac. In this instance you won't be able to use ODBC and instead will want to go through Connect > Web Data Connector as you had noted in your first comment.
On the Web Data Connector window where it's asking you to type a URL, instead look down at the bottom of the window where it says Use a Connector.
This should show you available connectors to choose from. I believe the URL is https://tableau.smartsheet.com:443/tableau/
Let me know if you've been able to connect from here!
It works, thanks very much!
Hi @Genevieve P. , I now have tried Tableau Prep Builder but cannot see Web Data Connector there as a Data Source. What should I do?
Here's an article I found from Tableau about this:
Hi @Hai Dao Le Thanks for sharing this information. Unfortunately the article doesn't address my issue. I have already connected my data and created dashboards using the WDC in Tableau. But suddenly since yesterday, the WDC is not able to connect and is asking me to login again and again. Would be grateful if you could share how to solve this. Does Tableau need a version upgrade maybe?
Hi @Nits I had the same issue recently and it resolved itself on its own after a couple days. I tried connecting using a blank new workbook to make sure the problem was in Smartsheet and not my Tableau workbook. At one point I selected the sheet and chose the options 'Import Text/Number colum data' AS TEXT and Import Metadata NO and it briefly worked.
I hope in a few days it will resolve itself for you too.
Hello everyone, I'm struggling with a method in Smartsheet API to add several rows to a sheet with Date Columns included. The point is compared with "update_rows" where it's working perfectly, when I try to use add_rows, the date format stays in ISO format and looks like this: Which is not the case with update_row where…
Does anyone have any experience with connecting between Smartsheet and Unanet?
We are using the smartsheet-python-sdk to insert rows into SmartSheets. For almost two years we have had this script running with no issue, but in the last week, SmartSheets has started to trim the leading zeros on fields that are all numeric. Nothing has changed in our sheet or in our script. Are others having this issue?…
©2024. All Rights Reserved Smartsheet Inc.