(AutoIt) SugarCRM Getting a Record

Gets a record from the Sugar instance using the //:record endpoint. In this example we get an Account record by it's ID, but only request the Name, Email, and Industry fields.

For more information, see https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.9/Integration/Web_Services/v10/Examples/Bash/How_to_Manipulate_Records_CRUD/#Getting_a_Record

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

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

$oHttp = ObjCreate("Chilkat.Http")
Local $bSuccess

; 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

$oHttp.SetRequestHeader "Cache-Control","no-cache"
$oHttp.SetRequestHeader "OAuth-Token","<access_token>"

$oSbResponseBody = ObjCreate("Chilkat.StringBuilder")
$bSuccess = $oHttp.QuickGetSb("http://<site_url>/rest/v10/Accounts/<record_id>?fields=name,email1,industry",$oSbResponseBody)
If ($bSuccess = False) Then
    ConsoleWrite($oHttp.LastErrorText & @CRLF)
    Exit
EndIf

$oJResp = ObjCreate("Chilkat.JsonObject")
$oJResp.LoadSb($oSbResponseBody)
$oJResp.EmitCompact = False

ConsoleWrite("Response Body:" & @CRLF)
ConsoleWrite($oJResp.Emit() & @CRLF)

Local $iRespStatusCode = $oHttp.LastStatus
ConsoleWrite("Response Status Code = " & $iRespStatusCode & @CRLF)
If ($iRespStatusCode >= 400) Then
    ConsoleWrite("Response Header:" & @CRLF)
    ConsoleWrite($oHttp.LastHeader & @CRLF)
    ConsoleWrite("Failed." & @CRLF)
    Exit
EndIf

; 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

Local $sId
Local $sName
Local $sDate_modified
Local $sIndustry
Local $sEmail1
Local $sV_module

$sId = $oJResp.StringOf("id")
$sName = $oJResp.StringOf("name")
$sDate_modified = $oJResp.StringOf("date_modified")
$sIndustry = $oJResp.StringOf("industry")
$sEmail1 = $oJResp.StringOf("email1")
$sV_module = $oJResp.StringOf("_module")