Retrieve all Users using the API

Hi Robert, welcome to the Community, happy to see you here 🙂

There are no silly questions here! You can query contacts - they will contain User info. 

Hope this helps and please get back to me if you have any further questions! 

Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Lisa Wrike Team member Become a Wrike expert with Wrike Discover

This powershell script will get you close: 

# Define your Wrike API access token

$accessToken = ‘XXXX’ # Replace with your actual access token

# Set up the headers with the authorization token

$headers = @{

    'Authorization' = "Bearer $accessToken"

}

# Fetch all users and collaborators

$contactsResponse = Invoke-WebRequest -Uri 'https://www.wrike.com/api/v4/contacts' -Headers $headers

$contacts = ($contactsResponse.Content | ConvertFrom-Json).data

# Fetch all groups

$groupsResponse = Invoke-WebRequest -Uri 'https://www.wrike.com/api/v4/groups' -Headers $headers

$groups = ($groupsResponse.Content | ConvertFrom-Json).data

# Process the data to match users with their groups, activation status, and other fields

$userData = foreach ($user in $contacts) {

    $userGroups = $groups | Where-Object { $_.memberIds -contains $user.id }

    $status = if ($user.deleted -eq $false) { 'Activated' } else { 'Deactivated' }

    $role = $user.profiles[0].role # Assuming the role is in the first profile

    [PSCustomObject]@{

        Id        = $user.id

        FirstName = $user.firstName

        LastName  = $user.lastName

        Email     = $user.profiles[0].email

        Groups    = ($userGroups | ForEach-Object { $_.title }) -join ', '

        Status    = $status

        Role      = $role

        Deleted   = $user.deleted

    }

}

# Export the processed data to a CSV file

$userData | Export-Csv -Path $PSscriptroot/WrikeUsersAndGroups.csv -NoTypeInformation

Write-Host "Export completed. Check the file 'WrikeUsersAndGroups.csv'."