Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

ODBC Connection to Smartsheet Issues

geewiz01
5 - Atom

Having issues connecting to Smartsheets and receiving these errors.  I read several posts but not getting the same results.  

  1. Using the 32 bit ODBC connection, nothing happens at all.
  2. Using Generic ODBC connection, I get this error:  

geewiz01_0-1617139399543.png

   3.Using a token with generic ODBC, I get this error.

geewiz01_1-1617139407466.png

 

Any ideas how to resolve?  Thanks in advance!

 

 

5 REPLIES 5
BrandonB
Alteryx
Alteryx

Have you tried this macro as an alternative? https://gallery.alteryx.com/#!app/SmartSheetInput/5c37718b826fd30988ede363 

 

 

BrandonB
Alteryx
Alteryx

Also I'm not sure if this write up is outdated at this point, but see if these instructions help if you are looking to leverage the ODBC connection: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connecting-Alteryx-to-Smartsheet/td-p/... 

geewiz01
5 - Atom

Thanks Brandon, I have tried this with no luck.  

geewiz01
5 - Atom

I'll give this one a try once I figure out how to use.  Thanks for the suggestion.

Syoung2893
5 - Atom

This link is outdated.  Steps 1 & 2 were fine, but 3 was a no-go.  I get the following messages:

Labels