Share
Report
39Hi, I'm trying to connect the Dynamics NAV OData V4 API to Power Apps. I'm using the Microsoft Dynamics NAV client connected to Dynamics 365 Business Central, and since we have a server room, I assume it's an on-premises.
1. When adding data, I see three options: Dynamics 365 Business Central, Dynamics 365 Business Central (on-premises), and Dynamics NAV. Which one should I select given my system?
2. Does the environment affect OData connection? In the developer environment, when I try to add OData v4 Data Sources, there's no URL input field. Even when I click "Edit Data," I only see options for "New Row" and "New Column." I even upgraded to the premium version thinking it was a limitation of the free version, but it's still not working.
3. I tried switching environments, but I got an error saying the production/sandbox environment has a 1GB database limit. My database is empty, so it shouldn’t be full, but I can't check because I'm not the Dynamics 365 admin. What's the typical database capacity?
4. When connecting to Dynamics NAV in the trial environment, should I use the full OData URL (e.g. http://<company-server-url>:<port-number>/<instance-number>/ODataV4/Company('YB%20Copy%2037%2010-04-24')/Activity_Sheets) or just the base URL (http://<company-server-url>:<port-number>/<instance-number>/ODataV4)? Even though I copied the URL from the Web Services page, I still get this error: "The URL is not a valid Microsoft Dynamics NAV OData feed URL. The OData feed URL can be found on the 'Web Services' page in Microsoft Dynamics NAV."
5. Where can I check the correct username and company name? My user card shows companyName\myName, but when logging in, I use just my name. Do I need to use the full format for the connection? Also, is it case-sensitive?
6. I'm following the methods outlined on the website below. However, how do I access the NAVUP?
https://www.fajdiga.info/blog/2018/03/27/connect-dynamics-nav-and-microsoft-powerapps/
All responses (
Answers (
