Importing Sales Orders from Business Central Online

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

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

Developer forum

Importing Sales Orders from Business Central Online - IF V2

Replies