通过 Js 检索共享点列表 [英] Retrieve Sharepoint List by Js
本文介绍了通过 Js 检索共享点列表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我创建了一个包含四列的共享点列表.我将它们命名如下:姓名、职位、办公室、薪水.你能帮我如何从我的列表中检索项目(使用 JavaScript)吗?
I created a sharepoint list with four columns. I named them as follows: Name, Position, Office, Salary. Could you please help me how to retrieve items from my list (using JavaScript)?
推荐答案
您可以使用以下示例代码替换您的站点 url、列表和列:
You can use the below sample code where you need to replace your site url, list and columns:
使用 JavaScript 编码获取 SharePoint 列表项:
var siteUrl = 'https://siteUrl';
var listName= 'MyCustomListName';
function retrieveListItems()
{
var clientContext = new SP.ClientContext(siteUrl);
var oList = clientContext.get_web().get_lists().getByTitle(listName);
var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml('<View><Query><Where><Geq><FieldRef Name=\'ID\'/>' +
'<Value Type=\'Number\'>1</Value></Geq>
</Where></Query><RowLimit>10</RowLimit></View>');
this.collListItem = oList.getItems(camlQuery);
clientContext.load(collListItem);
clientContext.executeQueryAsync(Function.createDelegate(this, this.onQuerySucceeded),
Function.createDelegate(this, this.onQueryFailed));
}
functiononQuerySucceeded(sender, args)
{
var listItemInfo = '';
var listItemEnumerator = collListItem.getEnumerator();
while (listItemEnumerator.moveNext()) {
var oListItem = listItemEnumerator.get_current();
listItemInfo += '\nID: ' + oListItem.get_id() +
'\nName: ' + oListItem.get_item('Name') +
'\nPosition: ' + oListItem.get_item('Position')+
'\nOffice: ' + oListItem.get_item('Office') +
'\nSalary: ' + oListItem.get_item('Salary');
}
alert(listItemInfo.toString());
}
functiononQueryFailed(sender, args)
{
alert('Request failed. ' +args.get_message() + '\n' + args.get_stackTrace());
}
使用 REST API 编码获取 SharePoint 列表项:
function retriveListItem()
{
var resultGridHtmlMySubmission=''
$.ajax (
{
url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('<SampleListName(yourlistTitle)>')/items?$select=Title,Name,Position,Office,Salary",
type: "GET",
data: JSON.stringify,
headers:
{
"Accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"X-RequestDigest": $("#__REQUESTDIGEST").val(),
"IF-MATCH": "*",
"X-HTTP-Method": null
},
cache: false,
success: function(data)
{
for (vari = 0; i<data.d.results.length; i++)
{
var item = data.d.results[i];
resultGridHtmlMySubmission+='<tr>';
resultGridHtmlMySubmission+='<tdalign="center" valign="middle"><span title="Sr.No."><b>'+item.Title+'</b></span></td>';
resultGridHtmlMySubmission+='<td align="center" valign="middle"><span title="Sr.No."><b>'+item.Name+'</b></span></td>';
resultGridHtmlMySubmission+='<td align="center" valign="middle"><span title="Sr.No."><b>'+item.Position+'</b></span></td>';
resultGridHtmlMySubmission+='<td align="center" valign="middle"><span title="Sr.No."><b>'+item.Office+'</b></span></td>';
resultGridHtmlMySubmission+='<td align="center" valign="middle"><span title="Sr.No."><b>'+item.Salary+'</b></span></td>';
resultGridHtmlMySubmission+='</tr>';
}
$("#tbodycontent").html(resultGridHtmlMySubmission);
},
error: function(data)
{
// $("#ResultDiv").empty().text(data.responseJSON.error);
}
});
}
参考网址:
http://ramdotnetdeveloper.blogspot.com/2016/08/crud-operation-in-sharepoint-2013.html?m=1
这篇关于通过 Js 检索共享点列表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文