使用控制台应用程序从共享点列表中提取数据 [英] Using a Console App to Extract a data from sharepoint list

问题描述

我一直在寻找有关执行此操作的最佳方法的时间，而我发现的是大量冲突的信息，而且即时通讯正要崩溃。

I have been searching for hours about the best way to do this and all I find is massively conflicting information and im at the point of breaking down.

一个共享点2013年站点，上面自然有一个列表。

I have a sharepoint 2013 site which naturally has a list on.

我希望连接到此列表并将信息提取到数据表中。

I wish to connect to this list and extract the information into a data table. shouldn't be that hard should it...

所以我尝试过的选择是，
我原本打算在ssis上获取信息并对其进行转换到达最终目的地。
这个共享点列表适配器显然有一个很棒的小适配器……不适用于SSIS 13 ！！！当然不是那是我唯一可以使用的版本。

So options I have tried, I was originally planning on ssis to pull the information and transform it prior to its final destination. There is a great little adapter apparently for this the sharepoint list adapter... doesn't work with SSIS 13 !!! of course it doesn't that's the only version I can use.

因此，我接着阅读了一个名为list.asmx的网络服务，该网络服务在被调用并查询时应返回一个xml。桌子的版本...太棒了！

So then I read up on a webservice called lists.asmx which when called and queried should return an xml version of the table... great!

我连接到Web服务，并且所有教程中需要使用的一种方法（GETLISTITEMS）在SP2013中并不存在！

I connect to the webservice and the one method that I need to use (GETLISTITEMS) which is in all the tutorials doesn't exist in SP2013!!!

有人可以给我一个例子或链接到一个显示连接或查询示例的网站

can someone please give me an example or link me to a website which shows connection and query examples of either

通过SSIS 13的数据
B如何连接到SP站点并提取表信息。

A pulling the data via SSIS 13 B how to connect to the SP site and extract a tables information.

请回复我的理智，谢谢

推荐答案

作为控制台应用程序我假设您是指Visual Studio中的ac＃控制台应用程序？仅为Google提供SharePoint 2013 CSOM-ClientSide对象模型。您可以找到大量的信息。
它使您可以从远方 /客户端管理SP环境（以及阅读列表）。您需要托管的API dll

as a console app i assume you mean a c# console app in visual studio? Just google for SharePoint 2013 CSOM - ClientSide object model. You can find tons of info on that. It allows you to manage your SP environment (as well as read lists) from 'a distance' / client-side. You need the managed API dlls

https://msdn.microsoft.com/en-us/library/office/fp179912.aspx

这篇关于使用控制台应用程序从共享点列表中提取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！