{"id":2871,"date":"2010-06-24T14:51:00","date_gmt":"2010-06-24T14:51:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/powershell\/2010\/06\/24\/using-new-webserviceproxy-to-get-modify-and-add-items-to-a-list-in-sharepoint-2007\/"},"modified":"2024-02-28T13:10:18","modified_gmt":"2024-02-28T21:10:18","slug":"using-new-webserviceproxy-to-get-modify-and-add-items-to-a-list-in-sharepoint-2007","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/powershell\/using-new-webserviceproxy-to-get-modify-and-add-items-to-a-list-in-sharepoint-2007\/","title":{"rendered":"Using New-WebServiceProxy to get, modify, and add items to a list in SharePoint 2007"},"content":{"rendered":"

The motivation<\/strong><\/p>\n

Let\u2019s say that you want to retrieve and modify a list in a SharePoint site, but you don\u2019t have access to Microsoft.SharePoint.dll. One possible solution is to try to search online or ask someone to let you copy the dll. If you are able to get a hold of it, you will quickly realize that the Microsoft.SharePoint.dll has some dependencies and that you are stuck again. Well, I will show you how you can get, modify and add items to a list in SharePoint using PowerShell V2.<\/p>\n

Pre requisites: First, you need a SharePoint site and credentials to modify that particular list. The illustration below shows the list (DemoList) that I want to modify.<\/p>\n

\"Image<\/a><\/p>\n

Get List Items<\/h5>\n

The New-WebServiceProxy Cmdlet creates a web service proxy object which lets you use and manage the web service.<\/p>\n

# The uri refers to the path of the service description, e.g. the .asmx page<\/span>            \r\n$uri<\/span> =<\/span> \"http:\/\/powershell\/TeamSite\/TestTeamSite\/Demos\/_vti_bin\/lists.asmx?WSDL\"<\/span>             \r\n            \r\n# Create the service<\/span>            \r\n$service<\/span> =<\/span> New-WebServiceProxy<\/span> -Uri<\/span> $uri<\/span>  -Namespace<\/span> SpWs<\/span>  -UseDefaultCredential<\/span>            \r\n            \r\n# The name of the list <\/span>            \r\n$listName<\/span> =<\/span> \"My Demo List\"<\/span>             \r\n            \r\n# Create xml query to retrieve list. <\/span>            \r\n$xmlDoc<\/span> =<\/span> new-object<\/span> System.Xml.XmlDocument<\/span>            \r\n$query<\/span> =<\/span> $xmlDoc<\/span>.<\/span>CreateElement<\/span>(<\/span>\"Query\"<\/span>)<\/span>            \r\n$viewFields<\/span> =<\/span> $xmlDoc<\/span>.<\/span>CreateElement<\/span>(<\/span>\"ViewFields\"<\/span>)<\/span>            \r\n$queryOptions<\/span> =<\/span> $xmlDoc<\/span>.<\/span>CreateElement<\/span>(<\/span>\"QueryOptions\"<\/span>)<\/span>            \r\n$query<\/span>.<\/span>set_InnerXml<\/span>(<\/span>\"FieldRef Name='Full Name'\"<\/span>)<\/span>             \r\n$rowLimit<\/span> =<\/span> \"10\"<\/span>            \r\n            \r\n$list<\/span> =<\/span> $null<\/span>             \r\n$service<\/span> =<\/span> $null<\/span>              \r\n            \r\ntry<\/span>{<\/span>            \r\n    $service<\/span> =<\/span> New-WebServiceProxy<\/span> -Uri<\/span> $uri<\/span>  -Namespace<\/span> SpWs<\/span>  -UseDefaultCredential<\/span>              \r\n}<\/span>            \r\ncatch<\/span>{<\/span>             \r\n    Write-Error<\/span> $_<\/span> -ErrorAction:<\/span>'SilentlyContinue'<\/span>             \r\n}<\/span><\/pre>\n
Now, we use the service object to retrieve the list.<\/p>\n
if<\/span>(<\/span>$service<\/span> -ne<\/span> $null<\/span>)<\/span>{<\/span>            \r\n    try<\/span>{<\/span>                    \r\n        $list<\/span> =<\/span> $service<\/span>.<\/span>GetListItems<\/span>(<\/span>$listName<\/span>,<\/span> \"\"<\/span>,<\/span> $query<\/span>,<\/span> $viewFields<\/span>,<\/span> $rowLimit<\/span>,<\/span> $queryOptions<\/span>,<\/span> \"\"<\/span>)<\/span>             \r\n    }<\/span>            \r\n    catch<\/span>{<\/span>             \r\n        Write-Error<\/span> $_<\/span> -ErrorAction:<\/span>'SilentlyContinue'<\/span>            \r\n    }<\/span>            \r\n}<\/span><\/pre>\n
Let\u2019s take a look at the $list object.<\/p>\n
$list<\/span><\/pre>\n
s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882<\/span><\/p>\n
dt\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : uuid:C2F41010-65B3-11d1-A29F-00AA00C14882<\/p>\n
rs\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : urn:schemas-microsoft-com:rowset<\/p>\n
z\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : #RowsetSchema<\/p>\n
#whitespace : {<\/p>\n
,<\/p>\n
}<\/p>\n
data\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : data<\/p>\n
 <\/p>\n
The items of the DemoList are located in $list.data.row.<\/p>\n
$list<\/span>.<\/span>data<\/span>.<\/span>row<\/span><\/pre>\n
ows_ContentTypeId\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 0x0100F20992473D85F74DBAFD4159A55805FB<\/span><\/p>\n
ows_Title\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Francisco<\/p>\n
ows_Car\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Impreza<\/p>\n
ows_IceCream\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Chocolate<\/p>\n
ows_Sport\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Basketball<\/p>\n
ows_ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 1<\/p>\n
ows_ContentType\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Item<\/p>\n
ows_Modified\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 2010-06-24 14:58:17<\/p>\n
… (more data) …<\/p>\n
For more information on getting list items visit http:\/\/msdn.microsoft.com\/en-us\/library\/lists.lists.getlistitems.aspx<\/a><\/p>\n
Update List Items<\/strong><\/p>\n
We want to modify the sport field value from \u201cbasketball\u201d to \u201csoccer\u201d. to do this, we use the $service and $list from the example above.<\/p>\n
# Get name attribute values (guids) for list and view<\/span>            \r\n$ndlistview<\/span> =<\/span> $service<\/span>.<\/span>getlistandview<\/span>(<\/span>$listname<\/span>,<\/span> \"\"<\/span>)<\/span>            \r\n$strlistid<\/span> =<\/span> $ndlistview<\/span>.<\/span>childnodes<\/span>.<\/span>item<\/span>(<\/span>0<\/span>)<\/span>.<\/span>name<\/span>            \r\n$strviewid<\/span> =<\/span> $ndlistview<\/span>.<\/span>childnodes<\/span>.<\/span>item<\/span>(<\/span>1<\/span>)<\/span>.<\/span>name<\/span>            \r\n            \r\n                \r\n# Create an xmldocument object and construct a batch element and its attributes. <\/span>            \r\n$xmldoc<\/span> =<\/span> new-object<\/span> system.xml.xmldocument<\/span>             \r\n            \r\n# note that an empty viewname parameter causes the method to use the default view   <\/span>            \r\n$batchelement<\/span> =<\/span> $xmldoc<\/span>.<\/span>createelement<\/span>(<\/span>\"batch\"<\/span>)<\/span>            \r\n$batchelement<\/span>.<\/span>setattribute<\/span>(<\/span>\"onerror\"<\/span>,<\/span> \"continue\"<\/span>)<\/span>            \r\n$batchelement<\/span>.<\/span>setattribute<\/span>(<\/span>\"listversion\"<\/span>,<\/span> \"1\"<\/span>)<\/span>            \r\n$batchelement<\/span>.<\/span>setattribute<\/span>(<\/span>\"viewname\"<\/span>,<\/span> $strviewid<\/span>)<\/span>            \r\n            \r\n            \r\n# Specify methods for the batch post using caml. to update or delete, specify the id of the item, <\/span>            \r\n# and to update or add, specify the value to place in the specified column<\/span>            \r\n$id<\/span> =<\/span> 1<\/span>            \r\n$xml<\/span> =<\/span> \"\"<\/span>            \r\n            \r\n# The row to be modified<\/span>            \r\n$rowId<\/span> =<\/span> $list<\/span>.<\/span>data<\/span>.<\/span>row<\/span>.<\/span>ows_id<\/span>            \r\n            \r\n# New field value<\/span>            \r\n$newsport<\/span> =<\/span>\"soccer\"<\/span>               \r\n            \r\n$xml<\/span> +=<\/span> <method id='$id' cmd='Update'>\"<\/span> +<\/span>            \r\n        \"<field name='ID'>$rowId<\/field>\"<\/span> +<\/span>            \r\n        \"<field name='Sport'>$newsport<\/field>\"<\/span> +<\/span>            \r\n        \"<\/method>\"<\/span>            \r\n                    \r\n# Set the xml content        <\/span>            \r\n$batchelement<\/span>.<\/span>innerxml<\/span> =<\/span> $xml<\/span>            \r\n            \r\n$ndreturn<\/span> =<\/span> $null<\/span>             \r\ntry<\/span> {<\/span>            \r\n    $ndreturn<\/span> =<\/span> $service<\/span>.<\/span>updatelistitems<\/span>(<\/span>$listname<\/span>,<\/span> $batchelement<\/span>)<\/span>             \r\n}<\/span>            \r\ncatch<\/span> {<\/span>             \r\n    write-error<\/span> $_<\/span> -erroraction:<\/span>'SilentlyContinue'<\/span>            \r\n}<\/span><\/pre>\n
Add New Items to the List <\/strong><\/p>\n
To add a new row to the list, everything is the same as in the update list items example above, the only difference is the xml content.<\/p>\n
In this case, the new row will contain the following information:<\/p>\n
Title: James<\/p>\n
Car: A4<\/p>\n
Sport: Swimming<\/p>\n
Icecream: Strawberry Cheese Cake<\/p>\n
$xml<\/span> =<\/span> \"<method id='$id' cmd='New'>\"<\/span> +<\/span>            \r\n        \"<field name='Title'>James<\/field>\"<\/span>+<\/span>            \r\n        \"<field name='Car'>A4<\/field>\"<\/span>+<\/span>            \r\n        \"<field name='Sport'>Swimming<\/field>\" <\/span>+<\/span>            \r\n        \"<field name='IceCream'>Strawberry cheese Cake<\/field>\" <\/span>+<\/span>            \r\n        \"<\/method>\"\"<\/span><\/pre>\n
At the end, our SharePoint list looks like this.<\/p>\n
Cheers,<\/p>\n
Francisco Gomez Gamino [MSFT]<\/p>\n","protected":false},"excerpt":{"rendered":"
The motivation Let\u2019s say that you want to retrieve and modify a list in a SharePoint site, but you don\u2019t have access to Microsoft.SharePoint.dll. One possible solution is to try to search online or ask someone to let you copy the dll. If you are able to get a hold of it, you will quickly […]<\/p>\n","protected":false},"author":600,"featured_media":13641,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2871","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powershell"],"acf":[],"blog_post_summary":"
The motivation Let\u2019s say that you want to retrieve and modify a list in a SharePoint site, but you don\u2019t have access to Microsoft.SharePoint.dll. One possible solution is to try to search online or ask someone to let you copy the dll. If you are able to get a hold of it, you will quickly […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/posts\/2871","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/users\/600"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/comments?post=2871"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/posts\/2871\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/media\/13641"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/media?parent=2871"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/categories?post=2871"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/tags?post=2871"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\"Image<\/a><\/p>\n
For more information on updating list items visit http:\/\/msdn.microsoft.com\/en-us\/library\/ms440289.aspx<\/a>.<\/p>\n