Use API to get Smartsheet Row Id's

cjab

Hi

 

In order to intergrate another Application I would like to use the API to request a list of Smartsheet row ID's and selected columns (possibly just 1 column which the the primary key in the other application.

 

This would either be all rows or selected rows.

 

The best output would be as a CSV file eg:

 

mySheetRowIDs.csv

ID, Column-n

6303407879466884,NP1234

7652086333630340,NP1250

.......

 

Where NP1234 is the selected column.

 

I could cope if the whole row was exported as CSV as long as I get the RowiD in a regular possition.

 

Other file formats would be accespable but the ouput from GETSHEET is hard to unravel for me

 

I want to run this task programaticaly so we can keep the row ID updated in the other application ready to send updates by API.

 

Thanks for any tips

 

Chris

Steve Weil

Hi Chris,

 

You can download a sheet using

 

GET https://api.smartsheet.com/2.0/sheets/{sheetId}

 

By default you will get the sheet contents in JSON, but if you want CSV, add an additional HTTP header "Accept: text/csv"

 

Details here: http://smartsheet-platform.github.io/api-docs/?shell#get-sheet-as-excel-pdf-csv