Select-MYOB Cmdlet
Searches MYOB data.
Syntax
Select-MYOB [parameters]
Remarks
The Select-MYOB cmdlet allows you to use a syntax similar to SQL SELECT statements to search MYOB data.
$conn = Connect-MYOB If using an online instance: -InitiateOAuth "GETANDREFRESH" -OAuthClientId "YourClientId" -OAuthClientSecret "YourClientSecret" -CallbackURL "http://localhost:33333" -CompanyFileId "327eed10-9615-4e5e-bd9e-ae2cc00e2c70" -User "companyFileUser" -Password "companyFilePassword" If using an on premise instance: -InitiateOAuth "OFF" -URL "http://localhost:8080/accountright" -CompanyFileId "327eed10-9615-4e5e-bd9e-ae2cc00e2c70" -User "companyFileUser" -Password "companyFilePassword"
Select-MYOB -Connection $conn -Table "Accounts" -Columns @("Id","Name") -Where "Type='Bank'"