Developer forum

Forum » Integration
Started by
Last reply
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
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: 15/07/2024 11:08:36
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
BC BluePrints template
For now I just downloaded and unzipped Because the instructions state: But I get: ...
Justin Sjouw
05/07/2024 11:19:39
Last post: 09/07/2024 10:32:08
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
User Provider and Smartseaches
How can we deactivate missing users in a integration with the User Provider? It was working, until the first user group based on a smartsearch was added. User Provider setup: One of the customers which no longer are available in the XML, have the fol ...
Michael Knudsen
25/06/2024 12:55:14
Last post: 26/06/2024 10:59:13
Variants in liveintegration and many calls to BC
Hi, When calling on a productlist or a product itself that have variants - it will send a request to BC with ALL the variants on the product itself. If you have alot of variants and are showing 15 products per page. This will take ALOT of time. Am I  ...
Jan Sangill
19/06/2024 15:18:22
Last post: 19/06/2024 18:52:03
Import related products
Hi, I'm looking for a way to import references to related products. We already have a data integration job, doing batch integration at a scheduled interval. My main issue is that products in the client's ERP are referenced by internal product ...
Martin Christensen
18/06/2024 13:42:13
Last post: 18/06/2024 14:20:33
Endpoint manager: adding new authentication types
Hi, How can we add custom authentication types to the Endpoint management? I can add an addin, but that needs to return a enum value from EndpointAuthenticationType which by the nature of an enum is sealed. The addin is displayed in the list of possi ...
Ben Doorn
11/06/2024 17:33:33
Last post: 12/06/2024 12:52:32
DW Discounts are ignored in live integration to BC18
Hi, We're having a problem where we are trying to make BC accept DW discounts, which I have seen work on other projects. It is a BC18 on-premise and the code unit is version For starters I want to ensure that the newest version of the c ...
Roald Haahr
11/06/2024 10:40:17
Last post: 12/06/2024 08:27:00
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
"Failed to handle windows scheduled task" when set to ignore
There's a setting to not show the scheduled task error: "Failed to handle windows scheduled task". However, it appears that it still reports in some situations. I can repro this by creating a dummy scheduled task and then deleting it. O ...
Scott Forsyth
28/07/2021 23:27:26
No replies yet
LiveIntegration - removing lines of type Fixed
Hi, We noticed that ProcessOrderLines method in OrderHandler.cs is not handling fixed orderlines (OrderLineType == "2") which ends removing them. This prevents custom fees from added to the order, ending in order total mismatch. Can this be ...
Mario Santos
05/04/2024 11:50:25
Last post: 06/06/2024 11:55:38
recurring orders recalculation
Hi there, We have a solution with a custom integration to ERP which controlling all the prices and discounts, also there is significant number of subscription/ recurring orders. Currently, if a recurring order is generated when no discount campaigns  ...
Umar Farooq
06/06/2024 08:42:33
Last post: 06/06/2024 09:53:32
Duplicate live requests for multiple countries
Hi there, I have a site using a recent version of live integration. When logged in I am getting customer specific prices. However, the LI logs show that two requests are made for each product: for two different VAT countries (DK and GB in my case). T ...
Imar Spaanjaars
23/04/2024 17:23:34
Last post: 04/06/2024 09:51:47
Batch integration - import property translations
Hi, Our customer has al her properties and translations in NAV. When I make the request where I specify the languages, I only get the Property field translations values for the main language: "ENU". How should I adjust this request to add t ...
Davy Capiau
30/05/2024 08:58:55
Last post: 03/06/2024 13:46:49
Now an then an error when submitting orders
Hi, Sometimes this error is generated when an order is being submitted from dw to BC with the LiveIntegration. Is there anything I can do to prevent this? ...
Justin Sjouw
31/05/2024 15:04:59
Last post: 03/06/2024 10:01:40
Add fields to codeunit
Hi, We have a solution with a standard BC integration and use Live Integration to retrieve orders and invoices. Now we would need to get a customfield from BC with the orderdata. Its a field that a tracking number for Logtrade. What do we need to do  ...
Aki Ruuskanen
23/05/2024 08:33:33
Last post: 23/05/2024 09:03:13
Prevent jobs from running if ERP connection is down
Hi guys, What would be the best way to account for ERP connection availability before running a batch job? We have seen situations where running a batch job would generate some errors if the ERP endpoint is down. Is there a standard way of handling t ...
Adrian Ursu
08/05/2024 10:08:42
Last post: 17/05/2024 09:18:55