Upload Json file data into smartsheet

amun

I need some help in passing json file into smartsheet.

I want to pass all the values from  file and load exactly same values or some columns as per my need in smartsheet.

 

I am using below syntax in the body to populate some columns as per my need

{"cells":[

          {"columnId":8423944366647172,"value":false},

          {"columnId":1105594972170116,"value":50}

         ]

}

 

 

I can update the smartsheet when hardcoded values , how can I assign the variables to pass all values in array?

Shaine Greenwood

Hi amun,

You'll want to establish global variables, possibly write other functions to update their values, then pass the global variable to the body of your update row request.