topic Re: How to read/write data from Smartsheet using Talend in Talend Studio

How to read/write data from Smartsheet using Talend

Anonymous — Thu, 04 Jul 2019 09:27:29 GMT

Hi All,

Can some one help me on how to write/read data from Smartsheet using Talend.

Thanks in Advance,

Nare.

Re: How to read/write data from Smartsheet using Talend

Anonymous — Thu, 04 Jul 2019 14:19:13 GMT

Hi,

You will have to make API calls to Smartsheet through REST components of Talend to fetch the data.

Please refer the Smartsheet API link below to get an idea about how the calls can be made.

https://smartsheet-platform.github.io/api-docs/#make-your-first-api-call

Once you get the result set, you can parse the JSON message according to your need.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How to read/write data from Smartsheet using Talend

Anonymous — Fri, 05 Jul 2019 12:13:20 GMT

Thanks @nthampi ,

As per you suggestion, now I am able to download the file successfully without any any issues.

Can you please help me on how to use put/post method to upload the file from my local directory and where I need to specify the filepath in tREST component.

Thanks In Advance,

Nare

Re: How to read/write data from Smartsheet using Talend

Anonymous — Fri, 05 Jul 2019 14:15:42 GMT

Hi,

Please refer the below link.

https://community.smartsheet.com/discussion/api-csv-import-active-smartsheet

I hope I have answered your query from Talend perspective. Could you please spare a second to mark the topic as resolved?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂