I have been doing quite a bit of automation. And have just hammered out some code today. this is some basic code to do simple queries in Powershell. I will obfuscate the API token to protect the not so innocent.

[Net.ServicePointManager]::SecurityProtocol = “tls12, tls11, tls”

$url = “https://api.monday.com/v2/”

$hdr = @{}

$hdr.Add(“Authorization” , “BIG LONG Token”)

$hdr.Add(“Content-Type”,“application/json”)

$bodytxt=‘{“query”:“{boards(limit:1){id name}}”}’

$response = Invoke-WebRequest -Uri $url -Headers $hdr -Method Post -body $bodytxt

$resBoards = ($response.content | ConvertFrom-Json)

$bodytxt = ‘{“query”:"{boards(ids:’ + $($resSheet.data.boards�0].id) + ‘),{columns{archived id title}}}"}’

Write-Host $bodytxt

$response = Invoke-WebRequest -Uri $url -Headers $hdr -Method Post -body $bodytxt

$resColumns = ($response.content | ConvertFrom-Json)

$bodytxt = ‘{“query”:"{boards(ids:’ + $($resSheet.data.boards�0].id) + ‘),{items {creator{id} creator_id group{ id } id name state updates {id}}}}"}’

Write-Host $bodytxt

$response = Invoke-WebRequest -Uri $url -Headers $hdr -Method Post -body $bodytxt

$resitems = ($response.content | ConvertFrom-Json)