Parameters   Output Objects  

Updates Box data.

Syntax

Update-Box [parameters]

Remarks

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

$conn = Connect-Box
Update-Box -Connection $conn -Table "Files" -Columns @("Name") -Values @("Sunset") -Id "123"

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

Update-Box -Connection $conn -Table "Files" -Columns @("Name") -Values @("Sunset") -Where "Id = '123'"

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

Select-Box -Connection $conn -Table Files -Where "Id = '123'" | Update-Box -Columns @("Id") -Values @("123 2")