Select-SAPBusinessOne Cmdlet
Searches SAP Business One data.
Syntax
Select-SAPBusinessOne [parameters]
Remarks
The Select-SAPBusinessOne cmdlet allows you to use a syntax similar to SQL SELECT statements to search SAP Business One data.
$conn = Connect-SAPBusinessOne -Url 'http://localhost:50000/b1s/v1' -User 'user' -Password 'password' -CompanyDB 'companydb' Select-SAPBusinessOne -Connection $conn -Table "Orders" -Columns @("DocEntry","DocType") -Where "DocType='dDocument_Items'"