Microsoft Dynamics CRM (Archived)

update null to lookup field using Xrm.WebApi.updateRecord

(0) Share

Report

Posted on by Santosh Kulkarni

235

I trying to set null to lookup field using Xrm.WebApi.updateRecord.

error:

An error occurred while validating input parameters: Microsoft.OData.ODataException: The 'odata.bind' instance or property annotation has a null value. In OData, the 'odata.bind' instance or property annotation must have a non-null string value.

code====================================================================

var updateSalesPlanMember = {};

// navigation property name
updateSalesPlanMember["kv_UserAddress@odata.bind"] = null;

Xrm.WebApi.updateRecord("kv_salesplanmember", recordId, updateSalesPlanMember).then(

function success(result) {
///success code
},
function (error) {
console.error(error.message);
}

);

code=============================================================

Thanks!

Kind regards

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (5)

Verified answer

crm development 870 on at

Like (0)

Report

Hi Santosh, refer below link..

https://stackoverflow.com/questions/49329838/setting-null-for-single-valued-navigation-property-using-xrm-webapi

Thanks,

Anand

Was this reply helpful? Yes No
Suggested answer

Nuno 2,005 on at

Like (0)

Report

Hi Santosh, try

updateSalesPlanMember["_kv_UserAddress_value"] = null;

Hope this helps.

Was this reply helpful? Yes No
Verified answer

David Jennaway 14,065 on at

Like (3)

Report

Unfortunately this is a limitation of the webAPI. To remove lookup values, you need to send a DELETE request to delete the value from the field

Was this reply helpful? Yes No
Verified answer

Arun Vinoth 11,615 Moderator on at

Like (0)

Report

Like David mentioned, you have to issue DELETE request to set null in lookup.

var req = new XMLHttpRequest();

req.open("DELETE", Xrm.Utility.getGlobalContext().getClientUrl() + "/api/data/v9.0/accounts()/account_parent_account()/$ref", true);

req.setRequestHeader("Accept", "application/json");

req.setRequestHeader("Content-Type", "application/json; charset=utf-8");

req.setRequestHeader("OData-MaxVersion", "4.0");

req.setRequestHeader("OData-Version", "4.0");

req.onreadystatechange = function() {

if (this.readyState === 4) {

req.onreadystatechange = null;

if (this.status === 204 || this.status === 1223) {

//Success - No Return Data - Do Something

}

}

};

req.send();

Refer my post in Stack Overflow: [View:https://stackoverflow.com/q/49329838/7920473]

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi Santosh,

this link might be helpful, looks like you are trying to remove the reference. you may want to try with 'DELETE'.

docs.microsoft.com/.../mt607875(v=crm.8)

Thanks,

Shayan

Was this reply helpful? Yes No
Verified answer

Santosh Kulkarni 235 on at

Like (0)

Report

Thanks All for the response.

I am able to remove the reference to the lookup field.

In my case I used below URL for DELETE request:

xhr.open("DELETE", serverURL + "/api/data/v9.0/" + refEntity + "(" + refEnityGuid + ")/" + relationship + "(" + entityId + ")/$ref", true);

Regards,

Santosh

Was this reply helpful? Yes No
Suggested answer

Salvador_Henrique 5 on at

Like (0)

Report

Hello,

I tried this and its works for me.

var quoteid = formContext.data.entity.getId().replace('{', '').replace('}', '');
var data = {
"aaa_mytextfield": null,
"_aaa_mylookupid_value": null
}

Xrm.WebApi.updateRecord("quote", quoteid, data).then(
function success(result) {
console.log(result);
},
function (error) {
console.log(error)
}
);

Was this reply helpful? Yes No