Use API to get Smartsheet Row Id's

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

Find more posts tagged with

Manufacturing

API and Developers

Services

Integrations

IT & Operations

Comments

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