SugarCRM Getting a Record

Dim success As Boolean = False

'  This example assumes the Chilkat API to have been previously unlocked.
'  See Global Unlock Sample for sample code.

Dim http As ChilkatHttp
http.Initialize("http")

'  Implements the following CURL command:

'  curl -H OAuth-Token:<access_token> -H Cache-Control:no-cache http://<site_url>/rest/v10/Accounts/<record_id>?fields=name,email1,industry

http.SetRequestHeader("Cache-Control", "no-cache")
http.SetRequestHeader("OAuth-Token", "<access_token>")

Dim sbResponseBody As ChilkatStringBuilder
sbResponseBody.Initialize
success = http.QuickGetSb("http://<site_url>/rest/v10/Accounts/<record_id>?fields=name,email1,industry", sbResponseBody)
If success = False Then
    Log(http.LastErrorText)
    Return
End If


Dim jResp As ChilkatJsonObject
jResp.Initialize
jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

Log("Response Body:")
Log(jResp.Emit)

Dim respStatusCode As Int = http.LastStatus
Log("Response Status Code = " & respStatusCode)
If respStatusCode >= 400 Then
    Log("Response Header:")
    Log(http.LastHeader)
    Log("Failed.")
    Return
End If


'  Sample JSON response:
'  (Sample code for parsing the JSON response is shown below)

'  {
'    "id": "ab2222df-73da-0e92-6887-5705428f4d68",
'    "name": "Test Record",
'    "date_modified": "2016-04-06T15:03:21-04:00",
'    "industry": "",
'    "email1": "test@sugar.com",
'    "_acl": {
'      "fields": {}
'    },
'    "_module": "Accounts"
'  }

'  Sample code for parsing the JSON response...
'  Use the following online tool to generate parsing code from sample JSON:
'  Generate Parsing Code from JSON

Dim id As String
Dim name As String
Dim date_modified As String
Dim industry As String
Dim email1 As String
Dim v_module As String

id = jResp.StringOf("id")
name = jResp.StringOf("name")
date_modified = jResp.StringOf("date_modified")
industry = jResp.StringOf("industry")
email1 = jResp.StringOf("email1")
v_module = jResp.StringOf("_module")