Export List Items Using SharePoint 2010 Web Service in Powershell

Also, since this script uses web service, it can be run from any client machine also.

Thanks man. Appreciate that you have posted this solution here. Helped me a lot.

If I leave the $viewName empty, the default view is not used. In fact, if I put in the guid, I don't get the expected columns. Any suggestions?

PS C:\exports> c:\exports\exporttestbh.ps1 Please pass the credentials that have access to the site: https://lbrmain.lbrealty.com/intranet cmdlet Get-Credential at command pipeline position 1 Supply values for the following parameters: Credential Exception calling "GetListItems" with "7" argument(s): "Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerExcepti on' was thrown." At C:\exports\exporttestbh.ps1:41 char:82 + [System.Xml.XmlNode]$nodeListItems =$listsWebServiceReference.GetListItems <<<< ($listName, $viewName, $query, $vie wFields, $rowLimit, $queryOptions, $null) + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : DotNetMethodException New-Object : Exception calling ".ctor" with "2" argument(s): "Access to the path 'c:\exports\ArmedForcesMembers.xml' is deni ed." At C:\exports\exporttestbh.ps1:42 char:28 + $output = New-Object <<<< -TypeName System.IO.StreamWriter -ArgumentList $outputXmlFilePath, $false + CategoryInfo : InvalidOperation: (:) [New-Object], MethodInvocationException + FullyQualifiedErrorId : ConstructorInvokedThrowException,Microsoft.PowerShell.Commands.NewObjectCommand You cannot call a method on a null-valued expression. At C:\exports\exporttestbh.ps1:43 char:25 + $output.WriteLine <<<< ($nodeListItems.Outerxml) + CategoryInfo : InvalidOperation: (WriteLine:String) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull You cannot call a method on a null-valued expression. At C:\exports\exporttestbh.ps1:44 char:25 + $output.WriteLine <<<< () + CategoryInfo : InvalidOperation: (WriteLine:String) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull You cannot call a method on a null-valued expression. At C:\exports\exporttestbh.ps1:45 char:23 + $output.Dispose <<<< () + CategoryInfo : InvalidOperation: (Dispose:String) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull Output file is generated in the path: c:\exports\ArmedForcesMembers.xml PS C:\exports>

Thanks

As a big sharepoint fan i really like this article and appreciate your efforts

Thank You:-)

Good Work........

Hi Vijai. Very nicely presented article. Everything clearly understood.