Here are some tips from our Support Team on working with Smartsheet data:
You often need to get data from Smartsheet using the Column ID because if you don't, the column order can change. For example, it is important to note that
/rows/cells/valuedoes not guarantee that the
valueis for the column you want. However,
/rows/cells[columnId=1234454223]/valuewill always get you values for the specified column ID.
The column id is a long number but you can get it by column title (assuming the column title is unique) with the following construct:
columns[title="title of column you want"]
For example, to get a value for the "PEI Values" column, you can do
When the data is not in alignment, this is a trick we use: (NOTE: this will not be necessary if they return values for all cells)
To align the
cell values with the selected
This can be tricky to understand if you aren't familiar with this type of data. If you get stuck, turn on support access with your account and let the support team know the name of the Klip.