Parameters   Output Objects  

Searches Sage 200 data.

Syntax

Select-Sage200 [parameters]

Remarks

The Select-Sage200 cmdlet allows you to use a syntax similar to SQL SELECT statements to search Sage 200 data.

$conn = Connect-Sage200 -InitiateOAuth 'GETANDREFRESH' -SubscriptionKey '12345' -Schema 'StandardUK'
Select-Sage200 -Connection $conn -Table "Banks" -Columns @("Id","Code") -Where "Description='Bob'"