Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Use API to get Smartsheet Row Id's

Options
cjab
cjab
edited 12/09/19 in Archived 2017 Posts

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

Comments

This discussion has been closed.