Extracting Data from Smart Sheet

Four Stars

Extracting Data from Smart Sheet

Hi All,

 

Please let me know, how to connect with the Smart sheet and to extract the data to any relative data base.

 

I could not find any options directly to connect with smart sheet.  Also, i have tried with ODBC / JDBC connectivity, its not helpful. Please share your update

 

Thanks

Highlighted
Eight Stars

Re: Extracting Data from Smart Sheet

Hi there,

 

Wasn't aware of SmartSheet before, and there don't appear to be any components in Talend Exchange which will do this.

 

However, a quick check of their website and I can see they have a RESTful API, plus native libraries including one for Java, so you will be able to do this from Talend.

 

Details of these can be found here:

 

http://developers.smartsheet.com/

 

If you're comfortable with Java, then the native API would be the best option, but if not, you'll be able to use the tREST component to get your data.

 

Regards,

 

 

Chris 

Four Stars

Re: Extracting Data from Smart Sheet

Thank you, Chris.


2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog