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

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

...

procedure TForm1.Button1Click(Sender: TObject);
var
http: TChilkatHttp;
jsonRequestBody: TChilkatJsonObject;
url: WideString;
resp: IChilkatHttpResponse;
jsonResponse: TChilkatJsonObject;

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

http := TChilkatHttp.Create(Self);

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 := TChilkatJsonObject.Create(Self);
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',0,0);
if (http.LastMethodSuccess <> 1) then
  begin
    Memo1.Lines.Add(http.LastErrorText);
    Exit;
  end;

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

jsonResponse := TChilkatJsonObject.Create(Self);
jsonResponse.Load(resp.BodyStr);
jsonResponse.EmitCompact := 0;
Memo1.Lines.Add(jsonResponse.Emit());

if (resp.StatusCode >= 300) then
  begin
    Memo1.Lines.Add('Failed.');

    Exit;
  end;
end;