We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

Tables Not Available After Connection to Smartsheet Live Data Connector

Logan_06
5 - Atom

After creating an ODBC connection to the Smartsheet Live Data Connector, I tried to connect to my Smartsheet tables in Alteryx. It looks like it creates a successful connection, but then none of my tables are available fore me to choose from. What could be causing this issue? 

 

Visual Query BuilderVisual Query BuilderODBC ConnectionODBC Connection

2 REPLIES 2
Dubes33
5 - Atom

You have to click on the tables tab and double click the table you want to use this article explains it well how exactly to do it but you also need to remove your uname and quotes in the sql editor after you select the table

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connecting-Alteryx-to-Smartsheet/td-p/...

apathetichell
17 - Castor

I can't get this thread to open (access denied) but my memory is there was a solid discussion of using API connectivity to Smartsheet vs their terrible ODBC read-only connection...

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Upload-Excel-Files-while-writing-to-Sm...

Labels