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,
Thanks for the quick reply.
I’m looking to get the data from the columns I have added to the document library as well as the name of each file. I am using Office 365 Sharepoint.
I’ll have a look at the links and see how I get on.
Thanks
Mark