Developer forum
Subject
                    Replies
                    Started by
                    Last reply
                
                                
                                    
                                
                                                        Endpoint Provider error when casting source to IODataBaseProvider 
                                  
                                        
                                            
                                        
                                
                            
                        Hi I am encountering an error/exception while attempting to export orders from DW 9 (9.17.9) to BC. The source provider is OrderProvider and the destination provider is EndpointProvider. The exception is as follows: System.InvalidCastException: Unabl ...
                        
                            Mateusz Struzik
                            
                        
                        10/09/2024 13:28:54
                        
                                    Last post: 11/09/2024 08:24:43
                                
                        
                                
                                    
                                
                                                        Automatic Digital Asset task working with If - Else logic
                                  
                                        
                                            
                                        
                                
                            
                        Hello there! I've been experimenting with the 'Digital assets checkin on products' Integration scheduled task and to my understanding it works based on pattern defined on an Asset Category. This works perfectly when defining one more fiel ...
                        
                            Barend Mosch
                            
                        
                        03/09/2024 14:29:36
                        
                                    Last post: 10/09/2024 15:44:01
                                
                        
                                                        OData provider doesn't return the expected data
                                  
                                        
                                            
                                        
                                
                            
                        I'm using the OData provider on a DW9.17.7 solution to get prices from the Business Central web service (DynamicwebSalesPrices3), but I'm not getting the expected prices. I have followed the configuration from https://doc.dynamicweb.dev/manua ...
                        
                            Michael Knudsen
                            
                        
                        07/09/2024 23:15:06
                        
                                    Last post: 09/09/2024 10:12:35
                                
                        
                                
                                    
                                
                                                        OData: Import Prices & Discounts (New price experience)
                                  
                                        
                                            
                                        
                                
                            
                        I'm new to OData, but I hope someone have a quick answer to my questions below. Is it possible from a DW9 solution to use the same endpoints as decribed below or is it restricted to DW10? https://doc.dynamicweb.dev/manual/tutorials/integration/bl ...
                        
                            Michael Knudsen
                            
                        
                        30/08/2024 11:33:19
                        
                                    Last post: 06/09/2024 09:16:47
                                
                         10
                                    
                                         Subscribe
                                    
                        
                                                        Discount Price Calculation Issue In BC
                                  
                                        
                                            
                                        
                                
                            
                        Dear Support, We use a standard integration code in BC, but we’ve encountered an issue when creating a standard order discount from DW. When the discounted order syncs to BC, the discount line is not created as a separate order line in BC. Inst ...
                        
                            Ya Min Thu
                            
                        
                        29/08/2024 12:44:36
                        
                                    Last post: 30/08/2024 12:36:23
                                
                        
                                                        Business Central Shipping integration fields 
                                  
                                        
                                            
                                        
                                
                            
                        Good Afternoon, Is there a way of setting these fields via the API? Seems like your documentation says it is only available via the live integration? The Sales Order REST Api doesn't have that as an endpoint and was just wondering how to set it f ...
                        
                            Joseph Vause
                            
                        
                        22/08/2024 17:29:54
                        
                                    Last post: 29/08/2024 11:03:21
                                
                        
                                                        Delete missing rows from source for specific source
                                  
                                        
                                            
                                        
                                
                            
                        Hi guys, I have a project where we get products from multiple external sources. The problem we have to solve is removing the missing products depending on the source of the data. I am unsure if we can configure the DataIntegration job to delete the m ...
                        
                            Adrian Ursu
                            
                        
                        15/07/2024 08:21:15
                        
                                    Last post: 28/08/2024 15:27:37
                                
                         12
                                    
                                         Subscribe
                                    
                        
                                
                                    
                                
                                                        Case sensitivity issue with OData and delta replication
                                  
                                        
                                            
                                        
                                
                            
                        Hi there, I am trying to use Delta replication in the OData provider but I think I have hit a case sensitivity issue. My JSON looks as follows; "value": [ { "no": "823332", "description": "FIKTIV-1-2" ...
                        
                            Imar Spaanjaars
                            
                        
                        14/08/2024 13:08:09
                        
                                    Last post: 22/08/2024 11:15:55
                                
                        
                                
                                    
                                
                                                        Database table for Category group field values - type: list box
                                  
                                        
                                            
                                        
                                
                            
                        Hi, Where can I find the values for list box type fields in the attribute groups? Kr Davy ...
                        
                            Davy Capiau
                            
                        
                        16/08/2024 13:31:40
                        
                                    Last post: 16/08/2024 14:41:24
                                
                        
                                                        Where did Refresh Schema go in DW 10?
                                  
                                        
                                            
                                        
                                
                            
                        Hi there, I have an integration job that maps from an XML document to a custom SQL table (using the DynamicWeb provider). I've added a new column to my table. but it won't show up in the backend's job. in DW 9 we had Refresh Schema but I  ...
                        
                            Imar Spaanjaars
                            
                        
                        13/08/2024 12:43:03
                        
                                    Last post: 14/08/2024 10:02:02
                                
                        
                                                        Bug: Integration Admin Screen doesn't like subfolders on Linux Docker Image
                                  
                                        
                                            
                                        
                                
                            
                        Reporting a bug on the Integration Page when using Linux Containers. If the XML file for the integration is in a subfolder, it cannot read the xml file, so you end up with a screen like this and the the backslash is causing problems as on linux it sh ...
                        
                            Joseph Vause
                            
                        
                        26/07/2024 12:22:44
                        
                                    Last post: 08/08/2024 13:15:50
                                
                        
                                                        Scheduled Task Logs for Odata Jobs
                                  
                                        
                                            
                                        
                                
                            
                        Hello, We are running into an issue with Scheduled task logs for Odata integration activities filing up drive space. These logs are duplicates of the data integration activity log for the job they are running. Each time it runs the log file continues ...
                        
                            Jeremy Fesmire
                            
                        
                        24/07/2024 23:00:46
                        
                                    Last post: 06/08/2024 12:48:33
                                
                        
                                                        Scheduled Tasks: Groups property not showing when making Excel from PIM Feed XML
                                  
                                        
                                            
                                        
                                
                            
                        Hi, I encountered, what I think is a bug, when exporting PIM Feed XML data to Excel with a scheduled task. I have a feed that listens to the warehouse that gets a list of products given a query. In the feed it is possible to state the properties incl ...
                        
                            Barend Mosch
                            
                        
                        31/05/2023 09:43:18
                        
                                    Last post: 06/08/2024 11:46:08
                                
                        
                                                        Performance and Zero results clearing cache
                                  
                                        
                                            
                                        
                                
                            
                        Hi, Summary: The EcomProvider (as Destination) seems to be clearing the cache even when there are no results to import. This was found in 9.17.2 Setup: We have many scheduled tasks that run every 5 minutes to get data from the ERP As expected, not ev ...
                        
                            Nuno Aguiar
                            
                        
                        08/05/2024 16:03:59
                        
                                    Last post: 31/07/2024 11:09:43
                                
                        
                                                        Acquiring a Token from Business Central
                                  
                                        
                                            
                                        
                                
                            
                        Hello, We are running Dynamic Web on a Linux Container in Azure. When attempting to acquire a token from Business Central we are getting the following error once it redirects back to Dynamic Web from BC SetAuthorizationCode failed: Operation is not s ...
                        
                            Joseph Vause
                            
                        
                        25/07/2024 16:32:16
                        
                                    Last post: 31/07/2024 10:40:55
                                
                        
                                
                                    
                                
                                                        Integration between Dynamicweb and LS Central
                                  
                                        
                                            
                                        
                                
                            
                        Hi guys, What is the current status of connecting Dynamicweb and LS Central? I know there was a standard (supported) integration between Dynamicweb and LS Retail back in Rapido days but I am unsure what is the current status. Can anybody help me out  ...
                        
                            Adrian Ursu
                            
                        
                        15/03/2023 09:15:57
                        
                                    Last post: 25/07/2024 07:38:27
                                
                        
                                                        No Source Table From JSON Source Provider In Data Integration 
                                  
                                        
                                            
                                        
                                
                            
                        Hi. I'm trying to set up a data integration using a JSON provider on a DW 9.12.12 solution. I'm running into an issue where no source table is found in my data: I think the issue comes down to the formatting of my JSON file without being 100% ...
                        
                            Bo Nyby
                            
                        
                        09/07/2024 10:59:56
                        
                                    Last post: 18/07/2024 11:35:49
                                
                        
                                
                                    
                                
                                                        How do OrderLines get the right IntegrationOrderId with BC oDatav4 Blueprint
                                  
                                        
                                            
                                        
                                
                            
                        I'm looking at the Blueprint for BC oDatav4 to export EcomOrders and EcomOrderLines. One thing I do'nt understand, is how EcomOrderLines will be added with the corect Document_No. Because I see that the Document_No gets stamped onto the Order ...
                        
                            Justin Sjouw
                            
                        
                        05/07/2024 11:53:31
                        
                                    Last post: 09/07/2024 13:42:34
                                
                        
                                
                                    
                                
                                                        Not able to get EcomPrices from LI after upgrade from LI version 7.2.12 to 7.4.x
                                  
                                        
                                            
                                        
                                
                            
                        Hi community, i'm having an issue with ecomprices returned from ERP after upgrade og DW version and LI. Below custom code snippet from a Swift productprice template works on LI versions 7.2.5 -> 7.2.12. After an upgrade of DW version to 9.17.7 ...
                        
                            Søren Jakobsen
                            
                        
                        09/07/2024 09:10:55
                        
                                    Last post: 09/07/2024 13:04:04
                                
                        
                                
                                    
                                
                                                        Selecting None on a column mapping still stores the original column name
                                  
                                        
                                            
                                        
                                
                            
                        Hi there, When I set up a job and choose None for the source column (and map it to a constant) it still stores a column name in the job XML. That causes some unnecessary overhead in the OData provider as it still uses that column in the select statem ...
                        
                            Imar Spaanjaars
                            
                        
                        02/07/2024 15:08:26
                        
                                    Last post: 02/07/2024 21:32:27