Developer forum

Forum » Integration » Importing Sales Orders from Business Central Online - IF V2

Importing Sales Orders from Business Central Online - IF V2

Niklas Malmqvist
Niklas Malmqvist
Reply

Hello!

We have set up a connector between an instance of  Dynamicweb 9.10.0 and an instance of Business Central online. We are able to query data via the DynamicwebConnectorTestTool, such as Products and Customers. However, when we try to fetch order, the result is empty.

The test tool can generate a query for importing orders (which yields an empty result), but in the documentation there is no example request for importing orders: https://doc.dynamicweb.com/documentation-9/integration/integration-framework-2/requests-responses#sideNavTitle1-2

The request I'm sending ("Orders Simple" from the test tool):

<GetEcomData Qty="10"><tables><SalesHeaders type="all" /></tables></GetEcomData>

The response I'm getting:

<?xml version="1.0" encoding="utf-16"?>
<tables version="1.2.0.11_NAV18.0.22893.24643" />

 

Any advice on how to make it work?

 

Kind regards,
Niklas


Replies

 
Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Niklas,
there is no such request implemented to get all SalesHeaders. But probably you can look on the Integration customer center requests:
there are requests to get the Sales Headers (type OpenOrder):
<GetList type="OpenOrder" customerID="20000" requestAmount="10" firstItem="1" />
https://doc.dynamicweb.com/documentation-9/integration/integration-framework-2/requests-responses#sideNavTitle1-3-2
and also you can get some more details on each specific order by calling the request like:
<GetItem type="OpenOrder" customerID="20000" documentNO="103002" />

If none of that helps then you could probably look on our extensibility points(events) available for subscribing to from our Dynamicweb Plugin-Unit
BC extension and implement your custom request handling, that will require some BC development and your custom application publishing.

Kind regards, Dmitrij

 

You must be logged in to post in the forum