(Delphi DLL) 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 for Delphi Downloads Chilkat non-ActiveX DLL for Delphi Chilkat ActiveX DLL for Delphi * The examples here use the non-ActiveX DLL.

uses
    Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
    Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Http, HttpResponse, JsonObject;

...

procedure TForm1.Button1Click(Sender: TObject);
var
http: HCkHttp;
jsonRequestBody: HCkJsonObject;
url: PWideChar;
resp: HCkHttpResponse;
jsonResponse: HCkJsonObject;

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

http := CkHttp_Create();

CkHttp_putAccept(http,'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 := CkJsonObject_Create();
CkJsonObject_UpdateString(jsonRequestBody,'first_name','Rob');
CkJsonObject_UpdateString(jsonRequestBody,'last_name','Robertson');
CkJsonObject_UpdateString(jsonRequestBody,'email[0].email_address','rob.robertson@sugar.crm');
CkJsonObject_UpdateString(jsonRequestBody,'email[0].primary_address','1');
CkJsonObject_UpdateString(jsonRequestBody,'email[0].invalid_email','0');
CkJsonObject_UpdateString(jsonRequestBody,'email[0].opt_out','0');
CkJsonObject_UpdateString(jsonRequestBody,'email[1].email_address','rob@sugar.crm');
CkJsonObject_UpdateString(jsonRequestBody,'email[1].primary_address','0');
CkJsonObject_UpdateString(jsonRequestBody,'email[1].invalid_email','0');
CkJsonObject_UpdateString(jsonRequestBody,'email[1].opt_out','1');

url := 'http://<site url>/rest/v10/Contacts';

CkHttp_SetRequestHeader(http,'OAuth-Token','ACCESS_TOKEN');

resp := CkHttp_PText(http,'POST',url,CkJsonObject__emit(jsonRequestBody),'utf-8','application/json',False,False);
if (CkHttp_getLastMethodSuccess(http) <> True) then
  begin
    Memo1.Lines.Add(CkHttp__lastErrorText(http));
    Exit;
  end;

Memo1.Lines.Add('Response Status Code: ' + IntToStr(CkHttpResponse_getStatusCode(resp)));

jsonResponse := CkJsonObject_Create();
CkJsonObject_Load(jsonResponse,CkHttpResponse__bodyStr(resp));
CkJsonObject_putEmitCompact(jsonResponse,False);
Memo1.Lines.Add(CkJsonObject__emit(jsonResponse));

if (CkHttpResponse_getStatusCode(resp) >= 300) then
  begin
    Memo1.Lines.Add('Failed.');
    CkHttpResponse_Dispose(resp);
    Exit;
  end;

CkHttpResponse_Dispose(resp);

CkHttp_Dispose(http);
CkJsonObject_Dispose(jsonRequestBody);
CkJsonObject_Dispose(jsonResponse);

end;