Parameters   Output Objects  

Searches JSON data.

Syntax

Select-JSON [parameters]

Remarks

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

$conn = Connect-JSON -DataModel 'Relational' -URI 'C:\people.json'
Select-JSON -Connection $conn -Table "NorthwindOData" -Columns @("personal.name.first","personal.name.last") -Where "personal.name.last='[email protected]'"