Developer forum

Forum » Integration » Need to import Customers with unique AccessUserUserName from Business Center

Need to import Customers with unique AccessUserUserName from Business Center

E-mail notifications
Girish Kamble
Reply
Posted on 07/07/2023 15:57:02

Hi,

I want to import customers from D365 Business Center. using <GetEcomData>  <tables>    <Customers type="all" />  </tables></GetEcomData> under "Dynamicweb codeunit request". 

But it is importing all the customers where AccessUserUserName is blank or null and duplicated, want to restrict it in DW Users Table.

 

Currently getting the data as below:

Here the username is getting duplicated or blank. Want to remove blank emails and have to be unique.

 


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 07/07/2023 16:05:08
Reply

Hi Girish,
try to set this as a key column in the DataIntegration job:

And maybe also here:

BR, Dmitrij

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 07/07/2023 16:09:24
Reply
This post has been marked as an answer

To filter out the users with blank UserName/Email you can add a condition like that on the table mapping:

Votes for this answer: 1
 
Girish Kamble
Posted on 07/07/2023 19:19:16
Reply

Hi Dmitriy, That worked for AccessUserUserName blank values but still needs a unique value in the field.

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 10/07/2023 11:19:35
Reply

Hi Girish,
the you can try to choose the AccessUserUserName  instead of AccessUserExternalId in the UserKeyfield and in the KeyColumns list.
Also if that doesn't work then maybe could be a combinaion of AccessUserUserName + AccessUserExternalId.
BR, Dmitrij

 

You must be logged in to post in the forum