Codeunit 7201 CDS Integration Impl.
src/Layers/W1/BaseApp/Integration/Dataverse/CDSIntegrationImpl.Codeunit.al5,384 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.Dataverse;using Microsoft.CRM.Outlook;using Microsoft.CRM.Team;using Microsoft.Finance.Currency;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Integration.D365Sales;using Microsoft.Integration.SyncEngine;using Microsoft.Utilities;using System;using System.Azure.Identity;using System.Azure.KeyVault;using System.Environment;using System.Environment.Configuration;using System.Globalization;using System.Media;using System.Reflection;using System.Security.AccessControl;using System.Security.Authentication;using System.Threading;using System.Utilities;codeunit 7201 "CDS Integration Impl."{ SingleInstance = true; var CDSIntegrationMgt: Codeunit "CDS Integration Mgt."; EnvironmentInfo: Codeunit "Environment Information"; CachedCompanyIdFieldNo: Dictionary of [Integer, Integer]; CachedOwnerIdFieldNo: Dictionary of [Integer, Integer]; CachedOwnerTypeFieldNo: Dictionary of [Integer, Integer]; CachedOwningTeamCheckWithoutBusinessUnit: Dictionary of [Guid, Boolean]; CachedOwningTeamCheckWithBusinessUnit: Dictionary of [Guid, Boolean]; CachedOwningUserCheckWithoutBusinessUnit: Dictionary of [Guid, Boolean]; CachedOwningUserCheckWithBusinessUnit: Dictionary of [Guid, Boolean]; CachedCompanyId: Guid; CachedDefaultOwningTeamId: Guid; CachedOwningBusinessUnitId: Guid; AreCompanyValuesCached: Boolean; CategoryTok: Label 'AL Dataverse Integration', Locked = true; TimeoutTxt: Label 'timeout', Locked = true; RetryAfterTimeoutErr: Label 'The operation timed out. Try again.\\%1', Comment = '%1 - exception message '; IntegrationNotConfiguredTxt: Label 'Integration is not configured.', Locked = true; IntegrationDisabledTxt: Label 'Integration is disabled.', Locked = true; BusinessEventsDisabledTxt: Label 'Business Events are disabled.', Locked = true; NoPermissionsTxt: Label 'No permissions.', Locked = true; RebuildCouplingTableQst: Label 'You should run this action only if you have migrated your Business Central installation from version 2019 Wave 1 (version 14) to the Cloud.\To rebuild the coupling table you must upload a per-tenant extension to this Business Central environment.\Do you want to navigate to the location where the extension file is uploaded?'; RebuildCouplingTableExtensionLinkTxt: Label 'https://go.microsoft.com/fwlink/?linkid=2245902', Locked = true; UpdateSynchronizationSetupTxt: Label 'Update synchronization setup.', Locked = true; SynchronizationSetupUpdatedTxt: Label 'Synchronization setup has been updated.', Locked = true; UpdateBusinessEventsSetupTxt: Label 'Update business events setup.', Locked = true; BusinessEventsSetupUpdatedTxt: Label 'Business events setup has been updated.', Locked = true; ConnectionFailureTxt: Label 'Connection failure.', Locked = true; OwnerSetTxt: Label 'Owner has been set.', Locked = true; UnsupportedOwnerTypeTxt: Label 'Unsupported owner type.', Locked = true; EntityHasNoCompanyIdFieldTxt: Label 'Entity has no CompanyId field.', Locked = true; CompanyIdSetTxt: Label 'CompanyId has been set.', Locked = true; CompanyIdCheckedTxt: Label 'CompanyId check is succeed.', Locked = true; InitializeCompanyCacheTxt: Label 'Initialize company cache.', Locked = true; SetCachedOwningTeamCheckTxt: Label 'Set cache for team check. Team: %1, skip business unit check: %2.', Locked = true; SetCachedOwningUserCheckTxt: Label 'Set cache for user check. User: %1, skip business unit check: %2.', Locked = true; ClearCacheTxt: Label 'Clear cache.', Locked = true; CannotFindCompanyIdFieldErr: Label 'There is no CompanyId field in table %1 %2.', Comment = '%1 = table ID, %2 = table name'; CompanyIdDiffersFromExpectedTxt: Label 'CompanyId differs from the expected one.', Locked = true; SetDefaultOwningTeamTxt: Label 'Set default owning team.', Locked = true; TeamNotFoundTxt: Label 'Team has not been found.', Locked = true; UserNotFoundTxt: Label 'User has not been found.', Locked = true; UpdateUserNameTxt: Label 'Update integration user name.', Locked = true; UpdateUserEmailTxt: Label 'Update integration user email.', Locked = true; UserNameNotUpdatedTxt: Label 'Integration user name has not been updated.', Locked = true; UserEmailNotUpdatedTxt: Label 'Integration user email has not been updated.', Locked = true; CannotUpdateUserNameAndEmailTxt: Label 'Cannot update integration user name and email.', Locked = true; CoupledUsersNotFoundTxt: Label 'Coupled users have not been found.', Locked = true; BusinessUnitNotFoundTxt: Label 'Business unit has not been found.', Locked = true; BusinessUnitMismatchTxt: Label 'Business unit in BC does not match business unit in Dataverse.', Locked = true; CompanyNotFoundTxt: Label 'Company has not been found.', Locked = true; OrganizationNotFoundTxt: Label 'Organization has not been found.', Locked = true; CurrencyNotFoundTxt: Label 'Organization has not been found.', Locked = true; GLSetupNotFoundTxt: Label 'GL setup has not been found.', Locked = true; IntegrationRoleNotFoundTxt: Label 'Integration role has not been found.', Locked = true; IntegrationRoleNotAssignedToTeamTxt: Label 'Integration role is not assigned to team.', Locked = true; RoleNotFoundForBusinessUnitTxt: Label 'Integration role is not found for business unit.', Locked = true; TeamBusinessUnitDiffersFromSelectedTxt: Label 'Team business unit differs from the selected one.', Locked = true; CannotAssignRoleToUserTxt: Label 'Cannot assign role to user.', Locked = true; CannotAssignRoleToTeamTxt: Label 'Cannot assign role to team.', Locked = true; CannotAddUserToTeamTxt: Label 'Cannot add user to team.', Locked = true; ConnectionRequiredFieldsTxt: Label 'A URL, user name and password are required.', Locked = true; Office365ConnectionRequiredFieldsTxt: Label 'A URL is required.', Locked = true; ConnectionRequiredFieldsMismatchTxt: Label 'The URL, user name, password, and authentication type must be the same on the Dataverse Connection Setup and Microsoft Dynamics 365 Connection Setup pages.', Locked = true; IgnoredAdminCredentialsTxt: Label 'Ignored administrator credentials.', Locked = true; InvalidAdminCredentialsTxt: Label 'Invalid administrator credentials.', Locked = true; InvalidUserCredentialsTxt: Label 'Invalid user credentials.', Locked = true; ConfigureSolutionTxt: Label 'Import and configure integration solution.', Locked = true; ImportSolutionTxt: Label 'Import integration solution.', Locked = true; SolutionConfiguredTxt: Label 'Integration solution has been imported and configured.', Locked = true; SolutionNotInstalledTxt: Label 'Integration solution is not installed.', Locked = true; SolutionInstalledTxt: Label 'Integration solution is installed.', Locked = true; ConnectionNotRegisteredTxt: Label 'Connection is not registered.', Locked = true; IntegrationRequirementsMetTxt: Label 'Integration requirements are met.', Locked = true; DefaultOwningTeamSetTxt: Label 'Default owning team has been set.', Locked = true; CannotSetDefaultOwningTeamTxt: Label 'Cannot set default owning team.', Locked = true; BusinessUnitFixedTxt: Label 'Business unit has been fixed.', Locked = true; ConnectionTestSucceedTxt: Label 'Connection test succeed.', Locked = true; ConnectionTestFailedTxt: Label 'Connection test failed.', Locked = true; IntegrationRequirementsNotMetTxt: Label 'Integration requirements are not met.', Locked = true; SolutionRequirementsNotMetTxt: Label 'Integration solution requirements are not met.', Locked = true; IntegrationUserRequirementsNotMetTxt: Label 'Integration user requirements are not met.', Locked = true; OwningTeamRequirementsNotMetTxt: Label 'Owning team requirements are not met.', Locked = true; InvalidSolutionVersionTxt: Label 'Solution version is invalid.', Locked = true; OwnerDiffersFromExpectedTxt: Label 'Owner differs from the expected one.', Locked = true; SynchronizeCompanyTxt: Label 'Synchronize company entity.', Locked = true; CompanySynchronizedTxt: Label 'Company has been synchronized.', Locked = true; PreviousIntegrationUserRolesAddedTxt: Label 'Previous integration user security roles added to current integration user.', Locked = true; RoleAssignedToTeamTxt: Label 'Role is assigned to team.', Locked = true; RoleAssignedToUserTxt: Label 'Role is assigned to user.', Locked = true; UserAddedToTeamTxt: Label 'User is added to team.', Locked = true; CannotCreateBusinessUnitTxt: Label 'Cannot create business unit.', Locked = true; BusinessUnitCreatedTxt: Label 'Business unit has been created.', Locked = true; CannotCreateTeamTxt: Label 'Cannot create team.', Locked = true; TeamCreatedTxt: Label 'Team has been created.', Locked = true; CannotCreateCompanyTxt: Label 'Cannot create company.', Locked = true; CompanyCreatedTxt: Label 'Company has been created.', Locked = true; AddCoupledUsersToTeamTxt: Label 'Add coupled users to the default owning team.', Locked = true; AddingCoupledUsersToTeamMsg: Label 'Adding coupled users to the default owning team.\#1##############################', Comment = '#1 place holder for ProcessingUserMsg'; ProcessingUserMsg: Label 'Processing user %1 of %2.', Comment = '%1 - user number, %2 - user count'; SetUserAsIntegrationUserTxt: Label 'Set user as an integration user.', Locked = true; CannotSetUserAsIntegrationUserTxt: Label 'Cannot set user as an integration user.', Locked = true; UserAlreadySetAsIntegrationUserTxt: Label 'User has already been set as an integration user.', Locked = true; UserSetAsIntegrationUserTxt: Label 'User has been set as an integration user.', Locked = true; SetAccessModeToNonInteractiveTxt: Label 'Set the user''s access mode to Non-Interactive.', Locked = true; CannotSetAccessModeToNonInteractiveTxt: Label 'Cannot set the user''s access mode to Non-Interactive.', Locked = true; AccessModeAlreadySetToNonInteractiveTxt: Label 'The user''s access mode is already set to Non-Interactive.', Locked = true; AccessModeSetToNonInteractiveTxt: Label 'The access mode for the user specified for the integration is set to Non-Interactive.', Locked = true; AccessModeSetToNonInteractiveMsg: Label 'The access mode for the user specified for the integration is set to Non-Interactive.'; FindOrCreateIntegrationUserTxt: Label 'Find or create integration user.', Locked = true; CreatedIntegrationUserTxt: Label 'Create integration user with app id %1 on %2.', Locked = true; FoundNoIntegrationUserTxt: Label 'Found no user with application id %1 on %2. Injecting a new application user.', Locked = true; FoundOneIntegrationUserTxt: Label 'Found one user with application id %1 on %2.', Locked = true; FoundMoreThanOneIntegrationUserTxt: Label 'Found more than one user with application id %1 on %2.', Locked = true; FoundMoreThanOneIntegrationUserErr: Label 'There are two or more users with application id %1 on %2.\\You must make sure that there is only one user with application id %1 on %2.', Comment = '%1 - this is a Guid; %2 - this is a URL'; FailedToInsertApplicationUserErr: Label 'Inserting application user with application id %1 on %2 has failed.', Comment = '%1 - this is a Guid; %2 - this is a URL'; FailedToInsertApplicationUserTxt: Label 'Inserting application user with application id %1 on %2 has failed.', Locked = true; IntegrationUserFullNameTxt: Label 'Business Central Integration', Locked = true; IntegrationUserFirstNameTxt: Label 'Business Central', Locked = true; IntegrationUserLastNameTxt: Label 'Integration', Locked = true; IntegrationUserPrimaryEmailStartTxt: Label 'john', Locked = true; IntegrationUserPrimaryEmailEndTxt: Label '@contoso.com', Locked = true; IntegrationUserPrimaryEmailTxt: Label 'john%1@contoso.com', Locked = true; CompanyAlreadyExistsTxt: Label 'Company already exists.', Locked = true; BusinessUnitAlreadyExistsTxt: Label 'Business unit already exists.', Locked = true; TeamAlreadyExistsTxt: Label 'Team already exists.', Locked = true; CheckBusinessUnitTxt: Label 'Check business unit.', Locked = true; CheckOwningTeamTxt: Label 'Check owning team.', Locked = true; CheckTeamRolesTxt: Label 'Check team roles.', Locked = true; CheckCompanyTxt: Label 'Check company.', Locked = true; CreateCompanyTxt: Label 'Create company.', Locked = true; BusinessUnitCoupledTxt: Label 'Busness unit is correctly coupled.', Locked = true; SolutionVersionReceivedTxt: Label 'Solution version has been received.', Locked = true; CannotGetSolutionVersionTxt: Label 'Cannot get solution version.', Locked = true; CurrencyMismatchTxt: Label 'Your local currency code does not match any ISO Currency Code in the Dataverse currency table.', Locked = true; UserHasNoRolesTxt: Label 'User has no roles.', Locked = true; SystemAdminRoleTxt: Label 'The user is assigned to the system administrator role.', Locked = true; NoSystemAdminRoleTxt: Label 'The admin user is not assigned to the System Administrator role.', Locked = true; NoSystemCustomizerRoleTxt: Label 'The admin user is not assigned to the System Customizer role.', Locked = true; NoIntegrationRoleTxt: Label 'The user is not assigned to the integration role.', Locked = true; UserNotLicensedTxt: Label 'The user''s access mode is not Non-Interactive, but the user is not a licensed user.', Locked = true; UserNotActiveTxt: Label 'The user account is disabled.', Locked = true; NotIntegrationUserTxt: Label 'User is not an integration user.', Locked = true; NotNonInteractiveAccessModeTxt: Label 'The user''s access mode is not Non-Interactive.', Locked = true; InvalidAccessModeTxt: Label 'The user''s access mode is not Read-Write or Non-Interactive.', Locked = true; ClearDisabledReasonTxt: Label 'Clear disabled reason.', Locked = true; CannotCreateCompanyErr: Label 'Cannot create company %1.', Comment = '%1 = company name'; CannotCreateBusinessUnitErr: Label 'Cannot create business unit %1.', Comment = '%1 = business unit name'; CannotCreateTeamErr: Label 'Cannot create team %1 for business unit %2.', Comment = '%1 = team name, %2 = business unit name'; CannotSetDefaultOwningTeamErr: Label 'Cannot set default owning team.'; CannotFindOwnerIdFieldErr: Label 'There is no OwnerId field in table %1 %2.', Comment = '%1 = table ID, %2 = table name'; CannotFindOwnerTypeFieldErr: Label 'There is no OwnerIdType field in table %1 %2.', Comment = '%1 = table ID, %2 = table name'; CannotFindOrganizationErr: Label 'Cannot find organization in Dataverse.'; BaseCurrencyNotFoundErr: Label 'Cannot find base currency in Dataverse.'; GLSetupNotFoundErr: Label 'Cannot find GL setup.'; LCYCodeNotFoundErr: Label 'To enable the connection to Dataverse, you must specify the LCY Code in General Ledger Setup.'; CompanyNotFoundErr: Label 'There is no company with external ID %1 in Dataverse.', Comment = '%1 = company external ID'; TeamNotFoundErr: Label 'There is no team with ID %1 in Dataverse.', Comment = '%1 = team ID'; UserNotFoundErr: Label 'There is no user with ID %1 in Dataverse.', Comment = '%1 = system user ID'; RoleNotFoundErr: Label 'There is no role with ID %1 in Dataverse.', Comment = '%1 = role ID'; BusinessUnitNotFoundErr: Label 'There is no business unit with ID %1 in Dataverse.', Comment = '%1 = business unit ID'; BusinessUnitMismatchErr: Label 'Business unit in BC does not match the business unit in Dataverse.'; OwnerIdTypeErr: Label 'Owner type must be either team or systemuser.'; OwnerDiffersFromExpectedErr: Label 'Entity owner differs from the expected one.'; TeamBusinessUnitDiffersFromSelectedErr: Label 'Team business unit differs from the selected one.'; UserBusinessUnitDiffersFromSelectedErr: Label 'User business unit differs from the selected one.'; UserDoesNotExistErr: Label 'There is no user with email address %1 in Dataverse. Enter a valid email address.', Comment = '%1 = User email address'; IntegrationRoleNotFoundErr: Label 'There is no integration role %1 for business unit %2.', Comment = '%1 = role name, %2 = business unit name'; SolutionFileNotFoundErr: Label 'A file that is required to complete the setup could not be found. Expand the session details at the bottom of this error message and open a support request.'; IntegrationUserPasswordWrongErr: Label 'Enter valid integration user credentials.'; AdminUserPasswordWrongErr: Label 'Enter valid administrator credentials.'; GeneralFailureErr: Label 'The setup failed because of a generic error. You must sign in to the Dataverse organization with an account that has System Administrator role and make sure that another import or deletion of a PowerApps solution is not currently in progress.'; InvalidUriErr: Label 'The value entered is not a valid URL.'; MustUseHttpsErr: Label 'The application is set up to support secure connections (HTTPS) to the Dataverse environment only. You cannot use HTTP.'; ReplaceServerAddressQst: Label 'The URL is not valid. Do you want to replace it with the URL suggested below?\\Entered URL: "%1".\Suggested URL: "%2".', Comment = '%1 and %2 are URLs'; CDSConnectionURLWrongErr: Label 'The URL is incorrect. Enter the URL for the Dataverse environment.'; TemporaryConnectionPrefixTok: Label 'TEMP-Dataverse-', Locked = true; TestServerAddressTok: Label '@@test@@', Locked = true; NewBusinessUnitNameTemplateTok: Label '<New> %1', Comment = '%1 = Business unit name', Locked = true; BusinessUnitNameTemplateTok: Label '%1 (%2)', Comment = '%1 = Company name, %2 = Company ID', Locked = true; BusinessUnitNameSuffixTok: Label ' (%1)', Comment = '%1 = Company ID', Locked = true; TeamNameTemplateTok: Label 'BCI - %1', Comment = '%1 = Business unit name', Locked = true; OAuthConnectionStringFormatTxt: Label 'Url=%1; AccessToken=%2; ProxyVersion=%3; %4', Locked = true; ClientSecretConnectionStringFormatTxt: Label '%1; Url=%2; ClientId=%3; ClientSecret=%4; ProxyVersion=%5', Locked = true; CertificateConnectionStringFormatTxt: Label '%1; Url=%2; ClientId=%3; Certificate=%4; ProxyVersion=%5', Locked = true; ClientSecretAuthTxt: Label 'AuthType=ClientSecret', Locked = true; CertificateAuthTxt: Label 'AuthType=Certificate', Locked = true; ClientSecretTok: Label '{CLIENTSECRET}', Locked = true; CertificateTok: Label '{CERTIFICATE}', Locked = true; ClientIdTok: Label '{CLIENTID}', Locked = true; ConnectionStringFormatTok: Label 'Url=%1; UserName=%2; Password=%3; ProxyVersion=%4; %5', Locked = true; ConnectionDisabledNotificationMsg: Label 'Connection to Dataverse is broken and that it has been disabled due to an error: %1', Comment = '%1 = Error text received from Dataverse'; MultipleCompaniesNotificationMsg: Label 'There are multiple Business Central companies that are connected to this Dataverse environment. Check the checkbox ''Multi-Company Synchronization Enabled'' on each table mapping to optimize its filters for multi-company synchronization.'; MultipleCompaniesNotificationNameTxt: Label 'Suggest to optimize the setup for connecting multiple companies to one Dataverse environment.'; MultipleCompaniesNotificationDescriptionTxt: Label 'Suggests to open Integration Table Mappings and set up multi-company support for each table mapping.'; OpenIntegrationTableMappingsMsg: Label 'Open Integration Table Mappings'; LearnMoreTxt: Label 'Learn more'; MultipleCompanySynchHelpLinkTxt: Label 'https://go.microsoft.com/fwlink/?linkid=2237688', Locked = true; CDSConnectionSetupTitleTxt: Label 'Set up a connection to Dataverse'; CDSConnectionSetupShortTitleTxt: Label 'Connect to Dataverse'; CDSConnectionSetupHelpTxt: Label 'https://go.microsoft.com/fwlink/?linkid=2115257', Locked = true; CDSConnectionSetupDescriptionTxt: Label 'Connect to Dataverse for better insights across business applications. Data will flow between the apps for better productivity.', Comment = 'Dataverse is the name of a Microsoft Service and should not be translated'; BaseIntegrationSolutionNotInstalledErr: Label 'Base Dataverse integration solution %1 is not installed.', Comment = '%1 = Dataverse solution name'; SolutionVersionErr: Label 'Version of the base Dataverse integration solution %1 is not the last one.', Comment = '%1 = solution version'; SystemAdminErr: Label 'User %1 has the %2 role on server %3.\\You must choose a user that does not have the %2 role.', Comment = '%1 = user name, %2 = security role name, %3 = server address'; UserRolesErr: Label 'User %1 does not have the required roles on server %3.\\You must choose a user that has the role %2.', Comment = '%1 = user name, %2 = security role name, %3 = server address'; TeamRolesErr: Label 'Team %1 for business unit %2 does not have the required role %3.', Comment = '%1 = team name, %2 = business unit name, %3 = security role name'; CannotAssignRoleToTeamErr: Label 'Cannot assign role %3 to team %1 for business unit %2.', Comment = '%1 = team name, %2 = business unit name, %3 = security role name'; CannotAssignRoleToIntegrationUserErr: Label 'Cannot assign the integration role to the integration user.'; UserNotLicensedErr: Label 'User %1 with access mode %3 is not licensed on server %2.', Comment = '%1 = user name, %2 = server address, %3 = access mode'; UserNotActiveErr: Label 'User %1 is disabled on server %2.', Comment = '%1 = user name, %2 = server address'; NotIntegrationUserErr: Label 'User %1 is not an integration user on server %2.', Comment = '%1 = user name, %2 = server address'; NotNonInteractiveAccessModeErr: Label 'User %1 has invalid access mode %3 on server %2. Valid access mode is Non-Interactive.', Comment = '%1 = user name, %2 = server address, %3 = actual access mode'; InvalidAccessModeErr: Label 'User %1 has invalid access mode %3 on server %2. Valid access modes are Read-Write or Non-Interactive.', Comment = '%1 = user name, %2 = server address, %3 = actual access mode'; UserHasNoRolesErr: Label 'User %1 has no user roles assigned on server %2.', Comment = '%1 = user name, %2 = server address'; NoSystemAdminRoleErr: Label 'Admin user %1 is not assigned to the System Administrator role on server %2.', Comment = '%1 = user name, %2 = server address'; ConnectionRequiredFieldsErr: Label 'A URL, user name and password are required.'; Office365ConnectionRequiredFieldsErr: Label 'A URL is required.'; ConnectionRequiredFieldsMismatchErr: Label 'The values of the Server Address, User Name, User Password and Authentication Type fields must match the corresponding field values on the Microsoft Dynamics 365 Connection Setup page.'; ConnectionStringPwdPlaceHolderMissingErr: Label 'The connection string must include the password placeholder {PASSWORD}.'; UserNameMustIncludeDomainErr: Label 'The user name must include the domain when the authentication type is set to Active Directory.'; UserNameMustBeEmailErr: Label 'The user name must be a valid email address when the authentication type is set to Office 365.'; LCYMustMatchBaseCurrencyErr: Label 'Your local currency code %1 does not match any ISO Currency Code in the Dataverse currency table. To continue, make sure that the local currency code in General Ledger Setup complies with the ISO standard and create a currency in Dataverse currency table that uses it as ISO Currency Code.', Comment = '%1 - ISO currency code'; BaseCurrencyMustExistInBCErr: Label 'The base currency %1 of the Dataverse environment must exist in Business Central and it must have an exchange rate.', Comment = '%1 - ISO currency code'; UserSetupTxt: Label 'User Dataverse Setup'; CannotResolveUserFromConnectionSetupErr: Label 'The user that is specified in the Dataverse Connection Setup does not exist.'; MissingUsernameTok: Label '{USER}', Locked = true; MissingPasswordTok: Label '{PASSWORD}', Locked = true; SystemAdminRoleTemplateIdTxt: Label '627090ff-40a3-4053-8790-584edc5be201', Locked = true; SystemCustomizerRoleTemplateIdTxt: Label '119f245c-3cc8-4b62-b31c-d1a046ced15d', Locked = true; IntegrationRoleIdTxt: Label 'a2b18661-9ff5-e911-a812-000d3a0b9028', Locked = true; VirtualTablesIntegrationRoleIdTxt: Label 'd7dbad50-c0f6-4b30-81cf-d2158f1e7c06', Locked = true; ErrorNotificationIdTxt: Label '5e9ed8ec-dc7d-42b5-b7fc-da8c08cea60f', Locked = true; ConnectionDisabledNotificationIdTxt: Label 'db1b4430-99b7-48c4-94ba-0e4975353134', Locked = true; MultipleCompaniesNotificationIdTxt: Label 'e2416988-361b-4ad9-9409-8cfe161ce2f0', Locked = true; HideNotificationTxt: Label 'Don''t show again'; ConnectionDefaultNameTok: Label 'Dataverse', Locked = true; BaseSolutionUniqueNameTxt: Label 'bcbi_CdsBaseIntegration', Locked = true; BaseSolutionDisplayNameTxt: Label 'Business Central Dataverse Base Integration', Locked = true; TemporaryConnectionName: Text; CDSConnectionClientIdAKVSecretNameLbl: Label 'globaldisco-clientid', Locked = true; CDSConnectionFirstPartyAppIdAKVSecretNameLbl: Label 'bctocdsappid', Locked = true; CDSConnectionClientSecretAKVSecretNameLbl: Label 'globaldisco-clientsecret', Locked = true; CDSConnectionFirstPartyAppCertificateNameAKVSecretNameLbl: Label 'bctocdsappcertificatename', Locked = true; MissingClientIdOrSecretTelemetryTxt: Label 'The client id or client secret have not been initialized. This indicates that the tenant is not embed ISV. Other tenants will use cert auth instead.', Locked = true; MissingFirstPartyappIdOrCertificateTelemetryTxt: Label 'The first-party app id or certificate have not been initialized.', Locked = true; MissingClientIdOrSecretErr: Label 'The client id or client secret have not been initialized.'; MissingClientIdOrSecretOnPremErr: Label 'You must register an Microsoft Entra application that will be used to connect to the Dataverse environment and specify the application id, secret and redirect URL in the Dataverse Connection Setup page.', Comment = 'Dataverse and Microsoft Entra are names of a Microsoft service and a Microsoft Azure resource and should not be translated.'; AuthTokenOrCodeNotReceivedErr: Label 'No access token or authorization error code received.', Locked = true; AccessTokenNotReceivedErr: Label 'Failed to acquire an access token for %1.', Comment = '%1 URL to the Dataverse environment.'; GuiNotAllowedTxt: Label 'GUI not allowed, so acquiring the auth code through the interactive experience is not possible', Locked = true; FixPermissionsUrlTxt: Label 'https://go.microsoft.com/fwlink/?linkid=2206515', Locked = true; InsufficientPriviegesTxt: Label 'The Dataverse user has insufficient privileges to perform this task. Navigate to this link to read about how to add privileges to the user: %1', Comment = '%1 A URL'; AttemptingAuthCodeTokenWithCertTxt: Label 'Attempting to acquire a CDS access token via authorization code flow with a SNI certificate', Locked = true; AttemptingClientCredentialsTokenWithCertTxt: Label 'Attempting to acquire a CDS access token via client credentials flow with a SNI certificate', Locked = true; AttemptingAuthCodeTokenFromCacheWithCertTxt: Label 'Attempting to acquire a CDS access token via authorization code flow from cache, with a SNI certificate', Locked = true; AttemptingClientCredentialsTokenFromCacheWithCertTxt: Label 'Attempting to acquire a CDS access token via client credentials flow from cache, with a SNI certificate', Locked = true; AttemptingAuthCodeTokenWithClientSecretTxt: Label 'Attempting to acquire a CDS access token via authorization code flow with a client secret', Locked = true; AttemptingClientCredentialsTokenWithClientSecretTxt: Label 'Attempting to acquire a CDS access token via client credentials flow with a client secret', Locked = true; AttemptingAuthCodeTokenFromCacheWithClientSecretTxt: Label 'Attempting to acquire a CDS access token via authorization code flow from cache, with a client secret', Locked = true; AttemptingClientCredentialsTokenFromCacheWithClientSecretTxt: Label 'Attempting to acquire a CDS access token via client credentials flow from cache, with a client secret', Locked = true; SuccessfulJITProvisioningTelemetryMsg: Label 'Service principal successfully provisioned for tenant.', Locked = true; ConnectionStringEmptyTxt: Label 'Connection string is is empty.', Locked = true; VTEnableAppTxt: Label 'Enable Entra app: %1', Locked = true; VTConfigureNonProdTxt: Label 'Configure virtual tables in non-production.', Locked = true; VTEmptyTenantIdTxt: Label 'Tetant Id is empty.', Locked = true; VTEmptyAadUserIdTxt: Label 'User Id is empty.', Locked = true; VTRegisterConnectionTxt: Label 'Registering connection.', Locked = true; VTConnectionRegisteredTxt: Label 'Connection is registered.', Locked = true; VTConfigureProdTxt: Label 'Configure virtual tables in production.', Locked = true; VTConfigFoundTxt: Label 'Virtual tables configuration is found.', Locked = true; VTConfigNotFoundTxt: Label 'Virtual tables configuration is not found.', Locked = true; VTConfigureTxt: Label 'Configure virtual tables.', Locked = true; VTCannotConfigureTxt: Label 'Cannot configure virtual tables.', Locked = true; VTAlreadyConfiguredTxt: Label 'Virtual tables are already configured.', Locked = true; VTAlreadyConfiguredQst: Label 'Virtual tables are already configured.\\Do you want to overwrite the connection parameters with the new values?'; VTDiffTemplateTxt: Label '%1: %2 -> %3', Comment = '%1 - field caption, %2 - current value, %3 - new value'; VTDiffFoundTxt: Label 'The %1 value stored in the virtual tables config differs from the new value.', Locked = true; VTConfiguredTxt: Label 'Virtual Tables have been configured.', Locked = true; VTConfigNameTxt: Label 'Business Central', Locked = true; VTSolutionPrefixTxt: Label 'dyn365bc', Locked = true; VTSolutionNameTxt: Label 'MicrosoftBusinessCentralERPVE', Locked = true; VTCompanyNotFoundTxt: Label 'Company has not been found.', Locked = true; VTDeleteCompanyTxt: Label 'Delete existing companies with the same company code.', Locked = true; VTInsertConfigTxt: Label 'Create the virtual tables config.', Locked = true; VTModifyConfigTxt: Label 'Update the virtual tables config.', Locked = true; VTResetAuthHeaderTxt: Label 'Reset the authorization header in the virtual tables config.', Locked = true; VTSetEnvironmentTxt: Label 'Set environment in the virtual tables config.', Locked = true; VTSetTargetHostTxt: Label 'Set target host in the virtual tables config.', Locked = true; VTSetCompanyIdTxt: Label 'Set company id in the virtual tables config.', Locked = true; VTSetTenantIdTxt: Label 'Set tenant id in the virtual tables config.', Locked = true; VTSetAadUserIdTxt: Label 'Set user id in the virtual tables config.', Locked = true; VTAppNotInstalledTxt: Label 'The Business Central Virtual Table app is not installed in Dataverse. You must install the app from Microsoft Marketplace before you can enable business events.'; VTAppSourceLinkTxt: Label 'https://appsource.microsoft.com/%1/product/dynamics-365/microsoftdynsmb.businesscentral_virtualentity', Locked = true; CRMEntityUrlTemplateTxt: Label '%1/main.aspx?pagetype=entityrecord&etn=%2&id=%3', Locked = true; CRMEntityWithAppUrlTemplateTxt: Label '%1/main.aspx?appname=%2&pagetype=entityrecord&etn=%3&id=%4', Locked = true; CRMEntityListUrlTemplateTxt: Label '%1/main.aspx?pagetype=entitylist&etn=%2&navbar=on&cmdbar=true', Locked = true; CRMEntityListWithAppUrlTemplateTxt: Label '%1/main.aspx?appname=%2&pagetype=entitylist&etn=%3&navbar=on&cmdbar=true', Locked = true; UsingCustomIntegrationUsernameEmailTxt: Label 'Dataverse setup is using custom integration username email, specified via event subscriber.', Locked = true; EnableCDSVirtualTablesJobQueueDescriptionTxt: Label 'Enabling %1 Dataverse virtual table', Comment = '%1 - virtual table name'; EnableCDSVirtualTablesJobQueueCategoryTxt: Label 'VIRTUAL T'; VirtualTableAppNameTxt: Label 'dyn365bc_BusinessCentralConfiguration', Locked = true; SyntheticRelationEntityNameTxt: Label 'dyn365bc_syntheticrelation', Locked = true; InstallVirtualTablesAppLbl: Label 'Install Virtual Tables App'; RetrievingEntityMetadataTxt: Label 'Retrieving entity metadata for table %1.', Locked = true, Comment = '%1 - table external name'; RetrievingEntityFieldsTxt: Label 'Retrieving entity fields for table %1.', Locked = true, Comment = '%1 - table external name'; [Scope('OnPrem')] procedure GetBaseSolutionUniqueName(): Text begin exit(BaseSolutionUniqueNameTxt); end; [Scope('OnPrem')] procedure GetBaseSolutionDisplayName(): Text begin exit(BaseSolutionDisplayNameTxt); end; [Scope('OnPrem')] procedure IsConnectionActive(): Boolean begin exit(IsConnectionActive(GetConnectionDefaultName())); end; [Scope('OnPrem')] procedure IsConnectionActive(ConnectionName: Text): Boolean var CDSConnectionSetup: Record "CDS Connection Setup"; begin if not CDSConnectionSetup.Get() then exit(false); exit(IsConnectionActive(CDSConnectionSetup, ConnectionName)); end; local procedure IsConnectionActive(var CDSConnectionSetup: Record "CDS Connection Setup"; ConnectionName: Text): Boolean var ActiveConnectionName: Text; begin if not CDSConnectionSetup."Is Enabled" then exit(false); if not HasTableConnection(TABLECONNECTIONTYPE::CRM, ConnectionName) then exit(false); ActiveConnectionName := GetDefaultTableConnection(TABLECONNECTIONTYPE::CRM); if ConnectionName = ActiveConnectionName then exit(true); exit(false); end; [Scope('OnPrem')] procedure ActivateConnection(): Boolean begin exit(ActivateConnection(GetConnectionDefaultName())); end; [Scope('OnPrem')] procedure ActivateConnection(ConnectionName: Text): Boolean var CDSConnectionSetup: Record "CDS Connection Setup"; begin if not CDSConnectionSetup.Get() then exit(false); if not CDSConnectionSetup."Is Enabled" then exit(false); exit(ActivateConnection(CDSConnectionSetup, ConnectionName)); end; local procedure ActivateConnection(var CDSConnectionSetup: Record "CDS Connection Setup"; ConnectionName: Text): Boolean var ActiveConnectionName: Text; begin if IsConnectionActive(CDSConnectionSetup, ConnectionName) then exit(true); if not HasTableConnection(TABLECONNECTIONTYPE::CRM, ConnectionName) then exit(false); ActiveConnectionName := GetDefaultTableConnection(TABLECONNECTIONTYPE::CRM); if ConnectionName = ActiveConnectionName then exit(true); if not CDSConnectionSetup.IsTemporary() then CDSIntegrationMgt.OnBeforeActivateConnection(); SetDefaultTableConnection(TABLECONNECTIONTYPE::CRM, ConnectionName, false); if not CDSConnectionSetup.IsTemporary() then CDSIntegrationMgt.OnAfterActivateConnection(); exit(true); end; [Scope('OnPrem')] procedure HasConnection(): Boolean begin exit(HasConnection(GetConnectionDefaultName())); end; local procedure HasConnection(ConnectionName: Text): Boolean var CDSConnectionSetup: Record "CDS Connection Setup"; begin if not CDSConnectionSetup.Get() then exit(false); exit(HasConnection(CDSConnectionSetup, ConnectionName)); end; local procedure HasConnection(var CDSConnectionSetup: Record "CDS Connection Setup"; ConnectionName: Text): Boolean begin if not CDSConnectionSetup."Is Enabled" then exit(false); if HasTableConnection(TABLECONNECTIONTYPE::CRM, ConnectionName) then exit(true); exit(false); end; [Scope('OnPrem')] procedure RegisterConnection(): Boolean begin exit(RegisterConnection(true)); end; [Scope('OnPrem')] procedure RegisterConnection(KeepExisting: Boolean): Boolean var ConnectionName: Text; begin ConnectionName := GetConnectionDefaultName(); exit(RegisterConnection(ConnectionName, KeepExisting)); end; [Scope('OnPrem')] procedure RegisterConnection(ConnectionName: Text): Boolean begin exit(RegisterConnection(ConnectionName, false)); end; [Scope('OnPrem')] procedure RegisterConnection(ConnectionName: Text; KeepExisting: Boolean): Boolean var CDSConnectionSetup: Record "CDS Connection Setup"; begin if not CDSConnectionSetup.Get() then exit(false); if not CDSConnectionSetup."Is Enabled" then exit(false); exit(RegisterConnection(CDSConnectionSetup, ConnectionName, KeepExisting)); end; [Scope('OnPrem')] procedure RegisterConnection(var CDSConnectionSetup: Record "CDS Connection Setup"; KeepExisting: Boolean): Boolean var ConnectionName: Text; begin ConnectionName := GetConnectionDefaultName(); exit(RegisterConnection(CDSConnectionSetup, ConnectionName, KeepExisting)); end; [Scope('OnPrem')] procedure RegisterConnection(var CDSConnectionSetup: Record "CDS Connection Setup"; ConnectionName: Text): Boolean begin exit(RegisterConnection(CDSConnectionSetup, ConnectionName, false)); end; [Scope('OnPrem')] procedure RegisterConnection(var CDSConnectionSetup: Record "CDS Connection Setup"; ConnectionName: Text; KeepExisting: Boolean): Boolean var ConnectionString: SecretText; IsTemporary: Boolean; begin IsTemporary := CDSConnectionSetup.IsTemporary(); if not IsTemporary then if KeepExisting then if HasTableConnection(TABLECONNECTIONTYPE::CRM, ConnectionName) then exit(true); ConnectionString := GetConnectionStringWithCredentials(CDSConnectionSetup); if ConnectionString.IsEmpty() then begin Session.LogMessage('0000GES', ConnectionStringEmptyTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; if not UnregisterConnection(ConnectionName) then ClearLastError(); if not IsTemporary then CDSIntegrationMgt.OnBeforeRegisterConnection(); if not TryRegisterTableConnection(ConnectionName, ConnectionString) then exit(false); if not IsTemporary then CDSIntegrationMgt.OnAfterRegisterConnection(); exit(true); end; [TryFunction] [NonDebuggable] local procedure TryRegisterTableConnection(ConnectionName: Text; ConnectionString: SecretText) begin RegisterTableConnection(TABLECONNECTIONTYPE::CRM, ConnectionName, ConnectionString.Unwrap()); end; [Scope('OnPrem')] procedure UnregisterConnection(): Boolean begin exit(UnregisterConnection(GetConnectionDefaultName())); end; [TryFunction] [Scope('OnPrem')] procedure UnregisterConnection(ConnectionName: Text) var IsTemporary: Boolean; begin if not HasTableConnection(TableConnectionType::CRM, ConnectionName) then exit; IsTemporary := ConnectionName.StartsWith(TemporaryConnectionPrefixTok); if not IsTemporary then CDSIntegrationMgt.OnBeforeUnregisterConnection(); UnregisterTableConnection(TABLECONNECTIONTYPE::CRM, ConnectionName); if not IsTemporary then CDSIntegrationMgt.OnAfterUnregisterConnection(); end; [Scope('OnPrem')] procedure IsIntegrationEnabled(): Boolean var CDSConnectionSetup: Record "CDS Connection Setup"; IsDetailedLoggingEnabled: Boolean; begin CDSIntegrationMgt.OnGetDetailedLoggingEnabled(IsDetailedLoggingEnabled); if not CDSConnectionSetup.ReadPermission() then exit(false); if not CDSConnectionSetup.Get() then begin if IsDetailedLoggingEnabled then Session.LogMessage('0000ARI', IntegrationNotConfiguredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; if not CDSConnectionSetup."Is Enabled" then begin if IsDetailedLoggingEnabled then Session.LogMessage('0000ARJ', IntegrationDisabledTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; OnAfterIntegrationEnabled(); exit(true); end; [Scope('OnPrem')] procedure IsBusinessEventsEnabled(): Boolean var CDSConnectionSetup: Record "CDS Connection Setup"; IsDetailedLoggingEnabled: Boolean; begin CDSIntegrationMgt.OnGetDetailedLoggingEnabled(IsDetailedLoggingEnabled); if not CDSConnectionSetup.ReadPermission() then exit(false); if not CDSConnectionSetup.Get() then begin if IsDetailedLoggingEnabled then Session.LogMessage('0000GIE', IntegrationNotConfiguredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; if not CDSConnectionSetup."Business Events Enabled" then begin if IsDetailedLoggingEnabled then Session.LogMessage('0000GIF', BusinessEventsDisabledTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; exit(true); end; [Scope('OnPrem')] procedure IsTeamOwnershipModelSelected(): Boolean var CDSConnectionSetup: Record "CDS Connection Setup"; begin if IsIntegrationEnabled() then if CDSConnectionSetup.Get() then exit(CDSConnectionSetup."Ownership Model" = CDSConnectionSetup."Ownership Model"::Team); exit(false); end; [Scope('OnPrem')] procedure GetConnectionDefaultName(): Text begin exit(ConnectionDefaultNameTok); end; [Scope('OnPrem')] procedure IsSolutionInstalled(): Boolean begin exit(IsSolutionInstalled(GetBaseSolutionUniqueName())); end; [Scope('OnPrem')] procedure IsSolutionInstalled(var CDSConnectionSetup: Record "CDS Connection Setup"): Boolean begin exit(IsSolutionInstalled(CDSConnectionSetup, GetBaseSolutionUniqueName())); end; [Scope('OnPrem')] procedure IsSolutionInstalled(UniqueName: Text): Boolean var CDSSolution: Record "CDS Solution"; begin CDSSolution.SetRange(UniqueName, UniqueName); if CDSSolution.FindFirst() then if CDSSolution.InstalledOn <> 0DT then begin Session.LogMessage('0000ARM', SolutionInstalledTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(true); end; Session.LogMessage('0000ARN', SolutionNotInstalledTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; [Scope('OnPrem')] procedure IsSolutionInstalled(var CDSConnectionSetup: Record "CDS Connection Setup"; UniqueName: Text): Boolean var Installed: Boolean; begin if TryCheckSolutionInstalled(CDSConnectionSetup, UniqueName, Installed) then if Installed then begin Session.LogMessage('0000ARO', SolutionInstalledTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(true); end; Session.LogMessage('0000ARP', SolutionNotInstalledTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; [TryFunction] local procedure TryCheckSolutionInstalled(var CDSConnectionSetup: Record "CDS Connection Setup"; UniqueName: Text; var Installed: Boolean) var CDSSolution: Record "CDS Solution"; TempConnectionName: Text; begin TempConnectionName := GetTempConnectionName(); RegisterConnection(CDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName, true); CDSSolution.SetRange(UniqueName, UniqueName); if CDSSolution.FindFirst() then Installed := CDSSolution.InstalledOn <> 0DT else Installed := false; UnregisterTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName); end; [Scope('OnPrem')] procedure GetSolutionVersion(var Version: Text): Boolean begin exit(GetSolutionVersion(GetBaseSolutionUniqueName(), Version)); end; [Scope('OnPrem')] procedure GetSolutionVersion(var CDSConnectionSetup: Record "CDS Connection Setup"; var Version: Text): Boolean begin exit(GetSolutionVersion(CDSConnectionSetup, GetBaseSolutionUniqueName(), Version)); end; [Scope('OnPrem')] procedure GetSolutionVersion(UniqueName: Text; var Version: Text): Boolean var CDSSolution: Record "CDS Solution"; begin CDSSolution.SetRange(UniqueName, UniqueName); if CDSSolution.FindFirst() then if CDSSolution.InstalledOn <> 0DT then begin Version := CDSSolution.Version; Session.LogMessage('0000ARQ', SolutionVersionReceivedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(true); end; Version := ''; Session.LogMessage('0000ARL', CannotGetSolutionVersionTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; [Scope('OnPrem')] procedure GetSolutionVersion(var CDSConnectionSetup: Record "CDS Connection Setup"; UniqueName: Text; var Version: Text): Boolean begin if TryGetSolutionVersion(CDSConnectionSetup, UniqueName, Version) then begin Session.LogMessage('0000ARR', SolutionVersionReceivedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if Version <> '' then exit(true); end; Version := ''; Session.LogMessage('0000ARS', CannotGetSolutionVersionTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; [TryFunction] local procedure TryGetSolutionVersion(var CDSConnectionSetup: Record "CDS Connection Setup"; UniqueName: Text; var Version: Text) var CDSSolution: Record "CDS Solution"; TempConnectionName: Text; begin TempConnectionName := GetTempConnectionName(); RegisterConnection(CDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName, true); Version := ''; CDSSolution.SetRange(UniqueName, UniqueName); if CDSSolution.FindFirst() then if CDSSolution.InstalledOn <> 0DT then Version := CDSSolution.Version; if Version <> '' then Session.LogMessage('0000AVR', SolutionNotInstalledTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else Session.LogMessage('0000ART', SolutionNotInstalledTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); UnregisterTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName); end; internal procedure GetVirtualTablesAppSourceLink(): Text var TempUserSettingsRecord: Record "User Settings"; Language: Codeunit Language; UserSettings: Codeunit "User Settings"; LanguageID: Integer; CultureName: Text; begin UserSettings.GetUserSettings(Database.UserSecurityId(), TempUserSettingsRecord); LanguageID := TempUserSettingsRecord."Language ID"; if (LanguageID = 0) then LanguageID := 1033; // Default to EN-US CultureName := Language.GetCultureName(LanguageID).ToLower(); exit(Text.StrSubstNo(VTAppSourceLinkTxt, CultureName)); end; internal procedure OpenVirtualTablesApp(ErrorInfo: ErrorInfo) begin Hyperlink(GetVirtualTablesAppSourceLink()); end; procedure SetupVirtualTables(var CDSConnectionSetup: Record "CDS Connection Setup"; var ConfigId: Guid) var CrmHelper: DotNet CrmHelper; EmptySecretText: SecretText; begin SetupVirtualTables(CDSConnectionSetup, CrmHelper, EmptySecretText, ConfigId); end; internal procedure SetupVirtualTables(var CDSConnectionSetup: Record "CDS Connection Setup"; var CrmHelper: DotNet CrmHelper; AccessToken: SecretText; var ConfigId: Guid) var TempAdminCDSConnectionSetup: Record "CDS Connection Setup" temporary; AADApplicationSetup: Codeunit "AAD Application Setup"; TempConnectionStringWithPlaceholder: Text; TempConnectionString: SecretText; EmptySecretText: SecretText; VTAppNotInstalledErrorInfo: ErrorInfo; begin Session.LogMessage('0000GBF', VTConfigureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if CDSConnectionSetup."Authentication Type" <> CDSConnectionSetup."Authentication Type"::Office365 then begin Session.LogMessage('0000GBH', VTCannotConfigureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CDSConnectionSetup.TestField("Authentication Type", CDSConnectionSetup."Authentication Type"::Office365); end; if not CheckConnectionRequiredFields(CDSConnectionSetup, true) then begin Session.LogMessage('0000GBI', VTCannotConfigureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(GetLastErrorText()); end; if AccessToken.IsEmpty() then begin // sign in as admin in interactive auth code flow GetAccessToken(CDSConnectionSetup."Server Address", true, AccessToken); TempConnectionStringWithPlaceholder := StrSubstNo(OAuthConnectionStringFormatTxt, CDSConnectionSetup."Server Address", '%1', CDSConnectionSetup.GetProxyVersion(), GetAuthenticationTypeToken(CDSConnectionSetup)); TempConnectionString := SecretStrSubstNo(TempConnectionStringWithPlaceholder, AccessToken); if not InitializeConnection(CrmHelper, TempConnectionString) then begin Session.LogMessage('0000GGP', ConnectionNotRegisteredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); ProcessConnectionFailures(); end; JITProvisionFirstPartyApp(CrmHelper); Sleep(5000); end; GetTempConnectionSetup(TempAdminCDSConnectionSetup, CDSConnectionSetup, AccessToken); if not IsVirtualTablesAppInstalled(TempAdminCDSConnectionSetup) then begin Session.LogMessage('0000GBJ', VTCannotConfigureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); VTAppNotInstalledErrorInfo.Message := VTAppNotInstalledTxt; VTAppNotInstalledErrorInfo.AddAction(InstallVirtualTablesAppLbl, Codeunit::"CDS Integration Impl.", 'OpenVirtualTablesApp'); Error(VTAppNotInstalledErrorInfo); end; FindOrCreateIntegrationUser(CDSConnectionSetup, '', EmptySecretText, AccessToken); AssignVirtualTablesIntegrationRole(CrmHelper, CDSConnectionSetup."User Name"); EnableAADApp(AADApplicationSetup.GetD365BCForVEAppId()); EnableAADApp(AADApplicationSetup.GetPowerPagesAnonymousAppId()); EnableAADApp(AADApplicationSetup.GetPowerPagesAuthenticatedAppId()); // for at an plugin in Dataverse can connect to BC with the VT app, configure the VT config ConfigureVirtualTables(TempAdminCDSConnectionSetup, ConfigId); end; local procedure EnableAADApp(AppId: Guid) var AADApplication: Record "AAD Application"; IdentityManagement: Codeunit "Identity Management"; Validate: Boolean; begin Session.LogMessage('0000GEW', StrSubstNo(VTEnableAppTxt, AppId), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); AADApplication.Get(AppId); Validate := EnvironmentInfo.IsSaaSInfrastructure(); if not Validate then Validate := IdentityManagement.IsUserNamePasswordAuthentication(); if Validate then AADApplication.Validate(State, AADApplication.State::Enabled) else AADApplication.State := AADApplication.State::Enabled; AADApplication.Modify(); Commit(); end; [NonDebuggable] local procedure ConfigureVirtualTables(var TempAdminCDSConnectionSetup: Record "CDS Connection Setup"; var ConfigId: Guid) var Company: Record Company; UrlHelper: Codeunit "Url Helper"; EnvironmentName: Text[100]; TargetHost: Text[255]; CompanyId: Guid; TenantId: Text[150]; UserId: Text[80]; IsPPE: Boolean; begin Session.LogMessage('0000GBK', VTConfigureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Company.Get(CompanyName()); CompanyId := Company.Id; EnvironmentName := CopyStr(EnvironmentInfo.GetEnvironmentName(), 1, MaxStrLen(EnvironmentName)); TargetHost := CopyStr(GetTargetHost(), 1, MaxStrLen(TargetHost)); IsPPE := UrlHelper.IsPPE(); if IsPPE then begin Session.LogMessage('0000GEV', VTConfigureNonProdTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); TenantId := CopyStr(GetAadTenantId(), 1, MaxStrLen(TenantId)); if TenantId = '' then Session.LogMessage('0000GEX', VTEmptyTenantIdTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); UserId := GetAadUserId(); if UserId = '' then Session.LogMessage('0000GEY', VTEmptyAadUserIdTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end else Session.LogMessage('0000GEZ', VTConfigureProdTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CheckVirtualTablesConfig(TempAdminCDSConnectionSetup, EnvironmentName, TargetHost, CompanyId, TenantId, UserId, IsPPE); UpdateVirtualTablesConfig(TempAdminCDSConnectionSetup, EnvironmentName, TargetHost, CompanyId, TenantId, UserId, IsPPE, ConfigId); Session.LogMessage('0000GBP', VTConfiguredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; [NonDebuggable] local procedure CheckVirtualTablesConfig(var TempAdminCDSConnectionSetup: Record "CDS Connection Setup"; EnvironmentName: Text[100]; TargetHost: Text[255]; CompanyId: Guid; TenantId: Text[150]; AadUserId: Text[80]; IsPPE: Boolean) var CRMBCVirtualTableConfig: Record "CRM BC Virtual Table Config."; TempConnectionName: Text; ConfigFound: Boolean; DiffFound: Boolean; DiffMessage: Text; begin Session.LogMessage('0000GF0', VTRegisterConnectionTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); TempConnectionName := GetTempConnectionName(); RegisterConnection(TempAdminCDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TableConnectionType::CRM, TempConnectionName, true); Session.LogMessage('0000GF1', VTConnectionRegisteredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); // Table connection is scoped, therefore all manipulations with CDS tables must be placed // in this procedure between SetDefaultTableConnection and UnregisterConnection CRMBCVirtualTableConfig.SetRange(msdyn_name, VTConfigNameTxt); ConfigFound := CRMBCVirtualTableConfig.FindFirst(); if ConfigFound then begin Session.LogMessage('0000GF2', VTConfigFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if (CRMBCVirtualTableConfig.msdyn_environment <> '') and (CRMBCVirtualTableConfig.msdyn_environment.ToLower() <> EnvironmentName.ToLower()) then begin Session.LogMessage('0000GE7', StrSubstNo(VTDiffFoundTxt, CRMBCVirtualTableConfig.FieldCaption(msdyn_environment)), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); DiffMessage += '\\' + StrSubstNo(VTDiffTemplateTxt, CRMBCVirtualTableConfig.FieldCaption(msdyn_environment), CRMBCVirtualTableConfig.msdyn_environment, EnvironmentName); DiffFound := true; end; if (CRMBCVirtualTableConfig.msdyn_targethost <> '') and (CRMBCVirtualTableConfig.msdyn_targethost.ToLower().TrimEnd('/') <> TargetHost.ToLower()) then begin Session.LogMessage('0000GE8', StrSubstNo(VTDiffFoundTxt, CRMBCVirtualTableConfig.FieldCaption(msdyn_targethost)), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); DiffMessage += '\\' + StrSubstNo(VTDiffTemplateTxt, CRMBCVirtualTableConfig.FieldCaption(msdyn_targethost), CRMBCVirtualTableConfig.msdyn_targethost, TargetHost); DiffFound := true; end; if (not IsNullGuid(CRMBCVirtualTableConfig.msdyn_DefaultCompanyId)) and (CRMBCVirtualTableConfig.msdyn_DefaultCompanyId <> CompanyId) then begin Session.LogMessage('0000GE9', StrSubstNo(VTDiffFoundTxt, CRMBCVirtualTableConfig.FieldCaption(msdyn_DefaultCompanyId)), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); DiffMessage += '\\' + StrSubstNo(VTDiffTemplateTxt, CRMBCVirtualTableConfig.FieldCaption(msdyn_DefaultCompanyId), CRMBCVirtualTableConfig.msdyn_DefaultCompanyId, CompanyId); DiffFound := true; end; if IsPPE then begin if (CRMBCVirtualTableConfig.msdyn_tenantid <> '') and (CRMBCVirtualTableConfig.msdyn_tenantid.ToLower() <> TenantId.ToLower()) then begin Session.LogMessage('0000GEA', StrSubstNo(VTDiffFoundTxt, CRMBCVirtualTableConfig.FieldCaption(msdyn_tenantid)), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); DiffMessage += '\\' + StrSubstNo(VTDiffTemplateTxt, CRMBCVirtualTableConfig.FieldCaption(msdyn_tenantid), CRMBCVirtualTableConfig.msdyn_tenantid, TenantId); DiffFound := true; end; if (CRMBCVirtualTableConfig.msdyn_aadUserId <> '') and (CRMBCVirtualTableConfig.msdyn_aadUserId.ToLower() <> AadUserId.ToLower()) then begin Session.LogMessage('0000GEB', StrSubstNo(VTDiffFoundTxt, CRMBCVirtualTableConfig.FieldCaption(msdyn_aadUserId)), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); DiffMessage += '\\' + StrSubstNo(VTDiffTemplateTxt, CRMBCVirtualTableConfig.FieldCaption(msdyn_aadUserId), CRMBCVirtualTableConfig.msdyn_aadUserId, AadUserId); DiffFound := true; end; end; if DiffFound then begin Session.LogMessage('0000GBO', VTAlreadyConfiguredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if not Confirm(VTAlreadyConfiguredQst + DiffMessage, false) then Error(''); end; end; UnregisterTableConnection(TableConnectionType::CRM, TempConnectionName); end; [NonDebuggable] local procedure UpdateVirtualTablesConfig(var TempAdminCDSConnectionSetup: Record "CDS Connection Setup"; EnvironmentName: Text[100]; TargetHost: Text[255]; CompanyId: Guid; TenantId: Text[150]; AadUserId: Text[80]; IsPPE: Boolean; var ConfigId: Guid) var CRMBCVirtualTableConfig: Record "CRM BC Virtual Table Config."; CRMCompany: Record "CRM Company"; Company: Record Company; TempConnectionName: Text; ConfigFound: Boolean; CompanyFound: Boolean; ModifyConfig: Boolean; begin Session.LogMessage('0000GMW', VTRegisterConnectionTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); TempConnectionName := GetTempConnectionName(); RegisterConnection(TempAdminCDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TableConnectionType::CRM, TempConnectionName, true); Session.LogMessage('0000GMX', VTConnectionRegisteredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); // Table connection is scoped, therefore all manipulations with CDS tables must be placed // in this procedure between SetDefaultTableConnection and UnregisterConnection CRMBCVirtualTableConfig.SetRange(msdyn_name, VTConfigNameTxt); ConfigFound := CRMBCVirtualTableConfig.FindFirst(); CompanyFound := CRMCompany.Get(CompanyId); if not ConfigFound then begin Session.LogMessage('0000GF3', VTConfigNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.msdyn_name := VTConfigNameTxt; CRMBCVirtualTableConfig.msdyn_apimanagedprefix := VTSolutionPrefixTxt; CRMBCVirtualTableConfig.msdyn_apimanagedsolutionname := VTSolutionNameTxt; Session.LogMessage('0000GEC', VTSetEnvironmentTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.msdyn_environment := EnvironmentName; // when specified then a plugin in Dataverse creates the Company if missing Session.LogMessage('0000GED', VTSetTargetHostTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.msdyn_targethost := TargetHost; // mandatory field if CompanyFound then begin Session.LogMessage('0000GEE', VTSetCompanyIdTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.msdyn_DefaultCompanyId := CompanyId; end; if IsPPE then begin Session.LogMessage('0000GEF', VTSetTenantIdTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.msdyn_tenantid := TenantId; Session.LogMessage('0000GEG', VTSetAadUserIdTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.msdyn_aadUserId := AadUserId; end; Session.LogMessage('0000GBL', VTInsertConfigTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.Insert(); end else begin if CRMBCVirtualTableConfig.msdyn_environment <> EnvironmentName then begin Session.LogMessage('0000GBM', VTSetEnvironmentTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.msdyn_environment := EnvironmentName; // when specified then a plugin in Dataverse creates the Company if missing ModifyConfig := true; end; if CRMBCVirtualTableConfig.msdyn_targethost <> TargetHost then begin Session.LogMessage('0000GEH', VTSetTargetHostTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.msdyn_targethost := TargetHost; // mandatory field ModifyConfig := true; end; if CompanyFound and (CRMBCVirtualTableConfig.msdyn_DefaultCompanyId <> CompanyId) then begin Session.LogMessage('0000GEI', VTSetCompanyIdTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.msdyn_DefaultCompanyId := CompanyId; ModifyConfig := true; end; if IsPPE then begin if CRMBCVirtualTableConfig.msdyn_tenantid <> TenantId then begin Session.LogMessage('0000GEJ', VTSetTenantIdTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.msdyn_tenantid := TenantId; ModifyConfig := true; end; if CRMBCVirtualTableConfig.msdyn_aadUserId <> AadUserId then begin Session.LogMessage('0000GEK', VTSetAadUserIdTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.msdyn_aadUserId := AadUserId; ModifyConfig := true; end; end; if ModifyConfig then begin Session.LogMessage('0000GEL', VTModifyConfigTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.Modify(); end; end; if not CompanyFound then begin if not ModifyConfig then begin // do fake modify to create cdm_company through a plugin Session.LogMessage('0000GH8', VTResetAuthHeaderTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.msdyn_odataauthorizationheader := Format(CreateGuid()); CRMBCVirtualTableConfig.Modify(); CRMBCVirtualTableConfig.msdyn_odataauthorizationheader := ''; CRMBCVirtualTableConfig.Modify(); end; if not CRMCompany.Get(CompanyId) then begin Session.LogMessage('0000GBN', VTCompanyNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMCompany.SetRange(cdm_CompanyCode, Company.Name); if not CRMCompany.IsEmpty() then begin Session.LogMessage('0000GH9', VTDeleteCompanyTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMCompany.DeleteAll(); end; CRMCompany.cdm_companyId := CompanyId; CRMCompany.cdm_CompanyCode := Company.Name; if Company."Display Name" = '' then CRMCompany.cdm_Name := Company.Name else CRMCompany.cdm_Name := CopyStr(Company."Display Name", 1, MaxStrLen(CRMCompany.cdm_Name)); CRMCompany.Insert(); end; if CRMBCVirtualTableConfig.msdyn_DefaultCompanyId <> CompanyId then begin Session.LogMessage('0000GEM', VTSetCompanyIdTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.msdyn_DefaultCompanyId := CompanyId; Session.LogMessage('0000GEN', VTModifyConfigTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMBCVirtualTableConfig.Modify(); end; end; ConfigId := CRMBCVirtualTableConfig.msdyn_businesscentralvirtualentityId; UnregisterTableConnection(TableConnectionType::CRM, TempConnectionName); end; local procedure GetAadTenantId(): Text var AzureADTenant: Codeunit "Azure AD Tenant"; begin exit(AzureADTenant.GetAadTenantId()); end; local procedure GetAadUserId(): Text[80] var UserProperty: Record "User Property"; begin if UserProperty.Get(UserSecurityId()) then exit(UserProperty."Authentication Object ID"); exit(''); end; local procedure GetTargetHost(): Text var BaseIndex: Integer; EndBaseUrlIndex: Integer; BaseUrl: Text; ApiUrl: Text; Path: Text; EndPathIndex: Integer; begin ApiUrl := GetUrl(ClientType::Api); if StrPos(LowerCase(ApiUrl), 'https://') <> 0 then BaseIndex := 9; if StrPos(LowerCase(ApiUrl), 'http://') <> 0 then BaseIndex := 8; BaseUrl := CopyStr(ApiUrl, BaseIndex); EndBaseUrlIndex := StrPos(BaseUrl, '/'); if EndBaseUrlIndex = 0 then exit(ApiUrl); Path := CopyStr(BaseUrl, EndBaseUrlIndex + 1); BaseUrl := CopyStr(BaseUrl, 1, EndBaseUrlIndex - 1); if EnvironmentInfo.IsSaaSInfrastructure() then exit(CopyStr(ApiUrl, 1, BaseIndex - 1) + BaseUrl); EndPathIndex := StrPos(Path, '/'); if EndPathIndex = 0 then exit(CopyStr(ApiUrl, 1, BaseIndex - 1) + BaseUrl); Path := CopyStr(Path, 1, EndPathIndex - 1); exit(CopyStr(ApiUrl, 1, BaseIndex - 1) + BaseUrl + '/' + Path); end; local procedure SetUserAsIntegrationUser(var CDSConnectionSetup: Record "CDS Connection Setup"; AdminUserName: Text; AdminPassword: SecretText; AccessToken: SecretText; AdminADDomain: Text) var CRMSystemuser: Record "CRM Systemuser"; TempAdminCDSConnectionSetup: Record "CDS Connection Setup" temporary; TempConnectionName: Text; begin Session.LogMessage('0000ARW', SetUserAsIntegrationUserTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); GetTempAdminConnectionSetup(TempAdminCDSConnectionSetup, CDSConnectionSetup, AdminUserName, AdminPassword, AccessToken, AdminADDomain); TempConnectionName := GetTempConnectionName(); RegisterConnection(TempAdminCDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName, true); // Table connection is scoped, therefore all manipulations with CDS tables must be placed // in this procedure between SetDefaultTableConnection and UnregisterConnection FilterUser(CDSConnectionSetup, CRMSystemuser); if not CRMSystemuser.FindFirst() then begin Session.LogMessage('0000ARX', UserNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(CannotResolveUserFromConnectionSetupErr); end; if (CRMSystemuser.InviteStatusCode <> CRMSystemuser.InviteStatusCode::InvitationAccepted) or (not CRMSystemuser.IsIntegrationUser) then begin Session.LogMessage('0000ARY', SetUserAsIntegrationUserTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMSystemuser.InviteStatusCode := CRMSystemuser.InviteStatusCode::InvitationAccepted; CRMSystemuser.IsIntegrationUser := true; if not CRMSystemuser.Modify() then Session.LogMessage('0000ARZ', CannotSetUserAsIntegrationUserTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else Session.LogMessage('0000AS0', UserSetAsIntegrationUserTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end else Session.LogMessage('0000AS1', UserAlreadySetAsIntegrationUserTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); UnregisterTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName); end; [NonDebuggable] local procedure SetAccessModeToNonInteractive(var CDSConnectionSetup: Record "CDS Connection Setup"; AdminUserName: Text; AdminPassword: SecretText; AccessToken: SecretText; AdminADDomain: Text): Boolean var CRMSystemuser: Record "CRM Systemuser"; TempAdminCDSConnectionSetup: Record "CDS Connection Setup" temporary; TempConnectionName: Text; ChangedToNonInteractive: Boolean; begin // User non-interactive mode is not supported on CRM OnPrem, therefore if authentication type is AD or IFD, do nothing if CDSConnectionSetup."Authentication Type" in [CDSConnectionSetup."Authentication Type"::AD, CDSConnectionSetup."Authentication Type"::IFD] then exit(false); Session.LogMessage('0000B2I', SetAccessModeToNonInteractiveTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); GetTempAdminConnectionSetup(TempAdminCDSConnectionSetup, CDSConnectionSetup, AdminUserName, AdminPassword, AccessToken, AdminADDomain); TempConnectionName := GetTempConnectionName(); RegisterConnection(TempAdminCDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName, true); // Table connection is scoped, therefore all manipulations with CDS tables must be placed // in this procedure between SetDefaultTableConnection and UnregisterConnection FilterUser(CDSConnectionSetup, CRMSystemuser); if not CRMSystemuser.FindFirst() then begin Session.LogMessage('0000B2J', UserNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(CannotResolveUserFromConnectionSetupErr); end; if CRMSystemuser.AccessMode <> CRMSystemuser.AccessMode::"Non-interactive" then begin Session.LogMessage('0000B2A', SetAccessModeToNonInteractiveTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMSystemuser.AccessMode := CRMSystemuser.AccessMode::"Non-interactive"; if not CRMSystemuser.Modify() then Session.LogMessage('0000B2B', CannotSetAccessModeToNonInteractiveTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else begin ChangedToNonInteractive := CRMSystemuser.AccessMode = CRMSystemuser.AccessMode::"Non-interactive"; if ChangedToNonInteractive then Session.LogMessage('0000B2C', AccessModeSetToNonInteractiveTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else Session.LogMessage('0000B2H', CannotSetAccessModeToNonInteractiveTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) end; end else Session.LogMessage('0000B2D', AccessModeAlreadySetToNonInteractiveTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); UnregisterTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName); exit(ChangedToNonInteractive); end; [NonDebuggable] local procedure FindOrCreateIntegrationUser(var CDSConnectionSetup: Record "CDS Connection Setup"; AdminUserName: Text; AdminPassword: SecretText; AccessToken: SecretText) var CRMSystemuser: Record "CRM Systemuser"; RootBusinessUnit: Record "CRM Businessunit"; TempAdminCDSConnectionSetup: Record "CDS Connection Setup" temporary; TempConnectionName: Text; CDSConnectionClientIdTxt: Text; CDSConnectionFirstPartyAppIdTxt: Text; CDSConnectionFirstPartyAppCertificateTxt: Text; NewConnectionString: Text; IntegrationUsernameEmailTxt: Text[100]; OnGetIntegrationUserEmailHandled: Boolean; CDSConnectionClientId: Guid; EmptyGuid: Guid; ExistingApplicationUserCount: Integer; EmptySecretText: SecretText; begin if CDSConnectionSetup."Authentication Type" <> CDSConnectionSetup."Authentication Type"::Office365 then exit; Session.LogMessage('0000C4J', FindOrCreateIntegrationUserTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); GetTempAdminConnectionSetup(TempAdminCDSConnectionSetup, CDSConnectionSetup, AdminUserName, AdminPassword, AccessToken, ''); TempConnectionName := GetTempConnectionName(); RegisterConnection(TempAdminCDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName, true); CDSConnectionClientIdTxt := GetCDSConnectionClientId(); CDSConnectionFirstPartyAppIdTxt := GetCDSConnectionFirstPartyAppId(); CDSConnectionFirstPartyAppCertificateTxt := GetCDSConnectionFirstPartyAppCertificate(); if CDSConnectionFirstPartyAppIdTxt <> '' then CDSConnectionClientId := CDSConnectionFirstPartyAppIdTxt else CDSConnectionClientId := CDSConnectionClientIdTxt; CRMSystemuser.SetRange(CRMSystemuser.ApplicationId, CDSConnectionClientId); ExistingApplicationUserCount := CRMSystemuser.Count(); if ExistingApplicationUserCount > 1 then begin Session.LogMessage('0000C4K', StrSubstNo(FoundMoreThanOneIntegrationUserTxt, CDSConnectionClientId, CDSConnectionSetup."Server Address"), Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(FoundMoreThanOneIntegrationUserErr, CDSConnectionClientId, CDSConnectionSetup."Server Address"); end; if ExistingApplicationUserCount = 1 then begin Session.LogMessage('0000C4L', StrSubstNo(FoundOneIntegrationUserTxt, CDSConnectionClientId, CDSConnectionSetup."Server Address"), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CrmSystemUser.FindFirst(); end else begin Session.LogMessage('0000C4M', StrSubstNo(FoundNoIntegrationUserTxt, CDSConnectionClientId, CDSConnectionSetup."Server Address"), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); OnGetIntegrationUserEmail(IntegrationUsernameEmailTxt, OnGetIntegrationUserEmailHandled); if not OnGetIntegrationUserEmailHandled then IntegrationUsernameEmailTxt := CopyStr(GetAvailableIntegrationUserEmail(), 1, MaxStrLen(CRMSystemuser.InternalEMailAddress)) else Session.LogMessage('0000IOW', UsingCustomIntegrationUsernameEmailTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if IntegrationUsernameEmailTxt = '' then begin Session.LogMessage('0000D1D', StrSubstNo(FailedToInsertApplicationUserTxt, CDSConnectionClientId, CDSConnectionSetup."Server Address"), Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(FailedToInsertApplicationUserErr, CDSConnectionClientId, CDSConnectionSetup."Server Address"); end; CRMSystemuser.ApplicationId := CDSConnectionClientId; CRMSystemuser.FirstName := IntegrationUserFirstNameTxt; CRMSystemuser.LastName := IntegrationUserLastNameTxt; CRMSystemuser.FullName := IntegrationUserFullNameTxt; RootBusinessunit.SetRange(ParentBusinessUnitId, EmptyGuid); RootBusinessunit.FindFirst(); CRMSystemUser.BusinessUnitId := RootBusinessUnit.BusinessUnitId; CRMSystemuser.InternalEMailAddress := IntegrationUsernameEmailTxt; if not CRMSystemuser.Insert() then begin Session.LogMessage('0000C4N', StrSubstNo(FailedToInsertApplicationUserTxt, CDSConnectionClientId, CDSConnectionSetup."Server Address"), Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(FailedToInsertApplicationUserErr, CDSConnectionClientId, CDSConnectionSetup."Server Address"); end; end; if not UpdateIntegrationUserNameAndEmailIfNeeded(CRMSystemuser) then Session.LogMessage('0000ENR', CannotUpdateUserNameAndEmailTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CDSConnectionSetup."User Name" := CRMSystemuser.InternalEMailAddress; CDSConnectionSetup.SetPassword(EmptySecretText); if (CDSConnectionFirstPartyAppIdTxt <> '') and (CDSConnectionFirstPartyAppCertificateTxt <> '') then NewConnectionString := StrSubstNo(CertificateConnectionStringFormatTxt, CertificateAuthTxt, CDSConnectionSetup."Server Address", ClientIdTok, CertificateTok, CDSConnectionSetup.GetProxyVersion()) else NewConnectionString := StrSubstNo(ClientSecretConnectionStringFormatTxt, ClientSecretAuthTxt, CDSConnectionSetup."Server Address", ClientIdTok, ClientSecretTok, CDSConnectionSetup.GetProxyVersion()); SetConnectionString(CDSConnectionSetup, NewConnectionString); UnregisterTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName); end; [NonDebuggable] local procedure FindOrCreateIntegrationUser(var CDSConnectionSetup: Record "CDS Connection Setup") var CRMSystemuser: Record "CRM Systemuser"; RootBusinessUnit: Record "CRM Businessunit"; CurrentCDSConnectionSetup: Record "CDS Connection Setup"; CurrentCRMConnectionSetup: Record "CRM Connection Setup"; TempConnectionName: Text; CDSConnectionClientIdTxt: Text; CDSConnectionFirstPartyAppIdTxt: Text; CDSConnectionFirstPartyAppCertificateTxt: Text; NewConnectionString: Text; IntegrationUsernameEmailTxt: Text[100]; CDSConnectionClientId: Guid; EmptyGuid: Guid; ExistingApplicationUserCount: Integer; CDSConnectionSetupEnabled: Boolean; EmptySecretText: SecretText; begin if CDSConnectionSetup."Authentication Type" <> CDSConnectionSetup."Authentication Type"::Office365 then exit; Session.LogMessage('0000GJ8', FindOrCreateIntegrationUserTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CDSConnectionClientIdTxt := GetCDSConnectionClientId(); CDSConnectionFirstPartyAppIdTxt := GetCDSConnectionFirstPartyAppId(); CDSConnectionFirstPartyAppCertificateTxt := GetCDSConnectionFirstPartyAppCertificate(); if CDSConnectionFirstPartyAppIdTxt <> '' then CDSConnectionClientId := CDSConnectionFirstPartyAppIdTxt else CDSConnectionClientId := CDSConnectionClientIdTxt; TempConnectionName := GetTempConnectionName(); // connect with the integration user, not with the admin. this relies on no user interaction if CurrentCDSConnectionSetup.Get() then if CurrentCDSConnectionSetup."Is Enabled" then CDSConnectionSetupEnabled := true; if CDSConnectionSetupEnabled then RegisterConnection(CurrentCDSConnectionSetup, TempConnectionName) else if CurrentCRMConnectionSetup.IsEnabled() then CurrentCRMConnectionSetup.RegisterConnectionWithName(TempConnectionName); SetDefaultTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName, true); CRMSystemuser.SetRange(CRMSystemuser.ApplicationId, CDSConnectionClientId); ExistingApplicationUserCount := CRMSystemuser.Count(); if ExistingApplicationUserCount > 1 then begin Session.LogMessage('0000GJ9', StrSubstNo(FoundMoreThanOneIntegrationUserTxt, CDSConnectionClientId, CDSConnectionSetup."Server Address"), Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(FoundMoreThanOneIntegrationUserErr, CDSConnectionClientId, CDSConnectionSetup."Server Address"); end; if ExistingApplicationUserCount = 1 then begin Session.LogMessage('0000GJA', StrSubstNo(FoundOneIntegrationUserTxt, CDSConnectionClientId, CDSConnectionSetup."Server Address"), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CrmSystemUser.FindFirst(); end else begin Session.LogMessage('0000GJB', StrSubstNo(FoundNoIntegrationUserTxt, CDSConnectionClientId, CDSConnectionSetup."Server Address"), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); IntegrationUsernameEmailTxt := CopyStr(GetAvailableIntegrationUserEmail(), 1, MaxStrLen(CRMSystemuser.InternalEMailAddress)); if IntegrationUsernameEmailTxt = '' then begin Session.LogMessage('0000GJC', StrSubstNo(FailedToInsertApplicationUserTxt, CDSConnectionClientId, CDSConnectionSetup."Server Address"), Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(FailedToInsertApplicationUserErr, CDSConnectionClientId, CDSConnectionSetup."Server Address"); end; CRMSystemuser.ApplicationId := CDSConnectionClientId; CRMSystemuser.FirstName := IntegrationUserFirstNameTxt; CRMSystemuser.LastName := IntegrationUserLastNameTxt; CRMSystemuser.FullName := IntegrationUserFullNameTxt; RootBusinessunit.SetRange(ParentBusinessUnitId, EmptyGuid); RootBusinessunit.FindFirst(); CRMSystemUser.BusinessUnitId := RootBusinessUnit.BusinessUnitId; CRMSystemuser.InternalEMailAddress := IntegrationUsernameEmailTxt; if not CRMSystemuser.Insert() then begin Session.LogMessage('0000GJD', StrSubstNo(FailedToInsertApplicationUserTxt, CDSConnectionClientId, CDSConnectionSetup."Server Address"), Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(FailedToInsertApplicationUserErr, CDSConnectionClientId, CDSConnectionSetup."Server Address"); end else Session.LogMessage('0000GJE', StrSubstNo(CreatedIntegrationUserTxt, CDSConnectionClientId, CDSConnectionSetup."Server Address"), Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; if not UpdateIntegrationUserNameAndEmailIfNeeded(CRMSystemuser) then Session.LogMessage('0000GJF', CannotUpdateUserNameAndEmailTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CDSConnectionSetup."User Name" := CRMSystemuser.InternalEMailAddress; CDSConnectionSetup.SetPassword(EmptySecretText); if (CDSConnectionFirstPartyAppIdTxt <> '') and (CDSConnectionFirstPartyAppCertificateTxt <> '') then NewConnectionString := StrSubstNo(CertificateConnectionStringFormatTxt, CertificateAuthTxt, CDSConnectionSetup."Server Address", ClientIdTok, CertificateTok, CDSConnectionSetup.GetProxyVersion()) else NewConnectionString := StrSubstNo(ClientSecretConnectionStringFormatTxt, ClientSecretAuthTxt, CDSConnectionSetup."Server Address", ClientIdTok, ClientSecretTok, CDSConnectionSetup.GetProxyVersion()); SetConnectionString(CDSConnectionSetup, NewConnectionString); UnregisterTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName); end; [Scope('OnPrem')] procedure SetupCertificateAuthentication(var CDSConnectionSetup: Record "CDS Connection Setup") var CrmHelper: DotNet CRMHelper; [NonDebuggable] CDSConnectionFirstPartyAppIdTxt: Text; [NonDebuggable] CDSConnectionFirstPartyAppCertificateTxt: Text; AdminAccessToken: SecretText; TempConnectionStringWithPlaceholder: Text; TempConnectionString: SecretText; JITProvisioningTelemetryMessageTxt: Text; PreviousIntegrationUserName: Text[250]; EmptySecretText: SecretText; begin CDSConnectionFirstPartyAppIdTxt := GetCDSConnectionFirstPartyAppId(); CDSConnectionFirstPartyAppCertificateTxt := GetCDSConnectionFirstPartyAppCertificate(); if (CDSConnectionFirstPartyAppIdTxt = '') or (CDSConnectionFirstPartyAppCertificateTxt = '') then exit; PreviousIntegrationUserName := CDSConnectionSetup."User Name"; // sign in as admin in interactive auth code flow GetAccessToken(CDSConnectionSetup."Server Address", false, AdminAccessToken); // register connection with CrmHelper TempConnectionStringWithPlaceholder := StrSubstNo(OAuthConnectionStringFormatTxt, CDSConnectionSetup."Server Address", '%1', CDSConnectionSetup.GetProxyVersion(), GetAuthenticationTypeToken(CDSConnectionSetup)); TempConnectionString := SecretStrSubstNo(TempConnectionStringWithPlaceholder, AdminAccessToken); if not InitializeConnection(CrmHelper, TempConnectionString) then begin Session.LogMessage('0000AU2', ConnectionNotRegisteredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); ProcessConnectionFailures(); exit; end; // JIT provision (backfill) the 1st party app service principal JITProvisioningTelemetryMessageTxt := CrmHelper.ProvisionServicePrincipal(CDSConnectionFirstPartyAppIdTxt, CDSConnectionFirstPartyAppCertificateTxt); if JITProvisioningTelemetryMessageTxt <> '' then if JITProvisioningTelemetryMessageTxt.Contains(SuccessfulJITProvisioningTelemetryMsg) then Session.LogMessage('0000ENK', JITProvisioningTelemetryMessageTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else Session.LogMessage('0000F0A', JITProvisioningTelemetryMessageTxt, Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); // even though CrmHelper.ProvisionServicePrincipal contains an async Graph call, you can't expect Dataverse to be aware of the newly provisioned service principal right away. // It has been tested that it fails if you try to create the application user right after you provision the service principal Sleep(5000); if not JITProvisioningTelemetryMessageTxt.Contains(SuccessfulJITProvisioningTelemetryMsg) then begin // try one more time, it could have failed because of a timeout JITProvisioningTelemetryMessageTxt := CrmHelper.ProvisionServicePrincipal(CDSConnectionFirstPartyAppIdTxt, CDSConnectionFirstPartyAppCertificateTxt); if JITProvisioningTelemetryMessageTxt <> '' then if JITProvisioningTelemetryMessageTxt.Contains(SuccessfulJITProvisioningTelemetryMsg) then Session.LogMessage('0000ENK', JITProvisioningTelemetryMessageTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else Session.LogMessage('0000F0A', JITProvisioningTelemetryMessageTxt, Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; // even though CrmHelper.ProvisionServicePrincipal contains an async Graph call, you can't expect Dataverse to be aware of the newly provisioned service principal right away. // It has been tested that it fails if you try to create the application user right after you provision the service principal Sleep(10000); // this will create integration user and update the proxy version and connection string FindOrCreateIntegrationUser(CDSConnectionSetup, '', EmptySecretText, AdminAccessToken); AssignPreviousIntegrationUserRoles(CrmHelper, PreviousIntegrationUserName, CDSConnectionSetup, AdminAccessToken); end; [Scope('OnPrem')] [NonDebuggable] procedure SetupCertificatetAuthenticationNoPrompt(var CDSConnectionSetup: Record "CDS Connection Setup") var CurrentCDSConnectionSetup: Record "CDS Connection Setup"; CurrentCRMConnectionSetup: Record "CRM Connection Setup"; CrmHelper: DotNet CRMHelper; [NonDebuggable] CDSConnectionFirstPartyAppIdTxt: Text; [NonDebuggable] CDSConnectionFirstPartyAppCertificateTxt: Text; PreviousIntegrationUserName: Text[250]; JITProvisioningTelemetryMessageTxt: Text; TempConnectionString: SecretText; begin CDSConnectionFirstPartyAppIdTxt := GetCDSConnectionFirstPartyAppId(); CDSConnectionFirstPartyAppCertificateTxt := GetCDSConnectionFirstPartyAppCertificate(); if (CDSConnectionFirstPartyAppIdTxt = '') or (CDSConnectionFirstPartyAppCertificateTxt = '') then exit; PreviousIntegrationUserName := CDSConnectionSetup."User Name"; // register connection with CrmHelper, with the previous integration user, not with an admin if CurrentCDSConnectionSetup.Get() then if CurrentCDSConnectionSetup."Is Enabled" then TempConnectionString := GetConnectionStringWithCredentials(CurrentCDSConnectionSetup); if TempConnectionString.IsEmpty() then if CurrentCRMConnectionSetup.Get() then if CurrentCRMConnectionSetup."Is Enabled" then TempConnectionString := CurrentCRMConnectionSetup.GetSecretConnectionStringWithCredentials(); if not InitializeConnection(CrmHelper, TempConnectionString) then begin Session.LogMessage('0000AU2', ConnectionNotRegisteredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); ProcessConnectionFailures(); exit; end; // JIT provision (backfill) the 1st party app service principal JITProvisioningTelemetryMessageTxt := CrmHelper.ProvisionServicePrincipal(CDSConnectionFirstPartyAppIdTxt, CDSConnectionFirstPartyAppCertificateTxt); if JITProvisioningTelemetryMessageTxt <> '' then if JITProvisioningTelemetryMessageTxt.Contains(SuccessfulJITProvisioningTelemetryMsg) then Session.LogMessage('0000GJG', JITProvisioningTelemetryMessageTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else Session.LogMessage('0000GJH', JITProvisioningTelemetryMessageTxt, Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); // even though CrmHelper.ProvisionServicePrincipal contains an async Graph call, you can't expect Dataverse to be aware of the newly provisioned service principal right away. // It has been tested that it fails if you try to create the application user right after you provision the service principal Sleep(5000); if not JITProvisioningTelemetryMessageTxt.Contains(SuccessfulJITProvisioningTelemetryMsg) then begin // try one more time, it could have failed because of a timeout JITProvisioningTelemetryMessageTxt := CrmHelper.ProvisionServicePrincipal(CDSConnectionFirstPartyAppIdTxt, CDSConnectionFirstPartyAppCertificateTxt); if JITProvisioningTelemetryMessageTxt <> '' then if JITProvisioningTelemetryMessageTxt.Contains(SuccessfulJITProvisioningTelemetryMsg) then Session.LogMessage('0000GJI', JITProvisioningTelemetryMessageTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else Session.LogMessage('0000GJJ', JITProvisioningTelemetryMessageTxt, Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; // even though CrmHelper.ProvisionServicePrincipal contains an async Graph call, you can't expect Dataverse to be aware of the newly provisioned service principal right away. // It has been tested that it fails if you try to create the application user right after you provision the service principal Sleep(10000); // this will create integration user and update the proxy version and connection string FindOrCreateIntegrationUser(CDSConnectionSetup); AssignPreviousIntegrationUserRoles(CrmHelper, PreviousIntegrationUserName, CDSConnectionSetup); end; [TryFunction] local procedure UpdateIntegrationUserNameAndEmailIfNeeded(var CRMSystemuser: Record "CRM Systemuser") var Email: Text[100]; EmailChanged: Boolean; NameChanged: Boolean; begin // update email address as insert could set an autogenerated email instead of the specified if (not CRMSystemuser.InternalEMailAddress.StartsWith(IntegrationUserPrimaryEmailStartTxt)) or (not CRMSystemuser.InternalEMailAddress.EndsWith(IntegrationUserPrimaryEmailEndTxt)) then begin Session.LogMessage('0000ENS', UpdateUserEmailTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Email := CopyStr(GetAvailableIntegrationUserEmail(), 1, MaxStrLen(CRMSystemuser.InternalEMailAddress)); if Email <> '' then begin CRMSystemuser.InternalEMailAddress := Email; EmailChanged := true; end; end; // add last name to first name as insert could set an autogenerated last name instead of the specified if CRMSystemuser.LastName <> IntegrationUserLastNameTxt then begin Session.LogMessage('0000ENT', UpdateUserNameTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMSystemuser.FirstName := IntegrationUserFullNameTxt; NameChanged := true; end; if (not EmailChanged) and (not NameChanged) then exit; CRMSystemuser.Modify(); if EmailChanged and ( (not CRMSystemuser.InternalEMailAddress.StartsWith(IntegrationUserPrimaryEmailStartTxt)) or (not CRMSystemuser.InternalEMailAddress.EndsWith(IntegrationUserPrimaryEmailEndTxt))) then Session.LogMessage('0000ENU', UserEmailNotUpdatedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if NameChanged and (CRMSystemuser.FirstName <> IntegrationUserFullNameTxt) then Session.LogMessage('0000ENW', UserNameNotUpdatedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; local procedure GetAvailableIntegrationUserEmail(): Text var IntegrationCRMSystemUser: Record "CRM Systemuser"; IntegrationUsernameEmailTxt: Text; EmailSuffix: Integer; begin EmailSuffix := 0; IntegrationUsernameEmailTxt := StrSubstNo(IntegrationUserPrimaryEmailTxt, ''); IntegrationCRMSystemuser.SetRange(InternalEMailAddress, IntegrationUsernameEmailTxt); while not IntegrationCRMSystemuser.IsEmpty() and (EmailSuffix < 100) do begin EmailSuffix += 1; IntegrationUsernameEmailTxt := StrSubstNo(IntegrationUserPrimaryEmailTxt, EmailSuffix); IntegrationCRMSystemuser.SetRange(InternalEMailAddress, IntegrationUsernameEmailTxt); end; if EmailSuffix >= 100 then exit(''); exit(IntegrationUsernameEmailTxt); end; [NonDebuggable] local procedure SyncCompany(var CDSConnectionSetup: Record "CDS Connection Setup"; AdminUserName: Text; AdminPassword: SecretText; AccessToken: SecretText; AdminADDomain: Text) var TempAdminCDSConnectionSetup: Record "CDS Connection Setup" temporary; Company: Record Company; GeneralLedgerSetup: Record "General Ledger Setup"; CDSCompany: Record "CDS Company"; RootCRMBusinessunit: Record "CRM Businessunit"; DefaultCRMBusinessunit: Record "CRM Businessunit"; UpdatedCRMBusinessunit: Record "CRM Businessunit"; CRMBusinessunit: Record "CRM Businessunit"; DefaultCRMTeam: Record "CRM Team"; InitialCRMTeam: Record "CRM Team"; UpdatingCRMTeam: Record "CRM Team"; UpdatedCRMTeam: Record "CRM Team"; NewCRMTransactioncurrency: Record "CRM Transactioncurrency"; CRMTransactioncurrency: Record "CRM Transactioncurrency"; CRMOrganization: Record "CRM Organization"; CRMRole: Record "CRM Role"; Currency: Record Currency; CurrExchRate: Record "Currency Exchange Rate"; CrmHelper: DotNet CrmHelper; TempConnectionName: Text; CompanyId: Text[36]; CompanyName: Text[30]; BusinessUnitName: Text[160]; TeamName: Text[160]; IntegrationRoleName: Text[100]; EmptyGuid: Guid; UpdateOwningTeam: Boolean; OwningTeamUpdated: Boolean; DefaultBusinessUnitFound: Boolean; IsCurrencyCheckHandled: Boolean; CRMBaseCurrencyCode: Text[5]; CRMBaseCurrencyFoundLocally: Boolean; begin Session.LogMessage('0000AS2', SynchronizeCompanyTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); ResetCache(); Company.Get(CompanyName()); CompanyId := GetCompanyExternalId(Company); CompanyName := CopyStr(Company.Name, 1, MaxStrLen(CompanyName)); BusinessUnitName := GetDefaultBusinessUnitName(CompanyName, CompanyId); GetTempAdminConnectionSetup(TempAdminCDSConnectionSetup, CDSConnectionSetup, AdminUserName, AdminPassword, AccessToken, AdminADDomain); InitializeConnection(CrmHelper, TempAdminCDSConnectionSetup); TempConnectionName := GetTempConnectionName(); RegisterConnection(TempAdminCDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName, true); // Table connection is scoped, therefore all manipulations with CDS tables must be placed // in this procedure between SetDefaultTableConnection and UnregisterConnection Session.LogMessage('0000AS3', CheckBusinessUnitTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); RootCRMBusinessunit.SetRange(ParentBusinessUnitId, EmptyGuid); RootCRMBusinessunit.FindFirst(); DefaultCRMBusinessunit.SetRange(ParentBusinessUnitId, RootCRMBusinessunit.BusinessUnitId); DefaultCRMBusinessunit.SetRange(Name, BusinessUnitName); DefaultBusinessUnitFound := DefaultCRMBusinessunit.FindFirst(); if not DefaultBusinessUnitFound then begin DefaultCRMBusinessunit.SetFilter(Name, '*' + CompanyId + '*'); if DefaultCRMBusinessunit.FindFirst() then DefaultBusinessUnitFound := DefaultCRMBusinessunit.Name.EndsWith(StrSubstNo(BusinessUnitNameSuffixTok, CompanyId)) end; if not DefaultBusinessUnitFound then begin DefaultCRMBusinessunit.Name := BusinessUnitName; DefaultCRMBusinessunit.TransactionCurrencyId := CRMTransactioncurrency.TransactionCurrencyId; DefaultCRMBusinessunit.ParentBusinessUnitId := RootCRMBusinessunit.BusinessUnitId; if not DefaultCRMBusinessunit.Insert() then begin Session.LogMessage('0000AS4', CannotCreateBusinessUnitTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(EnrichWithDotNetException(CannotCreateBusinessUnitErr), BusinessUnitName); end; Session.LogMessage('0000AS5', BusinessUnitCreatedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end else Session.LogMessage('0000AS6', BusinessUnitAlreadyExistsTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Session.LogMessage('0000AS7', CheckOwningTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); TeamName := GetOwningTeamName(DefaultCRMBusinessunit.Name); FilterTeam(DefaultCRMBusinessunit.BusinessUnitId, TeamName, DefaultCRMTeam); if not DefaultCRMTeam.FindFirst() then begin DefaultCRMTeam.Name := TeamName; DefaultCRMTeam.BusinessUnitId := DefaultCRMBusinessunit.BusinessUnitId; DefaultCRMTeam.TeamType := DefaultCRMTeam.TeamType::Owner; if not DefaultCRMTeam.Insert() then begin Session.LogMessage('0000AS8', CannotCreateTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(EnrichWithDotNetException(CannotCreateTeamErr), TeamName, BusinessUnitName); end; Session.LogMessage('0000AS9', TeamCreatedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end else Session.LogMessage('0000ASA', TeamAlreadyExistsTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Session.LogMessage('0000ASB', CheckTeamRolesTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if not CRMRole.Get(GetIntegrationRoleId()) then begin Session.LogMessage('0000ASC', IntegrationRoleNotFoundTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(IntegrationRoleNotFoundErr, IntegrationRoleName, RootCRMBusinessunit.Name); end; IntegrationRoleName := CRMRole.Name; CRMRole.SetRange(ParentRoleId, GetIntegrationRoleId()); CRMRole.SetRange(BusinessUnitId, DefaultCRMBusinessunit.BusinessUnitId); if not CRMRole.FindFirst() then begin Session.LogMessage('0000ASD', RoleNotFoundForBusinessUnitTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(IntegrationRoleNotFoundErr, IntegrationRoleName, DefaultCRMBusinessunit.Name); end; if not AssignTeamRole(CrmHelper, DefaultCRMTeam.TeamId, CRMRole.RoleId) then begin Session.LogMessage('0000ASE', CannotAssignRoleToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(EnrichWithDotNetException(CannotAssignRoleToTeamErr), DefaultCRMTeam.Name, DefaultCRMBusinessunit.Name, IntegrationRoleName); end; Session.LogMessage('0000ASF', RoleAssignedToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Session.LogMessage('0000ASG', CheckCompanyTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CDSCompany.SetRange(ExternalId, CompanyId); if not CDSCompany.FindFirst() then begin Session.LogMessage('0000ASH', CreateCompanyTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if not CRMOrganization.FindFirst() then begin Session.LogMessage('0000ASI', OrganizationNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(CannotFindOrganizationErr); end; if not CRMTransactioncurrency.Get(CRMOrganization.BaseCurrencyId) then begin Session.LogMessage('0000ASJ', CurrencyNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(BaseCurrencyNotFoundErr); end; CRMBaseCurrencyCode := CRMTransactioncurrency.ISOCurrencyCode; if not GeneralLedgerSetup.Get() then begin Session.LogMessage('0000ASK', GLSetupNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(GLSetupNotFoundErr); end; IsCurrencyCheckHandled := false; OnBeforeCheckGLSetupLCYCode(GeneralLedgerSetup, CRMTransactioncurrency, IsCurrencyCheckHandled); if not IsCurrencyCheckHandled then begin CRMTransactionCurrency.Reset(); if (GeneralLedgerSetup."LCY Code" = '') then Error(LCYCodeNotFoundErr); CRMTransactioncurrency.SetRange(ISOCurrencyCode, CopyStr(GeneralLedgerSetup."LCY Code", 1, MaxStrLen(TempAdminCDSConnectionSetup.BaseCurrencyCode))); if CRMTransactioncurrency.IsEmpty() then begin if Currency.Get(Uppercase(CRMBaseCurrencyCode)) then if CurrExchRate.ExchangeRateAdjmt(Today(), Currency.Code) <> 0 then CRMBaseCurrencyFoundLocally := true; if not CRMBaseCurrencyFoundLocally then begin Session.LogMessage('0000K8O', CurrencyMismatchTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(LCYMustMatchBaseCurrencyErr, GeneralLedgerSetup."LCY Code"); end; NewCRMTransactionCurrency.ISOCurrencyCode := CopyStr(GeneralLedgerSetup."LCY Code", 1, MaxStrLen(CRMTransactionCurrency.ISOCurrencyCode)); if GeneralLedgerSetup."Local Currency Description" <> '' then NewCRMTransactioncurrency.CurrencyName := CopyStr(GeneralLedgerSetup."Local Currency Description", 1, MaxStrLen(CRMTransactionCurrency.CurrencyName)) else NewCRMTransactioncurrency.CurrencyName := CopyStr(GeneralLedgerSetup."LCY Code", 1, MaxStrLen(CRMTransactionCurrency.CurrencyName)); if GeneralLedgerSetup."Local Currency Symbol" <> '' then NewCRMTransactioncurrency.CurrencySymbol := CopyStr(GeneralLedgerSetup."Local Currency Symbol", 1, MaxStrLen(CRMTransactionCurrency.CurrencySymbol)) else NewCRMTransactioncurrency.CurrencySymbol := CopyStr(GeneralLedgerSetup."LCY Code", 1, MaxStrLen(CRMTransactionCurrency.CurrencySymbol)); NewCRMTransactioncurrency.ExchangeRate := CurrExchRate.ExchangeRateAdjmt(Today(), Currency.Code); Evaluate(NewCRMTransactioncurrency.CurrencyPrecision, CopyStr(Currency."Amount Decimal Places", StrPos(Currency."Amount Decimal Places", ':') + 1)); if not NewCRMTransactionCurrency.Insert() then begin Session.LogMessage('0000K8P', CurrencyMismatchTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(LCYMustMatchBaseCurrencyErr, GeneralLedgerSetup."LCY Code"); end; end; if GeneralLedgerSetup."LCY Code" <> Uppercase(CRMBaseCurrencyCode) then begin CRMTransactioncurrency.FindFirst(); if not Currency.Get(Uppercase(CRMBaseCurrencyCode)) then begin Currency.Code := CopyStr(Uppercase(CRMBaseCurrencyCode), 1, MaxStrLen(Currency.Code)); Currency.Symbol := CRMTransactioncurrency.CurrencySymbol; Currency."ISO Code" := CopyStr(CRMTransactioncurrency.ISOCurrencyCode, 1, MaxStrLen(Currency."ISO Code")); Currency."Amount Decimal Places" := Format(CRMTransactioncurrency.CurrencyPrecision) + ':' + Format(CRMTransactioncurrency.CurrencyPrecision); Currency.Description := CopyStr(CRMTransactioncurrency.CurrencyName, 1, MaxStrlen(Currency.Description)); if not Currency.Insert() then begin Session.LogMessage('0000KJE', CurrencyMismatchTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(BaseCurrencyMustExistInBCErr, Uppercase(CRMBaseCurrencyCode)); end; end; CurrExchRate.SetRange("Currency Code", Currency.Code); if CurrExchRate.IsEmpty() then begin CurrExchRate."Currency Code" := Currency.Code; CurrExchRate."Relational Exch. Rate Amount" := 1; CurrExchRate."Relational Adjmt Exch Rate Amt" := 1; CurrExchRate."Exchange Rate Amount" := 1 / CRMTransactioncurrency.ExchangeRate; CurrExchRate."Relational Exch. Rate Amount" := CurrExchRate."Exchange Rate Amount"; CurrExchRate."Starting Date" := Today(); if not CurrExchRate.Insert() then begin Session.LogMessage('0000KJF', CurrencyMismatchTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(BaseCurrencyMustExistInBCErr, Uppercase(CRMBaseCurrencyCode)); end; end; end; end; CDSCompany.ExternalId := CompanyId; CDSCompany.Name := CompanyName; CDSCompany.DefaultOwningTeam := DefaultCRMTeam.TeamId; CDSCompany.OwnerIdType := CDSCompany.OwnerIdType::team; CDSCompany.OwnerId := DefaultCRMTeam.TeamId; if not CDSCompany.Insert() then begin Session.LogMessage('0000ASM', CannotCreateCompanyTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(EnrichWithDotNetException(CannotCreateCompanyErr), CompanyName); end; Session.LogMessage('0000ASN', CompanyCreatedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end else begin Session.LogMessage('0000ASO', CompanyAlreadyExistsTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if IsNullGuid(CDSCompany.DefaultOwningTeam) then begin CDSCompany.DefaultOwningTeam := DefaultCRMTeam.TeamId; if not CDSCompany.Modify() then begin Session.LogMessage('0000ASP', CannotSetDefaultOwningTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(EnrichWithDotNetException(CannotSetDefaultOwningTeamErr)); end; Session.LogMessage('0000ASQ', DefaultOwningTeamSetTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; end; UpdateOwningTeam := true; if InitialCRMTeam.Get(CDSCompany.DefaultOwningTeam) then if CRMBusinessunit.Get(InitialCRMTeam.BusinessUnitId) then UpdateOwningTeam := (CDSConnectionSetup."Business Unit Id" <> CRMBusinessunit.BusinessUnitId) or (CDSConnectionSetup."Business Unit Name" <> CRMBusinessunit.Name); if UpdateOwningTeam and not IsNullGuid(CDSConnectionSetup."Business Unit Id") then if UpdatedCRMBusinessunit.Get(CDSConnectionSetup."Business Unit Id") then begin // update default owning team field on CDS company Session.LogMessage('0000ASR', CheckOwningTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); TeamName := GetOwningTeamName(UpdatedCRMBusinessunit.Name); FilterTeam(UpdatedCRMBusinessunit.BusinessUnitId, TeamName, UpdatingCRMTeam); if not UpdatingCRMTeam.FindFirst() then begin UpdatingCRMTeam.Name := TeamName; UpdatingCRMTeam.BusinessUnitId := UpdatedCRMBusinessunit.BusinessUnitId; UpdatingCRMTeam.TeamType := UpdatingCRMTeam.TeamType::Owner; if not UpdatingCRMTeam.Insert() then begin Session.LogMessage('0000ASS', CannotCreateTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(EnrichWithDotNetException(CannotCreateTeamErr), TeamName, UpdatedCRMBusinessunit.Name); end; Session.LogMessage('0000AST', TeamCreatedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end else Session.LogMessage('0000ASU', TeamAlreadyExistsTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMRole.SetRange(ParentRoleId, GetIntegrationRoleId()); CRMRole.SetRange(BusinessUnitId, UpdatedCRMBusinessunit.BusinessUnitId); if not CRMRole.FindFirst() then begin Session.LogMessage('0000ASV', RoleNotFoundForBusinessUnitTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(IntegrationRoleNotFoundErr, IntegrationRoleName, UpdatedCRMBusinessunit.Name); end; if not AssignTeamRole(CrmHelper, UpdatingCRMTeam.TeamId, CRMRole.RoleId) then begin Session.LogMessage('0000ASW', CannotAssignRoleToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(EnrichWithDotNetException(CannotAssignRoleToTeamErr), UpdatingCRMTeam.Name, UpdatedCRMBusinessunit.Name, IntegrationRoleName); end; Session.LogMessage('0000ASX', RoleAssignedToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CDSCompany.DefaultOwningTeam := UpdatingCRMTeam.TeamId; if not CDSCompany.Modify() then begin Session.LogMessage('0000ASY', CannotSetDefaultOwningTeamTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(EnrichWithDotNetException(CannotSetDefaultOwningTeamErr)); end; OwningTeamUpdated := true; Session.LogMessage('0000ASZ', DefaultOwningTeamSetTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end else Session.LogMessage('0000AT0', BusinessUnitNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if not OwningTeamUpdated then begin UpdatedCRMTeam.Get(CDSCompany.DefaultOwningTeam); if not UpdatedCRMBusinessunit.Get(UpdatedCRMTeam.BusinessUnitId) then begin Session.LogMessage('0000AT1', BusinessUnitNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(BusinessUnitNotFoundErr, UpdatedCRMTeam.BusinessUnitId); end; if (CDSConnectionSetup."Business Unit Id" <> UpdatedCRMBusinessunit.BusinessUnitId) or (CDSConnectionSetup."Business Unit Name" <> UpdatedCRMBusinessunit.Name) then begin // fix business unit related fields in the setup table Session.LogMessage('0000AT2', BusinessUnitFixedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CDSConnectionSetup."Business Unit Id" := UpdatedCRMBusinessunit.BusinessUnitId; CDSConnectionSetup."Business Unit Name" := UpdatedCRMBusinessunit.Name; ModifyBusinessUnitCoupling(CDSConnectionSetup); end else Session.LogMessage('0000AT3', BusinessUnitCoupledTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; UnregisterTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName); Session.LogMessage('0000AT4', CompanySynchronizedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; local procedure EnrichWithDotNetException(ErrorMessage: Text): Text var DotNetExceptionHandler: Codeunit "DotNet Exception Handler"; DotNetExceptionMessage: Text; EnrichedErrorMessage: Text; begin DotNetExceptionHandler.Collect(); DotNetExceptionMessage := DotNetExceptionHandler.GetMessage(); if DotNetExceptionMessage = '' then exit(ErrorMessage); EnrichedErrorMessage := ErrorMessage + ' ' + DotNetExceptionMessage; if StrPos(DotNetExceptionMessage, 'PrivilegeId') = 0 then exit(EnrichedErrorMessage); EnrichedErrorMessage := EnrichedErrorMessage + ' ' + StrSubstNo(InsufficientPriviegesTxt, FixPermissionsUrlTxt); exit(EnrichedErrorMessage); end; [Scope('OnPrem')] procedure AddCoupledUsersToDefaultOwningTeam(var CDSConnectionSetup: Record "CDS Connection Setup"): Integer; var TempCRMSystemuser: Record "CRM Systemuser" temporary; begin GetCoupledUsers(TempCRMSystemuser); exit(AddUsersToDefaultOwningTeam(CDSConnectionSetup, TempCRMSystemuser)); end; [Scope('OnPrem')] procedure AddCoupledUsersToDefaultOwningTeam(var CDSConnectionSetup: Record "CDS Connection Setup"; var TempCRMSystemuser: Record "CRM Systemuser" temporary): Integer; var CRMIntegrationRecord: Record "CRM Integration Record"; TempSelectedCRMSystemuser: Record "CRM Systemuser" temporary; begin CRMIntegrationRecord.SetRange("Table ID", Database::"Salesperson/Purchaser"); if TempCRMSystemuser.FindSet() then repeat CRMIntegrationRecord.SetRange("CRM ID", TempCRMSystemuser.SystemUserId); if not CRMIntegrationRecord.IsEmpty() then begin TempSelectedCRMSystemuser.Init(); TempSelectedCRMSystemuser.TransferFields(TempCRMSystemuser); TempSelectedCRMSystemuser.Insert(); end; until TempCRMSystemuser.Next() = 0; exit(AddUsersToDefaultOwningTeam(CDSConnectionSetup, TempSelectedCRMSystemuser)); end; [Scope('OnPrem')] [NonDebuggable] procedure AddUsersToDefaultOwningTeam(var CDSConnectionSetup: Record "CDS Connection Setup"; var TempCRMSystemuser: Record "CRM Systemuser" temporary): Integer; var TempCDSTeammembership: Record "CDS Teammembership" temporary; TempSelectedCRMSystemuser: Record "CRM Systemuser" temporary; CrmHelper: DotNet CrmHelper; AdminUser: Text; AdminPassword: SecretText; AccessToken: SecretText; AdminADDomain: Text; begin CheckConnectionRequiredFields(CDSConnectionSetup, false); GetDefaultOwningTeamMembership(CDSConnectionSetup, TempCDSTeammembership); if TempCRMSystemuser.FindSet() then repeat TempCDSTeammembership.SetRange(SystemUserId, TempCRMSystemuser.SystemUserId); if TempCDSTeammembership.IsEmpty() then begin TempSelectedCRMSystemuser.Init(); TempSelectedCRMSystemuser.TransferFields(TempCRMSystemuser); TempSelectedCRMSystemuser.Insert(); end; until TempCRMSystemuser.Next() = 0; if TempSelectedCRMSystemuser.IsEmpty() then exit(0); SignInCDSAdminUser(CDSConnectionSetup, CrmHelper, AdminUser, AdminPassword, AccessToken, AdminADDomain, true); exit(AddUsersToDefaultOwningTeam(CDSConnectionSetup, CrmHelper, TempSelectedCRMSystemuser)); end; [Scope('OnPrem')] procedure AddCoupledUsersToDefaultOwningTeam(var CDSConnectionSetup: Record "CDS Connection Setup"; var CrmHelper: DotNet CrmHelper): Integer var TempCRMSystemuser: Record "CRM Systemuser" temporary; begin GetCoupledUsers(TempCRMSystemuser); exit(AddUsersToDefaultOwningTeam(CDSConnectionSetup, CrmHelper, TempCRMSystemuser)); end; [Scope('OnPrem')] procedure AddUsersToDefaultOwningTeam(var CDSConnectionSetup: Record "CDS Connection Setup"; var CrmHelper: DotNet CrmHelper; var TempCRMSystemuser: Record "CRM Systemuser" temporary): Integer var Window: Dialog; TeamId: Guid; Added: Integer; UserNumber: Integer; UserCount: Integer; begin Session.LogMessage('0000C9M', AddCoupledUsersToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); UserCount := TempCRMSystemuser.Count(); if UserCount = 0 then begin Session.LogMessage('0000C9O', CoupledUsersNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(0); end; TeamId := GetOwningTeamId(CDSConnectionSetup); if IsNullGuid(TeamId) then begin Session.LogMessage('0000C9P', TeamNotFoundTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(0); end; if GuiAllowed then begin Window.Open(AddingCoupledUsersToTeamMsg); Window.Update(1, ''); end; if TempCRMSystemuser.FindSet() then repeat if GuiAllowed then begin UserNumber += 1; Window.Update(1, StrSubstNo(ProcessingUserMsg, UserNumber, UserCount)); end; if AddUserToTeam(CrmHelper, TempCRMSystemuser.SystemUserId, TeamId) then Added += 1; until TempCRMSystemuser.Next() = 0; if GuiAllowed then Window.Close(); exit(Added); end; local procedure GetCoupledUsers(var TempCRMSystemuser: Record "CRM Systemuser" temporary) var CRMIntegrationRecord: Record "CRM Integration Record"; begin CRMIntegrationRecord.SetRange("Table ID", Database::"Salesperson/Purchaser"); if CRMIntegrationRecord.FindSet() then repeat TempCRMSystemuser.Init(); TempCRMSystemuser.SystemUserId := CRMIntegrationRecord."CRM ID"; if TempCRMSystemuser.Insert() then; until CRMIntegrationRecord.Next() = 0; end; procedure GetTempConnectionSetup(var TempCDSConnectionSetup: Record "CDS Connection Setup" temporary; var CDSConnectionSetup: Record "CDS Connection Setup"; AccessToken: SecretText); var EmptySecretText: SecretText; begin GetTempAdminConnectionSetup(TempCDSConnectionSetup, CDSConnectionSetup, '', EmptySecretText, AccessToken, ''); end; local procedure GetTempAdminConnectionSetup(var TempAdminCDSConnectionSetup: Record "CDS Connection Setup" temporary; var CDSConnectionSetup: Record "CDS Connection Setup"; AdminUser: Text; AdminPassword: SecretText; AccessToken: SecretText; AdminADDomain: Text); begin TempAdminCDSConnectionSetup.Init(); TempAdminCDSConnectionSetup."Proxy Version" := CDSConnectionSetup.GetProxyVersion(); TempAdminCDSConnectionSetup."Server Address" := CDSConnectionSetup."Server Address"; if CDSConnectionSetup."Authentication Type" = CDSConnectionSetup."Authentication Type"::Office365 then begin TempAdminCDSConnectionSetup.SetAccessToken(AccessToken); SetConnectionString(TempAdminCDSConnectionSetup, OAuthConnectionStringFormatTxt); end; if CDSConnectionSetup."Authentication Type" <> CDSConnectionSetup."Authentication Type"::Office365 then begin TempAdminCDSConnectionSetup."Authentication Type" := CDSConnectionSetup."Authentication Type"; TempAdminCDSConnectionSetup.Domain := CopyStr(AdminADDomain, 1, MaxStrLen(TempAdminCDSConnectionSetup.Domain)); TempAdminCDSConnectionSetup."User Name" := CopyStr(AdminUser, 1, MaxStrLen(TempAdminCDSConnectionSetup."User Name")); TempAdminCDSConnectionSetup.SetPassword(AdminPassword); SetConnectionString(TempAdminCDSConnectionSetup, ReplaceUserNameInConnectionString(CDSConnectionSetup, AdminUser)); end; end; [Scope('OnPrem')] procedure TestActiveConnection(): Boolean begin if TryCheckEntitiesAvailability() then begin Session.LogMessage('0000AT5', ConnectionTestSucceedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(true); end; Session.LogMessage('0000AT6', ConnectionTestFailedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; [Scope('OnPrem')] procedure TestSystemUsersAvailability() begin CheckSystemUsersAvailability(); end; [Scope('OnPrem')] procedure CheckIntegrationRequirements(var CDSConnectionSetup: Record "CDS Connection Setup"; Silent: Boolean): Boolean begin if Silent then begin if not TryCheckIntegrationRequirements(CDSConnectionSetup) then begin Session.LogMessage('0000AT7', IntegrationRequirementsNotMetTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; Session.LogMessage('0000AU0', IntegrationRequirementsMetTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(true); end; CheckIntegrationRequirements(CDSConnectionSetup); exit(true); end; [Scope('OnPrem')] procedure CheckIntegrationSolutionRequirements(var CDSConnectionSetup: Record "CDS Connection Setup"; Silent: Boolean): Boolean begin if Silent then begin if not TryCheckIntegrationSolutionRequirements(CDSConnectionSetup) then begin Session.LogMessage('0000AT8', SolutionRequirementsNotMetTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; exit(true); end; CheckIntegrationSolutionRequirements(CDSConnectionSetup); exit(true); end; [Scope('OnPrem')] procedure CheckIntegrationUserRequirements(var CDSConnectionSetup: Record "CDS Connection Setup"; Silent: Boolean): Boolean begin if Silent then begin if not TryCheckIntegrationUserRequirements(CDSConnectionSetup) then begin Session.LogMessage('0000AT9', IntegrationUserRequirementsNotMetTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; exit(true); end; CheckIntegrationUserRequirements(CDSConnectionSetup); exit(true); end; [Scope('OnPrem')] procedure CheckOwningTeamRequirements(var CDSConnectionSetup: Record "CDS Connection Setup"; Silent: Boolean): Boolean begin if Silent then begin if not TryCheckOwningTeamRequirements(CDSConnectionSetup) then begin Session.LogMessage('0000ATA', OwningTeamRequirementsNotMetTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; exit(true); end; CheckOwningTeamRequirements(CDSConnectionSetup); exit(true); end; [TryFunction] local procedure TryCheckIntegrationRequirements(var CDSConnectionSetup: Record "CDS Connection Setup") begin CheckIntegrationRequirements(CDSConnectionSetup); end; local procedure CheckIntegrationRequirements(var CDSConnectionSetup: Record "CDS Connection Setup") begin CheckIntegrationSolutionRequirements(CDSConnectionSetup); CheckIntegrationUserRequirements(CDSConnectionSetup); CheckOwningTeamRequirements(CDSConnectionSetup); CheckEntitiesAvailability(CDSConnectionSetup); end; [TryFunction] local procedure TryCheckIntegrationSolutionRequirements(var CDSConnectionSetup: Record "CDS Connection Setup") begin CheckIntegrationSolutionRequirements(CDSConnectionSetup); end; local procedure CheckIntegrationSolutionRequirements(var CDSConnectionSetup: Record "CDS Connection Setup") var Version: Text; begin if not GetSolutionVersion(CDSConnectionSetup, Version) then begin Session.LogMessage('0000ATC', SolutionNotInstalledTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(BaseIntegrationSolutionNotInstalledErr, GetBaseSolutionDisplayName()); end; if not IsSolutionVersionValid(Version) then begin Session.LogMessage('0000ATD', InvalidSolutionVersionTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(SolutionVersionErr); end; end; [TryFunction] local procedure TryCheckIntegrationUserRequirements(var CDSConnectionSetup: Record "CDS Connection Setup") begin CheckIntegrationUserRequirements(CDSConnectionSetup); end; local procedure CheckIntegrationUserRequirements(var CDSConnectionSetup: Record "CDS Connection Setup") var CRMRole: Record "CRM Role"; TempCRMRole: Record "CRM Role" temporary; CRMSystemuserroles: Record "CRM Systemuserroles"; CRMSystemuser: Record "CRM Systemuser"; IntegrationRoleName: Text; SystemAdminRoleName: Text; TempConnectionName: Text; IntegrationRoleDeployed: Boolean; ChosenUserHasSystemAdminRole: Boolean; ChosenUserHasIntegrationRole: Boolean; begin TempConnectionName := GetTempConnectionName(); RegisterConnection(CDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TableConnectionType::CRM, TempConnectionName, true); if CRMRole.FindSet() then repeat TempCRMRole.TransferFields(CRMRole); TempCRMRole.Insert(); if TempCRMRole.RoleId = GetIntegrationRoleId() then begin IntegrationRoleDeployed := true; IntegrationRoleName := TempCRMRole.Name; end; until CRMRole.Next() = 0; FilterUser(CDSConnectionSetup, CRMSystemuser); if CRMSystemuser.FindFirst() then begin if CRMSystemuser.IsDisabled then begin Session.LogMessage('0000ATF', UserNotActiveTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(UserNotActiveErr, CDSConnectionSetup."User Name", CDSConnectionSetup."Server Address"); end; if not CDSConnectionSetup."Connection String".Contains(ClientSecretAuthTxt) and not CDSConnectionSetup."Connection String".Contains(CertificateAuthTxt) then begin if not CRMSystemuser.IsIntegrationUser then begin Session.LogMessage('0000B2E', NotIntegrationUserTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(NotIntegrationUserErr, CDSConnectionSetup."User Name", CDSConnectionSetup."Server Address"); end; if CRMSystemuser.AccessMode <> CRMSystemuser.AccessMode::"Non-interactive" then begin Session.LogMessage('0000B2F', NotNonInteractiveAccessModeTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(NotNonInteractiveAccessModeErr, CDSConnectionSetup."User Name", CDSConnectionSetup."Server Address", CRMSystemuser.AccessMode); end; end; CRMSystemuserroles.SetRange(SystemUserId, CRMSystemuser.SystemUserId); if CRMSystemuserroles.FindSet() then repeat if TempCRMRole.Get(CRMSystemuserroles.RoleId) then begin if TempCRMRole.RoleTemplateId = GetSystemAdminRoleTemplateId() then begin ChosenUserHasSystemAdminRole := true; SystemAdminRoleName := TempCRMRole.Name end; if TempCRMRole.RoleId = GetIntegrationRoleId() then ChosenUserHasIntegrationRole := true; end; until CRMSystemuserroles.Next() = 0 else if (CDSConnectionSetup."Server Address" <> '') and (CDSConnectionSetup."Server Address" <> TestServerAddressTok) then begin Session.LogMessage('0000ATH', UserHasNoRolesTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(UserHasNoRolesErr, CDSConnectionSetup."User Name", CDSConnectionSetup."Server Address"); end; if ChosenUserHasSystemAdminRole then begin Session.LogMessage('0000ATI', SystemAdminRoleTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(SystemAdminErr, CDSConnectionSetup."User Name", SystemAdminRoleName, CDSConnectionSetup."Server Address"); end; if IntegrationRoleDeployed and (not ChosenUserHasIntegrationRole) then begin Session.LogMessage('0000ATJ', NoIntegrationRoleTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(UserRolesErr, CDSConnectionSetup."User Name", IntegrationRoleName, CDSConnectionSetup."Server Address"); end; end; UnregisterTableConnection(TableConnectionType::CRM, TempConnectionName); end; [Scope('OnPrem')] [NonDebuggable] procedure CheckIntegrationUserPrerequisites(var CDSConnectionSetup: Record "CDS Connection Setup"; AdminUserName: text; AdminPassword: SecretText; AccessToken: SecretText; AdminADDomain: Text) var TempCDSConnectionSetup: Record "CDS Connection Setup" temporary; CRMRole: Record "CRM Role"; CRMSystemuserroles: Record "CRM Systemuserroles"; CRMSystemuser: Record "CRM Systemuser"; TempConnectionName: Text; begin GetTempAdminConnectionSetup(TempCDSConnectionSetup, CDSConnectionSetup, AdminUserName, AdminPassword, AccessToken, AdminADDomain); TempConnectionName := GetTempConnectionName(); RegisterConnection(TempCDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TableConnectionType::CRM, TempConnectionName, true); FilterUser(CDSConnectionSetup, CRMSystemuser); if not CRMSystemuser.FindFirst() then begin Session.LogMessage('0000BNG', UserNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(UserDoesNotExistErr, CDSConnectionSetup."User Name"); end; if CRMSystemuser.IsDisabled then begin Session.LogMessage('0000BNH', UserNotActiveTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(UserNotActiveErr, CDSConnectionSetup."User Name", CDSConnectionSetup."Server Address"); end; if not (CRMSystemuser.AccessMode in [CRMSystemuser.AccessMode::"Read-Write", CRMSystemuser.AccessMode::"Non-interactive"]) then begin Session.LogMessage('0000B2G', InvalidAccessModeTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(InvalidAccessModeErr, CDSConnectionSetup."User Name", CDSConnectionSetup."Server Address", CRMSystemuser.AccessMode); end; if (not CRMSystemuser.IsLicensed) and (CRMSystemuser.AccessMode <> CRMSystemuser.AccessMode::"Non-interactive") then begin Session.LogMessage('0000ATG', UserNotLicensedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(UserNotLicensedErr, CDSConnectionSetup."User Name", CDSConnectionSetup."Server Address", CRMSystemuser.AccessMode); end; CRMSystemuserroles.SetRange(SystemUserId, CRMSystemuser.SystemUserId); if CRMSystemuserroles.FindSet() then repeat if CRMRole.Get(CRMSystemuserroles.RoleId) then if CRMRole.RoleTemplateId = GetSystemAdminRoleTemplateId() then begin Session.LogMessage('0000BNJ', SystemAdminRoleTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(SystemAdminErr, CDSConnectionSetup."User Name", CRMRole.Name, CDSConnectionSetup."Server Address"); end; until CRMSystemuserroles.Next() = 0; UnregisterTableConnection(TableConnectionType::CRM, TempConnectionName); end; [Scope('OnPrem')] [NonDebuggable] procedure CheckAdminUserPrerequisites(var CDSConnectionSetup: Record "CDS Connection Setup"; AdminUserName: Text; AdminPassword: Text; AccessToken: Text; AdminADDomain: Text) var TempCDSConnectionSetup: Record "CDS Connection Setup" temporary; CRMRole: Record "CRM Role"; CRMSystemuserroles: Record "CRM Systemuserroles"; CRMSystemuser: Record "CRM Systemuser"; TempConnectionName: Text; HasSystemAdminRole: Boolean; HasSystemCustomizerRole: Boolean; begin GetTempAdminConnectionSetup(TempCDSConnectionSetup, CDSConnectionSetup, AdminUserName, AdminPassword, AccessToken, AdminADDomain); CheckConnectionRequiredFields(TempCDSConnectionSetup, false); TempConnectionName := GetTempConnectionName(); RegisterConnection(TempCDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TableConnectionType::CRM, TempConnectionName, true); FilterUser(TempCDSConnectionSetup, CRMSystemuser); if not CRMSystemuser.FindFirst() then begin Session.LogMessage('0000BNK', UserNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(UserDoesNotExistErr, TempCDSConnectionSetup."User Name"); end; if CRMSystemuser.IsDisabled then begin Session.LogMessage('0000BNL', UserNotActiveTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(UserNotActiveErr, TempCDSConnectionSetup."User Name", TempCDSConnectionSetup."Server Address"); end; if not CRMSystemuser.IsLicensed then begin Session.LogMessage('0000BNM', UserNotLicensedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(UserNotLicensedErr, TempCDSConnectionSetup."User Name", TempCDSConnectionSetup."Server Address", CRMSystemuser.AccessMode); end; CRMSystemuserroles.SetRange(SystemUserId, CRMSystemuser.SystemUserId); if not CRMSystemuserroles.FindSet() then if (CDSConnectionSetup."Server Address" <> '') and (CDSConnectionSetup."Server Address" <> TestServerAddressTok) then begin Session.LogMessage('0000BNN', UserHasNoRolesTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(UserHasNoRolesErr, TempCDSConnectionSetup."User Name", TempCDSConnectionSetup."Server Address"); end; repeat if CRMRole.Get(CRMSystemuserroles.RoleId) then begin if CRMRole.RoleTemplateId = GetSystemAdminRoleTemplateId() then HasSystemAdminRole := true; if CRMRole.RoleTemplateId = GetSystemCustomizerRoleTemplateId() then HasSystemCustomizerRole := true; end; until CRMSystemuserroles.Next() = 0; if not HasSystemAdminRole then begin Session.LogMessage('0000BNO', NoSystemAdminRoleTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(NoSystemAdminRoleErr, TempCDSConnectionSetup."User Name", TempCDSConnectionSetup."Server Address"); end; if not HasSystemCustomizerRole then Session.LogMessage('0000BNP', NoSystemCustomizerRoleTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); UnregisterTableConnection(TableConnectionType::CRM, TempConnectionName); end; [TryFunction] local procedure TryCheckOwningTeamRequirements(var CDSConnectionSetup: Record "CDS Connection Setup") begin CheckOwningTeamRequirements(CDSConnectionSetup); end; local procedure CheckOwningTeamRequirements(var CDSConnectionSetup: Record "CDS Connection Setup") var CRMRole: Record "CRM Role"; CDSCompany: Record "CDS Company"; CDSTeamroles: Record "CDS Teamroles"; CRMTeam: Record "CRM Team"; CRMBusinessunit: Record "CRM Businessunit"; IntegrationRoleName: Text; TempConnectionName: Text; begin TempConnectionName := GetTempConnectionName(); RegisterConnection(CDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName, true); if not CRMRole.Get(GetIntegrationRoleId()) then begin Session.LogMessage('0000ATK', IntegrationRoleNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(RoleNotFoundErr, GetIntegrationRoleId()); end; IntegrationRoleName := CRMRole.Name; CDSCompany.SetRange(ExternalId, GetCompanyExternalId()); if not CDSCompany.FindFirst() then begin Session.LogMessage('0000ATL', CompanyNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(CompanyNotFoundErr, GetCompanyExternalId()); end; if not CRMTeam.Get(CDSCompany.DefaultOwningTeam) then begin Session.LogMessage('0000ATM', TeamNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(TeamNotFoundErr, CDSCompany.DefaultOwningTeam); end; if not CRMBusinessunit.Get(CRMTeam.BusinessUnitId) then begin Session.LogMessage('0000ATN', BusinessUnitNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(BusinessUnitNotFoundErr, CRMTeam.BusinessUnitId); end; if (CRMBusinessunit.BusinessUnitId <> CDSConnectionSetup."Business Unit Id") or (CRMBusinessunit.Name <> CDSConnectionSetup."Business Unit Name") then begin Session.LogMessage('0000B24', BusinessUnitMismatchTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(BusinessUnitMismatchErr); end; CRMRole.Reset(); CRMRole.SetRange(BusinessUnitId, CRMBusinessunit.BusinessUnitId); CRMRole.SetRange(ParentRoleId, GetIntegrationRoleId()); if not CRMRole.FindFirst() then begin Session.LogMessage('0000ATO', RoleNotFoundForBusinessUnitTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(IntegrationRoleNotFoundErr, IntegrationRoleName, CRMBusinessunit.Name); end; CDSTeamroles.SetRange(TeamId, CRMTeam.TeamId); CDSTeamroles.SetRange(RoleId, CRMRole.RoleId); if CDSTeamroles.IsEmpty() then begin Session.LogMessage('0000ATP', IntegrationRoleNotAssignedToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(TeamRolesErr, CRMTeam.Name, CRMBusinessunit.Name, IntegrationRoleName); end; UnregisterTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName); end; [TryFunction] [NonDebuggable] procedure IsVirtualTablesAppInstalled(var TempAdminCDSConnectionSetup: Record "CDS Connection Setup" temporary) begin CheckVirtualTablesAppInstalled(TempAdminCDSConnectionSetup); end; [NonDebuggable] local procedure CheckVirtualTablesAppInstalled(var TempAdminCDSConnectionSetup: Record "CDS Connection Setup" temporary) var CRMBCVirtualTableConfig: Record "CRM BC Virtual Table Config."; CRMCompany: Record "CRM Company"; TempConnectionName: Text; begin TempConnectionName := GetTempConnectionName(); RegisterConnection(TempAdminCDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TableConnectionType::CRM, TempConnectionName, true); if CRMBCVirtualTableConfig.IsEmpty() then; if CRMCompany.IsEmpty() then; UnregisterTableConnection(TableConnectionType::CRM, TempConnectionName); end; [Scope('OnPrem')] procedure CheckEntitiesAvailability(var CDSConnectionSetup: Record "CDS Connection Setup"; Silent: Boolean): Boolean begin if Silent then exit(TryCheckEntitiesAvailability(CDSConnectionSetup)); CheckEntitiesAvailability(CDSConnectionSetup); exit(true); end; [TryFunction] local procedure TryCheckEntitiesAvailability(var CDSConnectionSetup: Record "CDS Connection Setup") begin CheckEntitiesAvailability(CDSConnectionSetup); end; local procedure CheckEntitiesAvailability(var CDSConnectionSetup: Record "CDS Connection Setup") var CRMSystemuser: Record "CRM Systemuser"; CRMTeam: Record "CRM Team"; CRMRole: Record "CRM Role"; CRMSystemuserroles: Record "CRM Systemuserroles"; CRMBusinessunit: Record "CRM Businessunit"; CRMAccount: Record "CRM Account"; CRMContact: Record "CRM Contact"; CDSCompany: Record "CDS Company"; Id: Guid; TempConnectionName: Text; begin TempConnectionName := GetTempConnectionName(); RegisterConnection(CDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName, true); if CRMTeam.FindFirst() then Id := CRMTeam.TeamId; if CRMRole.FindFirst() then Id := CRMRole.RoleId; if CRMSystemuser.FindFirst() then Id := CRMSystemuser.SystemUserId; if CRMSystemuserroles.FindFirst() then Id := CRMSystemuserroles.SystemUserId; if CRMBusinessunit.FindFirst() then Id := CRMBusinessunit.BusinessUnitId; if CDSCompany.FindFirst() then Id := CDSCompany.CompanyId; if CRMAccount.FindFirst() then Id := CRMAccount.CompanyId; if CRMContact.FindFirst() then Id := CRMContact.CompanyId; UnregisterTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName); end; local procedure CheckSystemUsersAvailability() var CDSSystemuser: Record "CRM Systemuser"; Id: Guid; begin if CDSSystemuser.FindFirst() then Id := CDSSystemuser.SystemUserId; end; [TryFunction] local procedure TryCheckEntitiesAvailability() var CRMSystemuser: Record "CRM Systemuser"; CRMTeam: Record "CRM Team"; CRMRole: Record "CRM Role"; CRMSystemuserroles: Record "CRM Systemuserroles"; CRMBusinessunit: Record "CRM Businessunit"; CRMAccount: Record "CRM Account"; CRMContact: Record "CRM Contact"; CDSCompany: Record "CDS Company"; Id: Guid; begin if CRMTeam.FindFirst() then Id := CRMTeam.TeamId; if CRMRole.FindFirst() then Id := CRMRole.RoleId; if CRMSystemuser.FindFirst() then Id := CRMSystemuser.SystemUserId; if CRMSystemuserroles.FindFirst() then Id := CRMSystemuserroles.SystemUserId; if CRMBusinessunit.FindFirst() then Id := CRMBusinessunit.BusinessUnitId; if CDSCompany.FindFirst() then Id := CDSCompany.CompanyId; if CRMAccount.FindFirst() then Id := CRMAccount.CompanyId; if CRMContact.FindFirst() then Id := CRMContact.CompanyId; end; [Scope('OnPrem')] procedure SelectSDKVersion(var CDSConnectionSetup: Record "CDS Connection Setup"): Boolean var TempStack: Record TempStack temporary; begin if PAGE.RunModal(PAGE::"SDK Version List", TempStack) = ACTION::LookupOK then begin CDSConnectionSetup.Validate("Proxy Version", TempStack.StackOrder); exit(true); end; exit(false); end; [Scope('OnPrem')] procedure SelectBusinessUnit(var CDSConnectionSetup: Record "CDS Connection Setup"): Boolean var TempCRMBusinessUnit: Record "CRM Businessunit" temporary; EmptyGuid: Guid; PrevBusinessUnitId: Guid; DefaultBusinessUnitName: Text[160]; Changed: Boolean; AddArtificialDefaultBusinessUnit: Boolean; begin PrevBusinessUnitId := CDSConnectionSetup."Business Unit Id"; DefaultBusinessUnitName := GetDefaultBusinessUnitName(); if not GetFirstLevelBusinessUnits(CDSConnectionSetup, TempCRMBusinessUnit) then begin Changed := not IsNullGuid(PrevBusinessUnitId); if Changed then begin CDSConnectionSetup."Business Unit Id" := EmptyGuid; CDSConnectionSetup."Business Unit Name" := DefaultBusinessUnitName; end; exit(Changed); end; TempCRMBusinessUnit.SetRange(Name, DefaultBusinessUnitName); AddArtificialDefaultBusinessUnit := TempCRMBusinessUnit.IsEmpty(); TempCRMBusinessUnit.SetRange(Name); if AddArtificialDefaultBusinessUnit then begin TempCRMBusinessUnit.Init(); TempCRMBusinessUnit.BusinessUnitId := EmptyGuid; TempCRMBusinessUnit.Name := StrSubstNo(NewBusinessUnitNameTemplateTok, DefaultBusinessUnitName); TempCRMBusinessUnit.Insert(); end; if PAGE.RunModal(PAGE::"CDS Business Units", TempCRMBusinessUnit) <> ACTION::LookupOK then exit(false); Changed := TempCRMBusinessUnit.BusinessUnitId <> PrevBusinessUnitId; if Changed then begin CDSConnectionSetup."Business Unit Id" := TempCRMBusinessUnit.BusinessUnitId; if IsNullGuid(CDSConnectionSetup."Business Unit Id") then CDSConnectionSetup."Business Unit Name" := DefaultBusinessUnitName else CDSConnectionSetup."Business Unit Name" := TempCRMBusinessUnit.Name; end; exit(Changed); end; [TryFunction] local procedure GetFirstLevelBusinessUnits(var CDSConnectionSetup: Record "CDS Connection Setup"; var TempCRMBusinessunit: Record "CRM Businessunit" temporary) var CRMBusinessunit: Record "CRM Businessunit"; TempConnectionName: Text; RootBusinessUnitId: Guid; EmptyGuid: Guid; begin CheckConnectionRequiredFields(CDSConnectionSetup, false); TempConnectionName := GetTempConnectionName(); RegisterConnection(CDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName, true); // Table connection is scoped, therefore all manipulations with CDS tables must be placed // in this procedure between SetDefaultTableConnection and UnregisterConnection CRMBusinessunit.SetRange(ParentBusinessUnitId, EmptyGuid); if CRMBusinessunit.FindFirst() then begin RootBusinessUnitId := CRMBusinessunit.BusinessUnitId; CRMBusinessunit.SetRange(ParentBusinessUnitId, RootBusinessUnitId); CRMBusinessunit.SetRange(IsDisabled, false); if CRMBusinessunit.FindSet() then repeat TempCRMBusinessunit.Init(); TempCRMBusinessUnit.BusinessUnitId := CRMBusinessunit.BusinessUnitId; TempCRMBusinessUnit.Name := CRMBusinessUnit.Name; TempCRMBusinessunit.Insert(); until CRMBusinessunit.Next() = 0; if TempCRMBusinessunit.FindFirst() then; end; UnregisterTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName); end; [Scope('OnPrem')] procedure CheckConnectionRequiredFields(var CDSConnectionSetup: Record "CDS Connection Setup"; Silent: Boolean): Boolean var Success: Boolean; TelemetryTxt: Text; ErrorTxt: Text; begin Success := true; if CDSConnectionSetup."Server Address" = '' then Success := false; if CDSConnectionSetup."Authentication Type" <> CDSConnectionSetup."Authentication Type"::Office365 then begin if CDSConnectionSetup."User Name" = '' then Success := false; if not CDSConnectionSetup.HasPassword() then Success := false; end; if not Success then begin if CDSConnectionSetup."Authentication Type" <> CDSConnectionSetup."Authentication Type"::Office365 then begin TelemetryTxt := ConnectionRequiredFieldsTxt; ErrorTxt := ConnectionRequiredFieldsErr; end else begin TelemetryTxt := Office365ConnectionRequiredFieldsTxt; ErrorTxt := Office365ConnectionRequiredFieldsErr; end; Session.LogMessage('0000ATQ', TelemetryTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if not Silent then Error(ErrorTxt); end; exit(Success); end; [Scope('OnPrem')] procedure CheckConnectionRequiredFieldsMatch(var CDSConnectionSetup: Record "CDS Connection Setup"; Silent: Boolean): Boolean var CRMConnectionSetup: Record "CRM Connection Setup"; Success: Boolean; begin Success := true; if not CRMConnectionSetup.Get() then exit(true); if not CRMConnectionSetup."Is Enabled" then exit(true); if CDSConnectionSetup."Server Address" <> CRMConnectionSetup."Server Address" then Success := false; if CDSConnectionSetup."User Name" <> CRMConnectionSetup."User Name" then Success := false; if CDSConnectionSetup."User Password Key" <> CRMConnectionSetup."User Password Key" then Success := false; if CDSConnectionSetup."Authentication Type" <> CRMConnectionSetup."Authentication Type" then Success := false; if not Success then begin Session.LogMessage('0000BCM', ConnectionRequiredFieldsMismatchTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if not Silent then Error(ConnectionRequiredFieldsMismatchErr); end; exit(Success); end; local procedure FilterUser(var CDSConnectionSetup: Record "CDS Connection Setup"; var CRMSystemuser: Record "CRM Systemuser") begin case CDSConnectionSetup."Authentication Type" of CDSConnectionSetup."Authentication Type"::Office365, CDSConnectionSetup."Authentication Type"::OAuth: CRMSystemuser.SetFilter(InternalEMailAddress, StrSubstNo('@%1', CDSConnectionSetup."User Name")); CDSConnectionSetup."Authentication Type"::AD, CDSConnectionSetup."Authentication Type"::IFD: CRMSystemuser.SetFilter(DomainName, StrSubstNo('@%1', CDSConnectionSetup."User Name")); end; end; local procedure FilterTeam(BusinessUnitId: Guid; TeamName: Text; var CRMTeam: Record "CRM Team") begin CRMTeam.SetRange(Name, TeamName); CRMTeam.SetRange(BusinessUnitId, BusinessUnitId); CRMTeam.SetRange(IsDefault, false); end; local procedure GetUserName(var CDSConnectionSetup: Record "CDS Connection Setup") UserName: Text begin if CDSConnectionSetup."User Name" = '' then UserName := MissingUsernameTok else UserName := CopyStr(CDSConnectionSetup."User Name", StrPos(CDSConnectionSetup."User Name", '\') + 1); end; [Scope('OnPrem')] procedure RegisterAssistedSetup() var GuidedExperience: Codeunit "Guided Experience"; Language: Codeunit Language; ModuleInfo: ModuleInfo; AssistedSetupGroup: Enum "Assisted Setup Group"; VideoCategory: Enum "Video Category"; GuidedExperienceType: Enum "Guided Experience Type"; CurrentGlobalLanguage: Integer; begin if GuidedExperience.Exists(GuidedExperienceType::"Assisted Setup", ObjectType::Page, Page::"CDS Connection Setup Wizard") then exit; CurrentGlobalLanguage := GLOBALLANGUAGE; NavApp.GetCurrentModuleInfo(ModuleInfo); GuidedExperience.InsertAssistedSetup(CDSConnectionSetupTitleTxt, CDSConnectionSetupShortTitleTxt, CDSConnectionSetupDescriptionTxt, 10, ObjectType::Page, Page::"CDS Connection Setup Wizard", AssistedSetupGroup::Connect, '', VideoCategory::Connect, CDSConnectionSetupHelpTxt); GLOBALLANGUAGE(Language.GetDefaultApplicationLanguageId()); GuidedExperience.AddTranslationForSetupObjectTitle(GuidedExperienceType::"Assisted Setup", ObjectType::Page, Page::"CDS Connection Setup Wizard", Language.GetDefaultApplicationLanguageId(), CDSConnectionSetupTitleTxt); GLOBALLANGUAGE(CurrentGlobalLanguage); end; [NonDebuggable] local procedure GetConnectionStringWithCredentials(var CDSConnectionSetup: Record "CDS Connection Setup"): SecretText var ConnectionStringWithPassword: SecretText; ConnectionStringWithPasswordPlaceholder: Text; ConnectionStringWithClientSecret: SecretText; ConnectionStringWithClientSecretPlaceholder: Text; ConnectionStringWithCertificate: Text; ConnectionStringWithAccessToken: SecretText; ConnectionStringWithAccessTokenPlaceholder: Text; PasswordPlaceHolderPos: Integer; begin if CDSConnectionSetup."Connection String" = '' then exit; // if the setup record is temporary and user name is empty, this is a temp setup record constructed for the admin log-on // in this case, the connection string contains the URL and access token, so just use the connection string if CDSConnectionSetup.IsTemporary() then if CDSConnectionSetup."User Name" = '' then begin ConnectionStringWithAccessTokenPlaceholder := StrSubstNo(OAuthConnectionStringFormatTxt, CDSConnectionSetup."Server Address", '%1', CDSConnectionSetup.GetProxyVersion(), GetAuthenticationTypeToken(CDSConnectionSetup)); ConnectionStringWithAccessToken := SecretStrSubstNo(ConnectionStringWithAccessTokenPlaceholder, CDSConnectionSetup.GetSecretAccessToken()); exit(ConnectionStringWithAccessToken); end; // if auth type is Office365 and connection string contains {ClientSecret} token // then we will connect via OAuth client credentials grant flow, and construct the connection string accordingly, with the actual client secret if CDSConnectionSetup."Authentication Type" = CDSConnectionSetup."Authentication Type"::Office365 then begin if CDSConnectionSetup."Connection String".Contains(ClientSecretTok) then begin ConnectionStringWithClientSecretPlaceholder := StrSubstNo(ClientSecretConnectionStringFormatTxt, ClientSecretAuthTxt, CDSConnectionSetup."Server Address", GetCDSConnectionClientId(), '%1', CDSConnectionSetup.GetProxyVersion()); ConnectionStringWithClientSecret := SecretStrSubstNo(ConnectionStringWithClientSecretPlaceholder, GetCDSConnectionClientSecret()); Session.LogMessage('0000GRU', GetCDSConnectionClientId(), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(ConnectionStringWithClientSecret); end; if CDSConnectionSetup."Connection String".Contains(CertificateTok) then begin ConnectionStringWithCertificate := StrSubstNo(CertificateConnectionStringFormatTxt, CertificateAuthTxt, CDSConnectionSetup."Server Address", GetCDSConnectionFirstPartyAppId(), GetCDSConnectionFirstPartyAppcertificate(), CDSConnectionSetup.GetProxyVersion()); exit(ConnectionStringWithCertificate); end; end; PasswordPlaceHolderPos := StrPos(CDSConnectionSetup."Connection String", MissingPasswordTok); ConnectionStringWithPasswordPlaceholder := CopyStr(CDSConnectionSetup."Connection String", 1, PasswordPlaceHolderPos - 1) + '%1' + CopyStr(CDSConnectionSetup."Connection String", PasswordPlaceHolderPos + StrLen(MissingPasswordTok)); ConnectionStringWithPassword := SecretStrSubstNo(ConnectionStringWithPasswordPlaceholder, CDSConnectionSetup.GetSecretPassword()); exit(ConnectionStringWithPassword); end; [Scope('OnPrem')] procedure UpdateConnectionString(var CDSConnectionSetup: Record "CDS Connection Setup") var ConnectionString: Text; ConnectionStringWithClientSecret: Text; ConnectionStringWithCertificate: Text; begin if CDSConnectionSetup."Authentication Type" = CDSConnectionSetup."Authentication Type"::Office365 then begin if CDSConnectionSetup."Connection String".Contains(ClientSecretAuthTxt) then begin ConnectionStringWithClientSecret := StrSubstNo(ClientSecretConnectionStringFormatTxt, ClientSecretAuthTxt, CDSConnectionSetup."Server Address", ClientIdTok, ClientSecretTok, CDSConnectionSetup.GetProxyVersion()); SetConnectionString(CDSConnectionSetup, ConnectionStringWithClientSecret); exit; end; if CDSConnectionSetup."Connection String".Contains(CertificateAuthTxt) then begin ConnectionStringWithCertificate := StrSubstNo(CertificateConnectionStringFormatTxt, CertificateAuthTxt, CDSConnectionSetup."Server Address", ClientIdTok, CertificateTok, CDSConnectionSetup.GetProxyVersion()); SetConnectionString(CDSConnectionSetup, ConnectionStringWithCertificate); exit; end; end; ConnectionString := StrSubstNo( ConnectionStringFormatTok, CDSConnectionSetup."Server Address", GetUserName(CDSConnectionSetup), MissingPasswordTok, CDSConnectionSetup.GetProxyVersion(), GetAuthenticationTypeToken(CDSConnectionSetup)); SetConnectionString(CDSConnectionSetup, ConnectionString); end; [Scope('OnPrem')] procedure GetConnectionString(var CDSConnectionSetup: Record "CDS Connection Setup") ConnectionString: Text begin ConnectionString := CDSConnectionSetup."Connection String"; end; [Scope('OnPrem')] procedure SetConnectionString(var CDSConnectionSetup: Record "CDS Connection Setup"; ConnectionString: Text) begin if ConnectionString = '' then Clear(CDSConnectionSetup."Connection String") else begin if CDSConnectionSetup."Authentication Type" <> CDSConnectionSetup."Authentication Type"::Office365 then if StrPos(ConnectionString, MissingPasswordTok) = 0 then Error(ConnectionStringPwdPlaceHolderMissingErr); CDSConnectionSetup."Connection String" := CopyStr(ConnectionString, 1, MaxStrLen(CDSConnectionSetup."Connection String")); end; if not CDSConnectionSetup.Modify() then; end; [Scope('OnPrem')] [TryFunction] procedure TryGetCDSCompany(var CDSCompany: Record "CDS Company") begin GetCDSCompany(CDSCompany); end; [Scope('OnPrem')] procedure GetCDSCompany(var CDSCompany: Record "CDS Company") begin CDSCompany.SetRange(ExternalId, GetCompanyExternalId()); CDSCompany.FindFirst(); end; [Scope('OnPrem')] [TryFunction] procedure TryGetCompanyId(var CompanyId: Guid) begin CompanyId := GetCachedCompanyId(); end; [Scope('OnPrem')] procedure GetCoupledBusinessUnitId(): Guid var CDSConnectionSetup: Record "CDS Connection Setup"; EmptyGuid: Guid; begin if CDSConnectionSetup.Get() then exit(CDSConnectionSetup."Business Unit Id"); exit(EmptyGuid); end; [Scope('OnPrem')] procedure GetIntegrationUserId(var CDSConnectionSetup: Record "CDS Connection Setup") IntegrationUserId: Guid var CRMSystemuser: Record "CRM Systemuser"; TempConnectionName: Text; HasPersistentConnection: Boolean; begin CheckConnectionRequiredFields(CDSConnectionSetup, false); HasPersistentConnection := IsConnectionActive(CDSConnectionSetup, GetConnectionDefaultName()); if not HasPersistentConnection then begin TempConnectionName := GetTempConnectionName(); RegisterConnection(CDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TableConnectionType::CRM, TempConnectionName, true); end; FilterUser(CDSConnectionSetup, CRMSystemuser); if CRMSystemuser.FindFirst() then IntegrationUserID := CRMSystemuser.SystemUserId; if not HasPersistentConnection then UnregisterTableConnection(TableConnectionType::CRM, TempConnectionName); if IsNullGuid(IntegrationUserID) then ShowError(UserSetupTxt, CannotResolveUserFromConnectionSetupErr); end; [Scope('OnPrem')] procedure GetOwningTeamId(var CDSConnectionSetup: Record "CDS Connection Setup"): Guid var CRMBusinessUnit: Record "CRM Businessunit"; CRMTeam: Record "CRM team"; BusinessUnitId: Guid; TeamId: Guid; TeamName: Text; TempConnectionName: Text; HasPersistentConnection: Boolean; begin CheckConnectionRequiredFields(CDSConnectionSetup, false); BusinessUnitId := CDSConnectionSetup."Business Unit Id"; if IsNullGuid(BusinessUnitId) then begin Session.LogMessage('0000GDF', TeamNotFoundTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(TeamId); end; HasPersistentConnection := IsConnectionActive(CDSConnectionSetup, GetConnectionDefaultName()); if not HasPersistentConnection then begin TempConnectionName := GetTempConnectionName(); RegisterConnection(CDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TableConnectionType::CRM, TempConnectionName, true); end; if CRMBusinessUnit.Get(BusinessUnitId) then begin TeamName := GetOwningTeamName(CRMBusinessUnit.Name); FilterTeam(BusinessUnitId, TeamName, CRMTeam); if CRMTeam.FindFirst() then TeamId := CRMTeam.TeamId else Session.LogMessage('0000GDG', TeamNotFoundTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end else Session.LogMessage('0000GDH', TeamNotFoundTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if not HasPersistentConnection then UnregisterTableConnection(TableConnectionType::CRM, TempConnectionName); exit(TeamId); end; [Scope('OnPrem')] procedure GetDefaultOwningTeamMembership(var TempCDSTeammembership: Record "CDS Teammembership" temporary) var CDSConnectionSetup: Record "CDS Connection Setup"; begin if CDSConnectionSetup.Get() then GetDefaultOwningTeamMembership(CDSConnectionSetup, TempCDSTeammembership); end; [Scope('OnPrem')] procedure GetDefaultOwningTeamMembership(var CDSConnectionSetup: Record "CDS Connection Setup"; var TempCDSTeammembership: Record "CDS Teammembership" temporary) var CDSTeammembership: Record "CDS Teammembership"; BusinessUnitId: Guid; TeamId: Guid; TempConnectionName: Text; HasPersistentConnection: Boolean; begin if not CheckConnectionRequiredFields(CDSConnectionSetup, true) then exit; BusinessUnitId := CDSConnectionSetup."Business Unit Id"; if IsNullGuid(BusinessUnitId) then exit; TeamId := GetOwningTeamId(CDSConnectionSetup); if not IsNullGuid(TeamId) then begin HasPersistentConnection := IsConnectionActive(CDSConnectionSetup, GetConnectionDefaultName()); if not HasPersistentConnection then begin TempConnectionName := GetTempConnectionName(); RegisterConnection(CDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TableConnectionType::CRM, TempConnectionName, true); end; TempCDSTeammembership.Reset(); TempCDSTeammembership.DeleteAll(); CDSTeammembership.SetRange(TeamId, TeamId); if CDSTeammembership.FindSet() then repeat TempCDSTeammembership.Init(); TempCDSTeammembership.TransferFields(CDSTeammembership); TempCDSTeammembership.Insert(); until CDSTeammembership.Next() = 0; if not HasPersistentConnection then UnregisterTableConnection(TableConnectionType::CRM, TempConnectionName); end; end; local procedure AssignUserRole(var CrmHelper: DotNet CrmHelper; UserId: Guid; RoleId: Guid): Boolean begin if CrmHelper.CheckRoleAssignedToUser(UserId, RoleId) then exit(true); if not TryAssignUserRole(CrmHelper, UserId, RoleId) then begin Session.LogMessage('0000ATR', CannotAssignRoleToUserTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; if CrmHelper.CheckRoleAssignedToUser(UserId, RoleId) then exit(true); Session.LogMessage('0000ATS', CannotAssignRoleToUserTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; [TryFunction] local procedure TryAssignUserRole(var CrmHelper: DotNet CrmHelper; UserId: Guid; RoleId: Guid) begin CrmHelper.AssociateUserWithRole(UserId, RoleId); end; [TryFunction] local procedure TryGetUserId(var CrmHelper: DotNet CrmHelper; UserName: Text; var UserId: Guid) begin UserId := CrmHelper.GetUserId(UserName); end; local procedure AssignPreviousIntegrationUserRoles(var CrmHelper: DotNet CrmHelper; var CDSConnectionSetup: Record "CDS Connection Setup"; AccessToken: SecretText) var CRMConnectionSetup: Record "CRM Connection Setup"; Company: Record Company; TempAdminCDSConnectionSetup: Record "CDS Connection Setup" temporary; CRMSystemUserRoles: Record "CRM Systemuserroles"; RootCRMBusinessunit: Record "CRM Businessunit"; DefaultCRMBusinessunit: Record "CRM Businessunit"; DefaultCRMTeam: Record "CRM Team"; CRMRole: Record "CRM Role"; PreviousIntegrationUserRole: Record "CRM Role"; TeamName: Text[160]; CompanyId: Text[36]; CompanyName: Text[30]; BusinessUnitName: Text[160]; TempConnectionName: Text; EmptySecretText: SecretText; PreviousIntegrationUserId: Guid; CurrentIntegrationUserId: Guid; EmptyGuid: Guid; begin if not CRMConnectionSetup.Get() then exit; if CRMConnectionSetup."User Name" = '' then exit; if CRMConnectionSetup."User Name" = CDSConnectionSetup."User Name" then exit; if not TryGetUserId(CrmHelper, CRMConnectionSetup."User Name", PreviousIntegrationUserId) then begin Session.LogMessage('0000D4A', UserNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit; end; if not TryGetUserId(CrmHelper, CDSConnectionSetup."User Name", CurrentIntegrationUserId) then begin Session.LogMessage('0000D4B', UserNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit; end; ResetCache(); Company.Get(CompanyName()); CompanyId := GetCompanyExternalId(Company); CompanyName := CopyStr(Company.Name, 1, MaxStrLen(CompanyName)); BusinessUnitName := GetDefaultBusinessUnitName(CompanyName, CompanyId); GetTempAdminConnectionSetup(TempAdminCDSConnectionSetup, CDSConnectionSetup, '', EmptySecretText, AccessToken, ''); TempConnectionName := GetTempConnectionName(); RegisterConnection(TempAdminCDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName, true); // Table connection is scoped, therefore all manipulations with CDS tables must be placed // in this procedure between SetDefaultTableConnection and UnregisterConnection RootCRMBusinessunit.SetRange(ParentBusinessUnitId, EmptyGuid); RootCRMBusinessunit.FindFirst(); DefaultCRMBusinessunit.SetRange(ParentBusinessUnitId, RootCRMBusinessunit.BusinessUnitId); DefaultCRMBusinessunit.SetRange(Name, BusinessUnitName); if not DefaultCRMBusinessunit.FindFirst() then exit; TeamName := GetOwningTeamName(DefaultCRMBusinessunit.Name); FilterTeam(DefaultCRMBusinessunit.BusinessUnitId, TeamName, DefaultCRMTeam); if not DefaultCRMTeam.FindFirst() then exit; // assign the roles of the previous integration user to the current (newly set up) integration user and to the default owning team // if one of those roles is System Administrator, ignore it CRMSystemUserRoles.SetRange(SystemUserId, PreviousIntegrationUserId); if CRMSystemUserRoles.FindSet() then repeat if PreviousIntegrationUserRole.Get(CRMSystemUserRoles.RoleId) then if PreviousIntegrationUserRole.RoleTemplateId <> GetSystemAdminRoleTemplateId() then begin if not TryAssignUserRole(CrmHelper, CurrentIntegrationUserId, CRMSystemUserRoles.RoleId) then Session.LogMessage('0000D4C', CannotAssignRoleToUserTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CRMRole.SetRange(ParentRoleId, CRMSystemUserRoles.RoleId); CRMRole.SetRange(BusinessUnitId, DefaultCRMBusinessunit.BusinessUnitId); if not CRMRole.FindFirst() then Session.LogMessage('0000D4D', RoleNotFoundForBusinessUnitTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else if not AssignTeamRole(CrmHelper, DefaultCRMTeam.TeamId, CRMRole.RoleId) then Session.LogMessage('0000D4E', CannotAssignRoleToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) end; until CRMSystemUserRoles.Next() = 0; UnregisterTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName); Session.LogMessage('0000D4F', PreviousIntegrationUserRolesAddedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; local procedure AssignPreviousIntegrationUserRoles(var CrmHelper: DotNet CrmHelper; PreviousIntegrationUserName: Text[250]; var CDSConnectionSetup: Record "CDS Connection Setup"; AccessToken: SecretText) var TempAdminCDSConnectionSetup: Record "CDS Connection Setup" temporary; CRMSystemUserRoles: Record "CRM Systemuserroles"; PreviousIntegrationUserRole: Record "CRM Role"; TempConnectionName: Text; PreviousIntegrationUserId: Guid; CurrentIntegrationUserId: Guid; EmptySecretText: SecretText; begin if CDSConnectionSetup."User Name" = PreviousIntegrationUserName then exit; if not TryGetUserId(CrmHelper, PreviousIntegrationUserName, PreviousIntegrationUserId) then begin Session.LogMessage('0000D4A', UserNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit; end; if not TryGetUserId(CrmHelper, CDSConnectionSetup."User Name", CurrentIntegrationUserId) then begin Session.LogMessage('0000D4B', UserNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit; end; ResetCache(); GetTempAdminConnectionSetup(TempAdminCDSConnectionSetup, CDSConnectionSetup, '', EmptySecretText, AccessToken, ''); TempConnectionName := GetTempConnectionName(); RegisterConnection(TempAdminCDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName, true); // Table connection is scoped, therefore all manipulations with CDS tables must be placed // in this procedure between SetDefaultTableConnection and UnregisterConnection // assign the roles of the previous integration user to the current (newly set up) integration user CRMSystemUserRoles.SetRange(SystemUserId, PreviousIntegrationUserId); if CRMSystemUserRoles.FindSet() then repeat if PreviousIntegrationUserRole.Get(CRMSystemUserRoles.RoleId) then if not TryAssignUserRole(CrmHelper, CurrentIntegrationUserId, CRMSystemUserRoles.RoleId) then Session.LogMessage('0000D4C', CannotAssignRoleToUserTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); until CRMSystemUserRoles.Next() = 0; UnregisterTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName); Session.LogMessage('0000D4F', PreviousIntegrationUserRolesAddedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; [NonDebuggable] local procedure AssignPreviousIntegrationUserRoles(var CrmHelper: DotNet CrmHelper; PreviousIntegrationUserName: Text[250]; var CDSConnectionSetup: Record "CDS Connection Setup") var CurrentCDSConnectionSetup: Record "CDS Connection Setup"; CRMSystemUserRoles: Record "CRM Systemuserroles"; PreviousIntegrationUserRole: Record "CRM Role"; TempConnectionName: Text; PreviousIntegrationUserId: Guid; CurrentIntegrationUserId: Guid; begin if CDSConnectionSetup."User Name" = PreviousIntegrationUserName then exit; if not TryGetUserId(CrmHelper, PreviousIntegrationUserName, PreviousIntegrationUserId) then begin Session.LogMessage('0000GJK', UserNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit; end; if not TryGetUserId(CrmHelper, CDSConnectionSetup."User Name", CurrentIntegrationUserId) then begin Session.LogMessage('0000GJL', UserNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit; end; ResetCache(); CurrentCDSConnectionSetup.Get(); // register the connection with the current integration user, not with an admin TempConnectionName := GetTempConnectionName(); RegisterConnection(CurrentCDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName, true); // Table connection is scoped, therefore all manipulations with CDS tables must be placed // in this procedure between SetDefaultTableConnection and UnregisterConnection // assign the roles of the previous integration user to the current (newly set up) integration user CRMSystemUserRoles.SetRange(SystemUserId, PreviousIntegrationUserId); if CRMSystemUserRoles.FindSet() then repeat if PreviousIntegrationUserRole.Get(CRMSystemUserRoles.RoleId) then if not TryAssignUserRole(CrmHelper, CurrentIntegrationUserId, CRMSystemUserRoles.RoleId) then Session.LogMessage('0000GJM', CannotAssignRoleToUserTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); until CRMSystemUserRoles.Next() = 0; UnregisterTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName); Session.LogMessage('0000GJN', PreviousIntegrationUserRolesAddedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; local procedure AssignVirtualTablesIntegrationRole(var CrmHelper: DotNet CrmHelper; UserName: Text) var RoleId: Guid; begin RoleId := GetVirtualTablesIntegrationRoleId(); AssignIntegrationRole(CrmHelper, UserName, RoleId); end; [Scope('OnPrem')] procedure AssignIntegrationRole(var CrmHelper: DotNet CrmHelper; UserName: Text) var RoleId: Guid; begin RoleId := GetIntegrationRoleId(); AssignIntegrationRole(CrmHelper, UserName, RoleId); end; local procedure AssignIntegrationRole(var CrmHelper: DotNet CrmHelper; UserName: Text; RoleId: Guid) var UserId: Guid; begin if not TryGetUserId(CrmHelper, UserName, UserId) then begin Session.LogMessage('0000ATT', UserNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(UserDoesNotExistErr, UserName); end; if IsNullGuid(UserId) then begin Session.LogMessage('0000ATU', UserNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(UserDoesNotExistErr, UserName); end; if not AssignUserRole(CrmHelper, UserId, RoleId) then begin Session.LogMessage('0000ATV', CannotAssignRoleToUserTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(CannotAssignRoleToIntegrationUserErr); end; Session.LogMessage('0000ATW', RoleAssignedToUserTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; procedure AssignTeamRole(var CrmHelper: DotNet CrmHelper; TeamId: Guid; RoleId: Guid): Boolean begin if IsNullGuid(TeamId) then begin Session.LogMessage('0000GDI', CannotAssignRoleToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; if IsNullGuid(RoleId) then begin Session.LogMessage('0000GDJ', CannotAssignRoleToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; if CheckRoleAssignedToTeam(CrmHelper, TeamId, RoleId) then exit(true); if not TryAssignTeamRole(CrmHelper, TeamId, RoleId) then begin Session.LogMessage('0000ATX', CannotAssignRoleToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; if CheckRoleAssignedToTeam(CrmHelper, TeamId, RoleId) then exit(true); Session.LogMessage('0000ATY', CannotAssignRoleToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; [TryFunction] local procedure TryAssignTeamRole(var CrmHelper: DotNet CrmHelper; TeamId: Guid; RoleId: Guid) begin CrmHelper.AssociateTeamWithRole(TeamId, RoleId); end; local procedure CheckRoleAssignedToTeam(var CrmHelper: DotNet CrmHelper; TeamId: Guid; RoleId: Guid): Boolean begin exit(CrmHelper.CheckRoleAssignedToTeam(TeamId, RoleId)); end; local procedure AddUserToTeam(var CrmHelper: DotNet CrmHelper; UserId: Guid; TeamId: Guid): Boolean begin if CrmHelper.CheckUserAssociatedWithTeam(UserId, TeamId) then exit(false); if not TryAddUserToTeam(CrmHelper, UserId, TeamId) then begin Session.LogMessage('0000C97', CannotAddUserToTeamTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; if CrmHelper.CheckUserAssociatedWithTeam(UserId, TeamId) then begin Session.LogMessage('0000C9Q', UserAddedToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(true); end; Session.LogMessage('0000C98', CannotAddUserToTeamTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; [TryFunction] local procedure TryAddUserToTeam(var CrmHelper: DotNet CrmHelper; UserId: Guid; TeamId: Guid) begin CrmHelper.AssociateUserWithTeam(UserId, TeamId); end; [Scope('OnPrem')] [NonDebuggable] procedure ImportAndConfigureIntegrationSolution(var CDSConnectionSetup: Record "CDS Connection Setup"; RenewSolution: Boolean): Boolean begin exit(ImportAndConfigureIntegrationSolution(CDSConnectionSetup, RenewSolution, false)); end; [NonDebuggable] internal procedure ImportAndConfigureIntegrationSolution(var CDSConnectionSetup: Record "CDS Connection Setup"; RenewSolution: Boolean; GetTokenFromCache: Boolean): Boolean var CrmHelper: DotNet CrmHelper; AdminAccessToken: SecretText; AdminUserName: Text; AdminPassword: SecretText; AdminADDomain: Text; begin Session.LogMessage('0000ATZ', ConfigureSolutionTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CheckCredentials(CDSConnectionSetup); SignInCDSAdminUser(CDSConnectionSetup, CrmHelper, AdminUserName, AdminPassword, AdminAccessToken, AdminADDomain, GetTokenFromCache); JITProvisionFirstPartyApp(CrmHelper); Sleep(5000); ImportIntegrationSolution(CDSConnectionSetup, CrmHelper, AdminUserName, AdminPassword, AdminAccessToken, AdminADDomain, RenewSolution); ConfigureIntegrationSolution(CDSConnectionSetup, CrmHelper, AdminUserName, AdminPassword, AdminAccessToken, AdminADDomain, false); if not RenewSolution then if CheckIntegrationRequirements(CDSConnectionSetup, true) then begin Session.LogMessage('0000AU0', IntegrationRequirementsMetTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; exit(true); end; [Scope('OnPrem')] [TryFunction] [NonDebuggable] procedure SignInCDSAdminUser(var CDSConnectionSetup: Record "CDS Connection Setup"; var CrmHelper: DotNet CrmHelper; var AdminUser: Text; var AdminPassword: SecretText; var AccessToken: SecretText; var AdminADDomain: Text; GetTokenFromCache: Boolean) var TempConnectionStringWithPlaceholder: Text; TempConnectionString: SecretText; begin if CDSConnectionSetup."Authentication Type" <> CDSConnectionSetup."Authentication Type"::Office365 then begin if not PromptForAdminCredentials(CDSConnectionSetup, AdminUser, AdminPassword, AdminADDomain) then begin Session.LogMessage('0000AU1', InvalidAdminCredentialsTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(AdminUserPasswordWrongErr); end; case CDSConnectionSetup."Authentication Type" of CDSConnectionSetup."Authentication Type"::AD: begin TempConnectionStringWithPlaceholder := StrSubstNo(ConnectionStringFormatTok, CDSConnectionSetup."Server Address", AdminUser, '%1', CDSConnectionSetup.GetProxyVersion(), GetAuthenticationTypeToken(CDSConnectionSetup, AdminADDomain)); TempConnectionString := SecretStrSubstNo(TempConnectionStringWithPlaceholder, AdminPassword); end; CDSConnectionSetup."Authentication Type"::OAuth: TempConnectionString := ReplaceUserNamePasswordInConnectionString(CDSConnectionSetup, AdminUser, AdminPassword); else begin TempConnectionStringWithPlaceholder := StrSubstNo(ConnectionStringFormatTok, CDSConnectionSetup."Server Address", AdminUser, '%1', CDSConnectionSetup.GetProxyVersion(), GetAuthenticationTypeToken(CDSConnectionSetup)); TempConnectionString := SecretStrSubstNo(TempConnectionStringWithPlaceholder, AdminPassword); end; end end else begin GetAccessToken(CDSConnectionSetup."Server Address", GetTokenFromCache, AccessToken); TempConnectionStringWithPlaceholder := StrSubstNo(OAuthConnectionStringFormatTxt, CDSConnectionSetup."Server Address", '%1', CDSConnectionSetup.GetProxyVersion(), GetAuthenticationTypeToken(CDSConnectionSetup)); TempConnectionString := SecretStrSubstNo(TempConnectionStringWithPlaceholder, AccessToken); end; if not InitializeConnection(CrmHelper, TempConnectionString) then begin Session.LogMessage('0000AU2', ConnectionNotRegisteredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); ProcessConnectionFailures(); end; end; local procedure ReplaceUserNameInConnectionString(CDSConnectionSetup: Record "CDS Connection Setup"; NewUserName: Text): Text var UserNameTokenPos: Integer; NewConnectionString: Text; LeftPart: Text; RightPart: Text; UserNameTok: Text; begin UserNameTok := 'UserName='; UserNameTokenPos := StrPos(CDSConnectionSetup."Connection String", UserNameTok); LeftPart := CopyStr(NewConnectionString, 1, UserNameTokenPos - 1); RightPart := CopyStr(NewConnectionString, UserNameTokenPos); if RightPart.IndexOf(';') > 0 then NewConnectionString := LeftPart + UserNameTok + NewUserName + CopyStr(RightPart, RightPart.IndexOf(';')) else NewConnectionString := LeftPart + UserNameTok + NewUserName; exit(NewConnectionString); end; [Scope('OnPrem')] procedure ReplaceUserNamePasswordInConnectionString(CDSConnectionSetup: Record "CDS Connection Setup"; NewUserName: Text; NewPassword: SecretText): SecretText var PasswordPlaceHolderPos: Integer; NewConnectionStringWithPlaceholder: Text; NewConnectionString: SecretText; begin NewConnectionStringWithPlaceholder := ReplaceUserNameInConnectionString(CDSConnectionSetup, NewUserName); PasswordPlaceHolderPos := StrPos(NewConnectionStringWithPlaceholder, MissingPasswordTok); NewConnectionStringWithPlaceholder := CopyStr(NewConnectionStringWithPlaceholder, 1, PasswordPlaceHolderPos - 1) + '%1' + CopyStr(NewConnectionStringWithPlaceholder, PasswordPlaceHolderPos + StrLen(MissingPasswordTok)); NewConnectionString := SecretStrSubstNo(NewConnectionStringWithPlaceholder, NewPassword); exit(NewConnectionString); end; internal procedure GetDataverseCloudEndpoints(): Interface "Dataverse Cloud Endpoints" var CDSConnectionSetup: Record "CDS Connection Setup"; begin if not CDSConnectionSetup.Get() then CDSConnectionSetup.Init(); exit(CDSConnectionSetup.GetDataverseCloudEndpoints()); end; [Scope('OnPrem')] procedure GetAccessToken(ResourceURL: Text; GetTokenFromCache: Boolean; var AccessToken: SecretText) var OAuth2: Codeunit OAuth2; PromptInteraction: Enum "Prompt Interaction"; Endpoints: Interface "Dataverse Cloud Endpoints"; Scopes: List of [Text]; [NonDebuggable] ClientId: Text; ClientSecret: SecretText; [NonDebuggable] FirstPartyAppId: Text; [NonDebuggable] FirstPartyAppCertificate: SecretText; RedirectUrl: Text; AuthCodeError: Text; begin Endpoints := GetDataverseCloudEndpoints(); Scopes.Add(ResourceURL + '/user_impersonation'); ClientId := GetCDSConnectionClientId(); ClientSecret := GetCDSConnectionClientSecret(); FirstPartyAppId := GetCDSConnectionFirstPartyAppId(); FirstPartyAppCertificate := GetCDSConnectionFirstPartyAppCertificate(); if (FirstPartyAppId = '') or (FirstPartyAppCertificate.IsEmpty()) then if (ClientId = '') or (ClientSecret.IsEmpty()) then Error(GetMissingClientIdOrSecretErr()); RedirectUrl := GetRedirectURL(); if GetTokenFromCache then if (FirstPartyAppId <> '') and (not FirstPartyAppCertificate.IsEmpty()) then begin Session.LogMessage('0000EI9', AttemptingAuthCodeTokenFromCacheWithCertTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); OAuth2.AcquireAuthorizationCodeTokenFromCacheWithCertificate(FirstPartyAppId, FirstPartyAppCertificate, RedirectUrl, Endpoints.GetOAuthAuthorityUrl(), ResourceURL, AccessToken) end else begin Session.LogMessage('0000EIA', AttemptingAuthCodeTokenFromCacheWithClientSecretTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); OAuth2.AcquireAuthorizationCodeTokenFromCache(ClientId, ClientSecret, RedirectUrl, Endpoints.GetOAuthAuthorityUrl(), Scopes, AccessToken); end; if AccessToken.IsEmpty() then begin if not GuiAllowed then begin Session.LogMessage('0000DNV', GuiNotAllowedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit; end; if (FirstPartyAppId <> '') and (not FirstPartyAppCertificate.IsEmpty()) then begin Session.LogMessage('0000EIB', AttemptingAuthCodeTokenWithCertTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); OAuth2.AcquireTokenByAuthorizationCodeWithCertificate( FirstPartyAppId, FirstPartyAppCertificate, Endpoints.GetOAuthAuthorityUrl(), RedirectUrl, ResourceURL, PromptInteraction::Consent, AccessToken, AuthCodeError) end else begin Session.LogMessage('0000EIC', AttemptingAuthCodeTokenWithClientSecretTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); OAuth2.AcquireTokenByAuthorizationCode( ClientId, ClientSecret, Endpoints.GetOAuthAuthorityUrl(), RedirectUrl, Scopes, PromptInteraction::Consent, AccessToken, AuthCodeError) end; end; if AccessToken.IsEmpty() then begin if AuthCodeError <> '' then Session.LogMessage('0000C10', AuthCodeError, Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else Session.LogMessage('0000C11', AuthTokenOrCodeNotReceivedErr, Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(AccessTokenNotReceivedErr, ResourceURL); end; end; [Scope('OnPrem')] procedure GetBusinessEventAccessToken(ResourceURL: Text; GetTokenFromCache: Boolean; var AccessToken: SecretText) var OAuth2: Codeunit OAuth2; Endpoints: Interface "Dataverse Cloud Endpoints"; Scopes: List of [Text]; [NonDebuggable] ClientId: Text; ClientSecret: SecretText; [NonDebuggable] FirstPartyAppId: Text; [NonDebuggable] FirstPartyAppCertificate: SecretText; RedirectUrl: Text; AuthCodeError: Text; IdToken: Text; begin Endpoints := GetDataverseCloudEndpoints(); Scopes.Add(ResourceURL + '/.default'); ClientId := GetCDSConnectionClientId(); ClientSecret := GetCDSConnectionClientSecret(); FirstPartyAppId := GetCDSConnectionFirstPartyAppId(); FirstPartyAppCertificate := GetCDSConnectionFirstPartyAppCertificate(); if (FirstPartyAppId = '') or (FirstPartyAppCertificate.IsEmpty()) then if (ClientId = '') or (ClientSecret.IsEmpty()) then Error(GetMissingClientIdOrSecretErr()); RedirectUrl := GetRedirectURL(); if GetTokenFromCache then if (FirstPartyAppId <> '') and (not FirstPartyAppCertificate.IsEmpty()) then begin Session.LogMessage('0000GIG', AttemptingClientCredentialsTokenFromCacheWithCertTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); OAuth2.AcquireTokensFromCacheWithCertificate(FirstPartyAppId, FirstPartyAppCertificate, RedirectUrl, Endpoints.GetClientCredentialsTokenAuthorityUrl(), Scopes, AccessToken, IdToken); end else begin Session.LogMessage('0000GIH', AttemptingClientCredentialsTokenFromCacheWithClientSecretTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); OAuth2.AcquireTokensFromCache(ClientId, ClientSecret, RedirectUrl, Endpoints.GetClientCredentialsTokenAuthorityUrl(), Scopes, AccessToken, IdToken); end; if AccessToken.IsEmpty() then if (FirstPartyAppId <> '') and (not FirstPartyAppCertificate.IsEmpty()) then begin Session.LogMessage('0000GII', AttemptingClientCredentialsTokenWithCertTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); OAuth2.AcquireTokensWithCertificate(FirstPartyAppId, FirstPartyAppCertificate, RedirectUrl, Endpoints.GetClientCredentialsTokenAuthorityUrl(), Scopes, AccessToken, IdToken); end else begin Session.LogMessage('0000GIJ', AttemptingClientCredentialsTokenWithClientSecretTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); OAuth2.AcquireTokenWithClientCredentials(ClientId, ClientSecret, Endpoints.GetClientCredentialsTokenAuthorityUrl(), RedirectUrl, Scopes, AccessToken); end; if AccessToken.IsEmpty() then begin if AuthCodeError <> '' then Session.LogMessage('0000GIK', AuthCodeError, Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else Session.LogMessage('0000GIL', AuthTokenOrCodeNotReceivedErr, Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(AccessTokenNotReceivedErr, ResourceURL); end; end; [Scope('OnPrem')] procedure GetRedirectURL(): Text var CDSConnectionSetup: Record "CDS Connection Setup"; begin if EnvironmentInfo.IsSaaSInfrastructure() then exit(''); if CDSConnectionSetup.Get() then exit(CDSConnectionSetup."Redirect URL"); exit(''); end; [Scope('OnPrem')] procedure GetCDSConnectionClientId(): Text var CDSConnectionSetup: Record "CDS Connection Setup"; AzureKeyVault: Codeunit "Azure Key Vault"; [NonDebuggable] ClientId: Text; begin if EnvironmentInfo.IsSaaSInfrastructure() then if not AzureKeyVault.GetAzureKeyVaultSecret(CDSConnectionClientIdAKVSecretNameLbl, ClientId) then Session.LogMessage('0000C0Y', MissingClientIdOrSecretTelemetryTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else exit(ClientId); if CDSConnectionSetup.Get() then ClientId := CDSConnectionSetup."Client Id"; if ClientId = '' then OnGetCDSConnectionClientId(ClientId); exit(ClientId); end; [Scope('OnPrem')] [NonDebuggable] procedure GetCDSConnectionFirstPartyAppId(): Text var AzureKeyVault: Codeunit "Azure Key Vault"; ClientId: Text; begin if EnvironmentInfo.IsSaaSInfrastructure() then if not AzureKeyVault.GetAzureKeyVaultSecret(CDSConnectionFirstPartyAppIdAKVSecretNameLbl, ClientId) then Session.LogMessage('0000EBU', MissingFirstPartyappIdOrCertificateTelemetryTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else exit(ClientId); exit(ClientId); end; local procedure GetMissingClientIdOrSecretErr(): Text begin if EnvironmentInfo.IsSaaSInfrastructure() then exit(MissingClientIdOrSecretErr); exit(MissingClientIdOrSecretOnPremErr); end; [NonDebuggable] local procedure GetClientSecretFromEvent(): SecretText var ClientSecret: Text; begin OnGetCDSConnectionClientSecret(ClientSecret); exit(ClientSecret); end; [Scope('OnPrem')] [NonDebuggable] procedure GetCDSConnectionClientSecret(): SecretText var CDSConnectionSetup: Record "CDS Connection Setup"; AzureKeyVault: Codeunit "Azure Key Vault"; ClientSecret: SecretText; begin if EnvironmentInfo.IsSaaSInfrastructure() then if not AzureKeyVault.GetAzureKeyVaultSecret(CDSConnectionClientSecretAKVSecretNameLbl, ClientSecret) then Session.LogMessage('0000C0Z', MissingClientIdOrSecretTelemetryTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else exit(ClientSecret); if CDSConnectionSetup.Get() then ClientSecret := CDSConnectionSetup.GetSecretClientSecret(); if ClientSecret.IsEmpty() then ClientSecret := GetClientSecretFromEvent(); exit(ClientSecret); end; [Scope('OnPrem')] [NonDebuggable] procedure GetCDSConnectionFirstPartyAppCertificate(): Text; var AzureKeyVault: Codeunit "Azure Key Vault"; Certificate: Text; CertificateName: Text; begin if EnvironmentInfo.IsSaaSInfrastructure() then if not AzureKeyVault.GetAzureKeyVaultSecret(CDSConnectionFirstPartyAppCertificateNameAKVSecretNameLbl, CertificateName) then begin Session.LogMessage('0000EBV', MissingFirstPartyappIdOrCertificateTelemetryTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(Certificate); end; if not AzureKeyVault.GetAzureKeyVaultCertificate(CertificateName, Certificate) then Session.LogMessage('0000EC2', MissingFirstPartyappIdOrCertificateTelemetryTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(Certificate); end; [Scope('OnPrem')] [NonDebuggable] procedure ImportIntegrationSolution(var CDSConnectionSetup: Record "CDS Connection Setup"; var CrmHelper: DotNet CrmHelper; AdminUsername: Text; AdminPassword: SecretText; AccessToken: SecretText; AdminADDomain: Text; RenewSolution: Boolean) var TempAdminCDSConnectionSetup: Record "CDS Connection Setup" temporary; NavTenantSettingsHelper: DotNet NavTenantSettingsHelper; Version: DotNet Version; SolutionVersion: Text; SolutionInstalled: Boolean; SolutionOutdated: Boolean; ImportSolution: Boolean; begin GetTempAdminConnectionSetup(TempAdminCDSConnectionSetup, CDSConnectionSetup, AdminUserName, AdminPassword, AccessToken, AdminADDomain); if GetSolutionVersion(TempAdminCDSConnectionSetup, GetBaseSolutionUniqueName(), SolutionVersion) then if Version.TryParse(SolutionVersion, Version) then begin SolutionInstalled := true; SolutionOutdated := Version.CompareTo(NavTenantSettingsHelper.GetPlatformVersion()) < 0; end; if RenewSolution then ImportSolution := (not SolutionInstalled) or SolutionOutdated else ImportSolution := not SolutionInstalled; if ImportSolution then begin Session.LogMessage('0000AU4', ImportSolutionTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if not ImportDefaultCdsSolution(CrmHelper) then ProcessConnectionFailures(); end; end; [TryFunction] local procedure ImportDefaultCdsSolution(var CRMHelper: DotNet CrmHelper) begin CrmHelper.ImportDefaultCdsSolution(); end; [Scope('OnPrem')] [NonDebuggable] procedure ConfigureIntegrationSolution(var CDSConnectionSetup: Record "CDS Connection Setup"; var CrmHelper: DotNet CrmHelper; AdminUserName: Text; AdminPassword: SecretText; AccessToken: SecretText; AdminADDomain: Text; IsSilent: Boolean) begin FindOrCreateIntegrationUser(CDSConnectionSetup, AdminUserName, AdminPassword, AccessToken); AssignIntegrationRole(CrmHelper, CDSConnectionSetup."User Name"); // if Authentication Type is Office365 we don't need to set the user as integration user or non-interactive user // in this case we have injected a non-licensed application user that is bound to the Azure AD application used to connect to CDS if CDSConnectionSetup."Authentication Type" <> CDSConnectionSetup."Authentication Type"::Office365 then begin SetUserAsIntegrationUser(CDSConnectionSetup, AdminUserName, AdminPassword, AccessToken, AdminADDomain); if SetAccessModeToNonInteractive(CDSConnectionSetup, AdminUserName, AdminPassword, AccessToken, AdminADDomain) then if not IsSilent then Message(AccessModeSetToNonInteractiveMsg); end; SyncCompany(CDSConnectionSetup, AdminUserName, AdminPassword, AccessToken, AdminADDomain); AssignPreviousIntegrationUserRoles(CrmHelper, CDSConnectionSetup, AccessToken); Session.LogMessage('0000AU5', SolutionConfiguredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; [Scope('OnPrem')] procedure JITProvisionFirstPartyApp(var CrmHelper: DotNet CrmHelper) var [NonDebuggable] CDSConnectionFirstPartyAppIdTxt: Text; [NonDebuggable] CDSConnectionFirstPartyAppCertificateTxt: Text; JITProvisioningTelemetryMessageTxt: Text; begin CDSConnectionFirstPartyAppIdTxt := GetCDSConnectionFirstPartyAppId(); CDSConnectionFirstPartyAppCertificateTxt := GetCDSConnectionFirstPartyAppCertificate(); if (CDSConnectionFirstPartyAppIdTxt = '') or (CDSConnectionFirstPartyAppCertificateTxt = '') then exit; JITProvisioningTelemetryMessageTxt := CrmHelper.ProvisionServicePrincipal(CDSConnectionFirstPartyAppIdTxt, CDSConnectionFirstPartyAppCertificateTxt); if JITProvisioningTelemetryMessageTxt <> '' then if JITProvisioningTelemetryMessageTxt.Contains(SuccessfulJITProvisioningTelemetryMsg) then Session.LogMessage('0000ENK', JITProvisioningTelemetryMessageTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else Session.LogMessage('0000F0A', JITProvisioningTelemetryMessageTxt, Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; [Scope('OnPrem')] procedure HasCompanyIdField(TableId: Integer): Boolean var HasField: Boolean; begin CDSIntegrationMgt.OnHasCompanyIdField(TableId, HasField); exit(HasField); end; [Scope('OnPrem')] procedure CheckCompanyId(var RecRef: RecordRef): Boolean begin exit(TrySetAndCheckCompany(RecRef, true)); end; [Scope('OnPrem')] procedure SetCompanyId(var RecRef: RecordRef): Boolean begin exit(TrySetAndCheckCompany(RecRef, false)); end; [Scope('OnPrem')] procedure CheckCompanyIdNoTelemetry(var RecRef: RecordRef): Boolean var CompanyIdFldRef: FieldRef; ActualCompanyId: Guid; SavedCompanyId: Guid; begin if not FindCompanyIdField(RecRef, CompanyIdFldRef) then exit(false); ActualCompanyId := GetCachedCompanyId(); SavedCompanyId := CompanyIdFldRef.Value(); exit(ActualCompanyId = SavedCompanyId); end; [TryFunction] local procedure TrySetAndCheckCompany(var RecRef: RecordRef; CheckOnly: Boolean) var CompanyIdFldRef: FieldRef; ActualCompanyId: Guid; SavedCompanyId: Guid; IsCorrectCompany: Boolean; begin if not FindCompanyIdField(RecRef, CompanyIdFldRef) then begin Session.LogMessage('0000AVN', EntityHasNoCompanyIdFieldTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(CannotFindCompanyIdFieldErr, RecRef.Number(), RecRef.Name()); end; ActualCompanyId := GetCachedCompanyId(); SavedCompanyId := CompanyIdFldRef.Value(); IsCorrectCompany := SavedCompanyId = ActualCompanyId; if CheckOnly then begin if not IsCorrectCompany then begin Session.LogMessage('0000AVO', CompanyIdDiffersFromExpectedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(OwnerDiffersFromExpectedErr); end; Session.LogMessage('0000AVP', CompanyIdCheckedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit; end; if not IsCorrectCompany then CompanyIdFldRef.Value := ActualCompanyId; Session.LogMessage('0000AVT', CompanyIdSetTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; [Scope('OnPrem')] procedure ResetCompanyId(var RecRef: RecordRef): Boolean var Changed: Boolean; begin if TryResetCompanyId(RecRef, Changed) then exit(Changed); exit(false); end; [TryFunction] local procedure TryResetCompanyId(var RecRef: RecordRef; var Changed: Boolean) var CRMSalesorder: Record "CRM Salesorder"; CompanyIdFldRef: FieldRef; ActualCompanyId: Guid; SavedCompanyId: Guid; EmptyCompanyId: Guid; begin if RecRef.Number() = Database::"CRM Salesorder" then begin RecRef.SetTable(CRMSalesorder); if TryResetCompanyId(CRMSalesorder, Changed) then RecRef.GetTable(CRMSalesorder); exit; end; if not FindCompanyIdField(RecRef, CompanyIdFldRef) then begin Session.LogMessage('0000DDK', EntityHasNoCompanyIdFieldTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit; end; ActualCompanyId := GetCachedCompanyId(); SavedCompanyId := CompanyIdFldRef.Value(); if SavedCompanyId = ActualCompanyId then begin CompanyIdFldRef.Value := EmptyCompanyId; Changed := true; end; end; [TryFunction] local procedure TryResetCompanyId(var CRMSalesorder: Record "CRM Salesorder"; var Changed: Boolean) var ActualCompanyId: Guid; begin ActualCompanyId := GetCachedCompanyId(); if CRMSalesorder.CompanyId <> ActualCompanyId then exit; case CRMSalesorder.StateCode of CRMSalesorder.StateCode::Submitted: begin CRMSalesorder.StateCode := CRMSalesorder.StateCode::Active; CRMSalesorder.Modify(true); Clear(CRMSalesorder.CompanyId); CRMSalesorder.Modify(true); CRMSalesorder.StateCode := CRMSalesorder.StateCode::Submitted; CRMSalesorder.Modify(true); Changed := IsNullGuid(CRMSalesorder.CompanyId); end; CRMSalesorder.StateCode::Active: begin Clear(CRMSalesorder.CompanyId); CRMSalesorder.Modify(true); Changed := IsNullGuid(CRMSalesorder.CompanyId); end; end; end; [Scope('OnPrem')] procedure CheckOwningTeam(var RecRef: RecordRef): Boolean begin exit(CheckOwningTeam(RecRef, false)); end; [Scope('OnPrem')] procedure CheckOwningTeam(var RecRef: RecordRef; SkipBusinessUnitCheck: Boolean): Boolean var EmptyGuid: Guid; begin exit(CheckOwningTeam(RecRef, EmptyGuid, SkipBusinessUnitCheck)); end; [Scope('OnPrem')] procedure CheckOwningTeam(var RecRef: RecordRef; TeamId: Guid; SkipBusinessUnitCheck: Boolean): Boolean var TempCDSCompany: Record "CDS Company" temporary; begin exit(SetAndCheckOwner(RecRef, TempCDSCompany.OwnerIdType::team, TeamId, true, SkipBusinessUnitCheck)); end; [Scope('OnPrem')] procedure CheckOwningUser(var RecRef: RecordRef; UserId: Guid): Boolean begin exit(CheckOwningUser(RecRef, UserId, false)); end; [Scope('OnPrem')] procedure CheckOwningUser(var RecRef: RecordRef; UserId: Guid; SkipBusinessUnitCheck: Boolean): Boolean var TempCDSCompany: Record "CDS Company" temporary; begin exit(SetAndCheckOwner(RecRef, TempCDSCompany.OwnerIdType::systemuser, UserId, true, SkipBusinessUnitCheck)); end; [Scope('OnPrem')] procedure SetOwningTeam(var RecRef: RecordRef): Boolean var EmptyGuid: Guid; begin exit(SetOwningTeam(RecRef, EmptyGuid, false)); end; [Scope('OnPrem')] procedure SetOwningTeam(var RecRef: RecordRef; TeamId: Guid; SkipBusinessUnitCheck: Boolean): Boolean var TempCDSCompany: Record "CDS Company" temporary; begin exit(SetAndCheckOwner(RecRef, TempCDSCompany.OwnerIdType::team, TeamId, false, SkipBusinessUnitCheck)); end; [Scope('OnPrem')] procedure SetOwningUser(var RecRef: RecordRef; UserId: Guid; SkipBusinessUnitCheck: Boolean): Boolean var TempCDSCompany: Record "CDS Company" temporary; begin exit(SetAndCheckOwner(RecRef, TempCDSCompany.OwnerIdType::systemuser, UserId, false, SkipBusinessUnitCheck)); end; local procedure SetAndCheckOwner(var RecRef: RecordRef; OwnerIdType: Option; OwnerId: Guid; CheckOnly: Boolean; SkipBusinessUnitCheck: Boolean): Boolean begin exit(TrySetAndCheckOwner(RecRef, OwnerIdType, OwnerId, CheckOnly, SkipBusinessUnitCheck)); end; [TryFunction] local procedure TrySetAndCheckOwner(var RecRef: RecordRef; OwnerIdType: Option; OwnerId: Guid; CheckOnly: Boolean; SkipBusinessUnitCheck: Boolean) var TempCDSCompany: Record "CDS Company" temporary; OwnerIdTypeFldRef: FieldRef; OwnerIdFldRef: FieldRef; SavedOwnerIdType: Option; SavedOwnerId: Guid; IsCorrectOwner: Boolean; begin if IsNullGuid(OwnerId) and (OwnerIdType = TempCDSCompany.OwnerIdType::team) then begin Session.LogMessage('0000AU8', SetDefaultOwningTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); OwnerId := GetCachedDefaultOwningTeamId(); end; if not FindOwnerIdField(RecRef, OwnerIdFldRef) then Error(CannotFindOwnerIdFieldErr, RecRef.Number(), RecRef.Name()); if not FindOwnerTypeField(RecRef, OwnerIdTypeFldRef) then Error(CannotFindOwnerTypeFieldErr, RecRef.Number(), RecRef.Name()); SavedOwnerIdType := OwnerIdTypeFldRef.Value(); SavedOwnerId := OwnerIdFldRef.Value(); IsCorrectOwner := (SavedOwnerIdType = OwnerIdType) and (SavedOwnerId = OwnerId); if CheckOnly then if not IsCorrectOwner then begin Session.LogMessage('0000AUA', OwnerDiffersFromExpectedTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(OwnerDiffersFromExpectedErr); end; case OwnerIdType of TempCDSCompany.OwnerIdType::team: CheckOwningTeam(OwnerId, SkipBusinessUnitCheck); TempCDSCompany.OwnerIdType::systemuser: CheckOwningUser(OwnerId, SkipBusinessUnitCheck); else begin Session.LogMessage('0000AUC', UnsupportedOwnerTypeTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(OwnerIdTypeErr); end; end; if CheckOnly then exit; if not IsCorrectOwner then begin OwnerIdTypeFldRef.Value := OwnerIdType; OwnerIdFldRef.Value := OwnerId; end; Session.LogMessage('0000AUG', OwnerSetTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; local procedure CheckOwningTeam(TeamId: Guid; SkipBusinessUnitCheck: Boolean) var OwningCRMTeam: Record "CRM Team"; begin if TeamId = GetCachedDefaultOwningTeamId() then exit; if GetCachedOwningTeamCheck(TeamId, SkipBusinessUnitCheck) then exit; if not OwningCRMTeam.Get(TeamId) then begin Session.LogMessage('0000AUH', TeamNotFoundTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(TeamNotFoundErr, TeamId); end; CheckTeamHasIntegrationRole(OwningCRMTeam); if not SkipBusinessUnitCheck then if OwningCRMTeam.BusinessUnitId <> GetCachedOwningBusinessUnitId() then begin Session.LogMessage('0000AUI', TeamBusinessUnitDiffersFromSelectedTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(TeamBusinessUnitDiffersFromSelectedErr); end; SetCachedOwningTeamCheck(TeamId, SkipBusinessUnitCheck); end; local procedure CheckOwningUser(UserId: Guid; SkipBusinessUnitCheck: Boolean) var CRMSystemuser: Record "CRM Systemuser"; begin if GetCachedOwningUserCheck(UserId, SkipBusinessUnitCheck) then exit; if not CRMSystemuser.Get(UserId) then Error(UserNotFoundErr, UserId); if not SkipBusinessUnitCheck then if CRMSystemuser.BusinessUnitId <> GetCachedOwningBusinessUnitId() then Error(UserBusinessUnitDiffersFromSelectedErr); SetCachedOwningUserCheck(UserId, SkipBusinessUnitCheck); end; local procedure CheckTeamHasIntegrationRole(var CRMTeam: Record "CRM Team") var CRMRole: Record "CRM Role"; CDSTeamroles: Record "CDS Teamroles"; begin CRMRole.SetRange(BusinessUnitId, CRMTeam.BusinessUnitId); CRMRole.SetRange(ParentRoleId, GetIntegrationRoleId()); if not CRMRole.FindFirst() then begin Session.LogMessage('0000AUM', RoleNotFoundForBusinessUnitTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(IntegrationRoleNotFoundErr, GetIntegrationRoleName(), GetBusinessUnitName(CRMTeam.BusinessUnitId)); end; CDSTeamroles.SetRange(TeamId, CRMTeam.TeamId); CDSTeamroles.SetRange(RoleId, CRMRole.RoleId); if CDSTeamroles.IsEmpty() then begin Session.LogMessage('0000AUN', IntegrationRoleNotAssignedToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(TeamRolesErr, CRMTeam.Name, GetBusinessUnitName(CRMTeam.BusinessUnitId), GetIntegrationRoleName()); end; end; local procedure GetBusinessUnitName(BusinesUnitId: Guid) BusinessunitName: Text var CRMBusinessUnit: Record "CRM Businessunit"; begin if CRMBusinessunit.Get(BusinesUnitId) then BusinessunitName := CRMBusinessunit.Name else BusinessunitName := Format(BusinesUnitId); end; local procedure GetIntegrationRoleName() IntegrationRoleName: Text var CRMRole: Record "CRM Role"; begin if CRMRole.Get(GetIntegrationRoleId()) then IntegrationRoleName := CRMRole.Name else IntegrationRoleName := Format(GetIntegrationRoleId()); end; internal procedure FindCompanyIdField(var RecRef: RecordRef; var CompanyIdFldRef: FieldRef): Boolean var Field: Record "Field"; TableNo: Integer; FieldNo: Integer; begin TableNo := RecRef.Number(); if CachedCompanyIdFieldNo.ContainsKey(TableNo) then FieldNo := CachedCompanyIdFieldNo.Get(TableNo) else begin Field.SetRange(TableNo, TableNo); Field.SetRange(Type, Field.Type::GUID); Field.SetRange(FieldName, 'CompanyId'); if Field.FindFirst() then FieldNo := Field."No." else FieldNo := 0; CachedCompanyIdFieldNo.Add(TableNo, FieldNo); end; if FieldNo = 0 then exit(false); CompanyIdFldRef := RecRef.Field(FieldNo); exit(true); end; local procedure FindOwnerIdField(var RecRef: RecordRef; var OwnerIdFldRef: FieldRef): Boolean var Field: Record "Field"; TableNo: Integer; FieldNo: Integer; begin TableNo := RecRef.Number(); if CachedOwnerIdFieldNo.ContainsKey(TableNo) then FieldNo := CachedOwnerIdFieldNo.Get(TableNo) else begin Field.SetRange(TableNo, TableNo); Field.SetRange(Type, Field.Type::GUID); Field.SetRange(FieldName, 'OwnerId'); if Field.FindFirst() then FieldNo := Field."No." else FieldNo := 0; CachedOwnerIdFieldNo.Add(TableNo, FieldNo); end; if FieldNo = 0 then exit(false); OwnerIdFldRef := RecRef.Field(FieldNo); exit(true); end; [Scope('OnPrem')] procedure FindOwnerTypeField(var RecRef: RecordRef; var OwnerIdTypeFldRef: FieldRef): Boolean var Field: Record "Field"; TableNo: Integer; FieldNo: Integer; begin TableNo := RecRef.Number(); if CachedOwnerTypeFieldNo.ContainsKey(TableNo) then FieldNo := CachedOwnerTypeFieldNo.Get(TableNo) else begin Field.SetRange(TableNo, TableNo); Field.SetRange(Type, Field.Type::Option); Field.SetRange(FieldName, 'OwnerIdType'); Field.SetRange(OptionString, ' ,systemuser,team'); if Field.FindFirst() then FieldNo := Field."No." else FieldNo := 0; CachedOwnerTypeFieldNo.Add(TableNo, FieldNo); end; if FieldNo = 0 then exit(false); OwnerIdTypeFldRef := RecRef.Field(FieldNo); exit(true); end; local procedure GetCachedOwningTeamCheck(TeamId: Guid; SkipBusinessUnitCheck: Boolean): Boolean begin if SkipBusinessUnitCheck then begin if CachedOwningTeamCheckWithoutBusinessUnit.ContainsKey(TeamId) then exit(true); end else if CachedOwningTeamCheckWithBusinessUnit.ContainsKey(TeamId) then exit(true); exit(false); end; local procedure SetCachedOwningTeamCheck(TeamId: Guid; SkipBusinessUnitCheck: Boolean) begin Session.LogMessage('0000B2M', StrSubstNo(SetCachedOwningTeamCheckTxt, TeamId, SkipBusinessUnitCheck), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if SkipBusinessUnitCheck then begin if not CachedOwningTeamCheckWithoutBusinessUnit.ContainsKey(TeamId) then CachedOwningTeamCheckWithoutBusinessUnit.Add(TeamId, true); end else if not CachedOwningTeamCheckWithBusinessUnit.ContainsKey(TeamId) then CachedOwningTeamCheckWithBusinessUnit.Add(TeamId, true); end; local procedure GetCachedOwningUserCheck(UserId: Guid; SkipBusinessUnitCheck: Boolean): Boolean begin if SkipBusinessUnitCheck then begin if CachedOwningUserCheckWithoutBusinessUnit.ContainsKey(UserId) then exit(true); end else if CachedOwningUserCheckWithBusinessUnit.ContainsKey(UserId) then exit(true); exit(false); end; local procedure SetCachedOwningUserCheck(UserId: Guid; SkipBusinessUnitCheck: Boolean) begin Session.LogMessage('0000B2N', StrSubstNo(SetCachedOwningUserCheckTxt, UserId, SkipBusinessUnitCheck), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if SkipBusinessUnitCheck then begin if not CachedOwningUserCheckWithoutBusinessUnit.ContainsKey(UserId) then CachedOwningUserCheckWithoutBusinessUnit.Add(UserId, true); end else if not CachedOwningUserCheckWithBusinessUnit.ContainsKey(UserId) then CachedOwningUserCheckWithBusinessUnit.Add(UserId, true); end; local procedure GetCachedCompanyId(): Guid begin InitializeCompanyCache(); exit(CachedCompanyId); end; local procedure GetCachedDefaultOwningTeamId(): Guid begin InitializeCompanyCache(); exit(CachedDefaultOwningTeamId); end; local procedure GetCachedOwningBusinessUnitId(): Guid begin InitializeCompanyCache(); exit(CachedOwningBusinessUnitId); end; local procedure InitializeCompanyCache() var CDSCompany: Record "CDS Company"; CRMTeam: Record "CRM Team"; begin if AreCompanyValuesCached then exit; Session.LogMessage('0000B2O', InitializeCompanyCacheTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CDSCompany.SetRange(ExternalId, GetCompanyExternalId()); if not CDSCompany.FindFirst() then begin Session.LogMessage('0000B2P', CompanyNotFoundTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(CompanyNotFoundErr, GetCompanyExternalId()); end; if not CRMTeam.Get(CDSCompany.DefaultOwningTeam) then begin Session.LogMessage('0000B2Q', TeamNotFoundTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(TeamNotFoundErr, CDSCompany.DefaultOwningTeam); end; CachedCompanyId := CDSCompany.CompanyId; CachedDefaultOwningTeamId := CDSCompany.DefaultOwningTeam; CachedOwningBusinessUnitId := CRMTeam.BusinessUnitId; AreCompanyValuesCached := true; end; [Scope('OnPrem')] procedure ResetCache() begin Session.LogMessage('0000B2R', ClearCacheTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Clear(AreCompanyValuesCached); Clear(CachedCompanyId); Clear(CachedDefaultOwningTeamId); Clear(CachedOwningBusinessUnitId); Clear(CachedOwningTeamCheckWithoutBusinessUnit); Clear(CachedOwningTeamCheckWithBusinessUnit); Clear(CachedOwningUserCheckWithoutBusinessUnit); Clear(CachedOwningUserCheckWithBusinessUnit); end; [Scope('OnPrem')] procedure GetIntegrationSolutions(var SolutionUniqueNameList: List of [Text]) begin CDSIntegrationMgt.OnGetIntegrationSolutions(SolutionUniqueNameList); SolutionUniqueNameList.Insert(1, GetBaseSolutionUniqueName()) end; [Scope('OnPrem')] procedure GetIntegrationRequiredRoles(var RequiredRoleIdList: List of [Guid]) begin CDSIntegrationMgt.OnGetIntegrationRequiredRoles(RequiredRoleIdList); RequiredRoleIdList.Insert(1, GetIntegrationRoleId()); end; [Scope('OnPrem')] procedure CheckModifyConnectionURL(var ServerAddress: Text[250]) var UriHelper: DotNet Uri; UriHelper2: DotNet Uri; UriKindHelper: DotNet UriKind; UriPartialHelper: DotNet UriPartial; ProposedUri: Text[250]; begin if (ServerAddress = '') or (ServerAddress = TestServerAddressTok) then exit; ServerAddress := DelChr(ServerAddress, '<>'); if ServerAddress.EndsWith('/') then ServerAddress := ServerAddress.TrimEnd('/'); if not UriHelper.TryCreate(ServerAddress, UriKindHelper.Absolute, UriHelper2) then if not UriHelper.TryCreate('https://' + ServerAddress, UriKindHelper.Absolute, UriHelper2) then Error(InvalidUriErr); if UriHelper2.Scheme() <> 'https' then Error(MustUseHttpsErr); ProposedUri := UriHelper2.GetLeftPart(UriPartialHelper.Authority); // Test that a specific port number is given if ((UriHelper2.Port() = 443) or (UriHelper2.Port() = 80)) and (LowerCase(ServerAddress) <> LowerCase(ProposedUri)) then if Confirm(StrSubstNo(ReplaceServerAddressQst, ServerAddress, ProposedUri)) then ServerAddress := ProposedUri; end; [Scope('OnPrem')] [NonDebuggable] procedure InitializeConnection(var CrmHelper: DotNet CrmHelper): Boolean var CDSConnectionSetup: Record "CDS Connection Setup"; begin if not CDSConnectionSetup.Get() then exit(false); exit(InitializeConnection(CrmHelper, CDSConnectionSetup)); end; [Scope('OnPrem')] [NonDebuggable] procedure InitializeConnection(var CrmHelper: DotNet CrmHelper; var CDSConnectionSetup: Record "CDS Connection Setup"): Boolean begin exit(InitializeConnection(CrmHelper, GetConnectionStringWithCredentials(CDSConnectionSetup))); end; [TryFunction] [NonDebuggable] local procedure InitializeConnection(var CrmHelper: DotNet CrmHelper; ConnectionString: SecretText) begin CrmHelper := CrmHelper.CrmHelper(ConnectionString.Unwrap()); end; local procedure ProcessConnectionFailures() var DotNetExceptionHandler: Codeunit "DotNet Exception Handler"; FaultException: DotNet FaultException; FileNotFoundException: DotNet FileNotFoundException; ArgumentNullException: DotNet ArgumentNullException; CrmHelper: DotNet CrmHelper; ErrorMessage: Text; begin DotNetExceptionHandler.Collect(); if DotNetExceptionHandler.TryCastToType(GetDotNetType(FaultException)) then begin Session.LogMessage('0000AUP', ConnectionFailureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(GeneralFailureErr); end; if DotNetExceptionHandler.TryCastToType(GetDotNetType(FileNotFoundException)) then begin Session.LogMessage('0000AUQ', ConnectionFailureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(SolutionFileNotFoundErr); end; if DotNetExceptionHandler.TryCastToType(CrmHelper.OrganizationServiceFaultExceptionType()) then begin Session.LogMessage('0000AUR', ConnectionFailureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(GeneralFailureErr); end; if DotNetExceptionHandler.TryCastToType(CrmHelper.SystemNetWebException()) then begin Session.LogMessage('0000AUS', ConnectionFailureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(CDSConnectionURLWrongErr); end; if DotNetExceptionHandler.CastToType(ArgumentNullException, GetDotNetType(ArgumentNullException)) then case ArgumentNullException.ParamName() of 'cred': begin Session.LogMessage('0000AUT', ConnectionFailureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(AdminUserPasswordWrongErr); end; 'Organization Name': begin Session.LogMessage('0000AUU', ConnectionFailureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(CDSConnectionURLWrongErr); end; end; ErrorMessage := DotNetExceptionHandler.GetMessage(); if ErrorMessage <> '' then if ErrorMessage.ToLower().Contains(TimeoutTxt) then begin Session.LogMessage('0000EJ6', ConnectionFailureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(RetryAfterTimeoutErr, ErrorMessage); end; DotNetExceptionHandler.Rethrow(); end; local procedure GetSystemAdminRoleTemplateId(): Guid begin exit(TextToGuid(SystemAdminRoleTemplateIdTxt)); end; local procedure GetSystemCustomizerRoleTemplateId(): Guid begin exit(TextToGuid(SystemCustomizerRoleTemplateIdTxt)); end; local procedure GetIntegrationRoleId(): Guid begin exit(TextToGuid(IntegrationRoleIdTxt)); end; local procedure GetVirtualTablesIntegrationRoleId(): Guid begin exit(TextToGuid(VirtualTablesIntegrationRoleIdTxt)); end; local procedure GetErrorNotificationId(): Guid begin exit(TextToGuid(ErrorNotificationIdTxt)); end; local procedure GetConnectionDisabledNotificationId(): Guid begin exit(TextToGuid(ConnectionDisabledNotificationIdTxt)); end; local procedure GetMultipleCompaniesNotificationId(): Guid begin exit(TextToGuid(MultipleCompaniesNotificationIdTxt)); end; local procedure TextToGuid(TextVar: Text): Guid var GuidVar: Guid; begin if not Evaluate(GuidVar, TextVar) then; exit(GuidVar); end; internal procedure SendConnectionDisabledNotification(DisableReason: Text[250]) var Notification: Notification; begin Notification.Id := GetConnectionDisabledNotificationId(); Notification.Message := StrSubstNo(ConnectionDisabledNotificationMsg, DisableReason); Notification.Scope := NOTIFICATIONSCOPE::LocalScope; Notification.Send(); end; procedure SendMultipleCompaniesNotification() var MyNotifications: Record "My Notifications"; Notification: Notification; begin Notification.Id := GetMultipleCompaniesNotificationId(); if not MyNotifications.IsEnabled(Notification.Id) then exit; Notification.Message := MultipleCompaniesNotificationMsg; Notification.AddAction(OpenIntegrationTableMappingsMsg, Codeunit::"CDS Integration Impl.", 'OpenIntegrationTableMappings'); Notification.AddAction(LearnMoreTxt, Codeunit::"CDS Integration Impl.", 'MultipleCompanyNotificationHelpLink'); Notification.AddAction(HideNotificationTxt, CODEUNIT::"CDS Integration Impl.", 'DisableMultipleCompanyNotification'); Notification.Scope := NOTIFICATIONSCOPE::LocalScope; Notification.Send(); end; procedure MultipleCompanyNotificationHelpLink(Notification: Notification) begin Hyperlink(MultipleCompanySynchHelpLinkTxt); end; procedure DisableMultipleCompanyNotification(Notification: Notification) var MyNotifications: Record "My Notifications"; begin if not MyNotifications.Disable(GetMultipleCompaniesNotificationId()) then MyNotifications.InsertDefault(GetMultipleCompaniesNotificationId(), MultipleCompaniesNotificationNameTxt, MultipleCompaniesNotificationDescriptionTxt, false); end; procedure OpenIntegrationTableMappings(Notification: Notification) var IntegrationTableMapping: Record "Integration Table Mapping"; begin IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse); IntegrationTableMapping.SetRange("Delete After Synchronization", false); Page.Run(Page::"Integration Table Mapping List", IntegrationTableMapping); end; local procedure ShowError(ActivityDescription: Text[128]; ErrorMessage: Text) var MyNotifications: Record "My Notifications"; SystemInitialization: Codeunit "System Initialization"; begin if (not SystemInitialization.IsInProgress()) and (GetExecutionContext() = ExecutionContext::Normal) then Error(ErrorMessage); MyNotifications.InsertDefault(GetErrorNotificationId(), ActivityDescription, ErrorMessage, true); end; [Scope('OnPrem')] procedure InsertBusinessUnitCoupling(var CDSConnectionSetup: Record "CDS Connection Setup") var Company: Record Company; CDSCoupledBusinessUnit: Record "CDS Coupled Business Unit"; begin if IsNullGuid(CDSConnectionSetup."Business Unit Id") then exit; if not Company.Get(CompanyName()) then exit; CDSCoupledBusinessUnit.Validate("Company Id", Company.SystemId); CDSCoupledBusinessUnit.Validate("Business Unit Id", CDSConnectionSetup."Business Unit Id"); CDSCoupledBusinessUnit.Insert(true); end; [Scope('OnPrem')] procedure ModifyBusinessUnitCoupling(var CDSConnectionSetup: Record "CDS Connection Setup") var Company: Record Company; CDSCoupledBusinessUnit: Record "CDS Coupled Business Unit"; begin if not Company.Get(CompanyName()) then exit; CDSCoupledBusinessUnit.SetRange("Company Id", Company.SystemId); CDSCoupledBusinessUnit.DeleteAll(true); if IsNullGuid(CDSConnectionSetup."Business Unit Id") then exit; CDSCoupledBusinessUnit.Init(); CDSCoupledBusinessUnit.Validate("Company Id", Company.SystemId); CDSCoupledBusinessUnit.Validate("Business Unit Id", CDSConnectionSetup."Business Unit Id"); CDSCoupledBusinessUnit.Insert(true); end; [Scope('OnPrem')] procedure DeleteBusinessUnitCoupling(var CDSConnectionSetup: Record "CDS Connection Setup") var Company: Record Company; CDSCoupledBusinessUnit: Record "CDS Coupled Business Unit"; begin if not Company.Get(CompanyName()) then exit; CDSCoupledBusinessUnit.SetRange("Company Id", Company.SystemId); CDSCoupledBusinessUnit.SetRange("Business Unit Id", CDSConnectionSetup."Business Unit Id"); CDSCoupledBusinessUnit.DeleteAll(true); end; [Scope('OnPrem')] procedure TestConnection(var CDSConnectionSetup: Record "CDS Connection Setup"): Boolean begin if TryTestConnection(CDSConnectionSetup) then exit(true); exit(TryCheckCredentials(CDSConnectionSetup)); end; [TryFunction] local procedure TryTestConnection(var CDSConnectionSetup: Record "CDS Connection Setup") var CRMSystemuser: Record "CRM Systemuser"; TempConnectionName: Text; Id: Guid; begin CheckConnectionRequiredFields(CDSConnectionSetup, false); TempConnectionName := GetTempConnectionName(); RegisterConnection(CDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName, true); if CRMSystemuser.FindFirst() then Id := CRMSystemuser.SystemUserId; UnregisterTableConnection(TABLECONNECTIONTYPE::CRM, TempConnectionName); end; [Scope('OnPrem')] [TryFunction] procedure TryCheckCredentials(var CDSConnectionSetup: Record "CDS Connection Setup") begin CheckCredentials(CDSConnectionSetup); end; [Scope('OnPrem')] procedure CheckCredentials(var CDSConnectionSetup: Record "CDS Connection Setup") var CrmHelper: DotNet CrmHelper; begin CheckConnectionRequiredFields(CDSConnectionSetup, false); if (CDSConnectionSetup."Authentication Type" = CDSConnectionSetup."Authentication Type"::Office365) or (CDSConnectionSetup."Authentication Type" = CDSConnectionSetup."Authentication Type"::AD) then exit; if not InitializeConnection(CrmHelper, CDSConnectionSetup) then begin Session.LogMessage('0000BO2', ConnectionNotRegisteredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); ProcessConnectionFailures(); end; if not CheckCredentials(CrmHelper) then begin Session.LogMessage('0000BO3', InvalidUserCredentialsTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(IntegrationUserPasswordWrongErr); end; end; [TryFunction] local procedure CheckCredentials(var CrmHelper: DotNet CrmHelper) begin CrmHelper.CheckCredentials(); end; [Scope('OnPrem')] [TryFunction] procedure GetCDSVersion(var CDSConnectionSetup: Record "CDS Connection Setup"; var CDSVersion: Text) var CrmHelper: DotNet CrmHelper; begin if InitializeConnection(CrmHelper, CDSConnectionSetup) then CDSVersion := CrmHelper.GetConnectedCrmVersion() end; [Scope('OnPrem')] procedure InitializeProxyVersionList(var TempStack: Record TempStack temporary) var CrmHelper: DotNet CrmHelper; IList: DotNet GenericList1; i: Integer; ProxyCount: Integer; begin IList := CrmHelper.GetProxyIdList(); ProxyCount := IList.Count(); for i := 0 to ProxyCount - 1 do begin TempStack.StackOrder := IList.Item(i); TempStack.Insert(); end; end; [Scope('OnPrem')] procedure GetLastProxyVersionItem(): Integer var TempStack: Record TempStack temporary; begin InitializeProxyVersionList(TempStack); TempStack.FindLast(); exit(TempStack.StackOrder); end; [Scope('OnPrem')] procedure ClearConnectionDisableReason(var CDSConnectionSetup: Record "CDS Connection Setup") var Notification: Notification; begin if CDSConnectionSetup."Disable Reason" = '' then exit; Session.LogMessage('0000AUV', ClearDisabledReasonTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Notification.Id := GetConnectionDisabledNotificationId(); Notification.Recall(); Clear(CDSConnectionSetup."Disable Reason"); CDSConnectionSetup.Modify(); end; [Scope('OnPrem')] procedure UpdateDomainName(var CDSConnectionSetup: Record "CDS Connection Setup") var UserName: Text; begin UserName := CDSConnectionSetup."User Name"; if UserName <> '' then if StrPos(UserName, '\') > 0 then CDSConnectionSetup.Validate(Domain, CopyStr(UserName, 1, StrPos(UserName, '\') - 1)) else CDSConnectionSetup.Domain := ''; end; [Scope('OnPrem')] procedure CheckUserName(var CDSConnectionSetup: Record "CDS Connection Setup") var UserName: Text; begin UserName := CDSConnectionSetup."User Name"; if UserName <> '' then case CDSConnectionSetup."Authentication Type" of CDSConnectionSetup."Authentication Type"::AD: if StrPos(UserName, '\') = 0 then Error(UserNameMustIncludeDomainErr); CDSConnectionSetup."Authentication Type"::Office365: if StrPos(UserName, '@') = 0 then Error(UserNameMustBeEmailErr); end; end; local procedure GetDomainToken(var CDSConnectionSetup: Record "CDS Connection Setup"): Text begin if CDSConnectionSetup.Domain <> '' then exit(StrSubstNo('Domain=%1;', CDSConnectionSetup.Domain)); end; [Scope('OnPrem')] procedure GetAuthenticationTypeToken(var CDSConnectionSetup: Record "CDS Connection Setup"): Text begin exit(GetAuthenticationTypeToken(CDSConnectionSetup, '')); end; [Scope('OnPrem')] procedure GetAuthenticationTypeToken(var CDSConnectionSetup: Record "CDS Connection Setup"; Domain: Text): Text begin case CDSConnectionSetup."Authentication Type" of CDSConnectionSetup."Authentication Type"::Office365: exit('AuthType=Office365;'); CDSConnectionSetup."Authentication Type"::AD: if Domain = '' then exit('AuthType=AD;' + GetDomainToken(CDSConnectionSetup)) else exit('AuthType=AD; Domain=' + Domain + ';'); CDSConnectionSetup."Authentication Type"::IFD: exit('AuthType=IFD;' + GetDomainToken(CDSConnectionSetup) + 'HomeRealmUri= ;'); CDSConnectionSetup."Authentication Type"::OAuth: exit('AuthType=OAuth;' + 'AppId= ;' + 'RedirectUri= ;' + 'TokenCacheStorePath= ;' + 'LoginPrompt=Auto;'); end; end; [Scope('OnPrem')] procedure IsCDSVersionValid(CDSVersion: Text): Boolean var Version: DotNet Version; begin if CDSVersion <> '' then if Version.TryParse(CDSVersion, Version) then exit((Version.Major() > 6) and not ((Version.Major() = 7) and (Version.Minor() = 1))); exit(false); end; [Scope('OnPrem')] procedure IsSolutionVersionValid(SolutionVersion: Text): Boolean var Version: DotNet Version; begin if SolutionVersion <> '' then if Version.TryParse(SolutionVersion, Version) then exit(Version.Major() >= 1); exit(false); end; procedure MultipleCompaniesConnected(): Boolean var CDSCompanyCount: Integer; begin if not TryCDSCompanyCount(CDSCompanyCount) then exit(false); exit(CDSCompanyCount > 1); end; [TryFunction] local procedure TryCDSCompanyCount(var CompanyCount: Integer) var CDSCompany: Record "CDS Company"; CRMIntegrationManagement: Codeunit "CRM Integration Management"; begin if (CRMIntegrationManagement.IsCDSIntegrationEnabled() or CRMIntegrationManagement.IsCRMIntegrationEnabled()) then CompanyCount := CDSCompany.Count(); end; internal procedure GetBusinessEventsSupported(): Boolean var Supported: Boolean; Handled: Boolean; begin OnBeforeGetBusinessEventsSupported(Supported, Handled); if Handled then exit(Supported); exit(EnvironmentInfo.IsSaaSInfrastructure()); end; [NonDebuggable] procedure UpdateBusinessEventsSetupFromWizard(var SourceCDSConnectionSetup: Record "CDS Connection Setup") var CDSConnectionSetup: Record "CDS Connection Setup"; begin Session.LogMessage('0000GBQ', UpdateBusinessEventsSetupTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if not CDSConnectionSetup.Get() then begin CDSConnectionSetup.Init(); CDSConnectionSetup.Insert(); end; CDSConnectionSetup.Validate("Server Address", SourceCDSConnectionSetup."Server Address"); CDSConnectionSetup.Validate("Authentication Type", SourceCDSConnectionSetup."Authentication Type"); if not EnvironmentInfo.IsSaaSInfrastructure() then begin CDSConnectionSetup.Validate("Client Id", SourceCDSConnectionSetup."Client Id"); CDSConnectionSetup.SetClientSecret(SourceCDSConnectionSetup.GetSecretClientSecret()); CDSConnectionSetup.Validate("Redirect URL", SourceCDSConnectionSetup."Redirect URL"); end; CDSConnectionSetup.Validate("Business Events Enabled", SourceCDSConnectionSetup."Business Events Enabled"); CDSConnectionSetup.Validate("Virtual Tables Config Id", SourceCDSConnectionSetup."Virtual Tables Config Id"); CDSConnectionSetup.Modify(); Session.LogMessage('0000GBR', BusinessEventsSetupUpdatedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; [Scope('OnPrem')] procedure UpdateConnectionSetupFromWizard(var SourceCDSConnectionSetup: Record "CDS Connection Setup"; PasswordText: SecretText) var CDSConnectionSetup: Record "CDS Connection Setup"; begin Session.LogMessage('0000AUZ', UpdateSynchronizationSetupTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); if not CDSConnectionSetup.Get() then begin CDSConnectionSetup.Init(); CDSConnectionSetup.Insert(); end; CDSConnectionSetup.Validate("Server Address", SourceCDSConnectionSetup."Server Address"); CDSConnectionSetup.Validate("Authentication Type", SourceCDSConnectionSetup."Authentication Type"); CDSConnectionSetup.Validate("User Name", SourceCDSConnectionSetup."User Name"); CDSConnectionSetup.SetPassword(PasswordText); if not EnvironmentInfo.IsSaaSInfrastructure() then begin CDSConnectionSetup.Validate("Client Id", SourceCDSConnectionSetup."Client Id"); CDSConnectionSetup.SetClientSecret(SourceCDSConnectionSetup.GetSecretClientSecret()); CDSConnectionSetup.Validate("Redirect URL", SourceCDSConnectionSetup."Redirect URL"); end; CDSConnectionSetup.Validate("Proxy Version", SourceCDSConnectionSetup.GetProxyVersion()); CDSConnectionSetup.Validate("Business Unit Id", SourceCDSConnectionSetup."Business Unit Id"); CDSConnectionSetup.Validate("Business Unit Name", SourceCDSConnectionSetup."Business Unit Name"); CDSConnectionSetup.Validate("Is Enabled", SourceCDSConnectionSetup."Is Enabled"); CDSConnectionSetup.Validate(CurrencyDecimalPrecision, SourceCDSConnectionSetup.CurrencyDecimalPrecision); CDSConnectionSetup.Validate(BaseCurrencyId, SourceCDSConnectionSetup.BaseCurrencyId); CDSConnectionSetup.Validate(BaseCurrencyPrecision, SourceCDSConnectionSetup.BaseCurrencyPrecision); CDSConnectionSetup.Validate(BaseCurrencySymbol, SourceCDSConnectionSetup.BaseCurrencySymbol); CDSConnectionSetup.Validate(BaseCurrencyCode, SourceCDSConnectionSetup.BaseCurrencyCode); if SourceCDSConnectionSetup."Ownership Model" in [CDSConnectionSetup."Ownership Model"::Person, CDSConnectionSetup."Ownership Model"::Team] then CDSConnectionSetup.Validate("Ownership Model", SourceCDSConnectionSetup."Ownership Model") else CDSConnectionSetup.Validate("Ownership Model", CDSConnectionSetup."Ownership Model"::Team); SetConnectionString(CDSConnectionSetup, SourceCDSConnectionSetup."Connection String"); Session.LogMessage('0000AV0', SynchronizationSetupUpdatedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; [NonDebuggable] local procedure PromptForAdminCredentials(var CDSConnectionSetup: Record "CDS Connection Setup"; var AdminUser: Text; var AdminPassword: SecretText; var AdminADDomain: Text): Boolean var TempOfficeAdminCredentials: Record "Office Admin. Credentials" temporary; BackslashPos: Integer; begin TempOfficeAdminCredentials.Endpoint := CDSConnectionSetup."Server Address"; TempOfficeAdminCredentials.Insert(); Commit(); if Page.RunModal(Page::"Dynamics CRM Admin Credentials", TempOfficeAdminCredentials) <> Action::LookupOK then begin Session.LogMessage('0000AV1', IgnoredAdminCredentialsTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; if (TempOfficeAdminCredentials.Email = '') or (TempOfficeAdminCredentials.Password = '') then begin Session.LogMessage('0000AV2', InvalidAdminCredentialsTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; if CDSConnectionSetup."Authentication Type" = CDSConnectionSetup."Authentication Type"::AD then begin BackslashPos := StrPos(TempOfficeAdminCredentials.Email, '\'); if (BackslashPos <= 1) or (BackslashPos = StrLen(TempOfficeAdminCredentials.Email)) then Error(UserNameMustIncludeDomainErr); AdminADDomain := CopyStr(TempOfficeAdminCredentials.Email, 1, BackslashPos - 1); AdminUser := CopyStr(TempOfficeAdminCredentials.Email, BackslashPos + 1); AdminPassword := TempOfficeAdminCredentials.Password; exit(true); end; AdminUser := TempOfficeAdminCredentials.Email; AdminPassword := TempOfficeAdminCredentials.Password; exit(true); end; [Scope('OnPrem')] procedure GetTempConnectionName(): Text begin if TemporaryConnectionName = '' then TemporaryConnectionName := StrSubstNo('%1%2', TemporaryConnectionPrefixTok, CreateGuid()); exit(TemporaryConnectionName); end; [Scope('OnPrem')] procedure GetDefaultBusinessUnitName(): Text[160] var Company: Record Company; begin Company.Get(CompanyName()); exit(GetDefaultBusinessUnitName(Company.Name, GetCompanyExternalId(Company))); end; local procedure GetDefaultBusinessUnitName(CompanyName: Text; CompanyId: Text) BusinessUnitName: Text[160] var IsHandled: Boolean; begin OnBeforeGetDefaultBusinessUnitName(BusinessUnitName, IsHandled); if IsHandled then exit; BusinessUnitName := CopyStr(StrSubstNo(BusinessUnitNameTemplateTok, CompanyName, CompanyId), 1, MaxStrLen(BusinessUnitName)); end; local procedure GetOwningTeamName(BusinessUnitName: Text) TeamName: Text[160] begin TeamName := CopyStr(StrSubstNo(TeamNameTemplateTok, BusinessUnitName), 1, MaxStrLen(TeamName)); end; [Scope('OnPrem')] procedure GetCompanyExternalId() ExternalId: Text[36] var Company: Record Company; begin Company.Get(CompanyName()); ExternalId := GetCompanyExternalId(Company); end; local procedure GetCompanyExternalId(Company: Record Company) ExternalId: Text[36] begin ExternalId := CopyStr(Format(Company.SystemId).ToLower().Replace('{', '').Replace('}', ''), 1, MaxStrLen(ExternalId)); end; [Scope('OnPrem')] procedure ShowIntegrationUser(CDSConnectionSetup: Record "CDS Connection Setup") var CRMIntegrationManagement: Codeunit "CRM Integration Management"; IntegrationUserId: Guid; begin IntegrationUserId := GetIntegrationUserId(CDSConnectionSetup); Hyperlink(CRMIntegrationManagement.GetCRMEntityUrlFromCRMID(Database::"CRM Systemuser", IntegrationUserId)); end; [Scope('OnPrem')] procedure ShowOwningTeam(CDSConnectionSetup: Record "CDS Connection Setup") var CRMIntegrationManagement: Codeunit "CRM Integration Management"; OwningTeamId: Guid; begin OwningTeamId := GetOwningTeamId(CDSConnectionSetup); Hyperlink(CRMIntegrationManagement.GetCRMEntityUrlFromCRMID(Database::"CRM Team", OwningTeamId)); end; internal procedure ShowSyntheticRelationsConfig() var CDSConnectionSetup: Record "CDS Connection Setup"; begin if not CDSConnectionSetup.Get() then exit; if not IsNullGuid(CDSConnectionSetup."Virtual Tables Config Id") then Hyperlink(GetCRMEntityListUrl(CDSConnectionSetup, SyntheticRelationEntityNameTxt, VirtualTableAppNameTxt)); end; internal procedure ShowVirtualTablesConfig(CDSConnectionSetup: Record "CDS Connection Setup") begin if not IsNullGuid(CDSConnectionSetup."Virtual Tables Config Id") then Hyperlink(GetCRMEntityUrlFromCRMID(CDSConnectionSetup."Server Address", Database::"CRM BC Virtual Table Config.", CDSConnectionSetup."Virtual Tables Config Id", VirtualTableAppNameTxt)); end; internal procedure GetCRMEntityUrlFromCRMID(ServerAddress: Text; TableId: Integer; CRMId: Guid; AppName: Text): Text var CRMIntegrationManagement: Codeunit "CRM Integration Management"; CRMEntityUrl: Text; begin if AppName <> '' then CRMEntityUrl := StrSubstNo(CRMEntityWithAppUrlTemplateTxt, ServerAddress, AppName, CRMIntegrationManagement.GetCRMEntityTypeName(TableId), CRMId) else CRMEntityUrl := StrSubstNo(CRMEntityUrlTemplateTxt, ServerAddress, CRMIntegrationManagement.GetCRMEntityTypeName(TableId), CRMId); exit(CRMEntityUrl); end; internal procedure GetCRMEntityListUrl(var CDSConnectionSetup: Record "CDS Connection Setup"; EntityTypeName: Text; AppName: Text): Text begin if AppName <> '' then exit(StrSubstNo(CRMEntityListWithAppUrlTemplateTxt, CDSConnectionSetup."Server Address", AppName, EntityTypeName)) else exit(StrSubstNo(CRMEntityListUrlTemplateTxt, CDSConnectionSetup."Server Address", EntityTypeName)); end; [EventSubscriber(ObjectType::Table, Database::"Service Connection", 'OnRegisterServiceConnection', '', false, false)] local procedure HandleOnRegisterServiceConnection(var ServiceConnection: Record "Service Connection") var CDSConnectionSetup: Record "CDS Connection Setup"; [SecurityFiltering(SecurityFilter::Ignored)] CDSConnectionSetup2: Record "CDS Connection Setup"; RecRef: RecordRef; begin if not CDSConnectionSetup.Get() then begin if not CDSConnectionSetup2.WritePermission() then begin Session.LogMessage('0000AV4', NoPermissionsTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit; end; CDSConnectionSetup.Init(); CDSConnectionSetup.Insert(); end; RecRef.GetTable(CDSConnectionSetup); ServiceConnection.Status := ServiceConnection.Status::Enabled; if not CDSConnectionSetup."Is Enabled" then ServiceConnection.Status := ServiceConnection.Status::Disabled else if TryCheckEntitiesAvailability(CDSConnectionSetup) then ServiceConnection.Status := ServiceConnection.Status::Connected else ServiceConnection.Status := ServiceConnection.Status::Error; ServiceConnection.InsertServiceConnectionExtended( ServiceConnection, RecRef.RecordId(), CDSConnectionSetup.TableCaption(), CDSConnectionSetup."Server Address", PAGE::"CDS Connection Setup", PAGE::"CDS Connection Setup Wizard"); end; [Scope('OnPrem')] procedure ScheduleRebuildingOfCouplingTable() begin if not Confirm(RebuildCouplingTableQst) then exit else Hyperlink(RebuildCouplingTableExtensionLinkTxt); end; procedure GetOptionSetMetadata(EntityName: Text; FieldName: Text): Dictionary of [Integer, Text] var CrmHelper: DotNet CrmHelper; OptionMetadataDictionary: Dotnet GenericDictionary2; OptionMetadata: DotNet GenericKeyValuePair2; Result: Dictionary of [Integer, Text]; begin if (EntityName <> '') and (FieldName <> '') then if InitializeConnection(CrmHelper) then begin OptionMetadataDictionary := CrmHelper.GetOptionSetMetadata(EntityName, FieldName); foreach OptionMetadata in OptionMetadataDictionary do Result.Add(OptionMetadata.Key, OptionMetadata.Value); end; exit(Result); end; procedure InsertOptionSetMetadata(EntityName: Text; FieldName: Text; NewOptionLabel: Text): Integer var CRMOrganization: Record "CRM Organization"; CrmHelper: DotNet CrmHelper; Result: Integer; begin if (EntityName <> '') and (FieldName <> '') and (NewOptionLabel <> '') then if InitializeConnection(CrmHelper) then begin CRMOrganization.FindFirst(); if CRMOrganization.LanguageCode <> 0 then Result := CRMHelper.InsertOptionSetMetadata(EntityName, FieldName, NewOptionLabel, CRMOrganization.LanguageCode) else Result := CrmHelper.InsertOptionSetMetadata(EntityName, FieldName, NewOptionLabel); end; exit(Result); end; procedure InsertOptionSetMetadataWithOptionValue(EntityName: Text; FieldName: Text; NewOptionLabel: Text; NewOptionValue: Integer): Integer var CRMOrganization: Record "CRM Organization"; CrmHelper: DotNet CrmHelper; Result: Integer; begin if (EntityName <> '') and (FieldName <> '') and (NewOptionLabel <> '') and (NewOptionValue <> 0) then if InitializeConnection(CrmHelper) then begin CRMOrganization.FindFirst(); if CRMOrganization.LanguageCode <> 0 then Result := CRMHelper.InsertOptionSetMetadataWithOptionValueAndLanguageCode(EntityName, FieldName, NewOptionLabel, NewOptionValue, CRMOrganization.LanguageCode) else Result := CrmHelper.InsertOptionSetMetadataWithOptionValue(EntityName, FieldName, NewOptionLabel, NewOptionValue); end; exit(Result); end; procedure UpdateOptionSetMetadata(EntityName: Text; FieldName: Text; OptionValue: Integer; NewOptionLabel: Text) var CRMOrganization: Record "CRM Organization"; CrmHelper: DotNet CrmHelper; begin if (EntityName <> '') and (FieldName <> '') and (OptionValue <> 0) and (NewOptionLabel <> '') then if InitializeConnection(CrmHelper) then begin CRMOrganization.FindFirst(); if CRMOrganization.LanguageCode <> 0 then CrmHelper.UpdateOptionSetMetadataWithLanguageCode(EntityName, FieldName, OptionValue, NewOptionLabel, CRMOrganization.LanguageCode) else CrmHelper.UpdateOptionSetMetadata(EntityName, FieldName, OptionValue, NewOptionLabel); end; end; [NonDebuggable] internal procedure RegisterConfiguredConnection(var CrmHelper: DotNet CrmHelper): Text var CDSConnectionSetup: Record "CDS Connection Setup"; TempAdminCDSConnectionSetup: Record "CDS Connection Setup" temporary; TempConnectionName, TempConnectionStringWithPlaceholder : Text; TempConnectionString, AccessToken : SecretText; begin if not CDSConnectionSetup.FindFirst() then exit; if not CDSConnectionSetupConfiguredForVirtualTables(CDSConnectionSetup) then exit; GetTempConnectionSetup(TempAdminCDSConnectionSetup, CDSConnectionSetup, AccessToken); TempConnectionName := GetTempConnectionName(); GetAccessToken(CDSConnectionSetup."Server Address", true, AccessToken); TempConnectionStringWithPlaceholder := StrSubstNo(OAuthConnectionStringFormatTxt, CDSConnectionSetup."Server Address", '%1', CDSConnectionSetup.GetProxyVersion(), GetAuthenticationTypeToken(CDSConnectionSetup)); TempConnectionString := SecretStrSubstNo(TempConnectionStringWithPlaceholder, AccessToken); if not InitializeConnection(CrmHelper, TempConnectionString) then begin Session.LogMessage('0000KN7', ConnectionNotRegisteredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); ProcessConnectionFailures(); end; GetTempConnectionSetup(TempAdminCDSConnectionSetup, CDSConnectionSetup, AccessToken); TempConnectionName := GetTempConnectionName(); RegisterConnection(TempAdminCDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TableConnectionType::CRM, TempConnectionName, false); exit(TempConnectionName); end; local procedure CDSConnectionSetupConfiguredForVirtualTables(CDSConnectionSetup: Record "CDS Connection Setup"): Boolean begin if not CDSConnectionSetup."Business Events Enabled" then exit(false); if CDSConnectionSetup."Authentication Type" <> CDSConnectionSetup."Authentication Type"::Office365 then begin Session.LogMessage('0000LKE', VTCannotConfigureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CDSConnectionSetup.TestField("Authentication Type", CDSConnectionSetup."Authentication Type"::Office365); end; if not CheckConnectionRequiredFields(CDSConnectionSetup, true) then begin Session.LogMessage('0000LKF', VTCannotConfigureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(GetLastErrorText()); end; exit(true); end; internal procedure LoadAvailableVirtualTables(var CDSAvVirtualTableBuffer: Record "CDS Av. Virtual Table Buffer"; LoadOnlyVisible: Boolean) var CDSAvailableVirtualTable: Record "CDS Available Virtual Table"; CDSConnectionSetup: Record "CDS Connection Setup"; JobQueueEntry: Record "Job Queue Entry"; TempAdminCDSConnectionSetup: Record "CDS Connection Setup" temporary; CrmHelper: DotNet CrmHelper; AccessToken: SecretText; TempConnectionStringWithPlaceholder: Text; TempConnectionString: SecretText; TempConnectionName: Text; begin if CDSConnectionSetup.FindFirst() then if CDSConnectionSetup."Business Events Enabled" then begin if CDSConnectionSetup."Authentication Type" <> CDSConnectionSetup."Authentication Type"::Office365 then begin Session.LogMessage('0000KN5', VTCannotConfigureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); CDSConnectionSetup.TestField("Authentication Type", CDSConnectionSetup."Authentication Type"::Office365); end; if not CheckConnectionRequiredFields(CDSConnectionSetup, true) then begin Session.LogMessage('0000KN6', VTCannotConfigureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(GetLastErrorText()); end; GetAccessToken(CDSConnectionSetup."Server Address", true, AccessToken); TempConnectionStringWithPlaceholder := StrSubstNo(OAuthConnectionStringFormatTxt, CDSConnectionSetup."Server Address", '%1', CDSConnectionSetup.GetProxyVersion(), GetAuthenticationTypeToken(CDSConnectionSetup)); TempConnectionString := SecretStrSubstNo(TempConnectionStringWithPlaceholder, AccessToken); if not InitializeConnection(CrmHelper, TempConnectionString) then begin Session.LogMessage('0000KN7', ConnectionNotRegisteredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); ProcessConnectionFailures(); end; GetTempConnectionSetup(TempAdminCDSConnectionSetup, CDSConnectionSetup, AccessToken); TempConnectionName := GetTempConnectionName(); RegisterConnection(TempAdminCDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TableConnectionType::CRM, TempConnectionName, true); if CDSAvailableVirtualTable.FindSet() then repeat if CDSAvailableVirtualTable.mserp_hasbeengenerated or (not LoadOnlyVisible) then begin CDSAvVirtualTableBuffer.TransferFields(CDSAvailableVirtualTable); JobQueueEntry.SetRange("Object ID to Run", Codeunit::"Enable CDS Virtual Tables"); JobQueueEntry.SetRange("Object Type to Run", JobQueueEntry."Object Type to Run"::Codeunit); JobQueueEntry.SetRange("Job Queue Category Code", CopyStr(EnableCDSVirtualTablesJobQueueCategoryTxt, 1, MaxStrLen(JobQueueEntry."Job Queue Category Code"))); JobQueueEntry.SetRange(Description, StrSubstNo(EnableCDSVirtualTablesJobQueueDescriptionTxt, CDSAvailableVirtualTable.mserp_cdsentitylogicalname)); if JobQueueEntry.FindFirst() then if JobQueueEntry.Status in [JobQueueEntry.Status::"In Process", JobQueueEntry.Status::Ready] then CDSAvVirtualTableBuffer."In Process" := true; CDSAvVirtualTableBuffer.Insert(); end; until CDSAvailableVirtualTable.Next() = 0; UnregisterTableConnection(TableConnectionType::CRM, TempConnectionName); end; end; [NonDebuggable] internal procedure EnableVirtualTables(FilterTxt: Text) var CDSAvailableVirtualTable: Record "CDS Available Virtual Table"; CDSConnectionSetup: Record "CDS Connection Setup"; TempAdminCDSConnectionSetup: Record "CDS Connection Setup" temporary; CrmHelper: DotNet CrmHelper; AccessToken: SecretText; TempConnectionStringWithPlaceholder: Text; TempConnectionString: SecretText; TempConnectionName: Text; begin if CDSConnectionSetup.FindFirst() then if FilterTxt <> '' then begin if not CheckConnectionRequiredFields(CDSConnectionSetup, true) then begin Session.LogMessage('0000KN8', VTCannotConfigureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(GetLastErrorText()); end; GetAccessToken(CDSConnectionSetup."Server Address", true, AccessToken); TempConnectionStringWithPlaceholder := StrSubstNo(OAuthConnectionStringFormatTxt, CDSConnectionSetup."Server Address", '%1', CDSConnectionSetup.GetProxyVersion(), GetAuthenticationTypeToken(CDSConnectionSetup)); TempConnectionString := SecretStrSubstNo(TempConnectionStringWithPlaceholder, AccessToken); if not InitializeConnection(CrmHelper, TempConnectionString) then begin Session.LogMessage('0000KN9', ConnectionNotRegisteredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); ProcessConnectionFailures(); end; GetTempConnectionSetup(TempAdminCDSConnectionSetup, CDSConnectionSetup, AccessToken); TempConnectionName := GetTempConnectionName(); RegisterConnection(TempAdminCDSConnectionSetup, TempConnectionName); SetDefaultTableConnection(TableConnectionType::CRM, TempConnectionName, true); CDSAvailableVirtualTable.SetFilter(mserp_cdsentitylogicalname, FilterTxt); if CDSAvailableVirtualTable.FindFirst() then begin CDSAvailableVirtualTable.mserp_hasbeengenerated := true; CDSAvailableVirtualTable.Modify(); end; UnregisterTableConnection(TableConnectionType::CRM, TempConnectionName); end; end; procedure ScheduleEnablingVirtualTables(FilterList: List of [Text]) var JobQueueEntry: Record "Job Queue Entry"; FilterTxt: Text; WaitTime: Integer; EarliestStartDateTime: DateTime; begin EarliestStartDateTime := CurrentDateTime() + 1000; foreach FilterTxt in FilterList do begin Clear(JobQueueEntry); JobQueueEntry."Object Type to Run" := JobQueueEntry."Object Type to Run"::Codeunit; JobQueueEntry."Object ID to Run" := Codeunit::"Enable CDS Virtual Tables"; JobQueueEntry."Job Queue Category Code" := CopyStr(EnableCDSVirtualTablesJobQueueCategoryTxt, 1, MaxStrLen(JobQueueEntry."Job Queue Category Code")); EarliestStartDateTime += 90000 * WaitTime; JobQueueEntry."Earliest Start Date/Time" := EarliestStartDateTime; JobQueueEntry."Run in User Session" := false; JobQueueEntry.Description := StrSubstNo(EnableCDSVirtualTablesJobQueueDescriptionTxt, FilterTxt); JobQueueEntry."Maximum No. of Attempts to Run" := 3; JobQueueEntry."Rerun Delay (sec.)" := 30; JobQueueEntry.Insert(true); JobQueueEntry.SetXmlContent(FilterTxt); Commit(); Codeunit.Run(Codeunit::"Job Queue - Enqueue", JobQueueEntry); WaitTime += 1; end; end; procedure OpenEnableVirtualTablesJobFromNotification(ScheduledJobNotification: Notification) var JobQueueEntry: Record "Job Queue Entry"; begin JobQueueEntry.SetRange("Job Queue Category Code", EnableCDSVirtualTablesJobQueueCategoryTxt); Page.Run(Page::"Job Queue Entries", JobQueueEntry); end; procedure LearnMoreDisablingCRMConnection(ErrorInfo: ErrorInfo) begin Hyperlink('https://go.microsoft.com/fwlink/?linkid=2206514'); end; internal procedure CleanCDSIntegration(CompanyName: Text) var CDSConnectionSetup: Record "CDS Connection Setup"; CRMConnectionSetup: Record "CRM Connection Setup"; CRMIntegrationRecord: Record "CRM Integration Record"; IntegrationSyncJob: Record "Integration Synch. Job"; IntegrationsSyncJobErrors: Record "Integration Synch. Job Errors"; TableKey: Codeunit "Table Key"; DisableIntegrationRecordCleanup: Boolean; begin if CompanyName() <> CompanyName then begin CDSConnectionSetup.ChangeCompany(CompanyName); CRMConnectionSetup.ChangeCompany(CompanyName); IntegrationSyncJob.ChangeCompany(CompanyName); IntegrationsSyncJobErrors.ChangeCompany(CompanyName); CRMIntegrationRecord.ChangeCompany(CompanyName); end; // Here we delete the setup records CDSConnectionSetup.DeleteAll(); CRMConnectionSetup.DeleteAll(); OnBeforeCleanCRMIntegrationRecords(DisableIntegrationRecordCleanup); if not DisableIntegrationRecordCleanup then if not CRMIntegrationRecord.Truncate() then begin // Deleting all couplings can timeout so disable the keys before deleting TableKey.DisableAll(Database::"CRM Integration Record"); CRMIntegrationRecord.DeleteAll(); end; end; internal procedure GetEntityMetadata(TableNo: Integer): Text var TableMetadata: Record "Table Metadata"; CrmHelper: DotNet CrmHelper; begin if TableNo = 0 then exit(''); if not TableMetadata.Get(TableNo) then exit(''); if TableMetadata.ExternalName = '' then exit(''); if not InitializeConnection(CrmHelper) then exit(''); Session.LogMessage('0000QL8', StrSubstNo(RetrievingEntityMetadataTxt, TableMetadata.ExternalName), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(CrmHelper.GetEntityMetadata(TableMetadata.ExternalName)); end; internal procedure GetEntityFields(TableNo: Integer; var IntegrationField: Record "Integration Field") var Field: Record Field; TableMatadata: Record "Table Metadata"; CrmHelper: DotNet CrmHelper; FieldsDictionary: Dotnet GenericDictionary2; Fields: DotNet GenericKeyValuePair2; begin if TableNo = 0 then exit; if not TableMatadata.Get(TableNo) then exit; if TableMatadata.ExternalName = '' then exit; if not InitializeConnection(CrmHelper) then exit; Session.LogMessage('0000QL9', StrSubstNo(RetrievingEntityFieldsTxt, TableMatadata.ExternalName), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); FieldsDictionary := CrmHelper.GetEntityFields(TableMatadata.ExternalName); foreach Fields in FieldsDictionary do begin Field.SetRange(TableNo, TableNo); Field.SetRange(ExternalName, Fields.Key); if not Field.IsEmpty() then continue; IntegrationField."Table No." := TableNo; IntegrationField."Field Name" := Fields.Key; IntegrationField."Field Caption" := Fields.Value; IntegrationField.IsRuntime := true; IntegrationField.Insert(); end; end; [IntegrationEvent(false, false)] local procedure OnBeforeCleanCRMIntegrationRecords(var DisableIntegrationRecordCleanup: Boolean) begin end; [EventSubscriber(ObjectType::Table, Database::"Integration Synch. Job Errors", 'OnIsDataIntegrationEnabled', '', false, false)] local procedure IsDataIntegrationEnabled(var IsIntegrationEnabled: Boolean) begin if not IsIntegrationEnabled then IsIntegrationEnabled := CDSIntegrationMgt.IsIntegrationEnabled(); end; [EventSubscriber(ObjectType::Page, Page::"My Notifications", 'OnInitializingNotificationWithDefaultState', '', false, false)] local procedure InsertDefaultStateOnInitializingNotificationWithDefaultState() var MyNotifications: Record "My Notifications"; begin MyNotifications.InsertDefault(GetMultipleCompaniesNotificationId(), MultipleCompaniesNotificationNameTxt, MultipleCompaniesNotificationDescriptionTxt, true); end; [IntegrationEvent(false, false)] local procedure OnBeforeCheckGLSetupLCYCode(GLSetup: Record "General Ledger Setup"; CRMTransactioncurrency: Record "CRM Transactioncurrency"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnGetCDSConnectionClientId(var ClientId: Text) begin end; [IntegrationEvent(false, false)] local procedure OnGetCDSConnectionClientSecret(var ClientSecret: Text) begin end; [IntegrationEvent(false, false)] local procedure OnAfterIntegrationEnabled() begin end; [IntegrationEvent(false, false)] local procedure OnBeforeGetBusinessEventsSupported(var Supported: Boolean; var Handled: Boolean) begin end; [IntegrationEvent(true, false)] local procedure OnBeforeGetDefaultBusinessUnitName(var BusinessUnitName: Text[160]; var IsHandled: Boolean) begin end; [IntegrationEvent(true, false)] local procedure OnGetIntegrationUserEmail(var IntegrationUsernameEmailTxt: Text[100]; var IsHandled: Boolean) begin end;}