How can I a single cells value using API?

Options

I have the below code, I am trying to get the value a specific cell but I am getting the 1006 error. However if I modify this for a put request, it works without issue? also to note, I am doing this in vb


  Sub GetCompletedCellValue(apiKey As String, sheetId As Long, rowId As Long, columnId As Long)

    Using client As New HttpClient()

      client.DefaultRequestHeaders.Authorization = New AuthenticationHeaderValue("Bearer", apiKey)


            Dim getResponse As HttpResponseMessage = client.GetAsync($"https://api.smartsheet.com/2.0/sheets/{sheetId}/rows/{rowId}/cells/{columnId}").Result


      If getResponse.IsSuccessStatusCode Then

        Dim responseContent As String = getResponse.Content.ReadAsStringAsync().Result

        Dim cellData As JObject = JObject.Parse(responseContent)

        Dim cellValue As String = cellData("value").ToString()

        Debug.WriteLine("Current cell value: " & cellValue)

      Else

        Debug.WriteLine($"Error getting cell value: {getResponse.Content.ReadAsStringAsync().Result}")

      End If

    End Using

  End Sub

Answers