PowerShell

SugarCRM Create a Record List

See more SugarCRM Examples

Create a record list in Sugar consisting of a set of ids. PowerShell

Add-Type -Path "C:\chilkat\ChilkatDotNet47-x64\ChilkatDotNet47.dll"

$success = $false

$rest = New-Object Chilkat.Rest

$success = $rest.Connect("your.site.domain",443,$true,$true)
if ($success -ne $true) {
    $($rest.LastErrorText)
    exit
}

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

# The following code creates the JSON request body.
# The JSON created by this code is shown below.
$jsonReq = New-Object Chilkat.JsonObject
$jsonReq.UpdateString("records[0]","f16760a4-3a52-f77d-1522-5703ca28925f")
$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"
#   ]
# }

$sbReq = New-Object Chilkat.StringBuilder
$jsonReq.EmitSb($sbReq)

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

$sbJson = New-Object Chilkat.StringBuilder
$success = $rest.FullRequestSb("POST","/rest/v10/Accounts/record_list",$sbReq,$sbJson)
if ($success -ne $true) {
    $($rest.LastErrorText)
    exit
}

if ($rest.ResponseStatusCode -ne 200) {
    $("Received error response code: " + $rest.ResponseStatusCode)
    $("Response body:")
    $($sbJson.GetAsString())
    exit
}

$json = New-Object Chilkat.JsonObject
$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")
while ($i -lt $count_i) {
    $json.I = $i
    $strVal = $json.StringOf("records[i]")
    $i = $i + 1
}

# 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.")