Cmdlets for Exact Online

Build 24.0.9060

Select-ExactOnline Cmdlet

Parameters   Output Objects  

Searches Exact Online data.

Syntax

Select-ExactOnline [parameters]

Remarks

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

$conn = Connect-ExactOnline -Region 'United States' -Division '5512'
Select-ExactOnline -Connection $conn -Table "Accounts" -Columns @("Id","Name") -Where "City='Raleigh'"

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060