Developer forum

Forum » Integration » Updating customer data from NAV without retrieving the whole list each time

Updating customer data from NAV without retrieving the whole list each time

E-mail notifications
Jon Thorne
Jon Thorne
Reply
Posted on 14/03/2022 22:42:45

Hi,

In the ConnectorTestTool the example xml for "Get Customers Advanced" is:

<GetEcomData Qty="10" ReimportTable="true" SetCheckpointToNow="false" CustomModifier="Test"><tables><Customers type="all" /></tables></GetEcomData>

When testing this with the latest NAV connector it seems the options "Qty", "ReimportTable" and "SetCheckpointToNow" are not configured. The NAV database has a large number of customers. It is not really feasable to download the whole list everytime to check for any updates. Is there another way I should be doing this? Or do I have to customise the NAV code unit myself to implement something to make this work?

Regards,

Jon.


Replies

 
Jon Thorne
Jon Thorne
Posted on 17/03/2022 13:21:53
Reply

Hi, can anyone comment on this?

With the standard NAV integration, is it possible to filter for Customers like you can with products, or this needs to be customised to make it work?

Any example xml of ways to manage the integration with Customers would be appreciated.

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 17/03/2022 13:29:54
Reply

Hi Jon,
there was a paging implemented for getting all the customers/contacts implemented in the BC applications (latest version)
but this is not implemented for the NAV.
It is implemented in the same way as for the products.
Maybe you can upgrade to BC14 or BC18-19 and use a new app?
If upgrade is not a solution for you I can send you the codeunit for BC that does the paging for the customers/contacts so you can then
use it in your NAV codeunit.
BR, Dmitrij

 
Jon Thorne
Jon Thorne
Posted on 17/03/2022 13:45:43
Reply

Hi Dmitrij,

Thanks for the quick response. That makes sense of the sample xml, but update to BC from NAV is not an option. So I will have to try and implement something in the NAV codeunit. If you are able to send me the code for the BC codeunit that would helpful, but I assume that it would be a bit different from the NAV code?

Regards, Jon.

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 17/03/2022 13:49:33
Reply

Hi Jon,
it is in AL language and is very similar to NAV C/AL and is even much more simpler and easier to read :)
just send me the message to dbe@dynamicweb-cms.com so I can share this code to you.
BR, Dmitrij

 

You must be logged in to post in the forum