topic Re: Extracting Data from Smart Sheet in Talend Studio

Extracting Data from Smart Sheet

Anonymous — Sun, 29 Oct 2017 18:01:40 GMT

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

Re: Extracting Data from Smart Sheet

Anonymous — Sun, 29 Oct 2017 18:43:40 GMT

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

Re: Extracting Data from Smart Sheet

Anonymous — Sun, 29 Oct 2017 21:05:22 GMT

Thank you, Chris.