title: Post JSON to streak in excel vba
body: <p>I'm trying to update a large number of boxes on streak, and I have all these information in an excel sheet, however I realize when the request is sent, I ended up with "Sector12" on the website instead Sector12.value. </p>
  
  <p>Can anyone help me with this?</p>
  
  <p>Thank you in advance</p>
  
  <pre><code>        With CreateObject("Microsoft.XMLHTTP")
              .Open "POST", "https://www.streak.com/api/v1/boxes/" &amp; boxK &amp; "/fields/1007", False
              .SetRequestHeader "Accept", "application/json"
              .SetRequestHeader "Content-Type", "application/json"
              .SetRequestHeader "Authorization", "Basic " &amp; EncodeBase64("xxxxxxxxxxxxxx")
              Sector12 = Application.WorksheetFunction.VLookup(JsonBox.Item(Index).Item("name"), ActiveSheet.Range("A:D"), 2, 0)
  
  
              .Send "{'value':Sector12}"
  
          End With
  </code></pre>