CRM do not support direct update of Entity Reference properties, Use Navigation properties instead

Mahesh picture Mahesh · Nov 4, 2016 · Viewed 7.1k times · Source

I am using Ms Dynamic Web Api with Simple OData. I need to add new record for link entities.

I am using the below code snip and refer the documentation on https://github.com/object/Simple.OData.Client/wiki/Adding-entries-with-links

       var newContactData = await _oDataClient
            .For<Contacts>()
               .Set(new
               {
                   firstname = contactData.ContatDetails.firstname,
                   lastname = contactData.ContatDetails.lastname,
                   emailaddress1 = contactData.ContatDetails.emailaddress1
               })
               .InsertEntryAsync(true);

        var newContactLink = await  _oDataClient.For<New_project_contactses>()
                .Set(new
                {
                    _new_contact_project_name_new_value = contactData.ContatDetailsLink._new_contact_project_name_new_value,
                    new_project_contactsid = new Guid("0eb46b24-21a2-e611-80eb-c4346bc5b2d4"),
                    new_contact_type = contactData.ContatDetailsLink.new_contact_type,

                })
                .InsertEntryAsync(resultRequired: true);

i am getting exception

CRM do not support direct update of Entity Reference properties, Use Navigation properties insteadS

Answer

Astrotrain picture Astrotrain · Feb 3, 2017

Well, it is possible, but you need to use the special "@odata.bind" syntax to update your single-navigation properties.

For example, to update an account so that it references an existing primarycontactid, you can use a PATCH operation to the /api/data/v8.2/accounts endpoint with the following body:

{
   "name":"Sample Account",
   "[email protected]":"/contacts(00000000-0000-0000-0000-000000000001)"
}

See https://msdn.microsoft.com/en-us/library/gg328090.aspx#Anchor_3 (it is discussed in terms of creating an entity, but it works for updating as well).