Excel-REST - Smartsheet API: Update

gistfile1.vb

' curl https://api.smartsheet.com/1.1/row/{rowId}/cells \
Dim Request As New RestRequest
Request.Resource = "row/{rowId}/cells"
Request.AddUrlSegment "rowId", "RowId..."

' -H "Authorization: Bearer ACCESS_TOKEN" \
Request.AddHeader "Authorization", "Bearer ACCESS_TOKEN is set in authenticator"

' -H "Content-Type: application/json" \
Request.RequestFormat = json

' -X PUT \
Request.Method = httpPUT

' -d '[ {"columnId": 3738748463671172, "value": "Revision 2"}, {"columnId": 5427598323935108, "value": "On Time", "strict": false} ]'
Dim Data As New Collection
Data.Add New Dictionary
Data(1).Add "columnId", 3738748463671172
Data(1).Add "value", "Revision 2"

Data.Add New Dictionary
Data(2).Add "columnId", 5427598323935108
Data(2).Add "value", "On Time"
Data(2).Add "strict", False

' Automatically converted to json based on RequestFormat
Request.AddBody Data

' Alternative (you have to be careful with the quotes for json)
Request.AddBodyString "[{""columnId"": 3738748463671172, ""value"": ""Revision 2""}, {""columnId"": 5427598323935108, ""value"": ""On Time"", ""strict"": false}]"