Parameters   Output Objects  

Updates Paylocity data.

Syntax

Update-Paylocity [parameters]

Remarks

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

$conn = Connect-Paylocity -InitiateOauth "GETANDREFRESH" -OAuthClientID "YourClientId" -OAuthClientSecret "YourClientSecret" -RSAPublicKey "YourRSAPubKey" -Key "YourKey" -IV "YourIV"
Update-Paylocity -Connection $conn -Table "Employee" -Columns @("LastName") -Values @("Jon Doe") -Id "1234"

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

Update-Paylocity -Connection $conn -Table "Employee" -Columns @("LastName") -Values @("Jon Doe") -Where "EmployeeId = '1234'"

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

Select-Paylocity -Connection $conn -Table Employee -Where "EmployeeId = '1234'" | Update-Paylocity -Columns @("EmployeeId") -Values @("1234 2")