Parameters   Output Objects  

Searches Acumatica data.

Syntax

Select-Acumatica [parameters]

Remarks

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

$conn = Connect-Acumatica -OAuthClientId 'MyApplicationId' -OAuthClientSecret 'MySecretKey' -OAuthCallbackURL 'http://localhost:33333'
Select-Acumatica -Connection $conn -Table "Events" -Columns @("Id","location_displayName") -Where "Id='Jq74mCczmFXk1tC10GB'"