Hi there,
Does anyone know where I could find an example of how to read data from a document library in Office 365 sharepoint into a CSV file.
I can get the id of each record but I am not sure how to get the other fields I have created.
Thanks
Mark
Here is some of my code:
$ctx = New-Object Microsoft.SharePoint.Client.ClientContext($webUrl)
$ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($username, $password)
$web = $ctx.Web
$lists = $web.Lists.GetByTitle(‘hireman_documents’)
$ctx.Load($lists)
$query = [Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery(10000)
$items = $lists.GetItems( $query )
$ctx.load($items)
$ctx.ExecuteQuery();
$count = $items.Count – 1
for($intIndex = $count; $intIndex -gt -1; $intIndex–)
{
Write-Host $intIndex $items[$intIndex].Id
}
Hi Nico,
The scripts pointed me in the right direction. Thanks alot.
Part of the problem was the custom column had a space and I need to use Job_x0020_Number instead of Job Number.
I just need to use the export-csv to get the fields into a csv file but that shouldn’t be hard.
If you ever want to learn qlikview \ qlik sense let me know, you can contact me through my site http://www.techstuffy.com
All the best
Mark
Here is the script I ended up with that works with Office 365 Sharepoint :
$loadInfo1 = [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint.Client”)
$loadInfo2 = [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint.Client.Runtime”)
$webUrl = “https://your site”
$username = “your username”
$password = “your password” | ConvertTo-SecureString -AsPlainText -Force
$sourceListName = “hireman_documents”
$ctx = New-Object Microsoft.SharePoint.Client.ClientContext($webUrl)
$ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($username, $password)
$web = $ctx.Web
$list = $web.Lists.GetByTitle(‘your library’)
$query = New-Object Microsoft.SharePoint.Client.CamlQuery
$items = $list.GetItems($query)
$ctx.Load($list)
$ctx.Load($items);
$ctx.ExecuteQuery()
Write-Host $list.Title $list.ItemCount
Write-Host *************************
$items |% { Write-host “$($_[“Job_x0020_Number”]), $($_[“FileLeafRef”]) “}
