Visual FoxPro

SugarCRM Create a Record List

See more SugarCRM Examples

Create a record list in Sugar consisting of a set of ids. Visual FoxPro

LOCAL lnSuccess
LOCAL loRest
LOCAL loJsonReq
LOCAL loSbReq
LOCAL loSbJson
LOCAL loJson
LOCAL lcId
LOCAL lcAssigned_user_id
LOCAL lcModule_name
LOCAL lcDate_modified
LOCAL i
LOCAL lnCount_i
LOCAL lcStrVal

lnSuccess = 0

loRest = CreateObject('Chilkat.Rest')

lnSuccess = loRest.Connect("your.site.domain",443,1,1)
IF (lnSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loRest
    CANCEL
ENDIF

loRest.AddHeader("Cache-Control","no-cache")
loRest.AddHeader("OAuth-Token","<access_token>")

* The following code creates the JSON request body.
* The JSON created by this code is shown below.
loJsonReq = CreateObject('Chilkat.JsonObject')
loJsonReq.UpdateString("records[0]","f16760a4-3a52-f77d-1522-5703ca28925f")
loJsonReq.UpdateString("records[1]","ec409fbb-2b22-4f32-7fa1-5703caf78dc3")

* The JSON request body created by the above code:

* {
*   "records": [
*     "f16760a4-3a52-f77d-1522-5703ca28925f",
*     "ec409fbb-2b22-4f32-7fa1-5703caf78dc3"
*   ]
* }

loSbReq = CreateObject('Chilkat.StringBuilder')
loJsonReq.EmitSb(loSbReq)

loRest.AddHeader("Content-Type","application/json")

loSbJson = CreateObject('Chilkat.StringBuilder')
lnSuccess = loRest.FullRequestSb("POST","/rest/v10/Accounts/record_list",loSbReq,loSbJson)
IF (lnSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loRest
    RELEASE loJsonReq
    RELEASE loSbReq
    RELEASE loSbJson
    CANCEL
ENDIF

IF (loRest.ResponseStatusCode <> 200) THEN
    ? "Received error response code: " + STR(loRest.ResponseStatusCode)
    ? "Response body:"
    ? loSbJson.GetAsString()
    RELEASE loRest
    RELEASE loJsonReq
    RELEASE loSbReq
    RELEASE loSbJson
    CANCEL
ENDIF

loJson = CreateObject('Chilkat.JsonObject')
loJson.LoadSb(loSbJson)

* The following code parses the JSON response.
* A sample JSON response is shown below the sample code.

lcId = loJson.StringOf("id")
lcAssigned_user_id = loJson.StringOf("assigned_user_id")
lcModule_name = loJson.StringOf("module_name")
lcDate_modified = loJson.StringOf("date_modified")
i = 0
lnCount_i = loJson.SizeOfArray("records")
DO WHILE i < lnCount_i
    loJson.I = i
    lcStrVal = loJson.StringOf("records[i]")
    i = i + 1
ENDDO

* A sample JSON response body that is parsed by the above code:

* {
*   "id": "ef963176-4845-bc55-b03e-570430b4173c",
*   "assigned_user_id": "1",
*   "module_name": "Accounts",
*   "records": [
*     "f16760a4-3a52-f77d-1522-5703ca28925f",
*     "ec409fbb-2b22-4f32-7fa1-5703caf78dc3"
*   ],
*   "date_modified": "2016-04-05 21:39:19"
* }

? "Example Completed."

RELEASE loRest
RELEASE loJsonReq
RELEASE loSbReq
RELEASE loSbJson
RELEASE loJson