microsoft / bc2dataverse Goto Github PK

Integrate Business Central to Dataverse in a low code way

License: MIT License

C# 10.84% TypeScript 84.67% HTML 4.49%

bc2dataverse's Introduction

Overview

Welcome to the bc2dataverse extension page!

This tool helps you achieve quicker integration of your Dynamics 365 Business Central with Dataverse, that powers your Power Apps or Dynamics 365 Customer Engagement apps. Using inputs from you, it generates the AL code that can then be added to, or published as, an AL extension. The generated code conforms to the guidelines as specified at Customizing an Integration with Microsoft Dataverse.

This tool is a prototype and it is the sole responsibility of the user to ensure that the code generated using this tool is correct. The makers of the tool are not responsible for the consequences of executing such code in a production environment. You are welcome to visit the Support page. In case you wish to engage directly with us, please write to [email protected]. As we are a small team, please expect delays in getting back to you.

Features

This extension includes the following VS Code commands that become available on the Visual Studio Code command palette,

bc2dataverse: Generate proxy table generates the proxy table inside Business Central that mirrors the data on the Dataverse.
bc2dataverse: Generate list page generates a list page for the proxy table created above so users can view/ synchronize data for individual entities.
bc2dataverse: Map to existing table generates the AL codeunit that holds the code to map fields and tables between the Business Central data and the Dataverse data.

Start using this tool

Prerequisites

Please be mindful of these before you run this tool,

In order to use this extension, make sure that you are in a valid AL project by following the instructions at Get Started with AL.
Ensure that you have the AL Language extension installed in Visual Studio Code.
Always make sure that you have compiled your AL project before invoking any of the VS Code commands.

Installation

The most updated version of the installable can be found at the https://marketplace.visualstudio.com/items?itemName=TheBc2dataverseteam-MSDenmark.bc2dataverse. Install this extension into your Visual Studio Code environment by following the steps at Browse for extensions.

Contributing

This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.opensource.microsoft.com.

When you submit a pull request, a CLA bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., status check, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

Trademarks

This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies.

Enjoy!

bc2dataverse's People

Contributors

Stargazers

Watchers

Forkers

bertverbeek4ps msteitz-aino benmarriott-tvt shamsheer2008 sergeygolovindev

bc2dataverse's Issues

Error when execute commands

When I try to use the commands “generate page list” or “map to existing table”, the text box to inform the dataverse entity worker closes without giving time to enter a value and gives the following error:

Enter another dataverse URL

Once you have entered an dataverse URL in a project using the command "bc2dataverse: Generate proxy table" and you get the wrong one you cannot switch to another Dataverse URL.
There is no clear function. Even when you remove the extension.

Who can I speak with if the tool can't find an entity that is certainly in the environment provided in the prompts?

it comes up with the error in the attached screenshot

setting the base ID

When generating the proxy table, there is no way to set the base id to be used for the field IDs of the proxy table. They are numbered independently on the ID entered for the new proxy table.

No way to choose language

When I am generating proxy table, the caption and option members are generated in "some" language (in my case Czech). I need possibility to switch to get English captions and members. I didn't found any parameter for this on the tool.

error CDS0001: Error connecting to Dataverse.

Hi,
I am using this tool for few months already, but since last week I am getting this error when I try to generate the proxy table:

[Window Title]
Visual Studio Code

[Content]
Error: Microsoft (R) AL Table Proxy Generator version 11.0.11.39772
Copyright (C) Microsoft Corporation. All rights reserved

Authenticating Dataverse using ServiceUri=https://xxxxx.crm4.dynamics.com
error CDS0001: Error connecting to Dataverse. 
Microsoft.Dynamics.Nav.Xrm.Common.XrmException: Failed to connect to Dataverse

Server stack trace: 


Exception rethrown at [0]: 
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at Microsoft.Dynamics.Nav.Xrm.Common.IXrmService.Connect(String serviceUri, String token)
   at Microsoft.Dynamics.Nav.TableProxyGenerator.XrmMetadataService.CreateXmlMetadataService(String serviceUri, String token) in D:\a\_work\1\s\source\Prod\Microsoft.Dynamics.Nav.TableProxyGenerator\Xrm\XrmMetadataService.cs:line 67
   at Microsoft.Dynamics.Nav.TableProxyGenerator.TableProxyGeneratorTool.CreateXrmMetadataService(IList`1 diagnostics, String token) in D:\a\_work\1\s\source\Prod\Microsoft.Dynamics.Nav.TableProxyGenerator\TableProxyGeneratorTool.cs:line 92
    
Error: Microsoft (R) AL Table Proxy Generator version 11.0.11.39772
Copyright (C) Microsoft Corporation. All rights reserved

Authenticating Dataverse using ServiceUri=https://xxxxx.crm4.dynamics.com
error CDS0001: Error connecting to Dataverse. 
Microsoft.Dynamics.Nav.Xrm.Common.XrmException: Failed to connect to Dataverse

Server stack trace: 


Exception rethrown at [0]: 
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at Microsoft.Dynamics.Nav.Xrm.Common.IXrmService.Connect(String serviceUri, String token)
   at Microsoft.Dynamics.Nav.TableProxyGenerator.XrmMetadataService.CreateXmlMetadataService(String serviceUri, String token) in D:\a\_work\1\s\source\Prod\Microsoft.Dynamics.Nav.TableProxyGenerator\Xrm\XrmMetadataService.cs:line 67
   at Microsoft.Dynamics.Nav.TableProxyGenerator.TableProxyGeneratorTool.CreateXrmMetadataService(IList`1 diagnostics, String token) in D:\a\_work\1\s\source\Prod\Microsoft.Dynamics.Nav.TableProxyGenerator\TableProxyGeneratorTool.cs:line 92
    

    at c:\Users\xxx\.vscode\extensions\thebc2dataverseteam-msdenmark.bc2dataverse-1.0.0\out\helpers\utils.js:160:48
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
    at c:\Users\xxx\.vscode\extensions\thebc2dataverseteam-msdenmark.bc2dataverse-1.0.0\out\proxyGen.js:120:28
    at c:\Users\xxx\.vscode\extensions\thebc2dataverseteam-msdenmark.bc2dataverse-1.0.0\out\helpers\utils.js:138:16

[OK]

We have checked on AAD side that authentication is successful (first I though that problem is on AAD side because conditional access is used on tenant I am working with). I do not know if the problem is in the tool or it is something on Dataverse side (not expert on this).

Could someone:

try that it is working for someone else (problem on my side then...)
Tell me what is needed on DataVerse side to be able to connect (used account was working, no known changes were made by administrators on DataVerse side, account should be admin)
Thanks for helping me in triage...