Developer forum

Forum » Integration
Subject
Replies
Started by
Last reply
Change in date handling in OData provider
Hi there, Previously, when I imported datetime minvalue from BC (0001/1/1) into DynamicWeb it would end up as 0001/1/1 in the database also (I am using datetime2 as the column type which should support this). After upgrading to Dynamicweb 9.16.4, the ...
Imar Spaanjaars
06/12/2023 13:27:03
Last post: 03/01/2024 09:39:28
Dynamicweb.DataIntegration.Providers.DynamicwebViewProvider not included in App zip
Hi there, I downloaded 9.16.4 to update a site. I noticed that the ZIP doesn't include the DynamicwebViewProvider dll anymore. I do see it, however, referenced in the Admin csproj file: <PackageReference Include="Dynamicweb.DataIntegratio ...
Imar Spaanjaars
06/12/2023 10:47:41
Last post: 06/12/2023 14:01:10
Retrieving Stock Location information in Live Integration
Hi guys, I have a project where I need to ask BC to send over Stock Location availability in the Live Integration response and map the info to the existing Stock Locations in Dynamicweb. Basically, I need to map information to Stock Matrix based on t ...
Adrian Ursu
22/11/2023 11:03:43
Last post: 28/11/2023 19:53:25
Live Integration Discount
Hi, I have a situation where I might be missing some setting, but I'm unsure what is misconfigured. It concerns a dw 9.15.10 solution connected to BC14 via LiveIntegration, there the Live Prices are enabled, and ERP Controls discounts is checked. ...
Justin Sjouw
14/11/2023 16:52:26
Last post: 27/12/2023 12:47:50
How-to's for Live Integration / Custom Connectors
Can someone point me in the direction of some how-to's / examples (if they exist) on the dev / installation of connectors on the customer side? Is using a connector the only approach? We also have the possibility of creating a JSON based RestAPI  ...
Stephen Anthony Jackson
10/11/2023 10:48:18
Last post: 14/11/2023 13:06:27
Deactivate missing users and endpoint provider
Version: DW 9.16.1. I cant get the "Deactivate missing users" option to work when applied to a "User provider" as destination and a "Endpoint provider" (oData) as a source. No errors, but the missing users from the oData ...
Martin Moen
05/11/2023 12:12:39
Last post: 06/11/2023 10:17:13
Adding adapter breaks job
Hi there, Adding an adapter to an integration job breaks that job with an exception. Steps: 1. Open integration job 2. Click Add Adapter 3. Type a name and choose ConcatanateFieldsAdapter [sic] 4. Click Save and Close 5. Click Save and Close again 6. ...
Imar Spaanjaars
26/10/2023 22:07:23
Last post: 07/06/2024 07:46:31
PATCH option for Endpoints
Hi guys, I have noticed there is no PATCH option when using the Endpoints. Is this by design? Can I override this limitation? I need to be able to edit records in BC without using the DataIntegration Batch jobs. I am trying to use the endpoint from t ...
Adrian Ursu
18/10/2023 18:29:09
Last post: 19/10/2023 09:53:48
ForeignKey conflict when using double underscores (__)
Hi guys, I have some data containing double underscores (__) as follows: ProductID, ProductCategoryId, ProductCategoryFieldId, GroupId. I am trying to export and import this data into DW. Most of the data can be imported correctly but I get some weir ...
Adrian Ursu
17/10/2023 13:30:25
Last post: 18/10/2023 11:23:26
Fail on importing exported CSV files.
Hello. I am trying to do a simple export/import using ECom Provider as export source (have tried both name and ID options), and CSV provider as destination. As part of this process, I have to delete the 3-byte headerless CSV's created for empty e ...
Stephen Anthony Jackson
16/10/2023 13:04:39
Last post: 20/10/2023 18:34:45
AX LiveIntegration settings "ERP shipping item type"
Hi, Could you please advice what is the purpose of the setting "ERP shipping item type" in AX LiveIntegration component in DW? In documentation this setting does not exist, trying to play around with this setting did not have any impact (se ...
Tomas Vasiliƫnas
12/10/2023 15:34:37
Last post: 12/10/2023 15:51:24
Carts with many order lines takes a long time to calculate order with live integration
Hi, On a Swift we are experiencing that adding many order lines to a cart will cause the solution to load for a long time. E.g. a cart with 24 order lines (27 products in total as two orderlines have quantity 2 and 3) will take around 10 seconds for  ...
Roald Haahr
09/10/2023 16:04:12
Last post: 10/10/2023 16:39:23
Handle Odata response with "Expand"
Hi guys, I am trying to consume some Odata endpoints from an external application (not BC). Some endpoints require using an "expand" filter which will then add some additional information for a node (for example, the addresses of a customer ...
Adrian Ursu
30/09/2023 16:58:51
Last post: 02/10/2023 10:44:13
Liveintegration. productlist with variants takes a looong time. How to avoid this?
Hi, I have a productlist with variants. When using live intregration and this - the call to the live integration is too big. I have this checked: "Include variants in productinfo request". I cant disable this, because then it wont work when ...
Jan Sangill
12/09/2023 09:23:37
Last post: 13/09/2023 12:48:52
VAT rounding issues in BC
Hi there, I am using OData to send orders into BC. I got most of it working but I am now facing some rounding issues. I am sending the order line price with VAT (with the "Prices Including VAT" turned on) as the unit price for each product. ...
Imar Spaanjaars
06/09/2023 21:38:43
Last post: 07/09/2023 17:08:57
Length of order fields
Hi, We have an issue integrating the order fields from DW to BC. Some DW fields have a length that is too long to be integrated at BC. What is the best solution to solve this issue? Truncating the fields before sending them to BC? Truncating the fiel ...
Tomas Gomez
06/09/2023 13:25:45
Last post: 12/09/2023 14:34:04
How to get Order Shipping Status from Business Central to DW
Hi, I am integrating Endpoint to get the order details from Business Central to DW. However, I cannot get the fields required for Shipping Status from Business Central. Please let me know how we can get the Shipping Status from BC to DW. ...
Girish Kamble
31/08/2023 13:54:33
Last post: 13/09/2023 10:35:00
BC endpoints syntax for filtering
Hi guys, I am working on an integration with BC and I am trying to make use for the endpoints functionality. The first question I have is related to using the endpoints in the template (or back-end code) logic. For example, If I want to make a reques ...
Adrian Ursu
23/08/2023 13:57:43
Last post: 25/09/2023 14:21:15
Power BI integration
We have a client that wants to be able to access certain data from DW and use into Power BI. Is there any "easy" way of doing this? Or maybe its done before? We are thinking to expose data through and API endpoint, but thought it would be g ...
Anders Thoresen
22/08/2023 12:21:46
Last post: 22/08/2023 14:58:28
Differences results between using Connector Test Tool and Liveintegration in backoffice
Hi, Im experience some differences between using the "DynamicwebConnectorTestTool (2.5.0)" and the liveintegrationen in Dynamicweb Admin backoffice. Both are set up to use the same Web service URL from the server. Any suggestions to why thi ...
Marie Louise Veigert
21/08/2023 10:36:42
Last post: 21/08/2023 12:01:40