使用XML或RSS feed访问共享点列表时出现问题 [英] Issue with accessing sharepoint list as XML or RSS feed
问题描述
我一直在尝试访问共享点列表下面的示例
I have been trying to access sharepoint list example below
https://mycompany.sharepoint.com/sites/abcd/MySite/Lists/Projects/AllItems.aspx
此处的项目"是我需要以XML或RSS提要访问的列表,我在URL下方使用了
Here "Projects" is the list I need to access as XML or RSS feed, I have used below URL
https://mycompany.sharepoint.com/sites/abcd/MySite/_layouts/15/listfeed.aspx?List=0c6db33a-f266-4d85-993c-d02b9a58968d&View=63d070e7-c5b8-4184-9d93-1101649e2238
和
https://mycompany.sharepoint.com/sites/abcd/My?Site/_layouts/15/listfeed.aspx?List={0C6DB33A-F266-4D85-993C-D02B9A58968D}&Source=https://mycompany.sharepoint.com/sites/abcd/My?Site/Lists/Projects/AllItems%2
该列表包含名称,优先级,开始日期,结束日期..."等列.但是,当我尝试使用上述URL提取其提取项标题,说明时,而所有列表列都包含在说明列中
The list contains columns "Name, Priority, Start Date, End Date .... etc" however when I try to fetch using above URLs its fetching items title, description whereas all the list columns are included in the description column
请让我知道如何获取实际的列表项作为查询中的列.
Please let me know how do I get actual list items as the columns in the query.
PS:目前正在Excel中测试导入
PS: Currently testing the import in Excel
推荐答案
结果是否需要采用RSS(Atom)格式?
Does the result need to be in RSS (Atom) format?
还要考虑2010和更高版本的list.aspx服务以及2013和更高版本的REST服务,因为它们使您可以选择列并编写查询.
Also consider the 2010 and later lists.aspx service and the 2013 and later REST services as they let you select columns and write queries.
这是一个REST示例:
Here's a REST example:
/sites/training/_api/web/lists/getbytitle('Tasks')/items?
/sites/training/_api/web/lists/getbytitle('Tasks')/items?
select =标题,状态
select=Title,Status
这是2010年的示例:
Here's a 2010 example:
/sites/training/_vti_bin/ListData.svc/Tasks?
/sites/training/_vti_bin/ListData.svc/Tasks?
select =标题,状态
select=Title,Status
这是带有过滤器的REST示例:
here's a REST example with a filter:
/sites/training/_api/web/lists/getbytitle('Documents')/items?
/sites/training/_api/web/lists/getbytitle('Documents')/items?
这篇关于使用XML或RSS feed访问共享点列表时出现问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!