Developer forum

Forum » Integration » BC PIM Connector - Duplicate JSON key error when publishing pending products

BC PIM Connector - Duplicate JSON key error when publishing pending products

Arnór Halldórsson
Arnór Halldórsson
Reply

Description

We are testing the BC PIM Connector for an Advania webshop implementation and encounter a failure when attempting to publish pending products from Business Central to DynamicWeb 10. The connector establishes a connection to the DW10 instance successfully and can read data from its database, but the sync fails at product creation time with a duplicate key error on ProductName.

We tried going into the attribute mapping in the PIM connector and enabling / disabling the mapping for the ProductName field but the same error always occurs. 

Environment

DW instance URL: advania-vefverslun.test.lisa.is
DW version: 10.22.9
BC version: IS Business Central 27.4 (Platform 27.0.46893.0)
PIM Connector version: 1.1.1.0

Error Message

The JSON object already contains the key 'ProductName'.

Call Stack

DWPIMDataExchangeManagement_EX (CodeUnit 6177295).CreateProductInPIM line 50
DynamicWeb PIM Connector by SignUp Software AB v1.1.1.0
DWPIMDataExchangeManagement_EX (CodeUnit 6177295).ProcessItemActions line 21
DynamicWeb PIM Connector by SignUp Software AB v1.1.1.0
DWPIMDataExchangeManagement_EX (CodeUnit 6177295).FullProductSync line 10
DynamicWeb PIM Connector by SignUp Software AB v1.1.1.0
DWOverview_EX (Page 6177273).ApplyAllUpdates line 7
DynamicWeb PIM Connector by SignUp Software AB v1.1.1.0
DWOverview_EX (Page 6177273)."PendingUpdates - OnDrillDown" (Trigger) line 2
DynamicWeb PIM Connector by SignUp Software AB v1.1.1.0

Telemetry Ids

Internal session ID: b86202dc-3bd3-409a-aa19-49974eef0a66
App Insights session ID: 83b3f116-55f4-485e-81c0-74c6ff29248e
Client activity ID: a69f0685-1d39-4fa4-9dbe-1d2370c50b2f
User telemetry ID: 9420cb73-810f-42b2-a872-8811c6f9493b
Timestamp: 2026-03-05T15:46:05.7638004Z
 
Best regards,
Arnór
 

Replies

 
Lars Holm Byg Dynamicweb Employee
Lars Holm Byg
Reply

Hi Arnór
Great that you got your hands on it and is testing it. 

First of do you use the PIM for business central connector 1.0.0-BETA010 in the app store of DW? 


We found a bug recently in the way we handle unique ID for products in DW, creating an error similar to yours. 

This is fixed in 10.24 and onwards (Currently ring 0) - So if it is a demo / test invironment that you are using, could you then get it to ring 0 and see if that fixes it. 

Otherwise I will reach out to you to see or my self what is happening. 

 

You must be logged in to post in the forum