(PowerShell) SugarCRM: Importing Email Addresses (New Records)

Demonstrates how to import a new contact with email addresses.

For more information, see https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.9/Integration/Migration/Importing_Records/Importing_Email_Addresses/

Chilkat .NET Downloads Chilkat .NET Assemblies

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

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

$http = New-Object Chilkat.Http

$http.Accept = "application/json"

# The following JSON is sent in the request body:

# {
#   "first_name": "Rob",
#   "last_name": "Robertson",
#   "email": [
#     {
#       "email_address": "rob.robertson@sugar.crm",
#       "primary_address": "1",
#       "invalid_email": "0",
#       "opt_out": "0"
#     },
#     {
#       "email_address": "rob@sugar.crm",
#       "primary_address": "0",
#       "invalid_email": "0",
#       "opt_out": "1"
#     }
#   ]
# }

# Use this online tool to generate the code from sample JSON: 
# Generate Code to Create JSON

$jsonRequestBody = New-Object Chilkat.JsonObject
$jsonRequestBody.UpdateString("first_name","Rob")
$jsonRequestBody.UpdateString("last_name","Robertson")
$jsonRequestBody.UpdateString("email[0].email_address","rob.robertson@sugar.crm")
$jsonRequestBody.UpdateString("email[0].primary_address","1")
$jsonRequestBody.UpdateString("email[0].invalid_email","0")
$jsonRequestBody.UpdateString("email[0].opt_out","0")
$jsonRequestBody.UpdateString("email[1].email_address","rob@sugar.crm")
$jsonRequestBody.UpdateString("email[1].primary_address","0")
$jsonRequestBody.UpdateString("email[1].invalid_email","0")
$jsonRequestBody.UpdateString("email[1].opt_out","1")

$url = "http://<site url>/rest/v10/Contacts"

$http.SetRequestHeader("OAuth-Token","ACCESS_TOKEN")

$resp = $http.PText("POST",$url,$jsonRequestBody.Emit(),"utf-8","application/json",$false,$false)
if ($http.LastMethodSuccess -ne $true) {
    $($http.LastErrorText)
    exit
}

$("Response Status Code: " + $resp.StatusCode)

$jsonResponse = New-Object Chilkat.JsonObject
$jsonResponse.Load($resp.BodyStr)
$jsonResponse.EmitCompact = $false
$($jsonResponse.Emit())

if ($resp.StatusCode -ge 300) {
    $("Failed.")

    exit
}