Hello everyone.
I want to write a console application that creates Contacts in CRM if the Contacts do not exist yet. And if they exist the Contact shall not be created.
But I dont know how to "Import" the existing contacts to my console application so I can compare the Contacts I want to create to the Contacts that already exist.
Can anyone help me?
*This post is locked for comments
Hi,
You can get existing records from CRM using SDK only, check below sample code from SDK which have sample code for all the methods.
Hi,
You can check "Upsert", msdn.microsoft.com/.../dn932135.aspx
Hi,
Before you build the console application, may I suggest that you take a look at SSIS with Kingswaysoft. You can use that to import the existing contacts into CRM, and you can also use it to import new contacts only by looking (using Lookup Control) at the existing contacts that already exist in CRM.
Basically if Contact exists - Do Nothing, if Contact doesn't exist - Create New Contact.
If you still want to use a Console application, you loop through the group of contacts that you want to import, and for each one you check whether the contact already exist in the database. You can do that comparison by retrieving the list of Contacts ahead of time from your CRM org, or by checking for each time whether to contact exists.
There is plenty of sample code on msdn and the community on how to call Create and RetrieveMultiple records, or using a fetchXml expression that will just return a count of records that match your criteria (in case contacts exist). Basically create the Query to check if Contact exist. If your results has more than zero entities, the Contact already exists in the database.
Hope this helps.
Instead of Import you need to write logic in your console app to get a contact with primary key (like first name, last name, email etc) from CRM. If you get one record, then the contact exists if NOT write logic to create contact in CRM.
Hope this resolves your query!!!
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
