List and List Items

Add a list item

You can add a list item using the Add-KshListItem cmdlet.

Using a HashTable:

$value = @{ Title = 'My New Request'; Status = 'New' }
$list = Get-KshList -ListTitle 'Approval%20Requests'
Add-KshListItem -List $list -Value $value

Or using a PSCustomObject:

$value = New-Object -TypeName PSObject
$value | Add-Member -MemberType NoteProperty -Name Title -Value "My New Request"
$value | Add-Member -MemberType NoteProperty -Name Status -Value "New"
$list = Get-KshList -ListTitle 'Approval%20Requests'
Add-KshListItem -List $list -Value $value

Add list items in bulk

You can add multiple list items at once from a CSV file. This is useful for bulk inserts.

$csv = @"
Title,Status
My New Request 1,New
My New Request 2,New
My New Request 3,New
"@
$value = ConvertFrom-Csv $csv
$list = Get-KshList -ListTitle 'Approval%20Requests'
Add-KshListItem -List $list -Value $value

Retrieve list items

You can retrieve list items using the Get-KshListItem cmdlet with the -All parameter. This will return all the items in the specified list.

$list = Get-KshList -ListTitle 'Approval%20Requests'
Get-KshListItem -List $list -All

Query list items

You can query list items using the Get-KshListItem cmdlet and a CAML query.

$list = Get-KshList -ListTitle 'Approval%20Requests'
Get-KshListItem -List $list -ViewXml '<View><Query><Where><Eq><FieldRef Name="Title" /><Value Type="Text">Approval for purchase</Value></Eq></Where></Query></View>'