![]() ![]() Modify the app's manifest to configure OAuth2 implicit grant flow and an spa type reply URL for the Excel add-in.įrom the application's Overview, select Manifest.We’ve combined the best of Microsoft Excel and SAP Analytics Cloud. For purposes of this article, select Accounts in this organizational directory only. Specifies which accounts that you would like your application to support. The name of your application as it will display to your users, such as Excel Add-in for Business Central. ![]() On the Register an application page, fill in the following information, then select Register.: Setting Under Manage, select App registrations > New registration. Search for and select Azure Active Directory. For more guidelines, go to Register your application with your Azure Active Directory tenant. The Excel add-in requires that you add (register) a separate Azure AD application in the Azure AD tenant. When Azure AD authentication was set up for your Business Central deployment, an Azure AD tenant was created in Microsoft Azure, and an application for Business Central was registered in the tenant. Register and configure an application in Microsoft Azure Otherwise, select Set to expose the API.įor information about how to expose the Web API, go to Quickstart: Configure an application to expose web APIs. On the Expose API page, if the Application ID URI box is filled out, then API is already exposed, so you don't have to do anything else.Under Manage, select App registrations, then select the app registration for Business Central authentication.Search for and select Azure Active Directory.You can also use the following steps to verify. The API may have already been exposed as part of the Azure AD authentication setup. Before the Excel add-in can be configured, you must configure the Business Central application in Azure AD to expose its Web API. When Business Central is configured for Azure AD authentication, the Business Central application is registered as an application in an Azure AD. If your deployment is multitenant, Business Central Web client must accept host names for tenants.įor more information, go to Configure the Web Server to Accept Host Names for Tenants.īusiness Central client computers have a supported version of Excel.įor more information, go to System Requirements.Įxpose the Business Central application Web API in Azure AD OData enabled and uses Secure Sockets Layer (SSL) for authentication.įor more information, go to Using Security Certificates with Business Central On-Premises.īusiness Central Web Server configured to use SSL (https).įor more information, go to Configure SSL to Secure the Connection to Web Client. Otherwise, you'll get an error that the realm is not defined when trying to edit data using Edit in Excel.įor Business Central 2021 release wave 2 (v19) and earlier, go to Configure Azure Active Directory Authentication with WS-Federation. ![]() The add-in is based on the Microsoft Dynamics Office Add-In available from the Office Store.įor more information about how users work with Excel from Business Central, see Viewing and Editing in Excel From Business Central.īe sure to set WSFederationLoginEndpoint parameter of Business Central Server instance. When this add-in is set up, the Edit in Excel action is added. But the Open in Excel action doesn't allow them to push changed data back to Business Central. Without this add-in, users can open a list page in Excel from the Open in Excel action on the page. Users can get fresh data from Business Central into Excel and push updated data from Excel to Business Central. You can set up the Business Central deployment to support an add-in that enables users in the Business Central client to work with data from list pages in Excel. This article does not apply to the older Excel add-in that was available for installation with the Dynamics NAV Client connected to Business Central client by using the Business Central Setup in versions older than 2019 release wave 2. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |