Unable to read-in SmartSheet Data

Hi,

I'm having issues actually getting the data from SmartSheets to show up in my workflow. I successfully connected via the Live Data Connector and ODBC, but as you can see in the screen shot, no data is read into the workflow even though there is data in the Preview window.

What would cause this to happen?

smartsheet results.png

I've already replied to this post but wanted to submit a new post to see if I get faster feedback. :-)

Thanks for any help in resolving this.

-Mike

Datasets

Database Connection

Accepted answers

PaulN

Hi @mix_pix,

Thank you for your feedback. So based on your test, Browse tool could be workaround. If you had another tool -like browse tool- after select tool, do you see the intermediate data?

Smartsheet is not currently part supported data sources in Alteryx (https://help.alteryx.com/11.3/DataSources/SupportedDataSources.htm) so you face unexpected behaviours.

Kind regards,

Paul Noirel

Customer Support Engineer

All comments

PaulN

Hi @mix_pix,

What is your version of Alteryx please?

If you connect a browse tool, do you see any data?

Thanks,

Paul Noirel

Customer Support Engineer

mix_pix

Hi Paul,

I'm using 11.3.3.

I am able to see the data using a Browse tool, but not any other tool.

Using Select toolUsing Browse tool

ClevelC

Hi,

I know this was solved, but I recently experienced this and it was due to the size of the string field data coming through. The Results window has a limit on what it can show. If you put an 'Auto Field' tool right after your input tool it will help shrink down the data set allowing you to view the results as normal. You can also put a 'Select' tool and manually reduce the string field sizes as another option.

Hope this helps anyone else in the future!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703