Developer forum
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
                                
                         10
                                    
                                         Subscribe
                                    
                        
                                                        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