Does anyone have experience updating Smartsheet using Alteryx?
I am able to bring in data from Smartsheet to Alteryx using ODBC, but it seems like it doesn't go the other way.
I am using the same ODBC on the output, and the mapping looks fine as well, but I get an error message with "Primary Key required for Update option"
Things I have tried:
1. Matching column names
2. Matching Schema/data types
Strange thing is that when I try to change the Output Option to "Delete Data & Append" then it says it can't find the table name. (but in the "Append Field Map", all fields are showing up correctly)
I would appreciate any help!
