Walkthrough: Inserting Data from XML Documents to Multiple tables (Dynamics NAV)

13. September 2017 Tabrez Ajaz Comments (0)

Web services allow easy communication and data exchange in a secured environment. In Microsoft Dynamics NAV 2013, we can create, publish, and consume Web services. Once published you can also use and Add as web reference in Visual Studio 2012 and insert data into NAV table from Visual studio through web services.

About this Walkthrough:

This walkthrough will let you know the followings:

  • Create tables in NAV. 
  • Create XMLPort in NAV.Import data from XML file into NAV XMLPort.
  • Create Webservices.
  • Use of Webservices in Visual Studio to insert data into NAV tables.

Create tables in NAV

For this example I'll use 3 tables:

ID         Name 
50003   T_Department 
50004   T_Employee 
50005   T_EmpInfo 

 

1. T_Department Table Schema:

2. T_Employee Table Schema:

3. T_EmpInfo Table Schema:

 

Create XMLPort in NAV

For this example I'll use 2 XML Ports.

ID           Name 
50060    Test_XMLEmployeeInfo
50062    XMLPort_Department



1. Test_XMLEmployeeInfo Schema: Keep in mind of tables, its attributes indentation         & Data Source.

2. XMLPort_Department Schema: Keep in mind of tables, its attributes indentation            & Data Source.

 

Import data from XML file into NAV XMLPort

1. Create XML as shown in below example as save at some location in your computer.

2. Now go to NAV development environment. Select Codeunit and click on button New. 

In this example i have created few Codeunits to import XML Data into XMLPort. Let's see how it looks

Declare Variables in C/AL Globals:


Code to be written OnRun() trigger.

 

Save it and Then Press CTRL+R (TO RUN).

Run Table T_Employee and T_EmpInfo to cross check the inserted values 
Output screen will look something like this.

In the above Walkthourgh we have gone through tables, xmlport and import process.

***END*** 
Thanks for your Patience

Now in this Walkthrough we will learn how to consume the webservice. Let's start

1. First create Codeunit that will be used as a web service. In below screenshot i have created one. To create new one click obn button New.

ID         Name
50063  InsertIntoEmpTable

 

2. Now to go Menu-View-C/Al Globals-Function tab and give function name. In the below screenshot i have added some function names.

 

3. In the above screenshot there is button the right side of screen(Locals). Click on this button.

4. In the Parameter tab enter paramater name as shown below. 

 

5. Now click on Variable tab and assign Local variables.

 

6. Save the Codeunit now.

7. Now open in design mode and go to function name. Write some lines of code as            shown below.

8. Now open NAV RTC (Role Tailored Client)

From the Search bar at the top right type Web service. Click on Web Service option, it will open up below screen. 

9. Click on button New to create new Web service. In below screen i have added one.

 10. Click on button New will open up below screen. Now here you need to select and         enter other details in the column such as 
              - Object type (select codeunit).
              - Object Id (select object id of above codeunit).
              - Enter service name.
              - Check Publish checkbox.
              - Copy the SOAP URL. In order to run click on web icon available in SOAP URL                   column.

              

11. Run the web service by clicking on web icon. Copy the URL.

 

12. Now launch Visual Studio (I am running VS 2013)
13. Go to File-Click on New Project.
14. From List of application types click on Visual C# and choose Windows Form. Also          give name and save file at some path of your computer.

15. Now in below Walkthrough we will learn to design windows form, place some              controls, add web reference and will write some lines of codes to consume web            services. 

  • First we will add web reference. To add web reference. 
  • Right click on Reference and click on Add Service reference. 
  • In the below screen i have added one "Rich textbox" and one Button from toolbox.

  • In Add service reference windows copy and paste the web service URL (copy              from Step 11) and click on button Advanced.

  • Now click on button Add Web reference.

  • Now copy paste Web service URL as shown below. Keep in mind the following at this step.
    • In the URL you need to mention either localhost (if you are working on your local   machine) OR.
    • If you are on remote desktop then enter computer IP. In the below i have mentioned IP address before colon.
    • Click on right arrow button just adjacent to URL in order to execute it.

  • Once run the window will look something like this. give web reference name and click on button Add reference.

  • Added web reference will start appearing in Visual Studio solution explorer panel. I have saved as name WebReference.

 

16. Now go to .CS file and write following line of code. Don't forget to add namespace
using System.Net;
using CreateEmployeeEntry_XMLPORT.WebReferencename;

 

17. Now run the code. You will get a window where you need to enter your XML and click on Save Employee Details button.

Tags:

Add comment