Hi all,
I am trying to create a custom workflow that generates a list of resource account id and e-mail address (custom field added to bookableresource entity), then send out custom html e-mail using this list. This is for Dynamic 365 V8.2 cloud version. I created an EntityCollection based on fetchxml but I get error message in visual studio when I tried to get field value in each row from the EntityCollection, I read through below MSDN tutorial:
msdn.microsoft.com/.../gg328149.aspx
and tried below so far:
string accountid = bookedResource.Attribute["accountid"]; (Microsoft.xrm.sdk.Entity does not contain definition for attribute...)
string accountid = bookedResource["accountid"]; (cannot implicit convert object to string...)
Below is my code, can anyone tell me how to do this?
//retrieve resource account ID and e-mail that has open work order and has e-mail data stored under bookableresource entity const string fetchVendor = @" <fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true' > <entity name='bookableresource' > <attribute name='accountid' /> <attribute name='bookableresourceid' /> <attribute name='jt_bookingemail' /> <filter> <condition attribute='jt_bookingemail' operator='not-null' /> </filter> <link-entity name='bookableresourcebooking' from='resource' to='bookableresourceid' > <link-entity name='msdyn_workorder' from='msdyn_workorderid' to='msdyn_workorder' > <filter> <condition attribute='msdyn_substatusname' operator='eq' value='OPEN' /> </filter> </link-entity> </link-entity> </entity> </fetch> "; EntityCollection vendorCollection = service.RetrieveMultiple(new FetchExpression(fetchVendor)); foreach (Entity bookedResource in vendorCollection.Entities) { string accountid = bookedResource["accountid"]; string jt_bookingmail = bookedResource.GetAttributeValue['jt_bookingmail']; //pass account id and e-mail string into method that create and send out e-mails };