Delphi DLL

SugarCRM: Importing Email Addresses (New Records)

See more SugarCRM Examples

Demonstrates how to import a new contact with email addresses. Delphi 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
success: Boolean;
http: HCkHttp;
jsonRequestBody: HCkJsonObject;
url: PWideChar;
resp: HCkHttpResponse;
jsonResponse: HCkJsonObject;

begin
success := False;

// 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 := CkHttpResponse_Create();
success := CkHttp_HttpJson(http,'POST',url,jsonRequestBody,'application/json',resp);
if (success = False) 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.');
    Exit;
  end;

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

end;