Angularjs Sharepoint Rest API to showing all columns

I have created a very basic controller to pull data from a SharePoint list, but it only pulls the base Title and created column. It doesn't pull any columns I have created, which are the ones I require. Is there a setting in SP itself to state it is available for the API?

<div ng-app="listApp">
<div id="App1" ng-controller="controller1">
<h1>First List Itemsh1>
<div ng-repeat="item in items">
<p>{{item.Title}}p>
div>
div>
div>

var appVar = angular.module('listApp', []);
appVar.controller("controller1", function($scope){
GetListItems($scope, "List1");
});
function GetListItems($scope, listName){
$.ajax({
url: "https://example.com/sites/mysite/_api/web/lists/GetByTitle('"+listName+"')/items",
method: "GET",
async: false,
headers: { "Accept": "application/json;odata=verbose" },
success: function(data){
$scope.items = data.d.results;
},
error: function(sender,args){
console.log(args.get_message());
}
});
}

SP.ListItemCollection resource endpoint

/_api/web/lists/getByTitle('')/items

returns all the field values for a list items with some limitation for User/Lookup fields (for performance reasons):

In case of User/Lookup fields only lookup ids will be retrieved by default.

In your example only SP.ListItem.Title property is printed, if you want to display all the returned list item values it could be accomplished like this:

<divng-repeat="iteminitems">
<p>{{item.Title}}p>
<png-repeat="(key,value)initem">
{{value}}
p>
div>

Some another suggestions:

Prefer $http_serviceover jQuery.ajax() in Angular apps

Example

<divng-app="spApp"ng-controller="TasksController">
<table>
<trng-repeat="tintasks">
<tdng-repeat="(key,value)int"ng-if="!value.hasOwnProperty('__deferred')&&!value.hasOwnProperty('__metadata')">
{{value}}
td>
tr>
table>
div>

Controller

angular.module('spApp',[])
.controller('TasksController',function($scope,$http){
$scope.tasks=[];
$scope.getListItems=function(listTitle){
return$http({
method:'GET',
url:_spPageContextInfo.webAbsoluteUrl+"/_api/web/lists/getbytitle('"+listTitle+"')/items",
headers:{'Accept':'application/json;odata=verbose'}
});
}
$scope.getListItems("Tasks")
.success(function(data,status){
$scope.tasks=data.d.results;
})
.error(function(data,status){
console.log("Anerroroccured");
});
});

1 Reply

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

Ramesh Palaniappan10y ago
Accepted answer
SP.ListItemCollection resource endpoint
```
/_api/web/lists/getByTitle('')/items
```
returns all the field values for a list items with some limitation for User/Lookup fields (for performance reasons):
In case of User/Lookup fields only lookup ids will be retrieved by default.
In your example only SP.ListItem.Title property is printed, if you want to display all the returned list item values it could be accomplished like this:
<divng-repeat="iteminitems">
<p>{{item.Title}}p>
<png-repeat="(key,value)initem">
{{value}}
p>
div>
Some another suggestions:
- Prefer $http_serviceover jQuery.ajax() in Angular apps
Example
<divng-app="spApp"ng-controller="TasksController">
<table>
<trng-repeat="tintasks">
<tdng-repeat="(key,value)int"ng-if="!value.hasOwnProperty('__deferred')&&!value.hasOwnProperty('__metadata')">
{{value}}
td>
tr>
table>
div>
Controller
angular.module('spApp',[])
.controller('TasksController',function($scope,$http){
$scope.tasks=[];
$scope.getListItems=function(listTitle){
return$http({
method:'GET',
url:_spPageContextInfo.webAbsoluteUrl+"/_api/web/lists/getbytitle('"+listTitle+"')/items",
headers:{'Accept':'application/json;odata=verbose'}
});
}
$scope.getListItems("Tasks")
.success(function(data,status){
$scope.tasks=data.d.results;
})
.error(function(data,status){
console.log("Anerroroccured");
});
});
+2