Important: Did you know: about parameterized conditionals?
The idea of paramaterizing a Data Integration job, is basically that WHERE-conditions are set upon calling a job. So you can have a general job for multiple purposes, by setting the condition variables on the fly. Learn more here: https://doc.dynamic ...
Important: Data Integration jobs work locally / in test, but not live?
At helpdesk we frequently receive cases like: When running Data Integration jobs locally (test, staging) it works well, but when trying to execute on live solution, it fails (not with error, but just doesn't complete). Solution: Make sure that the we ...
NAV integration - Value cannot be null. Parameter name: cipherText
HI, We are trying to setup an integration between DW and NAV, but get this error when we are calling the service: "Value cannot be null. Parameter name: cipherText". We are using DynamicwebConnectorService - 22.214.171.124 and it should be set up ok. includ ...
User Providers does not work with conditionals and Edit Source settings
Hi, I am using user provider as a source provider and XML provider as a destination providerd. So what i was trying to do was, i will send new or updated users to Remote server based on the following conditionals, AccessUserCountry = CountryName Acce ...
User Provider setting "Export Users Created or edited Since last Export"
HI, I am exporting users to our ERP system and one of the requirement is to send only new or updated users. In order to make it happen, i used user provider as a source provider and in there i set a setting "Export Users Created or edited Since last ...
How to Connect to Microsoft Dynamics 365 for Finance and Operations (on-premises) - Solution
Here i am going to explain the simple trick to connected to Microsoft Dynamics 365 for Finance and Operations (on-premises). For this, we need to modify on the Dynamics365Connector.cs in DynamicwebConnectorService here is the current code to get auth ...
Trigger JobFinished notification (ScheduledTaskAddin)
Hi I have made a custom ScheduledTaskAddin and I have a notification subscriber listening on the JobFinished notification. But this notification is not fired when my custom ScheduledTaskAddin has runned (it runs an import activity). Therefore the cod ...
Remove users not in import - but only from the import-to-group
Hi I need to set up an import of users (source=XML provider) to a specific usergroup and have users from that usergroup removed from the usergroup if the users are not in the imported xml file. The users should not be completely deleted if they are m ...
Variants not visible after import until app service is restarted
We're importing variants using the Dynamicwebprovider into the tables EcomProducts, EcomVariantGroupProductRelation, EcomVariantOptionsProductRelation and some other tables. The interesting issue is that when a new product is imported (with 1 variant ...
AX Live Integration framework with 2 different companies
Hi We have a requirement to connect Live integration framework with 2 different companies in the AX. what is the best approach for that? need to get data accordingly and orders also need to go accordingly. As B2C data goes to one company and B2B data ...
Does Dynamicweb Support NAV 2018 / D365 Business Central?
Do you Support NAV 2018 / D365 Business Central? I regularly get asked if Dynamicweb supports the latest version of NAV. In October 2018, the NAV name will go away. Instead Microsoft is moving forward with the name D365 Business Central. Soon the que ...
Export Customer addresses
Hi, I am looking at exporting customer addresses to ERP system and i looked into the documentation and did not find anything related to it. Is there any good way to export customer addresses to an ERP system ? Regards Asim ...
Insert/Update additional user addresses
Hi, We are getting additional user addresses from ERP and depeding upon the XML received we want to update the exisitng addresses or inser new ones if they are not available against a user who is already available. I have tried XML provider as a sour ...
Conditionals not working while exporting AccessUserAddress
HI, I have a strange issue regarding conditionals when i am exporting data from table "AccessUserAddress". Currently, this is what i am filtering on "AccessUserAddressAdress <> @NULLOREMPTY". It filter out the null rows but it does not filter o ...
creation integration activity went into endless repeated steps
https://www.useloom.com/share/54d6c993de1b44b086b0883972ae83ac Dear Sir This happen very often intermittently refer to the attached video. May I know what could went wrong that at time I do not face the problem and at time I face the problem. Attache ...
Tan Pang Lin
Hi, I try to check the documentation on how to install the code unit on NAV side as well as install DynamicWebConnectorService and DynamicWebServiceTestApp. The code unit successfully installed on NAV but when I try to connect the DW to the web servi ...
Order Details in IntegrationCustomerCenter
Hi guys, We are using Integration Customer Center in one of our projects. I was wondering if there is any way to display the content of an order instead of loading the PDF from NAV. I understand this is a live call, but I am not sure if this is suppo ...
SQL Provider - Remove missing rows after import
Hi When using the SQL Provider as destination the setting "Remove missing rows after import" gets reset if you do this: set the setting "Remove missing rows after import" in the destination settings save and close the activity task edit the activity ...