Become a Business Central API Superhero

[@beleventh3998]

Just what I was looking for :).. Thank you so much for making this video!

[@bhmtraders3457]

Possible to return response value or api page with data while we call bound actions

[@KephaMurage]

This is very insightful, thank you.

[@edyzere]

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?

[@dennisfredborg]

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

[@edyzere]

@@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.

[@edyzere]

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.

[@dennisfredborg]

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 🙂