- Видео 33
- Просмотров 63 394
Dennis Fredborg
Добавлен 3 окт 2010
External Business Events in Business Central
Git hub: github.com/dfredborg/BcBusinessEvents
Blog post: fredborg.org/?p=1393
Getting started with External Business Events in Business Central
Blog post: fredborg.org/?p=1393
Getting started with External Business Events in Business Central
Просмотров: 157
Видео
Automating Client Secret Renewal with Azure Logic Apps and Azure Key Vault
Просмотров 1,1 тыс.7 месяцев назад
Automating client secret renewal using Azure Logic Apps and Azure Key Vault. Ensure seamless connectivity and enhanced security for your Business Central applications with a step-by-step guide. Learn how to set up app registration, configure API permissions, manage secrets in Azure Key Vault, and create a workflow to automate secret renewals. #Azure #LogicApps #KeyVault #Automation #BusinessCen...
Model Driven App Using Business Central and Virtual Tables
Просмотров 5407 месяцев назад
In this video, we'll explore how to create a Model-Driven app using Microsoft Dynamics 365 Business Central and Dataverse. We will walk through the process of setting up virtual tables, customizing views and forms, and integrating data from a custom module in Business Central. By the end, you'll have a functional app showcasing superheroes, their powers, and related data, demonstrating the seam...
Enhancing Business Central with PowerApps
Просмотров 3028 месяцев назад
Unlock the power of Microsoft Dynamics 365 Business Central with PowerApps! This guide covers everything from choosing the right type of app-Canvas, Model-Driven, or Portal-to seamlessly integrating with Dataverse. Enhance your Business Central experience with tailored apps that boost productivity and streamline operations. Perfect for beginners and seasoned developers alike, discover how to ex...
webhooks in business central
Просмотров 1,6 тыс.11 месяцев назад
In this video we will cover the topic of Webhooks in Business central Azure function code on github: github.com/dfredborg/WebHooks URLS: Get list of APIs: GET : api.businesscentral.dynamics.com/v2.0/{{TeantID}}/{{EnviromentName}}/api/microsoft/runtime/beta/companies({{CompanyID}})/webhookSupportedResources Subscriptions: GET: api.businesscentral.dynamics.com/v2.0/{{TeantID}}/{{EnviromentName}}/...
The Netflix Effect: How a Market Disruptor Could Change the Business Central Consulting Landscape
Просмотров 144Год назад
In this video, we will take a look at what might be coming in the future. Link to the blog post: fredborg.org/?p=843 Link to centralQ : www.centralq.ai/ #msdyn365bc
Become a Business Central API Superhero part 2
Просмотров 677Год назад
This is a short follow-up to my previous video Business Central API Superhero Link to blog post: fredborg.org/?p=834 Link to book Microsoft Dynamics 365 Business Central API v2.0 Reference: sparebrained.com/books/business-central-api-reference/ #msdyn365bc
Become a Business Central API Superhero
Просмотров 4,2 тыс.Год назад
If you want to become a BC API Superhero well this is for you. #msdyn365bc blog post: fredborg.org/?p=769
Simple Unit Test in AL (Business Central)
Просмотров 2,3 тыс.Год назад
In this video, I will run through a simple unit test in AL #msdyn365bc Source Code: dfredborg.visualstudio.com/Business Central/_git/UnitTestShort?path=/Test/Cod60100.TestMyJsonManagment.al
AL Developers we need to do better - Testing
Просмотров 297Год назад
The final video in the AL Developers we need to do better, and in this video we are going to talk about testing. Blog post: fredborg.org/?p=719 Automated Testing in Microsoft Dynamics 365 Business Central by Luc van Vugt : subscription.packtpub.com/search?query=automated testing microsoft dynamics 365 business central
AL Dev we need to do better - Part 2 Workflows
Просмотров 176Год назад
In this video, we are going to look at some of the workflows that we should adopt as AL developers. Link to the blog post: fredborg.org/?p=703 Link to Al Guidelines: alguidelines.dev/ Erik Hougaard youtube: ruclips.net/user/ErikHougaard
AL Developers we need to do better - Part 1
Просмотров 4002 года назад
This is the first video in a series about what skills and mindsets we need to adopt as AL developers. You can find the companion blog post here: fredborg.org/?p=694
Becoming a programmer : PowerShot
Просмотров 1482 года назад
If you ever wanted to become a programmer but you did not know where to start, then this video will help you on your way. We will cover 0:00 - Intro 0:41 - Datatypes 08:53 - Collections 18:53 - Loops 26:12 - How to Structure your code 50:24 - Think like a programmer Please also check out my blog post here: fredborg.org/?p=617 PowerShot The role of a solution, enterprise, or an IT architect in a...
Simple AL Report from Scratch in Business Central
Просмотров 6 тыс.3 года назад
Let us create a simple AL report from scratch in Business Central
RDLC Layouts for Business Central Business Consultants
Просмотров 6 тыс.3 года назад
In this Video we will take a look at how you can make simple changes to your report layouts in Business Central, without having to change your Extensions. Twitter: DennisFredborg Blog: fredborg.org Linkeind: www.linkedin.com/in/dfredborg/
Xliff Translation tool for Business Central
Просмотров 4,3 тыс.4 года назад
Xliff Translation tool for Business Central
Create you own Visual Studio Code Snippet
Просмотров 1464 года назад
Create you own Visual Studio Code Snippet
Azure DevOps as a Ticket System for Business Central
Просмотров 16 тыс.4 года назад
Azure DevOps as a Ticket System for Business Central
Thursdag nugget: Upgrade paths to Business Central
Просмотров 2754 года назад
Thursdag nugget: Upgrade paths to Business Central
Thursday nugget - Interfaces in Business Central
Просмотров 3804 года назад
Thursday nugget - Interfaces in Business Central
Thursday nugget - Enums in Business Central
Просмотров 1744 года назад
Thursday nugget - Enums in Business Central
Thursday nugget - Performance Testing in Business Central
Просмотров 2354 года назад
Thursday nugget - Performance Testing in Business Central
Background Sessions in Business Central
Просмотров 2354 года назад
Background Sessions in Business Central
Page Background Tasks in Business Central
Просмотров 5874 года назад
Page Background Tasks in Business Central
Connect Visual Studio Code to business central
Просмотров 14 тыс.5 лет назад
Connect Visual Studio Code to business central
Thanks for the great video and blog! I will give it a try.
Could you please make some videos of customize the reports in real practice?
Great and useful. Do you know how to sign an XML with a certificate in AL? I'm struggling with it and a little of help would be welcome. Thank you ever so much
Hi, no sorry that is not something that I have done before, but my first thought would be to use an azure function, but like I said it is not something I have tried to do 😊
It helps me a lot. Thank Dennis.
Hello is it possible for regular Microsoft 365 E3 licensed users without business central to access data through virtual tables and create update delete records ? I need to make a travel order process in powerapps. This is an already existing process in BC but not all the employees in the company have access to business central so it would be nice to make a powerapp with virtual tables so everything made in the app can be synced into BC.
Hi, since dataverse uses an app registration behind the scenes to connect to businesses central, I do not think that the user needs access to businesses central directly, however this is only an assumption and not something I have tried myself.
@@dennisfredborg I've tried it with a test account with the license I mentioned an also set it to to system administrator in power platform admin center, but when I click on a available business central tables it won't load and also if I open an app with some data nothing shows up idk what is the problem but probably a license issue called multiplexing :/
Hi Dennis, i just create custom API with Custom table (source table), when i test get method in postman response value[] which mean success, and when i update table via page list UI, i test get using postman response Internal_ServerError, Sorry, the current permissions prevented the action. (TableData xx) ,when i test other entity response is success 200 eg: (env)/api/v2.0/companies(id)/salesInvoices is success.
@yayakdrake hi, did you remember to assign permissions in business central to you Entra application for any specific tables you need to access?
@@dennisfredborg thanks dennis, you save my 2 days,,, you're right, in permission i set to specific table/package, thanks btw
Hello your videos helped me a lot :), you showed me exactly what I needed from BC. Keep up the good work:)
At the "For each" step, what did you configure as Output in parameters?
In my blog post, you should be able to see all the source code fredborg.org/?p=1352
Possible to return response value or api page with data while we call bound actions
is there a way to consume webhooks from an external solution in business central?
@Diya-d3c well it depends on the external system, because you should be able to create a codeunit, that you could expose as the notification url, however it will require that the other system can use oauth as part of their notification... to be honest I would not let Business Central be a direct subscriber to an other system webhooks, it would much easier and cleaner to have an azure function as a broker. And then let the azure function subscribe to the external system, and then when triggered retrieve the data, and push it to Business Central
Cool, I just use the keys and do not manage them. Do you know if it is possible to use Azure Key Vault in Postman for test API calls to Business Central Online?
To be honest I have not tried this but it should be possible learning.postman.com/docs/sending-requests/postman-vault/azure-key-vault/
Hi Dennis! We are unable to connect from BC Cloud to VS Code, we are setting all the paramters ok. Should we check on any permissions or Licences that we should have on BC? Thanks!
Hi, as fare as I know then your user must have super permissions in the environment, but it should tell you in the vs code terminal if you have a permissions problem
I was told that webhooks have limited support. Has this changed in 2024?
It depends on what you mean by limited? After my experience they can do what you would expect from webhooks
I'm not able to add it to the latest chrome browser.. can you plz guide on it ?
Hi, to be honest I haven't used it in a long time, but I think a good starting point could be this page marketplace.visualstudio.com/items?itemName=ms.vss-exploratorytesting-web#supportedbrowsers it shows Microsofts official documentation. I hope I helps 🙂
Great. this is really helpful. But I can not test the Azure function. is there any other way to test it?
Well you can pretty much use any http enabled endpoint, like logic apps, power apps or Web apps, the only requirement is that it can receive and send http requests and responds.
Very constructive thanks for the video.
Thanks for sharing. Helpful content!
Hvordan ville du lave en side på bc hvor man kan poste noget til et andet api, fx hvis man vil kunne oprette zendesk tickets fra bc, via en side på bc som man poster til zendesk api?
Hej, altså tænker du at du vil kalde en API page i BC, som så skal kalde en API hos zendesk? Fordi skal ville jeg nok lave en unbound action hvor du udstiller en function fra en codeunit, eller lave det på insert triggeren på en API page.
Thank you so much, was so stuck with an RDLC remittance advice and was able to fix it!
Thank you very much !!!
Dear Dennis, First of all thank you for uploading this extremely helpful video on creating a Business Central API. I have now successfully been able to develop a custom API page on the Sandbox, but I am struggling to publish it to the Cloud Instance of our Customer. Would you by any chance have more information on how to do this and whether there are some prerequisites required?
Hello again. I am considering buying your book, I just need to know if it will serve me for what I need. The company for which I am developing manually captures the price of EUR and USD, what I need is to create an EndPoint (I imagine it must be with AL) to be able to consult the last value or price captured. Within Dynamics 365 Business center in the inspection I see that these values are saved in a table called "Currency Exchange Rate (330)" and the page "Currency Exchange Rates (483, List)". Does your book help me to know how? Can you help me? Thank you so much.
Hi, the easiest way to achieve this without having to code any AL, is to go to webservices in Business Central and expose page 483, then copy the link from the OData v4 URL, fredborg.org/wp-content/uploads/2023/07/vmconnect_InC3WkSxRO.png and use OData filter learn.microsoft.com/en-us/dynamics-nav/using-filter-expressions-in-odata-uris to filter for the record that you need 🙂
Thank you very much for your video, although it helped me I don't quite understand what you did in VS Code with the AL language. You mentioned that there are other places to better learn about the Dynamics APIs. Where do you recommend I start? I already managed to get the APIs working in postman without the AL part, and it's driving me crazy that it doesn't return a table called "Currency Exchange Rate". I need to be able to consult with an EndPoint the last recorded price of the currencies, I think I'm close. Can you help me?
Hi a good resource is this book www.kauffmann.nl/2023/01/31/microsoft-dynamics-365-business-central-api-v2-0-reference/ to be able to help you I need a little bit more information 🙂 Did you create a new API page called "Currency Exchange Rate" that you wish to access through the API, but you cannot find it? or you can find it but it does not return any data? also, remember that I have a blog post for this video here fredborg.org/?p=769 which might help you with the AL code there is also a part 2 here fredborg.org/?p=834
@@dennisfredborg Thank you very much for taking the time to respond. After doing some research I think what I did was enable the standard APIs in Azure, I really need help man, let's just say I'm a bit green with Dynamics. Can you give me a consultancy? What I need is that when some conditions occur (such as the introduction of values in some fields in certain tables) an endpoint that I built is hit. Now you tell me how you handle that of the consultancies. It would really help me. Thanks in advance for being able to help me.
hi i am unable to connect BC with VSC
Hi, what does your Launch Json look like? it should look something like this: { "version": "0.2.0", "configurations": [ { "name": "Microsoft cloud sandbox", "request": "launch", "type": "al", "environmentType": "Sandbox", "environmentName": "NAME_OF_ENVIROMENT", "breakOnError": "All", "launchBrowser": true, "enableLongRunningSqlStatements": true, "enableSqlInformationDebugger": true, "tenant": "TEANTID" } ] } Or like so for Docker: { "version": "0.2.0", "configurations": [ { "type": "al", "request": "launch", "name": "Docker", "server": "CONTAINER_NAME/", "serverInstance": "BC", "environmentType": "OnPrem", "tenant": "default", "port": 7049, "authentication": "UserPassword", "breakOnError": true, "schemaUpdateMode": "Synchronize", "launchBrowser": true, "enableLongRunningSqlStatements": true, "enableSqlInformationDebugger": true } ] }
Just what I was looking for :).. Thank you so much for making this video!
This is very insightful, thank you.
Excellent video, thank you very much for sharing <3
Hi dennis, please let me know how to setup the report builder application for business central 365
Hi Dennis, can you share the report builder configuration setup for business central 365.
Hello Dennis, thank you for your video, it is very useful, although I tried to do ir exactly like that and the lines with item information for the invoice are not shown on the report!!! Do you know why that happens?
we can't read anything
Great!!! Could you please make a video on column grouping.
Interesting ¡¡¡¡ excelent :0
Hello, where can i find the Base Application.xlf file? Is there a folder that contains all translation that microsoft hold? I have an another question. Is it possible too switch the target with the source? example: source: Phone, target: Telefon and now i want to switch the expression in the notepad like: source: Telefon, target: Phone and then using the importtoxliff function. I am not into javascrip, so if it possible how would it look like in the powershell command?
Great Dennis. Very useful. But, what about Enums?. Does it work with enums?, because I can't manage to translate enums properly for SaaS environment. Thank you ever so much
good morning, excuse me, a question the file "Base Application.da-DK.xlf" would be the same as the file "ALProject1.da-DK.xlf" "greetings
Hi, no the base application.dk-DK.xlf is the file that holds Microsoft base application xliff translations, and the alproject xliff file is the xliff file which is generated in your extension. So put in another way, base application xliff is your source and alproject xliff is your target.
@@dennisfredborg thanks very much buddy
Good day Mate, Thanks for the video. I am trying to create a flow with outlook and devops such that if I get a support request email with attachments it should send that to my support team with the attachments but the problem I am facing is the support email is not receiving the attachments. For some reason those attachments getting corrupted. Any advice on that?
Hi Dennis, do i understand this correctly there is no code written inside the function that are in the interface? So you just implement it in the CU and call the function. Can you change the parameters of the function inside the CU? And why would we use an interface in the first place instead just write the logic in the CU?
Hi, The idea behind an interface vs a codeunit is that an Interface it a strong contract, which means that if you wish to extend some code though an interface you must implement all the functions, this helps to avoid writing code that will break because it expects a function that is not there. So the idea is that if you create an interface I can then implement this interface knowing that whom ever might change code in your underlying functions, my code will still work because I have subscribed to your interface and not the underlying code. A good example of this is in the base app if you look at the Price Calculation, because it is written based on an interface you can safely change between the different implementations, because there is a strong contract, so I would know that everything is handled in one way or another. I know that the concept of interface can seem very abstract, but if you are interested you should try to look at how interfaces work in C# since there is much more documentation, and the concept is the same for AL.
nice , simple but very helpful demonstration
Super video
Nice simple explanation.