Powershell Tricks¶

XML¶

Call Azure DevOps API¶

Generate an access token here first.

$accessToken = "your access token"

$organization = "MAJORITY"
$base64AccessToken = [Convert]::ToBase64String([System.Text.Encoding]::UTF8.GetBytes(":$accessToken"))
$headers = @{"Authorization"="Basic $base64AccessToken"; "Content-Type"="application/json"};
$feedId = "7dd99ac5-e967-4a56-9881-e16011273db0"

$packages = $(Invoke-WebRequest 
              -Uri "https://feeds.dev.azure.com/$organization/_apis/packaging/Feeds/$feedId/packages?protocolType=NuGet&packageNameQuery=$NameQuery&api-version=6.1-preview.1" 
              -Headers $headers 
              -Method Get 
              | ConvertFrom-Json).value

Working with files¶

##  load a csv file into an array of objects
$items = Get-Content data.csv | ConvertFrom-csv
##  or JSON
$items = Get-Content data.csv | ConvertFrom-Json
##  read properties and etc
Write-Host $items[0].columnName

##  Save objects to JSON string
ConvertTo-Json $items[0] -Compress # -Compress means minify JSON