Confluence Cloud API - number of posts by user
$headers = @{
'Accept' = 'application/json'
'Content-Type' = 'application/json'
'Authorization' = ("Basic {0}" -f ([Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes(("{0}:{1}" -f 'alexandrm@rabota.ua', '********')))))
}
$users = @()
$res = @{
_links = @{
next = '/rest/api/content?expand=version.by&limit=200'
}
}
while ($res._links.next) {
Write-Host $res._links.next
$res = Invoke-RestMethod -Uri ('https://rabota.atlassian.net/wiki' + $res._links.next) -Headers $headers
foreach ($x in $res.results) {
$users += New-Object PSObject -Property @{
user = $x.version.by.publicName
}
}
}
$users | Group-Object user | Sort-Object count -Descending | select count, namewill print something like:
Count Name
---
633 Alexandr Marchenko
107 Alla Ustymenko
82 Yar
82 Bogdana Matvieieva