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
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:
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