Select-SageIntacct Cmdlet
Searches Sage Intacct data.
Syntax
Select-SageIntacct [parameters]
Remarks
The Select-SageIntacct cmdlet allows you to use a syntax similar to SQL SELECT statements to search Sage Intacct data.
$conn = Connect-SageIntacct -User 'myusername' -CompanyID 'TestCompany' -Password 'mypassword' -SenderID 'Test' -SenderPassword 'abcde123'
Select-SageIntacct -Connection $conn -Table "Customer" -Columns @("Name","TotalDue") -Where "CustomerId='12345'"