Interaction between two databases.

smartkoshak · 2019-07-28

Hi there! I'm new to NAV and hope to get some piece of advice from you. My issue is the following.
I need to implement interaction between two NAVs.
Let's say we have DataBase1 (DB1) and DataBase2 (DB2).
At DB2 I have a SOAP web-service based on a codeunit.
I send HTTP POST request from DB1 which contains Sales Order Header and Sales Order Lines data as a Json.
I need to get this data at DB2 and handle it (create the corresponding records).
How can I do that?

Wisa123 · 2019-07-29

Hi,

First up, you'll need knowledge about the System and the AL language to implement this kind of behaviour.
If you are new to NAV/BC this will get you started:
https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-dev-overview

You will most likely want to use a REST (OData) Service to create the functionality you described. Assuming you know the basics of Webservices, the following link should guide you in the right direction:
https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/web-services

The newer releases of the AL language have decent features to handle communication via HTTP in order to call your Service. If you want to solve the issue using the "old" language C/AL, you'll have to perform a few more steps, so I recommend creating an AL extension.

/Wisa

KTA8 · 2019-07-29

Which NAV version?

smartkoshak · 2019-07-29

KTA8 wrote: »

Which NAV version?

Microsoft Dynamics 365 Business Central
Version W1 14.1

aacnsilva · 2019-07-29

I don't think you can handle JSON with a SOAP web service. SOAP web services only use XML to transfer data. (https://www.w3schools.com/xml/xml_soap.asp)
If you want to use JSON you'll have to check the ODATA web services and the new API system included in BC.
Check if this article helps: https://andreilungu.com/use-rest-web-service-import-to-business-central/

Wisa123 · 2019-07-29

Hi,

First up, you'll need knowledge about the System and the AL language to implement this kind of behaviour.
If you are new to NAV/BC this will get you started:
https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-dev-overview

You will most likely want to use a REST (OData) Service to create the functionality you described. Assuming you know the basics of Webservices, the following link should guide you in the right direction:
https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/web-services

The newer releases of the AL language have decent features to handle communication via HTTP in order to call your Service. If you want to solve the issue using the "old" language C/AL, you'll have to perform a few more steps, so I recommend creating an AL extension.

/Wisa

smartkoshak · 2019-07-31

Thank you for all the replies! The task has been done.

kriki · 2019-08-15

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

Interaction between two databases.

Best Answer

Answers

Categories