execute multiple request

(0) Share

Report

Posted on by Community Member

Hi all,

We have a requirement like..we have 2entities "a" and "b" and having relationship 1(a) to n(b)..in "b" entity there is a lookup of "a" and "a" entity records having multiple tasks for each record.Now i have to retrieve all the open tasks related to the lookup selected in entity "b" and have to create tasks in the entity "b" for that particular record of "b".What is the best approach to achive this?can i do retrievemultiple and executemultiplerequest in plugin?Please suggest me the best approach.

Thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Sanjay ,

For me I would suggest to use executemultiplerequest , as you may have multiple tasks and you also need to create task in entity "b".

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

I assume that you would not have more than 5000 tasks. So, you can use a retrievemultiple to get the related entity tasks & use an executemultiplerequest for the creation of the tasks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

thanks for your response goutam,yes i am thinking to follow that approach only.If you have any sample code on execute multiple request pls share with me and one more requirement is if we dont know what type of activity is in parent entity then how can we achieve this?i have to create that type of activity in its child also.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi Sanjay ,

Please refer below sample code -

https://msdn.microsoft.com/en-in/library/jj863631.aspx

https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/org-service/use-executemultiple-improve-performance-bulk-data-load

https://msdynamicscrmblog.wordpress.com/2013/05/10/use-executemultiplerequest-for-bulk-createupdatedelete-using-c-in-dynamics-crm-2011-2/

You can execute fetchXML and then loop through the record based on typecode you can check what type of activity is .

Was this reply helpful? Yes No
Nflannery 360 on at

Like (0)

Report
Copy link

Link copied!

Even if there are more than 5000 results to return you can use paging to retrieve all.

msdn.microsoft.com/.../gg327917.aspx

Was this reply helpful? Yes No