Codeunit 5345 Integration Rec. Synch. Invoke
src/Layers/W1/BaseApp/Integration/SynchEngine/IntegrationRecSynchInvoke.Codeunit.al838 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Integration.SyncEngine;using Microsoft.Finance.Dimension;using Microsoft.Integration.Dataverse;using System.IO;codeunit 5345 "Integration Rec. Synch. Invoke"{ trigger OnRun() begin CheckContext(); SynchRecord( IntegrationTableMappingContext, SourceRecordRefContext, DestinationRecordRefContext, IntegrationRecordSynchContext, SynchActionContext, IgnoreSynchOnlyCoupledRecordsContext, JobIdContext, IntegrationTableConnectionTypeContext); end; var IntegrationTableMappingContext: Record "Integration Table Mapping"; IntegrationRecordSynchContext: Codeunit "Integration Record Synch."; SourceRecordRefContext: RecordRef; DestinationRecordRefContext: RecordRef; IntegrationTableConnectionTypeContext: TableConnectionType; JobIdContext: Guid; SynchActionType: Option "None",Insert,Modify,ForceModify,IgnoreUnchanged,Fail,Skip,Delete,Uncouple,Couple; SourceAndDestinationConflictErr: Label 'Cannot update a record in the %2 table. The mapping between %3 field on the %1 table and the %4 field on the %2 table is bi-directional, and one or both values have changed since the last synchronization.', Comment = '%1 = Source record table caption, %2 = destination table caption, %3 = source field caption, %4 = destination field caption'; ModifyFailedErr: Label 'Modifying %1 failed because of the following error: %2.', Comment = '%1 = Table Caption, %2 = Error from modify process.'; ModifyFailedSimpleErr: Label 'Modifying %1 failed.', Comment = '%1 = Table Caption'; ConfigurationTemplateNotFoundErr: Label 'The %1 %2 was not found.', Comment = '%1 = Configuration Template table caption, %2 = Configuration Template Name';#pragma warning disable AA0470 CoupledRecordIsDeletedErr: Label 'The %1 record cannot be updated because it is coupled to a deleted record.', Comment = '1% = Source Table Caption';#pragma warning restore AA0470 CopyDataErr: Label 'The data could not be updated because of the following error: %1.', Comment = '%1 = Error message from transferdata process.'; SynchActionContext: Option; IgnoreSynchOnlyCoupledRecordsContext: Boolean; IsContextInitialized: Boolean; ContextErr: Label 'The integration record synchronization context has not been initialized.'; CategoryTok: Label 'AL Dataverse Integration', Locked = true; SyncConflictResolvedTxt: Label 'Synchronization conflict has been resolved as no one changed bidirectional field was detected. Fields modified: %1, additional fields modified: %2.', Locked = true; SyncConflictNotResolvedTxt: Label 'Synchronization conflict has not been resolved as a changed bidirectional field was detected. Field mapping: %1, %2, %3 -> %4.', Locked = true; procedure SetContext(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef; IntegrationRecordSynch: Codeunit "Integration Record Synch."; SynchAction: Option; IgnoreSynchOnlyCoupledRecords: Boolean; JobId: Guid; IntegrationTableConnectionType: TableConnectionType) begin IntegrationTableMappingContext := IntegrationTableMapping; IntegrationRecordSynchContext := IntegrationRecordSynch; SourceRecordRefContext := SourceRecordRef; DestinationRecordRefContext := DestinationRecordRef; SynchActionContext := SynchAction; IgnoreSynchOnlyCoupledRecordsContext := IgnoreSynchOnlyCoupledRecords; IntegrationTableConnectionTypeContext := IntegrationTableConnectionType; JobIdContext := JobId; IsContextInitialized := true; end; procedure GetContext(var IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var IntegrationRecordSynch: Codeunit "Integration Record Synch."; var SynchAction: Option) begin CheckContext(); IntegrationTableMapping := IntegrationTableMappingContext; IntegrationRecordSynch := IntegrationRecordSynchContext; SourceRecordRef := SourceRecordRefContext; DestinationRecordRef := DestinationRecordRefContext; SynchAction := SynchActionContext; end; procedure WasModifiedAfterLastSynch(IntegrationTableMapping: Record "Integration Table Mapping"; RecordRef: RecordRef): Boolean var IntegrationRecordManagement: Codeunit "Integration Record Management"; LastModifiedOn: DateTime; begin LastModifiedOn := GetRowLastModifiedOn(IntegrationTableMapping, RecordRef); if IntegrationTableMapping."Integration Table ID" = RecordRef.Number() then exit( IntegrationRecordManagement.IsModifiedAfterIntegrationTableRecordLastSynch( IntegrationTableConnectionTypeContext, RecordRef.Field(IntegrationTableMapping."Integration Table UID Fld. No.").Value(), IntegrationTableMapping."Table ID", LastModifiedOn)); exit( IntegrationRecordManagement.IsModifiedAfterRecordLastSynch( IntegrationTableConnectionTypeContext, RecordRef, LastModifiedOn)); end; procedure GetRowLastModifiedOn(IntegrationTableMapping: Record "Integration Table Mapping"; FromRecordRef: RecordRef): DateTime var ModifiedFieldRef: FieldRef; begin if FromRecordRef.Number() = IntegrationTableMapping."Integration Table ID" then begin ModifiedFieldRef := FromRecordRef.Field(IntegrationTableMapping."Int. Tbl. Modified On Fld. No."); exit(ModifiedFieldRef.Value()); end; ModifiedFieldRef := FromRecordRef.Field(FromRecordRef.SystemModifiedAtNo()); exit(ModifiedFieldRef.Value()); end; local procedure CheckContext() begin if not IsContextInitialized then Error(ContextErr); end; local procedure SynchRecord(var IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var IntegrationRecordSynch: Codeunit "Integration Record Synch."; var SynchAction: Option; IgnoreSynchOnlyCoupledRecords: Boolean; JobId: Guid; IntegrationTableConnectionType: TableConnectionType) var TempTempIntegrationFieldMapping: Record "Temp Integration Field Mapping" temporary; AdditionalFieldsModified: Boolean; SourceWasChanged: Boolean; WasModified: Boolean; IsHandled: Boolean; BothModified: Boolean; UpdateConflictHandled: Boolean; SkipRecord: Boolean; RecordState: Option NotFound,Coupled,Decoupled; SourceFieldName: Text; SourceFieldCaption: Text; DestinationFieldName: Text; DestinationFieldCaption: Text; IsDestinationDeleted: Boolean; begin // Find the coupled record or prepare a new one RecordState := GetCoupledRecord( IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, SynchAction, IsDestinationDeleted, JobId, IntegrationTableConnectionType); if RecordState = RecordState::NotFound then begin if SynchAction = SynchActionType::Fail then exit; if IsDestinationDeleted or (IntegrationTableMapping."Synch. Only Coupled Records" and not IgnoreSynchOnlyCoupledRecords) then begin SynchAction := SynchActionType::Skip; exit; end; PrepareNewDestination(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef); SynchAction := SynchActionType::Insert; end; if SynchAction = SynchActionType::Insert then SourceWasChanged := true else begin OnWasModifiedAfterLastSynch(IntegrationTableConnectionTypeContext, IntegrationTableMapping, SourceRecordRef, SourceWasChanged, IsHandled); if not IsHandled then SourceWasChanged := WasModifiedAfterLastSynch(IntegrationTableMapping, SourceRecordRef); if SynchAction <> SynchActionType::ForceModify then if SourceWasChanged then begin if IntegrationTableMapping.GetDirection() = IntegrationTableMapping.Direction::Bidirectional then BothModified := WasModifiedAfterLastSynch(IntegrationTableMapping, DestinationRecordRef); end else SynchAction := SynchActionType::IgnoreUnchanged; end; if not (SynchAction in [SynchActionType::Insert, SynchActionType::Modify, SynchActionType::ForceModify]) then begin if SynchAction = SynchActionType::IgnoreUnchanged then OnBeforeIgnoreUnchangedRecordHandled(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef); exit; end; if SourceWasChanged or (SynchAction = SynchActionType::ForceModify) then TransferFields( IntegrationRecordSynch, IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, SynchAction, AdditionalFieldsModified, JobId, BothModified); if BothModified then begin if IntegrationRecordSynch.GetWasBidirectionalFieldModified() then begin IntegrationRecordSynch.GetBidirectionalFieldModifiedContext(TempTempIntegrationFieldMapping); OnUpdateConflictDetected(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, UpdateConflictHandled, SkipRecord); if not UpdateConflictHandled then begin if not GetFieldNameAndCaption(SourceRecordRef, TempTempIntegrationFieldMapping."Source Field No.", SourceFieldName, SourceFieldCaption) then begin SourceFieldName := Format(TempTempIntegrationFieldMapping."Source Field No."); SourceFieldCaption := SourceFieldName; end; if not GetFieldNameAndCaption(DestinationRecordRef, TempTempIntegrationFieldMapping."Destination Field No.", DestinationFieldName, DestinationFieldCaption) then begin DestinationFieldName := Format(TempTempIntegrationFieldMapping."Destination Field No."); DestinationFieldCaption := DestinationFieldName; end; Session.LogMessage('0000CTC', StrSubstNo(SyncConflictNotResolvedTxt, TempTempIntegrationFieldMapping."No.", TempTempIntegrationFieldMapping."Integration Table Mapping Name", SourceFieldName, DestinationFieldName), Verbosity::Normal, DataClassification::CustomerContent, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); SynchAction := SynchActionType::Fail; LogSynchError( SourceRecordRef, DestinationRecordRef, StrSubstNo(SourceAndDestinationConflictErr, SourceRecordRef.Caption(), DestinationRecordRef.Caption(), SourceFieldCaption, DestinationFieldCaption), JobId); MarkIntegrationRecordAsFailed(IntegrationTableMapping, SourceRecordRef, JobId, IntegrationTableConnectionType, SynchAction); exit; end; if SkipRecord then begin SynchAction := SynchActionType::Skip; exit; end; SynchAction := SynchActionType::ForceModify; end; Session.LogMessage('0000CTD', StrSubstNo(SyncConflictResolvedTxt, IntegrationRecordSynch.GetWasModified(), AdditionalFieldsModified), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; WasModified := IntegrationRecordSynch.GetWasModified() or AdditionalFieldsModified; if (SynchAction = SynchActionType::Modify) and (not WasModified) then SynchAction := SynchActionType::IgnoreUnchanged; case SynchAction of SynchActionType::Insert: InsertRecord( IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, SynchAction, JobId, IntegrationTableConnectionType); SynchActionType::Modify, SynchActionType::ForceModify: ModifyRecord( IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, SynchAction, JobId, IntegrationTableConnectionType, BothModified); SynchActionType::IgnoreUnchanged: begin UpdateIntegrationRecordCoupling( IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, IntegrationTableConnectionType); OnAfterUnchangedRecordHandled(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef); UpdateIntegrationRecordTimestamp( IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, IntegrationTableConnectionType, JobId); end; end; end; [TryFunction] local procedure GetFieldNameAndCaption(RecRef: RecordRef; FieldNo: Integer; var FieldName: Text; var FieldCaption: Text) begin if RecRef.FieldExist(FieldNo) then begin FieldName := RecRef.Field(FieldNo).Name(); FieldCaption := RecRef.Field(FieldNo).Caption(); end else begin FieldName := Format(FieldNo); FieldCaption := FieldName; end; end; local procedure InsertRecord(var IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var SynchAction: Option; JobId: Guid; IntegrationTableConnectionType: TableConnectionType) var CRMIntegrationManagement: Codeunit "CRM Integration Management"; InsertWithSystemId: Boolean; begin OnBeforeInsertRecord(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, InsertWithSystemId); if InsertWithSystemId then InsertWithSystemId := CRMIntegrationManagement.IsCRMTable(SourceRecordRef.Number()); DestinationRecordRef.Insert(true, InsertWithSystemId); ApplyConfigTemplate(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, JobId, SynchAction); OnInsertRecordOnAfterApplyConfigTemplate(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef); if SynchAction <> SynchActionType::Fail then begin UpdateIntegrationRecordCoupling( IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, IntegrationTableConnectionType); Commit(); OnAfterInsertRecord(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef); if DestinationRecordRef.Number() = IntegrationTableMapping."Table ID" then // refetch the local record as subscribers to the OnAfterInsertRecord above could update it if DestinationRecordRef.GetBySystemId(DestinationRecordRef.Field(DestinationRecordRef.SystemIdNo).Value()) then; UpdateIntegrationRecordTimestamp( IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, IntegrationTableConnectionType, JobId); end; Commit(); end; local procedure ModifyRecord(var IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var SynchAction: Option; JobId: Guid; IntegrationTableConnectionType: TableConnectionType; BothModified: Boolean) var LastError: Text; LogError: Text; begin OnBeforeModifyRecord(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef); if DestinationRecordRef.Modify(true) then begin UpdateIntegrationRecordCoupling( IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, IntegrationTableConnectionType); OnAfterModifyRecord(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef); if DestinationRecordRef.Number() = IntegrationTableMapping."Table ID" then // refetch the local record as subscribers to the OnAfterModifyRecord above could update it // for example, this is the case while synching customers and vendors if DestinationRecordRef.GetBySystemId(DestinationRecordRef.Field(DestinationRecordRef.SystemIdNo).Value()) then; UpdateIntegrationRecordTimestamp( IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, IntegrationTableConnectionType, JobId, BothModified); end else begin LastError := GetLastErrorText(); OnErrorWhenModifyingRecord(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef); SynchAction := SynchActionType::Fail; if LastError <> '' then LogError := StrSubstNo(ModifyFailedErr, DestinationRecordRef.Caption(), RemoveTrailingDots(LastError)) else LogError := StrSubstNo(ModifyFailedSimpleErr, DestinationRecordRef.Caption()); LogSynchError(SourceRecordRef, DestinationRecordRef, LogError, JobId); MarkIntegrationRecordAsFailed(IntegrationTableMapping, SourceRecordRef, JobId, IntegrationTableConnectionType, SynchAction); end; Commit(); end; local procedure ApplyConfigTemplate(var IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; JobId: Guid; var SynchAction: Option) var ConfigTemplateHeader: Record "Config. Template Header"; ConfigTemplateManagement: Codeunit "Config. Template Management"; ConfigTemplateCode: Code[10]; Handled: Boolean; begin OnBeforeDetermineConfigTemplateCode(IntegrationTableMapping, ConfigTemplateCode, Handled); if not Handled then if DestinationRecordRef.Number() = IntegrationTableMapping."Integration Table ID" then ConfigTemplateCode := FindIntTableConfigTemplate(IntegrationTableMapping, SourceRecordRef) else ConfigTemplateCode := FindTableConfigTemplate(IntegrationTableMapping, SourceRecordRef); if ConfigTemplateCode <> '' then begin OnBeforeApplyRecordTemplate(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, ConfigTemplateCode); if ConfigTemplateHeader.Get(ConfigTemplateCode) then begin ConfigTemplateManagement.UpdateRecord(ConfigTemplateHeader, DestinationRecordRef); if DestinationRecordRef.Number() <> IntegrationTableMapping."Integration Table ID" then InsertDimensionsFromTemplate(ConfigTemplateHeader, DestinationRecordRef); OnAfterApplyRecordTemplate(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef); end else begin SynchAction := SynchActionType::Fail; LogSynchError( SourceRecordRef, DestinationRecordRef, StrSubstNo(ConfigurationTemplateNotFoundErr, ConfigTemplateHeader.TableCaption(), ConfigTemplateCode), JobId); end; end; end; local procedure InsertDimensionsFromTemplate(ConfigTemplateHeader: Record "Config. Template Header"; var DestinationRecordRef: RecordRef) var DimensionsTemplate: Record "Dimensions Template"; PrimaryKeyFieldRef: FieldRef; PrimaryKeyRef: KeyRef; begin PrimaryKeyRef := DestinationRecordRef.KeyIndex(1); if PrimaryKeyRef.FieldCount() <> 1 then exit; PrimaryKeyFieldRef := PrimaryKeyRef.FieldIndex(1); if PrimaryKeyFieldRef.Type() <> FieldType::Code then exit; DimensionsTemplate.InsertDimensionsFromTemplates(ConfigTemplateHeader, CopyStr(Format(PrimaryKeyFieldRef.Value()), 1, 20), DestinationRecordRef.Number); DestinationRecordRef.Get(DestinationRecordRef.RecordId()); end; local procedure GetCoupledRecord(var IntegrationTableMapping: Record "Integration Table Mapping"; var RecordRef: RecordRef; var CoupledRecordRef: RecordRef; var SynchAction: Option; var IsDestinationMarkedAsDeleted: Boolean; JobId: Guid; IntegrationTableConnectionType: TableConnectionType): Integer var DeletionConflictHandled: Boolean; SetSynchActionHandled: Boolean; RecordState: Option NotFound,Coupled,Decoupled; begin IsDestinationMarkedAsDeleted := false; RecordState := FindRecord( IntegrationTableMapping, RecordRef, CoupledRecordRef, IsDestinationMarkedAsDeleted, IntegrationTableConnectionType); if RecordState <> RecordState::NotFound then if not IsDestinationMarkedAsDeleted then begin if RecordState = RecordState::Decoupled then SynchAction := SynchActionType::ForceModify; if SynchAction <> SynchActionType::ForceModify then SynchAction := SynchActionType::Modify; exit(RecordState); end; if SynchAction <> SynchActionType::ForceModify then if RecordState = RecordState::Coupled then begin OnDeletionConflictDetected(IntegrationTableMapping, RecordRef, DeletionConflictHandled); if not DeletionConflictHandled then OnDeletionConflictDetectedSetRecordStateAndSynchAction(IntegrationTableMapping, RecordRef, CoupledRecordRef, RecordState, SynchAction, DeletionConflictHandled); if not DeletionConflictHandled then begin RecordState := RecordState::NotFound; SynchAction := SynchActionType::Fail; LogSynchError(RecordRef, CoupledRecordRef, StrSubstNo(CoupledRecordIsDeletedErr, RecordRef.Caption), JobId); MarkIntegrationRecordAsFailed(IntegrationTableMapping, RecordRef, JobId, IntegrationTableConnectionType, SynchAction); end else case IntegrationTableMapping."Deletion-Conflict Resolution" of IntegrationTableMapping."Deletion-Conflict Resolution"::"Restore Records": begin PrepareNewDestination(IntegrationTableMapping, RecordRef, CoupledRecordRef); RecordState := RecordState::Coupled; SynchAction := SynchActionType::Insert; end; IntegrationTableMapping."Deletion-Conflict Resolution"::"Remove Coupling": begin RecordState := RecordState::Decoupled; SynchAction := SynchActionType::None; end; IntegrationTableMapping."Deletion-Conflict Resolution"::None: OnDeletionConflictSetSynchAction(IntegrationTableMapping, RecordRef, SynchAction, SetSynchActionHandled); end; end; exit(RecordState); end; internal procedure FindRecord(var IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var IsDestinationDeleted: Boolean; IntegrationTableConnectionType: TableConnectionType): Integer var IntegrationRecordManagement: Codeunit "Integration Record Management"; IDFieldRef: FieldRef; RecordIDValue: RecordID; RecordState: Option NotFound,Coupled,Decoupled; RecordFound: Boolean; Direction: Option; begin if IntegrationTableMapping.Direction <> IntegrationTableMapping.Direction::Bidirectional then Direction := IntegrationTableMapping.Direction else if SourceRecordRef.Number = IntegrationTableMapping."Table ID" then Direction := IntegrationTableMapping.Direction::ToIntegrationTable else Direction := IntegrationTableMapping.Direction::FromIntegrationTable; if Direction = IntegrationTableMapping.Direction::ToIntegrationTable then // NAV -> Integration Table synch RecordFound := FindIntegrationTableRecord( IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, IsDestinationDeleted, IntegrationTableConnectionType) else begin // Integration Table -> NAV synch IDFieldRef := SourceRecordRef.Field(IntegrationTableMapping."Integration Table UID Fld. No."); RecordFound := IntegrationRecordManagement.FindRecordIdByIntegrationTableUid( IntegrationTableConnectionType, IDFieldRef.Value, IntegrationTableMapping."Table ID", RecordIDValue); if RecordFound then IsDestinationDeleted := not DestinationRecordRef.Get(RecordIDValue); end; if RecordFound then exit(RecordState::Coupled); // If no explicit coupling is found, attempt to find a match based on user data if FindAndCoupleDestinationRecord( IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, IsDestinationDeleted, IntegrationTableConnectionType) then exit(RecordState::Decoupled); exit(RecordState::NotFound); end; internal procedure FindCoupledRecord(var IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var IsDestinationDeleted: Boolean; IntegrationTableConnectionType: TableConnectionType): Integer var IntegrationRecordManagement: Codeunit "Integration Record Management"; IDFieldRef: FieldRef; RecordIDValue: RecordID; RecordState: Option NotFound,Coupled,Decoupled; RecordFound: Boolean; begin if SourceRecordRef.Number = IntegrationTableMapping."Table ID" then RecordFound := FindIntegrationTableRecord(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, IsDestinationDeleted, IntegrationTableConnectionType) else begin IDFieldRef := SourceRecordRef.Field(IntegrationTableMapping."Integration Table UID Fld. No."); RecordFound := IntegrationRecordManagement.FindRecordIdByIntegrationTableUid(IntegrationTableConnectionType, IDFieldRef.Value, IntegrationTableMapping."Table ID", RecordIDValue); if RecordFound then IsDestinationDeleted := not DestinationRecordRef.Get(RecordIDValue); end; if RecordFound then exit(RecordState::Coupled); exit(RecordState::NotFound); end; local procedure FindAndCoupleDestinationRecord(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var DestinationIsDeleted: Boolean; IntegrationTableConnectionType: TableConnectionType) DestinationFound: Boolean begin OnFindUncoupledDestinationRecord( IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, DestinationIsDeleted, DestinationFound); if DestinationFound then begin UpdateIntegrationRecordCoupling( IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, IntegrationTableConnectionType); UpdateIntegrationRecordTimestamp( IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, IntegrationTableConnectionType, JobIdContext); end; end; local procedure FindIntegrationTableRecord(IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var IsDestinationDeleted: Boolean; IntegrationTableConnectionType: TableConnectionType) FoundDestination: Boolean var IntegrationRecordManagement: Codeunit "Integration Record Management"; IDValueVariant: Variant; begin FoundDestination := IntegrationRecordManagement.FindIntegrationTableUIdByRecordRef(IntegrationTableConnectionType, SourceRecordRef, IDValueVariant); if FoundDestination then IsDestinationDeleted := not IntegrationTableMapping.GetRecordRef(IDValueVariant, DestinationRecordRef); end; procedure PrepareNewDestination(var IntegrationTableMapping: Record "Integration Table Mapping"; var RecordRef: RecordRef; var CoupledRecordRef: RecordRef) begin CoupledRecordRef.Close(); if RecordRef.Number = IntegrationTableMapping."Table ID" then CoupledRecordRef.Open(IntegrationTableMapping."Integration Table ID") else CoupledRecordRef.Open(IntegrationTableMapping."Table ID"); CoupledRecordRef.Init(); end; local procedure LogSynchError(var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; ErrorMessage: Text; JobId: Guid) var IntegrationSynchJobErrors: Record "Integration Synch. Job Errors"; EmptyRecordID: RecordID; begin if DestinationRecordRef.Number = 0 then begin EmptyRecordID := SourceRecordRef.RecordId(); Clear(EmptyRecordID); IntegrationSynchJobErrors.LogSynchError(JobId, SourceRecordRef.RecordId(), EmptyRecordID, ErrorMessage) end else begin IntegrationSynchJobErrors.LogSynchError(JobId, SourceRecordRef.RecordId(), DestinationRecordRef.RecordId(), ErrorMessage); // Close destination - it is in error state and can no longer be used. DestinationRecordRef.Close(); end; end; [Scope('OnPrem')] procedure CheckTransferFields(var IntegrationRecordSynch: Codeunit "Integration Record Synch."; IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var FieldsModified: Boolean; var BidirectionalFieldsModified: Boolean) var CDSTransformationRuleMgt: Codeunit "CDS Transformation Rule Mgt."; AdditionalFieldsModified: Boolean; begin OnBeforeTransferRecordFields(SourceRecordRef, DestinationRecordRef); CDSTransformationRuleMgt.ApplyTransformations(SourceRecordRef, DestinationRecordRef, IntegrationTableMapping); IntegrationRecordSynch.SetParameters(SourceRecordRef, DestinationRecordRef, true); Commit(); if IntegrationRecordSynch.Run() then begin if IntegrationRecordSynch.GetWasModified() then FieldsModified := true; if IntegrationRecordSynch.GetWasBidirectionalFieldModified() then BidirectionalFieldsModified := true; if BidirectionalFieldsModified then exit; end; OnAfterTransferRecordFields(SourceRecordRef, DestinationRecordRef, AdditionalFieldsModified, true); if AdditionalFieldsModified then FieldsModified := true; end; local procedure TransferFields(var IntegrationRecordSynch: Codeunit "Integration Record Synch."; IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var SynchAction: Option; var AdditionalFieldsModified: Boolean; JobId: Guid; BothModified: Boolean) var CDSTransformationRuleMgt: Codeunit "CDS Transformation Rule Mgt."; begin OnBeforeTransferRecordFields(SourceRecordRef, DestinationRecordRef); CDSTransformationRuleMgt.ApplyTransformations(SourceRecordRef, DestinationRecordRef, IntegrationTableMapping); IntegrationRecordSynch.SetParameters(SourceRecordRef, DestinationRecordRef, SynchAction <> SynchActionType::Insert); if IntegrationRecordSynch.Run() then begin if BothModified and IntegrationRecordSynch.GetWasBidirectionalFieldModified() then exit; OnAfterTransferRecordFields(SourceRecordRef, DestinationRecordRef, AdditionalFieldsModified, SynchAction <> SynchActionType::Insert); end else begin SynchAction := SynchActionType::Fail; LogSynchError( SourceRecordRef, DestinationRecordRef, StrSubstNo(CopyDataErr, RemoveTrailingDots(GetLastErrorText)), JobId); MarkIntegrationRecordAsFailed(IntegrationTableMappingContext, SourceRecordRef, JobId, IntegrationTableConnectionTypeContext, SynchAction); Commit(); end; end; procedure MarkIntegrationRecordAsFailed(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; JobId: Guid; IntegrationTableConnectionType: TableConnectionType) var SynchAction: Option; begin SynchAction := SynchActionType::Fail; MarkIntegrationRecordAsFailed(IntegrationTableMapping, SourceRecordRef, JobId, IntegrationTableConnectionType, SynchAction); end; procedure MarkIntegrationRecordAsFailed(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; JobId: Guid; IntegrationTableConnectionType: TableConnectionType; ForceMarkAsSkipped: Boolean) var CRMIntegrationManagement: Codeunit "CRM Integration Management"; IntegrationRecordManagement: Codeunit "Integration Record Management"; DirectionToIntTable: Boolean; begin if IntegrationTableMapping.Type = IntegrationTableMapping.Type::Dataverse then if CRMIntegrationManagement.IsIntegrationRecordChild(IntegrationTableMapping."Table ID") then exit; DirectionToIntTable := IntegrationTableMapping.Direction = IntegrationTableMapping.Direction::ToIntegrationTable; IntegrationRecordManagement.MarkLastSynchAsFailure(IntegrationTableConnectionType, SourceRecordRef, DirectionToIntTable, JobId, ForceMarkAsSkipped); end; procedure MarkIntegrationRecordAsFailed(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; JobId: Guid; IntegrationTableConnectionType: TableConnectionType; var SyncAction: Option) var CRMIntegrationManagement: Codeunit "CRM Integration Management"; IntegrationRecordManagement: Codeunit "Integration Record Management"; DirectionToIntTable: Boolean; MarkedAsSkipped: Boolean; begin if IntegrationTableMapping.Type = IntegrationTableMapping.Type::Dataverse then if CRMIntegrationManagement.IsIntegrationRecordChild(IntegrationTableMapping."Table ID") then exit; DirectionToIntTable := IntegrationTableMapping.Direction = IntegrationTableMapping.Direction::ToIntegrationTable; MarkedAsSkipped := SyncAction = SynchActionType::Skip; IntegrationRecordManagement.MarkLastSynchAsFailure(IntegrationTableConnectionType, SourceRecordRef, DirectionToIntTable, JobId, MarkedAsSkipped); if MarkedAsSkipped then SyncAction := SynchActionType::Skip; end; local procedure UpdateIntegrationRecordCoupling(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef; IntegrationTableConnectionType: TableConnectionType) var IntegrationRecordManagement: Codeunit "Integration Record Management"; LocalRecordRef: RecordRef; IntegrationRecordRef: RecordRef; IntegrationTableUidFieldRef: FieldRef; IntegrationTableUid: Variant; IsHandled: Boolean; begin OnUpdateIntegrationRecordCoupling(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, IsHandled, IntegrationTableConnectionType); if IsHandled then exit; if SourceRecordRef.Number() = IntegrationTableMapping."Table ID" then begin LocalRecordRef := SourceRecordRef; IntegrationRecordRef := DestinationRecordRef; end else begin LocalRecordRef := DestinationRecordRef; IntegrationRecordRef := SourceRecordRef; end; IntegrationTableUidFieldRef := IntegrationRecordRef.Field(IntegrationTableMapping."Integration Table UID Fld. No."); IntegrationTableUid := IntegrationTableUidFieldRef.Value(); IntegrationRecordManagement.UpdateIntegrationTableCoupling( IntegrationTableConnectionType, IntegrationTableUid, LocalRecordRef); end; local procedure UpdateIntegrationRecordTimestamp(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef; IntegrationTableConnectionType: TableConnectionType; JobID: Guid) begin UpdateIntegrationRecordTimestamp(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, IntegrationTableConnectionType, JobID, false); end; local procedure UpdateIntegrationRecordTimestamp(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef; IntegrationTableConnectionType: TableConnectionType; JobID: Guid; BothModified: Boolean) var IntegrationRecordManagement: Codeunit "Integration Record Management"; CRMIntegrationManagement: Codeunit "CRM Integration Management"; LocalRecordRef: RecordRef; IntegrationRecordRef: RecordRef; IntegrationTableUidFieldRef: FieldRef; IntegrationTableUid: Variant; IntegrationTableModifiedOn: DateTime; LocalTableModifiedOn: DateTime; DirectionToIntTable: Boolean; IsHandled: Boolean; begin OnUpdateIntegrationRecordTimestamp(IntegrationTableMapping, SourceRecordRef, DestinationRecordRef, IntegrationTableConnectionType, JobID, BothModified, IsHandled); if IsHandled then exit; if IntegrationTableMapping.Type = IntegrationTableMapping.Type::Dataverse then if CRMIntegrationManagement.IsIntegrationRecordChild(IntegrationTableMapping."Table ID") then exit; DirectionToIntTable := SourceRecordRef.Number() = IntegrationTableMapping."Table ID"; if DirectionToIntTable then begin LocalRecordRef := SourceRecordRef; IntegrationRecordRef := DestinationRecordRef; end else begin LocalRecordRef := DestinationRecordRef; IntegrationRecordRef := SourceRecordRef; end; IntegrationTableUidFieldRef := IntegrationRecordRef.Field(IntegrationTableMapping."Integration Table UID Fld. No."); IntegrationTableUid := IntegrationTableUidFieldRef.Value(); IntegrationTableModifiedOn := GetRowLastModifiedOn(IntegrationTableMapping, IntegrationRecordRef); LocalTableModifiedOn := GetRowLastModifiedOn(IntegrationTableMapping, LocalRecordRef); if BothModified then // adjust time to let sync in back direction if DirectionToIntTable then IntegrationTableModifiedOn -= 999 else LocalTableModifiedOn -= 10; IntegrationRecordManagement.UpdateIntegrationTableTimestamp( IntegrationTableConnectionType, IntegrationTableUid, IntegrationTableModifiedOn, LocalRecordRef.Number(), LocalTableModifiedOn, JobID, IntegrationTableMapping.Direction); Commit(); end; local procedure RemoveTrailingDots(Message: Text): Text begin exit(DelChr(Message, '>', '.')); end; internal procedure FindTableConfigTemplate(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef): Code[10] var TableConfigTemplate: Record "Table Config Template"; SearchRecordRef: RecordRef; SearchFieldRef: FieldRef; TableConfigTemplateFilter: Text; begin if IntegrationTableMapping."Parent Name" <> '' then TableConfigTemplate.SetRange("Integration Table Mapping Name", IntegrationTableMapping."Parent Name") else TableConfigTemplate.SetRange("Integration Table Mapping Name", IntegrationTableMapping.Name); TableConfigTemplate.SetCurrentKey(Priority); TableConfigTemplate.SetAscending(Priority, true); if TableConfigTemplate.FindSet() then repeat TableConfigTemplateFilter := TableConfigTemplate.GetIntegrationTableFilter(); if TableConfigTemplateFilter = '' then exit(TableConfigTemplate."Table Config Template Code"); SearchRecordRef.Open(SourceRecordRef.Number); SearchRecordRef.SetView(TableConfigTemplateFilter); SearchFieldRef := SearchRecordRef.Field(IntegrationTableMapping."Integration Table UID Fld. No."); SearchFieldRef.SetRange(SourceRecordRef.Field(IntegrationTableMapping."Integration Table UID Fld. No.").Value()); if not SearchRecordRef.IsEmpty() then exit(TableConfigTemplate."Table Config Template Code"); SearchRecordRef.Close(); until TableConfigTemplate.Next() = 0; end; internal procedure FindIntTableConfigTemplate(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef): Code[10] var IntTableConfigTemplate: Record "Int. Table Config Template"; SearchRecordRef: RecordRef; SearchFieldRef: FieldRef; IntTableConfigTemplateFilter: Text; begin if IntegrationTableMapping."Parent Name" <> '' then IntTableConfigTemplate.SetRange("Integration Table Mapping Name", IntegrationTableMapping."Parent Name") else IntTableConfigTemplate.SetRange("Integration Table Mapping Name", IntegrationTableMapping.Name); IntTableConfigTemplate.SetCurrentKey(Priority); IntTableConfigTemplate.SetAscending(Priority, true); if IntTableConfigTemplate.FindSet() then repeat IntTableConfigTemplateFilter := IntTableConfigTemplate.GetTableFilter(); if IntTableConfigTemplateFilter = '' then exit(IntTableConfigTemplate."Int. Tbl. Config Template Code"); SearchRecordRef.Open(SourceRecordRef.Number); SearchRecordRef.SetView(IntTableConfigTemplateFilter); SearchFieldRef := SearchRecordRef.Field(SourceRecordRef.SystemIdNo); SearchFieldRef.SetRange(SourceRecordRef.Field(SourceRecordRef.SystemIdNo).Value()); if not SearchRecordRef.IsEmpty() then exit(IntTableConfigTemplate."Int. Tbl. Config Template Code"); SearchRecordRef.Close(); until IntTableConfigTemplate.Next() = 0; end; [IntegrationEvent(false, false)] local procedure OnUpdateConflictDetected(var IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var UpdateConflictHandled: Boolean; var SkipRecord: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnDeletionConflictDetected(var IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DeletionConflictHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnDeletionConflictSetSynchAction(var IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var SynchAction: Option "None",Insert,Modify,ForceModify,IgnoreUnchanged,Fail,Skip,Delete,Uncouple,Couple; var SetSynchActionHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnDeletionConflictDetectedSetRecordStateAndSynchAction(var IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var CoupledRecordRef: RecordRef; var RecordState: Option NotFound,Coupled,Decoupled; var SynchAction: Option "None",Insert,Modify,ForceModify,IgnoreUnchanged,Fail,Skip,Delete,Uncouple,Couple; var DeletionConflictHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeTransferRecordFields(SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef) begin end; [IntegrationEvent(false, false)] local procedure OnAfterTransferRecordFields(var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var AdditionalFieldsWereModified: Boolean; DestinationIsInserted: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeModifyRecord(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef) begin end; [IntegrationEvent(false, false)] local procedure OnAfterModifyRecord(IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef) begin end; [IntegrationEvent(false, false)] local procedure OnErrorWhenModifyingRecord(IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeInsertRecord(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var InsertWithSystemId: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterInsertRecord(IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef) begin end; [IntegrationEvent(false, false)] local procedure OnAfterUnchangedRecordHandled(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeApplyRecordTemplate(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var TemplateCode: Code[10]) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeDetermineConfigTemplateCode(IntegrationTableMapping: Record "Integration Table Mapping"; var TemplateCode: Code[10]; var Handled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterApplyRecordTemplate(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef) begin end; [IntegrationEvent(false, false)] local procedure OnFindUncoupledDestinationRecord(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var DestinationIsDeleted: Boolean; var DestinationFound: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnUpdateIntegrationRecordCoupling(IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var IsHandled: Boolean; IntegrationTableConnectionType: TableConnectionType) begin end; [IntegrationEvent(false, false)] local procedure OnWasModifiedAfterLastSynch(IntegrationTableConnectionType: TableConnectionType; IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var SourceWasChanged: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnUpdateIntegrationRecordTimestamp(IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; IntegrationTableConnectionType: TableConnectionType; JobID: Guid; BothModified: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeIgnoreUnchangedRecordHandled(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef) begin end; [IntegrationEvent(false, false)] local procedure OnInsertRecordOnAfterApplyConfigTemplate(IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordREf; var DestinationRecordRef: RecordRef) begin end;}