SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
How can I retrieve via REST service in SharePoint item column values in JSON:
This is my snippet:
$.ajax({
url: '/_api/web/lists/getbytitle("my list")/items/getbyid(3)',
type: 'GET',
header: {'Accept': 'application/json;odata=verbose'},
success: function(data) { alert(data.title); }
});
It's not working, any help?
<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script>
function restEndPoints2013(){
$.ajax({
url: "http://site/_api/Web/Lists/GetByTitle('listName')/items(3)",
type: "GET",
headers: {"accept": "application/json;odata=verbose"},
success: function(data){
$.each(data.d.results, function(index, item){
alert(item.Title);
});
},
error: function(error){
alert(JSON.stringify(error));
}
});
}
</script>
<body>
<script>
restEndPoints2013();
</script>
Dump this into an HTML editor and upload it to a server and see what happens.
Iterate through data.d.results:
function(data) {
$.each(data.d.results, function(i,result) {
//get item property
var strTitle = result.Title;
});
You can easily use jQuery for this. At first you build your Query String:
//For the Element with the ID 1
var urlQuery = "https://www.url.i/site/_vti_bin/ListData.svc/Listname?$filter=ID eq 1";
Then you can access the items from the list:
$.getJSON(urlQuery,
function (data) {
$.each(data.d.results, function (i, item) {
var title = item.Title;
});
});
EDIT 1: Fixed it, should work for SP2010.
EDIT 2: For SP 2013 you can use this Query String:
http://url.i/sites/siteName/_api/web/lists/getByTitle('listName')/items?$filter=Id eq 1
Then you should get the element as XML. If you put
accept: application/json;odata=verbose
in the HTTP-Header you get the result as JSON
Here are some more information about Rest in SharePoint 2013
may be you should use $.ajax instead of $.getJSON and replace "header: {"Accept": "application/json;odata=verbose"}" by " dataType: 'json' " in order to get the response in JSON format. Besides, try to add to your ajax the parameter "async: false" to make the request synchronous because you are trying to get the value from an empty object.
