Codeunit 7102 Contact Sync Processor

Base Application, Microsoft.CRM.Outlook

src/Layers/W1/BaseApp/CRM/Outlook/ContactSyncProcessor.Codeunit.al407 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.CRM.Outlook;using Microsoft.CRM.Contact;codeunit 7102 "Contact Sync Processor"{    var        SuppressUI: Boolean;        SyncSuccessLbl: Label '%1 contacts have been synchronized successfully.', Comment = '%1 = Number of synced contacts';        StartMsg: Label 'This can take a few minutes if you have many contacts.';        ContactAlreadyExistsLbl: Label 'Contact with this email already exists';        GraphBatchUriLbl: Label 'https://graph.microsoft.com/v1.0/$batch', Locked = true;        GraphContactFolderUrlLbl: Label '/me/contactFolders/%1/contacts', Comment = '%1 = Folder ID', Locked = true;        ContentTypeLbl: Label 'application/json', Locked = true;        AuthorizationLbl: Label 'Bearer %1', Comment = '%1 = Access token', Locked = true;        AcceptLbl: Label 'application/json', Locked = true;        GivenNameLbl: Label 'givenName', Locked = true;        SurnameLbl: Label 'surname', Locked = true;        DisplayNameLbl: Label 'displayName', Locked = true;        CompanyNameLbl: Label 'companyName', Locked = true;        MobilePhoneLbl: Label 'mobilePhone', Locked = true;        CategoriesLbl: Label 'categories', Locked = true;        EmailAddressesLbl: Label 'emailAddresses', Locked = true;        BusinessPhonesLbl: Label 'businessPhones', Locked = true;        AddressLbl: Label 'address', Locked = true;        EmailNameLbl: Label 'name', Locked = true;        BCCategoryLbl: Label 'Business Central', Locked = true;        JobTitleLbl: Label 'jobTitle', Locked = true;        FolderIdLbl: Label 'parentFolderId', Locked = true;        EmailPrimaryLbl: Label 'primaryEmailAddress', Locked = true;        InitialsLbl: Label 'initials', Locked = true;        CityLbl: Label 'city', Locked = true;        CountyLbl: Label 'state', Locked = true;        PostCodeLbl: Label 'postalCode', Locked = true;        CountryorRegionLbl: Label 'countryOrRegion', Locked = true;        BusinessAddressLbl: Label 'businessAddress', Locked = true;        BatchSize: Integer;        // Telemetry/Logging Messages        SyncStartedTxt: Label 'ProcessBidirectionalSync started with %1 queue entries : Sync Direction %2', Comment = '%1 = queue count, %2 = sync direction', Locked = true;        NoQueueEntriesTxt: Label 'No contacts in sync queue, exiting', Locked = true;        SyncingContactToLocalTxt: Label 'Syncing contact  from O365 to Business Central', Locked = true;        ContactSyncSuccessTxt: Label 'Contact  successfully synced to Business Central', Locked = true;        NoContactsToSyncMsg: Label 'No contacts were synchronized.', Locked = true;        ContactSyncFailedTxt: Label 'Failed to sync contact  to Business Central', Locked = true;        SyncCompletedTxt: Label 'Bidirectional sync completed. Total synced: %1', Comment = '%1 = number of synced contacts', Locked = true;        CategoryLbl: Label 'Contact Sync', Locked = true, Comment = 'Telemetry category name';        BatchRequestStartedTxt: Label 'Starting batch request with %1 contacts', Comment = '%1 = batch size', Locked = true;        BatchRequestCompletedTxt: Label 'Batch request completed with %1 successful, %2 failed', Comment = '%1 = success count, %2 = fail count', Locked = true;        BatchRequestFailedTxt: Label 'Batch request failed', Locked = true;        HttpStatusErrorLbl: Label 'HTTP Status: %1', Comment = '%1 = HTTP status code', Locked = true;        // Batch request JSON keys        BatchIdLbl: Label 'id', Locked = true;        BatchMethodLbl: Label 'method', Locked = true;        BatchUrlLbl: Label 'url', Locked = true;        BatchHeadersLbl: Label 'headers', Locked = true;        BatchBodyLbl: Label 'body', Locked = true;        BatchMethodPostLbl: Label 'POST', Locked = true;#if not CLEAN29    [Obsolete('Removed due to Contact Sync redesign, will be deleted in future release.', '29.0')]    procedure ProcessBidirectionalSync(var TempSyncQueue: Record "Contact Sync Queue" temporary; AccessToken: SecretText)    begin    end;#endif    procedure ProcessBidirectionalSync(var TempSyncQueue: Record "Contact Sync Queue" temporary; AccessToken: SecretText; FolderId: Text; SyncDirection: Enum "ContactSyncDirection")    var        TempBatchQueue: Record "Contact Sync Queue" temporary;        SyncedCount: Integer;        BatchCount: Integer;        ProgressDialog: Dialog;    begin        BatchSize := 20; // Microsoft Graph batch limit        Session.LogMessage('0000QSV', StrSubstNo(SyncStartedTxt, TempSyncQueue.Count(), Format(SyncDirection)), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryLbl);        if not TempSyncQueue.FindSet() then begin            Session.LogMessage('0000QSW', NoQueueEntriesTxt, Verbosity::Verbose, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryLbl);            exit;        end;        SyncedCount := 0;        BatchCount := 0;        if not SuppressUI then            ProgressDialog.Open(StartMsg);        repeat            case TempSyncQueue."Sync Direction" of                TempSyncQueue."Sync Direction"::"To BC":                    if (SyncDirection = SyncDirection::"Full Sync") then begin                        Session.LogMessage('0000QSX', StrSubstNo(SyncingContactToLocalTxt), Verbosity::Verbose, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryLbl);                        if SyncContactToBC(TempSyncQueue) then begin                            Session.LogMessage('0000QSY', StrSubstNo(ContactSyncSuccessTxt), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryLbl);                            TempSyncQueue."Sync Status" := TempSyncQueue."Sync Status"::Processed;                            SyncedCount += 1;                        end else begin                            Session.LogMessage('0000QSZ', StrSubstNo(ContactSyncFailedTxt), Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryLbl);                            TempSyncQueue."Sync Status" := TempSyncQueue."Sync Status"::Error;                        end;                        TempSyncQueue.Modify(false);                    end;                TempSyncQueue."Sync Direction"::"To M365":                    begin                        // Add to batch queue                        TempBatchQueue.TransferFields(TempSyncQueue);                        TempBatchQueue.Insert(false);                        BatchCount += 1;                        // Process batch when we reach 20 records or end of queue                        if BatchCount >= BatchSize then begin                            SyncedCount += ProcessBatchToO365(TempBatchQueue, TempSyncQueue, AccessToken, FolderId);                            TempBatchQueue.DeleteAll();                            BatchCount := 0;                        end;                    end;            end;        until TempSyncQueue.Next() = 0;        // Process remaining batch        if BatchCount > 0 then            SyncedCount += ProcessBatchToO365(TempBatchQueue, TempSyncQueue, AccessToken, FolderId);        if not SuppressUI then            ProgressDialog.Close();        Session.LogMessage('0000QT3', StrSubstNo(SyncCompletedTxt, SyncedCount), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryLbl);        if not SuppressUI then            if SyncedCount > 0 then                Message(SyncSuccessLbl, SyncedCount)            else                Message(NoContactsToSyncMsg);    end;    [NonDebuggable]    local procedure ProcessBatchToO365(var TempBatchQueue: Record "Contact Sync Queue" temporary; var TempSyncQueue: Record "Contact Sync Queue" temporary; AccessToken: SecretText; FolderId: Text): Integer    var        HttpClient: HttpClient;        HttpContent: HttpContent;        HttpResponse: HttpResponseMessage;        BatchRequest: JsonObject;        RequestsArray: JsonArray;        ResponseJson: JsonObject;        ResponsesArray: JsonArray;        ResponseToken: JsonToken;        BatchJsonText: Text;        ResponseText: Text;        Headers: HttpHeaders;        RequestId: Integer;        SuccessCount: Integer;        FailCount: Integer;        StatusCode: Integer;    begin        if not TempBatchQueue.FindSet() then            exit(0);        Session.LogMessage('0000QT8', StrSubstNo(BatchRequestStartedTxt, TempBatchQueue.Count()), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryLbl);        RequestId := 1;        repeat            RequestsArray.Add(BuildBatchRequestItem(TempBatchQueue, FolderId, RequestId));            RequestId += 1;        until TempBatchQueue.Next() = 0;        BatchRequest.Add('requests', RequestsArray);        BatchRequest.WriteTo(BatchJsonText);        HttpContent.WriteFrom(BatchJsonText);        HttpContent.GetHeaders(Headers);        Headers.Clear();        Headers.Add('Content-Type', ContentTypeLbl);        HttpClient.DefaultRequestHeaders.Add('Authorization', SecretStrSubstNo(AuthorizationLbl, AccessToken));        HttpClient.DefaultRequestHeaders.Add('Accept', AcceptLbl);        if not HttpClient.Post(GraphBatchUriLbl, HttpContent, HttpResponse) then begin            // Mark all as error            TempBatchQueue.SetLoadFields("Sync Status", "Error Message");            if TempBatchQueue.FindSet() then                repeat                    if TempSyncQueue.Get(TempBatchQueue."Entry No.") then begin                        TempSyncQueue."Sync Status" := TempSyncQueue."Sync Status"::Error;                        TempSyncQueue."Error Message" := BatchRequestFailedTxt;                        TempSyncQueue.Modify(false);                    end;                until TempBatchQueue.Next() = 0;            exit(0);        end;        HttpResponse.Content.ReadAs(ResponseText);        ResponseJson.ReadFrom(ResponseText);        // Process batch responses        SuccessCount := 0;        FailCount := 0;        if ResponseJson.Get('responses', ResponseToken) then begin            ResponsesArray := ResponseToken.AsArray();            TempBatchQueue.FindSet();            RequestId := 1;            repeat                if GetBatchResponseStatus(ResponsesArray, RequestId, StatusCode) then                    if TempSyncQueue.Get(TempBatchQueue."Entry No.") then begin                        if (StatusCode >= 200) and (StatusCode < 300) then begin                            TempSyncQueue."Sync Status" := TempSyncQueue."Sync Status"::Processed;                            SuccessCount += 1;                        end else begin                            TempSyncQueue."Sync Status" := TempSyncQueue."Sync Status"::Error;                            TempSyncQueue."Error Message" := StrSubstNo(HttpStatusErrorLbl, StatusCode);                            FailCount += 1;                        end;                        TempSyncQueue.Modify(false);                    end;                RequestId += 1;            until TempBatchQueue.Next() = 0;        end;        Session.LogMessage('0000QT9', StrSubstNo(BatchRequestCompletedTxt, SuccessCount, FailCount), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryLbl);        exit(SuccessCount);    end;    local procedure BuildBatchRequestItem(Contact: Record "Contact Sync Queue"; FolderId: Text; RequestId: Integer): JsonObject    var        RequestItem: JsonObject;        HeadersObject: JsonObject;        BodyObject: JsonObject;        BodyText: Text;    begin        BodyText := BuildContactJsonBody(Contact, FolderId);        BodyObject.ReadFrom(BodyText);        RequestItem.Add(BatchIdLbl, Format(RequestId));        RequestItem.Add(BatchMethodLbl, BatchMethodPostLbl);        RequestItem.Add(BatchUrlLbl, StrSubstNo(GraphContactFolderUrlLbl, FolderId));        HeadersObject.Add('Content-Type', ContentTypeLbl);        RequestItem.Add(BatchHeadersLbl, HeadersObject);        RequestItem.Add(BatchBodyLbl, BodyObject);        exit(RequestItem);    end;    local procedure GetBatchResponseStatus(ResponsesArray: JsonArray; RequestId: Integer; var StatusCode: Integer): Boolean    var        ResponseToken: JsonToken;        ResponseObject: JsonObject;        IdToken: JsonToken;        StatusToken: JsonToken;        i: Integer;    begin        // Responses are typically returned in the same order as requests        // Try direct index access first (RequestId is 1-based, array is 0-based)        if ResponsesArray.Get(RequestId - 1, ResponseToken) then begin            ResponseObject := ResponseToken.AsObject();            if ResponseObject.Get('id', IdToken) then                if IdToken.AsValue().AsText() = Format(RequestId) then                    if ResponseObject.Get('status', StatusToken) then begin                        StatusCode := StatusToken.AsValue().AsInteger();                        exit(true);                    end;        end;        // Fallback to linear search if direct access didn't match (order not guaranteed)        for i := 0 to ResponsesArray.Count() - 1 do begin            ResponsesArray.Get(i, ResponseToken);            ResponseObject := ResponseToken.AsObject();            if ResponseObject.Get('id', IdToken) then                if IdToken.AsValue().AsText() = Format(RequestId) then                    if ResponseObject.Get('status', StatusToken) then begin                        StatusCode := StatusToken.AsValue().AsInteger();                        exit(true);                    end;        end;        exit(false);    end;    local procedure SyncContactToBC(var TempSyncQueue: Record "Contact Sync Queue" temporary): Boolean    var        Contact: Record Contact;    begin        // Check if contact already exists        Contact.Reset();        Contact.SetRange("E-Mail", CopyStr(TempSyncQueue."Email Address", 1, MaxStrLen(Contact."E-Mail")));        Contact.SetRange(Type, Contact.Type::Person);        if Contact.FindFirst() then begin            TempSyncQueue."Error Message" := ContactAlreadyExistsLbl;            exit(false); // Contact already exists        end;        // Create new contact in BC        Contact.Init();        Contact."No." := '';        Contact.Type := Contact.Type::Person;        if TempSyncQueue."Display Name" <> '' then            Contact.Name := CopyStr(TempSyncQueue."Display Name", 1, MaxStrLen(Contact.Name))        else            Contact.Name := CopyStr(TempSyncQueue."Given Name" + ' ' + TempSyncQueue.Surname, 1, MaxStrLen(Contact.Name));        Contact."First Name" := CopyStr(TempSyncQueue."Given Name", 1, MaxStrLen(Contact."First Name"));        Contact.Surname := CopyStr(TempSyncQueue.Surname, 1, MaxStrLen(Contact.Surname));        Contact."E-Mail" := CopyStr(TempSyncQueue."Email Address", 1, MaxStrLen(Contact."E-Mail"));        Contact."Job Title" := CopyStr(TempSyncQueue."Job Title", 1, MaxStrLen(Contact."Job Title"));        Contact."Company Name" := CopyStr(TempSyncQueue."Company Name", 1, MaxStrLen(Contact."Company Name"));        Contact."Phone No." := CopyStr(TempSyncQueue."Business Phone", 1, MaxStrLen(Contact."Phone No."));        Contact."Mobile Phone No." := CopyStr(TempSyncQueue."Mobile Phone", 1, MaxStrLen(Contact."Mobile Phone No."));        Contact.Address := CopyStr(TempSyncQueue.Address, 1, MaxStrLen(Contact.Address));        Contact.City := CopyStr(TempSyncQueue.City, 1, MaxStrLen(Contact.City));        Contact.County := CopyStr(TempSyncQueue.County, 1, MaxStrLen(Contact.County));        Contact."Post Code" := CopyStr(TempSyncQueue."Post Code", 1, MaxStrLen(Contact."Post Code"));        Contact."Country/Region Code" := CopyStr(TempSyncQueue."Country/Region Code", 1, MaxStrLen(Contact."Country/Region Code"));        if Contact.Insert(true) then begin            TempSyncQueue."BC Contact No." := Contact."No.";            exit(true);        end;        exit(false);    end;    local procedure BuildContactJsonBody(Contact: Record "Contact Sync Queue"; FolderId: Text): Text    var        JsonObject: JsonObject;        JsonText: Text;    begin        JsonObject.Add(GivenNameLbl, Contact."Given Name");        JsonObject.Add(SurnameLbl, Contact.Surname);        if Contact."Display Name" <> '' then            JsonObject.Add(DisplayNameLbl, Contact."Display Name")        else            JsonObject.Add(DisplayNameLbl, Contact."Given Name" + ' ' + Contact.Surname);        JsonObject.Add(CompanyNameLbl, Contact."Company Name");        JsonObject.Add(InitialsLbl, Contact.Initials);        JsonObject.Add(MobilePhoneLbl, Contact."Mobile Phone");        JsonObject.Add(JobTitleLbl, Contact."Job Title");        JsonObject.Add(CategoriesLbl, BuildCategoriesArray());        JsonObject.Add(FolderIdLbl, FolderId);        // Add email addresses        if Contact."Email Address" <> '' then            JsonObject.Add(EmailPrimaryLbl, BuildPrimaryEmailArray(Contact."Email Address"));        if Contact."Email 2" <> '' then            JsonObject.Add(EmailAddressesLbl, BuildEmailArray(Contact."Email 2"));        // Add business phones        if Contact."Business Phone" <> '' then            JsonObject.Add(BusinessPhonesLbl, BuildPhoneArray(Contact."Business Phone"));        JsonObject.Add(BusinessAddressLbl, BuildAddressObject(Contact));        JsonObject.WriteTo(JsonText);        exit(JsonText);    end;    local procedure BuildAddressObject(var Contact: Record "Contact Sync Queue"): JsonObject    var        AddressObject: JsonObject;    begin        AddressObject.Add(CityLbl, Contact.City);        AddressObject.Add(CountyLbl, Contact.County);        AddressObject.Add(PostCodeLbl, Contact."Post Code");        AddressObject.Add(CountryorRegionLbl, Contact."Country/Region Code");        exit(AddressObject);    end;    local procedure BuildEmailArray(EmailAddress: Text[80]): JsonArray    var        EmailArray: JsonArray;        EmailObject: JsonObject;    begin        EmailObject.Add(AddressLbl, EmailAddress);        EmailObject.Add(EmailNameLbl, EmailAddress);        EmailArray.Add(EmailObject);        exit(EmailArray);    end;    local procedure BuildPrimaryEmailArray(EmailAddress: Text[80]): JsonObject    var        EmailObject: JsonObject;    begin        EmailObject.Add(AddressLbl, EmailAddress);        EmailObject.Add(EmailNameLbl, EmailAddress);        exit(EmailObject);    end;    local procedure BuildPhoneArray(PhoneNo: Text[30]): JsonArray    var        PhoneArray: JsonArray;    begin        PhoneArray.Add(PhoneNo);        exit(PhoneArray);    end;    local procedure BuildCategoriesArray(): JsonArray    var        CategoriesArray: JsonArray;    begin        CategoriesArray.Add(BCCategoryLbl);        exit(CategoriesArray);    end;    /// <summary>    /// Suppresses UI elements (dialogs and messages) during execution.    /// Use this method in test scenarios to prevent unexpected UI prompts.    /// </summary>    /// <param name="Suppress">Set to true to suppress UI elements.</param>    procedure SetSuppressUI(Suppress: Boolean)    begin        SuppressUI := Suppress;    end;    /// <summary>    /// Returns whether UI suppression is currently enabled.    /// </summary>    /// <returns>True if UI is suppressed, false otherwise.</returns>    procedure IsSuppressUI(): Boolean    begin        exit(SuppressUI);    end;}