Customer Service forum

How to set null in the Lookup fields using C# custom web api

(0) Share

Report

Posted on by Community Member

Hello Guys,

I am facing an issue that how to set null value in the Lookup field using c# web api.

I am using following code--

address["field schema name"] = null;

Its working fine when i use 2011 endpoint service to update the null but not with the custom c# web api.

Your help would be a great help.

Categories:

Other

I have the same question (0)

All responses (10)

Answers (1)

Community Member on at

Like (0)

Report

thanks for the response,

i am already using the @odata.bind in the schema name.

If i am passing the Guid of the record the its being saved in the CRM but when i try to set it null by sending the null string then its throwing the error.

Was this reply helpful? Yes No
LeoAlt 16,331 Moderator on at

Like (0)

Report

Hi partner,

When using WebApi to update lookup field, we should add "@odata.bind" after field name.

You could refer to samples of using WebApi with C#.

Please try address["field name@odata.bind"] instead.

Hope it helps.

Best Regards

Leo

Was this reply helpful? Yes No
LeoAlt 16,331 Moderator on at

Like (0)

Report

Hi partner,

You could try "" (empty) instead of null.

In addition, could you kindly share the error message?

Hope it helps.

Best Regards

Leo

Was this reply helpful? Yes No
Suggested answer

Dynamics365 Rocker 7,755 on at

Like (1)

Report

Hi Shashikant,

Please go through below link, It may help you:

community.dynamics.com/.../254377

Was this reply helpful? Yes No
Suggested answer

AllanDeCastro 156 on at

Like (0)

Report

Hello,

Why are you trying to specify this field is null ? If you have nothing to put in this field just delete the line. :)

(Maybe you will have some errors if specific development use this field after, but normally you have to handle this)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

this field is already containing some so i want to remove that data from the field that's why i need to set it as null

Was this reply helpful? Yes No
LeoAlt 16,331 Moderator on at

Like (0)

Report

Hi partner,

Have you tried the suggestions? How is the situation now?

Best Regards

Leo

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

yes folk, i have tried it and its not working and throwing the usual error "Object reference not set to an instance of an object" something like this which means its not accepting the either "" or null.

Was this reply helpful? Yes No
Verified answer

Arun Vinoth 11,615 Moderator on at

Like (1)

Report

You cannot set null to lookup using web api.

Rather use DELETE verb for single valued navigation property.

stackoverflow.com/.../7920473

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thanks

Was this reply helpful? Yes No