Parameters   Output Objects  

Searches Sage 50 UK data.

Syntax

Select-Sage50UK [parameters]

Remarks

The Select-Sage50UK cmdlet allows you to use a syntax similar to SQL SELECT statements to search Sage 50 UK data.

$conn = Connect-Sage50UK -URL 'http://localhost:5493/sdata/accounts50/GCRM/{C4C863BE-B098-4A7D-A78B-D7A92B8ADB59}' -User 'Manager' -Password 'xxxxxx'
Select-Sage50UK -Connection $conn -Table "TradingAccounts" -Columns @("TradingAccountUUID","Name") -Where "TradingAccountUUID='c2ef66a5-a545-413b-9312-79a53caadbc4'"