Configure the NAV web service Tutorial
00:00:00 In this video, I’ll show you how to configure the OData web service, so that the Converter and the Designer can get information about your fields inside your NAV database.
00:00:21 So, the first step is to open the NAV client and go to the web services.
00:00:31 And then you create a new web service for page 7702, this is a standard page that is in all your NAV installations by default. We name the web service “fields” and then we publish the OData web service.
00:01:03 So, if we move away from this and then back, you can see the OData URLs are published and I want to copy the OData URL, not the OData version4, but the OData URL here. Copy the cell.
00:01:20 Now I can use this with the Converter, let’s see how that works. In the Converter, you can paste this information into the Table definition field, then you can click Test, to see if it works.
00:01:37 Now we will un-tag the web service, and we can see that it works. You can also go to the Designer, and into Settings, and enter the information about the field service and test it from here as well.
00:01:53 And everything works. So now the Designer and the Converter know how to get information about fields inside NAV.
00:02:03 If the OData doesn’t work, for some reason - there can be firewalls or other types of security that block access to OData - then you can also export your tables to a text file. I’ll show you how.
00:02:19 These are the tables. I select all the tables and then click File, Export, and put the file on the desktop. Name it “All tables”, and select text format, and then hit Save.
00:02:40 The benefit of using the OData web service instead of the table definition file here, is that the OData web service changes dynamically when you update information inside NAV. If you change table definitions or the field definition, then the OData will react, whereas if you use a static file like the file we are exporting right now, then you’ll have to create a new file every time you change information inside NAV.
00:03:12 So that’s it, now I have a file here called All tables, and I can also use that from in here. Let’s try to delete that and browse to the All tables.
00:03:28 There it is, and I can test it. And it can also see field information in that. This is considered a back-up strategy for when the OData doesn’t work. That’s it!