修改SharePoint列表项-SQL [英] Modify SharePoint List Items - SQL
问题描述
我目前正在为一个客户开发一个项目，以使用Orchestrator(SCORCH)交付自动化解决方案，并将System Center产品和SharePoint集成在一起.我不是SharePoint管理员，我的SQL平均水平.
I am currently working on a project for a client to deliver automated solutions with Orchestrator (SCORCH), integrating System Center products and SharePoint. I am not a SharePoint admin and my SQL is average.
客户端仅运行SharePoint 2007，因此我无法使用SCORCH SharePoint集成包.
The client only runs SharePoint 2007 and therefore I cannot use the SCORCH SharePoint Integration Pack.
SharePoint列表被用作自动化的触发和控制机制，需要由SCORCH监视和更新.
SharePoint lists are being used as the trigger and control mechanism for automation and they need to be monitored and updated by SCORCH.
我已经对这部分进行了排序，我可以使用SQL访问列表项，并在必要时使用SCORCH SQL Integration Pack访问插入/更新.
I have this part sorted, I can access the list items using SQL and Insert/Update where necessary using SCORCH SQL Integration Pack.
为此，需要能够更新列表条件(例如，从列表中的下拉菜单中添加或删除项目).
To expand on this, there is a requirement to be able to update the list criteria (e.g. add or remove an item from a drop down menu within the list).
我不知道在哪里可以找到此选项，我的SQL并不完美(我的进程/T-SQL将在发布前由SharePoint DBA进行检查和调整)，但是当我知道在哪里时，我可以轻松地更新列表项看.
I have no clue where to look for this option, my SQL is not fantastic (my processes/T-SQL will be reviewed and tweaked by the SharePoint DBA before release) but I can easily update the list items when I know where to look.
我会很感激你能给我的任何建议.预先感谢！
I'd appreciate any pointers you can give me. Thanks in advance!
推荐答案
您可以使用Web服务更新列表项.
You can use web service to update list items.
Lists.UpdateListItems方法:
Lists.UpdateListItems Method:
然后从SQL Server中的存储过程调用Web服务.
Then call web service from a Stored Procedure in SQL server.
https://www.codeproject .com/Articles/428200/如何从存储过程调用Web服务
最好的问候，
这篇关于修改SharePoint列表项-SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
