Code SharePoint
lll
Home
SharePoint Tutorial
CSOM
REST API
JSOM
PowerShell
Interview Questions
Categories
x
All Methods (101)
Site (5)
List (27)
List Item (5)
Navigation (7)
Content Type (8)
Field (10)
View (12)
Folder (2)
File (15)
Group (5)
Page (5)
Property Bag (0)
Permission Level (0)
Categories
All Methods (101)
Site (5)
List (27)
List Item (5)
Navigation (7)
Content Type (8)
Field (10)
View (12)
Folder (2)
File (15)
Group (5)
Page (5)
Property Bag (0)
Permission Level (0)
Get All Items in SharePoint using PowerShell
The example in this topic show how to use PowerShell to Get All Items in SharePoint
# Provide credentials over here
$creds
=
(
New-Object
System.Management.Automation.PSCredential
"<<UserName>>"
,
(
ConvertTo-SecureString
"<<Password>>"
-AsPlainText
-Force
))
# Provide URL of the Site over here
# If you do not wish to pass credentials hard coded then you can use: -Credentials (Get-Credential). This will prompt to enter credentials
Connect-PnPOnline
-Url
http://MyServer/sites/MySiteCollection
-Credentials
$creds
# Get Context
$clientContext
=
Get-PnPContext
$targetWeb
=
Get-PnPWeb
# Get the list object
$targetList
=
$targetWeb
.
Lists
.
GetByTitle(
"New list"
)
$clientContext
.
Load(
$targetList
)
$clientContext
.
ExecuteQuery()
# Get the fields object. List all the columns separated with comma
$fields
=
"Id"
,
"Title"
$ListItems
=
Get-PnPListItem
-List
$targetList
-Fields
$fields
foreach
(
$ListItem
in
$ListItems
)
{
Write-Host
"Item Id : "
$ListItem
[
"ID"
]
"Item Title : "
$ListItem
[
"Title"
]
}
Disconnect-PnPOnline
Similar examples using different APIs
:
Get All Items using JSOM
Get All Items using REST-API
Get All Items using CSOM
Thank you for reading this article. This code was tested in SharePoint 2013
We value your feedback:
Page URL:
Name:
Email:
Feedback: