How to read/write data from Smartsheet using Talend

[Anonymous]

Hi All,

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

Thanks in Advance,

Nare.

[Anonymous]

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 🙂

[Anonymous]

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

[Anonymous]

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 🙂