Getting data from navision

Hi, Hussein_charif 

If you have access to SQL Server where the Navision database is located, you can run direct SQL queries to extract data. This requires an understanding of the structure of the database and the SQL language.

You can also write custom C/AL (for older versions of Navision) or AL (for newer Dynamics 365 Business Central) code to export the data. These codes can be used to create reports or export data to a file. You can check the following link:

How to Process URL Without Opening a Web Browser in C/AL - NAVUSER

Although you mentioned not using OData, you can still use SOAP web services, which is another type of web service available in Navision. These services can be configured and used without the need for OData URLs.

For more information on extracting data, you can check out the link below:

Importing and Exporting Data in Microsoft Dynamics NAV 2013 R2 CU 8 - Microsoft Dynamics 365 Blog

Extracting data - Microsoft Dynamics NAV [Book]

Export-NAVData (Microsoft.BusinessCentral.Management) - Dynamics NAV | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.