How do I get the Metadata from the Smartsheet?

Hello All,


I am able to get the Row and Column from the smartsheet JSON response but in it there are no metadata. I used things like:

params = {'include': 'objectValue,objectProperties,format,formula,columnType,options'}

and passed it with the request. But I still do not get any metadata. Specifically, I am trying to get the "_OUTLINELEVEL_" column that is present in the smartsheet.


Could someone please help me get this data?

Answers

  • Lucas Rayala
    Lucas Rayala ✭✭✭✭✭✭

    hi @sm_py, I believe you are trying to determine parent/child relationships between rows, correct? if you review the json when performing a get_sheet, you will see an "id" associated to the row, and a "parentID" associated to a row if the row is indented. If you pull the row id and the row parentID, you would be able to construct the outline. i haven't seen any specific method to get the outline without doing a little bit of legwork, but it shouldn't be too hard to pull apart.