How to insert data into the list?

When I run the code in console the item is getting created with empty columns, but when I run same code with input values it is showing as request failed. Following is my code..Check it and help me...Thanks in advance

$(document).ready(function() {

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('Ideas')/items('69')?$select=IdeaId,Title",

method: "GET",

headers: { "Accept": "application/json; odata=verbose", "Content-Type": "application/json;odata=verbose", },

success: function (response) {

if (response.d != undefined) {

var ResultDiv = response.d;

$("#ideaId").val(ResultDiv.IdeaId);

$("#ideaDescription").val(ResultDiv.Title);

}

/*error: function (response) {

$("#ResultDiv").empty().text(responseJSON.error);

}*/

});

//Add an item to list

createListItem();

//Update an item

updateListItem();

});

function createListItem() {

use strict;

var clientContext = new SP.ClientContext.get_current();

var oList = clientContext.get_web().get_lists().getByTitle("RiskRatings");

var itemCreateInfo = new SP.ListItemCreationInformation();

var oListItem = oList.addItem(itemCreateInfo);

var listItemRole = document.getElementById("txtraterrole").value;

alert(listItemRole);

var listItemName = document.getElementById("txtratername").value;

alert(listItemName);

var listItemRating = document.getElementById("txtrating").value;

alert(listItemRating);

var listItemComments = document.getElementById("txtriskcomments").value;

alert(listItemComments);

oListItem.set_item('RaterRole', listItemRole);

oListItem.set_item('RaterName', listItemName );

oListItem.set_item('Rating', listItemRating);

oListItem.set_item('RiskComments', listItemComments);

oListItem.update();

clientContext.load(oListItem);

clientContext.executeQueryAsync(Function.createDelegate(this, this.onQuerySucceeded), Function.createDelegate(this, this.onQueryFailed));

}

function onQuerySucceeded() {

alert('Item created: ' + oListItem.get_id());

}

function onQueryFailed(sender, args) {

alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace());

}

function clearFields(){

document.getElementById("txtraterrole").value="";

document.getElementById("txtratername").value="";

document.getElementById("txtrating").value="";

document.getElementById("txtriskcomments").value="";

}

Request : please mention SharePoint in the title so that other can also help you.

I am not able to get what you are trying to in your code. but here is code to create Item in list. Please Change column names and list name in your code.

SP.SOD.executeFunc('sp.js', 'SP.ClientContext', createListItem);//makes sure sp.js is loaded and then calls createListItem method
function createListItem() {
var clientContext = new SP.ClientContext.get_current();//if the page and the list are in same site.If list is in different site then use relative url instead of get_current
var oList = clientContext.get_web().get_lists().getByTitle('ListName');
var itemCreateInfo = new SP.ListItemCreationInformation();
this.oListItem = oList.addItem(itemCreateInfo);
oListItem.set_item('Title', 'My New Item!');
oListItem.set_item('Body', 'Hello World!');
oListItem.update();
clientContext.load(oListItem);
clientContext.executeQueryAsync(
Function.createDelegate(this, this.onQuerySucceeded),
Function.createDelegate(this, this.onQueryFailed)
);
}
function onQuerySucceeded() {
alert('Item created: ' + oListItem.get_id());
}
function onQueryFailed(sender, args) {
alert('Request failed. ' + args.get_message() +
'\n' + args.get_stackTrace());
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Yahiya Iqbal9y ago
Request : please mention SharePoint in the title so that other can also help you.

I am not able to get what you are trying to in your code. but here is code to create Item in list. Please Change column names and list name in your code.

SP.SOD.executeFunc('sp.js', 'SP.ClientContext', createListItem);//makes sure sp.js is loaded and then calls createListItem method
function createListItem() {
var clientContext = new SP.ClientContext.get_current();//if the page and the list are in same site.If list is in different site then use relative url instead of get_current
var oList = clientContext.get_web().get_lists().getByTitle('ListName');
var itemCreateInfo = new SP.ListItemCreationInformation();
this.oListItem = oList.addItem(itemCreateInfo);
oListItem.set_item('Title', 'My New Item!');
oListItem.set_item('Body', 'Hello World!');
oListItem.update();
clientContext.load(oListItem);
clientContext.executeQueryAsync(
Function.createDelegate(this, this.onQuerySucceeded),
Function.createDelegate(this, this.onQueryFailed)
);
}
function onQuerySucceeded() {
alert('Item created: ' + oListItem.get_id());
}
function onQueryFailed(sender, args) {
alert('Request failed. ' + args.get_message() +
'\n' + args.get_stackTrace());
}