API CSV import to active SmartSheet

ajskrilla

Hello,

I have written a program that utilizes the API from smartsheets; for simplicity, it just takes data from a source and imports it to SmartSheets. Problem is, it can only import it on a new sheet, not an active sheet. I understand that there is a tool that was recently developed: Data Uploader.(https://www.smartsheet.com/datauploader?_ga=2.147368181.372019632.1545060519-1537166030.1544741559) 

That can do this, but unfortunately, I do not think there is something within the SmartSheet module that satisfies that. I have looked over the API reference guide and I cannot see that this is possible.

Right now, I have an issue because I just need it to interact to one smartsheet and import the data to this one sheet hourly. 

Please let me know if this is possible.

dAVE Inden

Sending requests to import will always create a new sheet from the data you provide. If you have data that you want added to an existing sheet I would suggest using requests to Add Rows to the sheet or to Update Rows on the sheet with the data from your file. This is how Data Uploader is performing its functions.

You can have your application read the data from the CSV file and then use that in requests to Add Rows or Update Rows. I'd start by reviewing those sections of the API docs.

Add Rows:

http://smartsheet-platform.github.io/api-docs/#add-rows

Update Rows:

http://smartsheet-platform.github.io/api-docs/#update-rows