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)