Update field value with web api retrun 400 bad request when the origional value is null

(0) Share

Report

Posted on by Harvin

I want to update the table fields through web api according to the following site.

How to: Use the portal Web API | Microsoft Learn

The following code works well when the origional value is not null, but when the origional value is null, the request returns 400 bad request.

function updateRecordAttribute(col, recordObj) {
 var attributeName = col.name,
 value = recordObj[attributeName],
 newValue = prompt("Please enter \"" + col.label + "\"", value);
 if (newValue != null && newValue !== value) {
 appAjax('Updating...', {
 type: "PUT",
 url: "/_api/contacts(" + recordObj.id + ")/" + attributeName,
 contentType: "application/json",
 data: JSON.stringify({
 "value": newValue
 }),
 success: function(res) {
 table.updateRecord(attributeName, newValue, recordObj);
 }
 });
 }
 return false;
 }

So how can I update the field value when the origional value is null?

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Akah Mandela 445 on at

Like (0)

Report
Copy link

Link copied!
You could update your function to handle null values as follows
function updateRecordAttribute(col, recordObj) { var attributeName = col.name, value = recordObj[attributeName], newValue = prompt("Please enter \"" + col.label + "\"", value); if (newValue !== null) { // Only proceed if newValue is not null appAjax('Updating...', { type: "PUT", url: "/_api/contacts(" + recordObj.id + ")/" + attributeName, contentType: "application/json", data: JSON.stringify({ "value": newValue }), success: function(res) { table.updateRecord(attributeName, newValue, recordObj); } }); } else { // Handle null value (e.g., display a message or take alternative action) console.log("New value is null. No update performed."); } return false; }

Was this reply helpful? Yes No
Harvin 15 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply, but my case is the original value is null, not the new value is null.

Was this reply helpful? Yes No
Akah Mandela 445 on at

Like (0)

Report
Copy link

Link copied!
Then you should also check if the original value is null and do the update
function updateRecordAttribute(col, recordObj) { var attributeName = col.name, value = recordObj[attributeName], newValue = prompt("Please enter \"" + col.label + "\"", value); if (newValue !== null || value == null) { // Only proceed if newValue or value is not null appAjax('Updating...', { type: "PUT", url: "/_api/contacts(" + recordObj.id + ")/" + attributeName, contentType: "application/json", data: JSON.stringify({ "value": newValue }), success: function(res) { table.updateRecord(attributeName, newValue, recordObj); } }); } else { // Handle null value (e.g., display a message or take alternative action) console.log("New value is null. No update performed."); } return false; }

Was this reply helpful? Yes No
Harvin 15 on at

Like (0)

Report
Copy link

Link copied!

Sorry, my requirement is updating the null value to expected value, not skip.

Was this reply helpful? Yes No
Verified answer

Harvin 15 on at

Like (0)

Report
Copy link

Link copied!

Sorry, it's my mistake, the codes have no problem. The reason of the error is that my "newValue" become null.

Was this reply helpful? Yes No