Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Eric Parrott]

Hello,

I am trying to create a web app with functionality that mirrors a NAV list page, and displays the same information.  I was able to build a Windows Form Application in Visual Studio that worked a desired after publishing the NAV page as a web service.  However, with the Windows Form app, I was able to leverage the Web Reference property and use the Form_OnLoad function.  All I really had to do was create the service and call the following in the Form.OnLoad function:

SomeListWS_Service svc = new SomeListWS_Service {UseDefaultCredentials = true };
dataGridView1.DataSource = svc.ReadMultiple(new SomeListWS_Filter[] { }, null, 0);

and the GridView on the Windows Form populated with the same record set (same list) as the role-tailored NAV page.  Does anyone know the best way to connect to and populate a GridView control this same way but on an asp/html based page?  Any input would be greatly appreciated.

Thanks!
 

——————————
Eric Parrott
Red River Computer Company
Claremont NH
——————————

[Geovanny Fuentes]

Can you elaborate further what this is intended for?

A new app?

Web app?

Trying to save on a license?

Remember triggers may not execute correctly, including locks and triggers may cause issues. 

Just FYI>

——————————
Geovanny Fuentes
San Diego CA
——————————
——————————————-

[Eric Parrott]

Hi Geovanny,
This would be for a web application.  The goal would be that users ultimately can view the given list via an html page, select individual records to view them in a Card-like html page, and make modifications to those records as necessary.  I’m not too worried about dysfunctional trigger code at this point.  I haven’t been able to find very much helpful material (books or otherwise) that do an adequate job explaining how to get started tackling this type of project.

——————————
Eric Parrott
Red River Computer Company
Claremont NH
——————————
——————————————-

[Joe Shields]

Here is a link to making a basic c# console app to add and modify customers in NAV with odata. I think you could use this as a starting point for how to have your app interact with NAV.

https://msdn.microsoft.com/en-us/library/hh166960(v=nav.90).aspx

——————————
Joe Shields
Advanced Media Technologies
——————————
——————————————-

[Geovanny Fuentes]

Joe, remember a few things:

1. Is there a direct connection to a NAV web service you created on your side to handle the connection? And will there be a Web service on the internet side communication with NAV webservice?

2. Will there be a temp storage location on the website that will display data as needed for viewing/updating that NAV provides information on?
3. Did you proper setup a firewall port access to allow these types of connection?

Eric provided a nice link Microsoft has please use it. 

I made suggest viewing some helpful youtube video’s people may have.

Good luck.

How Do I Use OData Web Services to Modify Data in Microsoft Dynamics NAV 2013 R2

YouTube		remove preview
How Do I Use OData Web Services to Modify Data in Microsoft Dynamics NAV 2013 R2 Web: http://www.epcgroup.net | E-mail: contact@epcgroup.net | Phone: (888) 381-9725 * SharePoint Server 2013, Office 365, Windows Azure, Amazon Web Services (AWS), SharePoint Server 2010 & SharePoint 2007: Review, Architecture Development, Planning, Configuration & Implementations, Upgrades, Global Initiatives, Training, and Post Go-live Support with Extensive Knowledge Transfer | Custom Branding and View this on YouTube >

——————————
Geovanny Fuentes
San Diego CA
——————————
——————————————-