Parameters   Output Objects  

Updates Cloudant data.

Syntax

Update-Cloudant [parameters]

Remarks

The Update-Cloudant cmdlet allows you to use a syntax similar to SQL UPDATE statements to update Cloudant data.

$conn = Connect-Cloudant -User 'abc123' -Password 'abcdef'
Update-Cloudant -Connection $conn -Table "Movies" -Columns @("MovieRating") -Values @("R") -Id "70f6284d2a395396dbb3a60b4ce3d2d6"

The Where parameter can also be used to specify the primary key of the table:

Update-Cloudant -Connection $conn -Table "Movies" -Columns @("MovieRating") -Values @("R") -Where "Id = '70f6284d2a395396dbb3a60b4ce3d2d6'"

The primary key can also be passed to the cmdlet along the pipeline:

Select-Cloudant -Connection $conn -Table Movies -Where "MovieRating = 'R'" | Update-Cloudant -Columns @("MovieRating") -Values @("R 2")