copy records through plugin

(0) Share

Report

Posted on by crmprogrammer2013

2,665

Hi,

I am writing a plugin to copy the related records of an entity. I was able to copy the parent record and stuck in copying related records. I've retrieved related records through query expression and I am trying to create new records(duplicates).

Here is the code snippet that is throwing error: "Cannot insert duplicate key".
                            if (listCaseParticipants != null)//listCaseParticipants has the retrieved entitycollection
                            {
                                foreach (Entity caseparticipants in listCaseParticipants)
                                {
                                    Entity caseparticipantentity = caseparticipants;
                                    caseparticipantentity.Attributes.Remove(caseparticipantentity.LogicalName + "id");//this line throws error.
                                    Guid relatedCasePId = service.Create(caseparticipantentity);

}

How should I create new copy of each retrieved record?

Please guide me through this. Thanks for any help.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

saemmang 205 on at

Like (2)

Report

Hi,

You could use an InitializeFromRequest for that:

https://msdn.microsoft.com/en-us/library/jj863602.aspx

This will copy the records values.

Steve

Was this reply helpful? Yes No
Suggested answer

Aiden Kaskela 19,696 on at

Like (1)

Report

Hi Roxanna,

The error you're getting isn't removing the key attribute (that code is fine, I tested the same code with Contact). The problem is in the Create call. Try explicitly setting a new key on your entity like this:

caseparticipantentity[caseparticipantentity.LogicalName + "id"] = Guid.NewGuid();

Guid relatedCasePId = service.Create(caseparticipantentity);

This will prevent you from getting the duplicate key exception.

Hope this helps! I'd appreciate if you'd mark this as a Verified answer.

Thanks,

Aiden

Was this reply helpful? Yes No
crmprogrammer2013 2,665 on at

Like (0)

Report

Thanks Aiden,

But I am getting this error: 'Entity Id must be the same as the value set in property bag'

Was this reply helpful? Yes No
saemmang 205 on at

Like (1)

Report
Hi Roxanna,

The property caseparticipantentity.Id must be the same as the attribute caseparticipantentity[caseparticipantentity.LogicalName + "id"].

So you could add the following line to your code to change the property:

caseparticipantentity.Id = Guid.Empty;

Please don't assign self-created GUIDs to new records. Let the system create the new Id for you. Otherwise it may impact the performance of CRM.

That's why it would be a cleaner solution to use the InitializeFromRequest.

Steve

Was this reply helpful? Yes No
crmprogrammer2013 2,665 on at

Like (0)

Report

Hi Steve,

You are right. I've used 'InitializeFromRequest' instead and was able to complete this.

It's indeed a much cleaner way of doing like you said.

Thank you so much.

Merry Christmas. :):):)

Was this reply helpful? Yes No

Community site session details

copy records through plugin

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

copy records through plugin

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates