Hello forums,
When setting up a new integration job to import customers, the job will succeed using the DynamicWeb Provider but fails using the User Provider.
Here are the two errors I get, they seem to imply a NULL PK, even though AccessUserExternalId is set as the PK on the job and in the destination settings when using User Provider, and is not null in the source XML.
Error: Value cannot be null. (Parameter 'key') Stack: at System.Collections.Generic.Dictionary`2.FindValue(TKey key) at System.Collections.Generic.Dictionary`2.TryGetValue(TKey key, TValue& value) at Dynamicweb.DataIntegration.Providers.UserProvider.UserDestinationWriter.Write(Dictionary`2 row, Mapping mapping, Boolean discardDuplicates) at Dynamicweb.DataIntegration.Providers.UserProvider.UserProvider.RunJob(Job job)
Job Failed with the following message: Value cannot be null. (Parameter 'key') The failed input row is: [AccessUserExternalId:"00073"], [AccessUserCustomerNumber:"00073"], [AccessUserUserName:"WALT MASSEY FORD - DEALER CLOSED"], [AccessUserName:"WALT MASSEY FORD - DEALER CLOSED"], [AccessUserEmail:""], [AccessUserPhone:""], [AccessUser_PaymentTerms:"EOM"], [AccessUser_PaymentMethod:"Check"], [AccessUser_DeliveryTerms:"Pre-Pay"], [AccessUser_DeliveryMode:"OTHER"], [AccessUserActive:"False"], [AccessUserAddress:"25060 HWY 51"], [AccessUserAddress2:""], [AccessUserCity:"Crystal Springs"], [AccessUserState:"MS"], [AccessUserZip:"39059"], [AccessUserCountryCode:"US"], [AccessUserCountry:"United States"]
Attached is my source XML.
Thanks,
Skylar Kennedy