Classic ASP
Classic ASP
SugarCRM Create a Record List
See more SugarCRM Examples
Create a record list in Sugar consisting of a set of ids.Chilkat Classic ASP Downloads
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
success = 0
set rest = Server.CreateObject("Chilkat.Rest")
success = rest.Connect("your.site.domain",443,1,1)
If (success <> 1) Then
Response.Write "<pre>" & Server.HTMLEncode( rest.LastErrorText) & "</pre>"
Response.End
End If
success = rest.AddHeader("Cache-Control","no-cache")
success = rest.AddHeader("OAuth-Token","<access_token>")
' The following code creates the JSON request body.
' The JSON created by this code is shown below.
set jsonReq = Server.CreateObject("Chilkat.JsonObject")
success = jsonReq.UpdateString("records[0]","f16760a4-3a52-f77d-1522-5703ca28925f")
success = jsonReq.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"
' ]
' }
set sbReq = Server.CreateObject("Chilkat.StringBuilder")
success = jsonReq.EmitSb(sbReq)
success = rest.AddHeader("Content-Type","application/json")
set sbJson = Server.CreateObject("Chilkat.StringBuilder")
success = rest.FullRequestSb("POST","/rest/v10/Accounts/record_list",sbReq,sbJson)
If (success <> 1) Then
Response.Write "<pre>" & Server.HTMLEncode( rest.LastErrorText) & "</pre>"
Response.End
End If
If (rest.ResponseStatusCode <> 200) Then
Response.Write "<pre>" & Server.HTMLEncode( "Received error response code: " & rest.ResponseStatusCode) & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( "Response body:") & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( sbJson.GetAsString()) & "</pre>"
Response.End
End If
set json = Server.CreateObject("Chilkat.JsonObject")
success = json.LoadSb(sbJson)
' The following code parses the JSON response.
' A sample JSON response is shown below the sample code.
id = json.StringOf("id")
assigned_user_id = json.StringOf("assigned_user_id")
module_name = json.StringOf("module_name")
date_modified = json.StringOf("date_modified")
i = 0
count_i = json.SizeOfArray("records")
Do While i < count_i
json.I = i
strVal = json.StringOf("records[i]")
i = i + 1
Loop
' 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"
' }
Response.Write "<pre>" & Server.HTMLEncode( "Example Completed.") & "</pre>"
%>
</body>
</html>