Need to connect to Nav 5.0 - is there a good API / Connector

rich_smith

Hi,

I want to connect to NAV 5.0 via an API or a connector. Ideally I'd be using a C# client, or JSON REST API. I need to create and edit products, prices and sales orders. Does such a product exist? Has anyone written a c# client?

Thanks!

vaprog

Hi,

Your request is too wage. Do you need to read or write? From within your local network (secure environment) or from outside). Do you need any busines logic from NAV or just data? How many connections do you need to support, What's the expected transfer volume?

Some of your Options:

• direct access to SQL Server
• ODBC
• C/FRONT
• NAS using ComCom
• NAS using some other kind of automation
• 3rd party components

jglathe

Hi rich_smith,

depends a little on your runtime version and if you're on SQL. If it's NAV2009SP1 or NAV2009R2 technical on SQL, but NAV5.0 business logic (pretty common these days), then you could use web services... there are some limitations regarding authentification (AD only, lots of blogs out there that show the pitfalls), but connecting from C# and Java works fine. If you have a NAV5.0 runtime, then you only have older possibilities, like vaprog wrote.

wth best regards

Jens

rich_smith

Hi vaprog / jglathe,

Thanks for the swift responses!

I need to read and write from a secure environment. Ideally with business logic, or else I can just connect to DB directly. Its not heavy usage, just max 3 connections. I've worked directly with NAV SQL server database via .Net before, but I was wondering if someone had wrapped this in an API to avoid me having to think through business rules etc.

I'm using Nav 5.0 runtime on SQL.

I guess I'll just try ADO or the like.

Richard.