Wednesday 15 April 2015

Using REST to fetch SharePoint View Items -



Using REST to fetch SharePoint View Items -

i trying build right url homecoming items in sharepoint view using rest api.

using browser , next url can homecoming items in list.

https://mysharepoint.sharepoint.com/sites/mysite/_api/web/lists/getbytitle('announcements')/items

and can view definition using next url.

https://mysharepoint.sharepoint.com/sites/mysite/_api/web/lists/getbytitle('announcements')/views/getbytitle('latest news')/

but cannot figure out need set @ end of url items returned the view.

sp.view object not contain methods manipulating list items. sp.view object contains sp.view.viewquery property specifies query used list view. means next approach used retrieving list items view:

perform first request caml query list view using sp.view.viewquery property perform sec request retrieve list items specifying caml query how homecoming list items list view using rest api using javascript function getjson(url) { homecoming $.ajax({ url: url, type: "get", contenttype: "application/json;odata=verbose", headers: { "accept": "application/json;odata=verbose" } }); } function getlistitems(weburl,listtitle, querytext) { var viewxml = '<view><query>' + querytext + '</query></view>'; var url = weburl + "/_api/web/lists/getbytitle('" + listtitle + "')/getitems"; var querypayload = { 'query' : { '__metadata': { 'type': 'sp.camlquery' }, 'viewxml' : viewxml } }; homecoming $.ajax({ url: url, method: "post", data: json.stringify(querypayload), headers: { "x-requestdigest": $("#__requestdigest").val(), "accept": "application/json; odata=verbose", "content-type": "application/json; odata=verbose" } }); } function getlistitemsforview(weburl,listtitle,viewtitle) { var viewqueryurl = weburl + "/_api/web/lists/getbytitle('" + listtitle + "')/views/getbytitle('" + viewtitle + "')/viewquery"; homecoming getjson(viewqueryurl).then( function(data){ var viewquery = data.d.viewquery; homecoming getlistitems(weburl,listtitle,viewquery); }); }

usage

getlistitemsforview(_sppagecontextinfo.webabsoluteurl,'announcements','latest news') .done(function(data) { var items = data.d.results; for(var = 0; < items.length;i++) { console.log(items[i].title); } }) .fail( function(error){ console.log(json.stringify(error)); });

rest sharepoint-2013

No comments:

Post a Comment