How to programmatically export data from Smartsheet to csv?

We are new to Smartsheet and our requirement is to programmatically export data from Smartsheet to csv using C# application. What type of license we need? Also, it would be great if you can share some documentation or steps to achieve the same.   

Answers

  • To do any work with the API, you'll need a Business plan at a minimum. For C#, In the Smartsheet C# SDK, there's a method called GetSheetAsCSV, which you can call with the arguments ID and a BinaryWriter to output a CSV. You can find more here:
    https://github.com/smartsheet/smartsheet-csharp-sdk/blob/mainline/smartsheet-csharp-sdk/main/Smartsheet/Api/SheetResources.cs