Add Trello users to ONLYOFFICE Apps

This script automates the process of retrieving Trello users and adding them to ONLYOFFICE Apps. It ensures that all Trello team members are onboarded into ONLYOFFICE Apps.

How it works

• Retrieve Trello users - Fetches a list of users with their names and usernames.
• Add Trello users to ONLYOFFICE Apps - Trello usernames are used to create temporary emails.

Full example

import requests

# Trello API credentials
TRELLO_API_KEY = "your_trello_api_key"
TRELLO_TOKEN = "your_trello_token"
TRELLO_BOARD_ID = "your_board_id"
TRELLO_API_URL = "https://api.trello.com/1"

# ONLYOFFICE Apps API credentials
ONLYOFFICE_API_HOST = "your-docspace.onlyoffice.com"
ONLYOFFICE_API_KEY = "your_onlyoffice_api_key"

# Headers for the ONLYOFFICE Apps authentication
ONLYOFFICE_HEADERS = {
    "Accept": "application/json",
    "Authorization": f"Bearer {ONLYOFFICE_API_KEY}",
    "Content-Type": "application/json"
}

# Step 1: Retrieve Trello users
def get_trello_users(board_id):
    url = f"{TRELLO_API_URL}/boards/{board_id}/members"
    params = {"key": TRELLO_API_KEY, "token": TRELLO_TOKEN}
    response = requests.get(url, params=params)

    if response.status_code == 200:
        users = response.json()
        return [{"name": user["fullName"], "username": user["username"]} for user in users]
    else:
        print(f"Failed to retrieve Trello users: {response.status_code} - {response.text}")
        return []

# Step 2: Add Trello users to ONLYOFFICE Apps
def add_user_to_docspace(name, username, password):
    url = f'https://{ONLYOFFICE_API_HOST}/api/2.0/people'
    data = {
        'password': password,
        'firstName': name,
        'lastName': '',
        'email': f'{username}@docspace.com'
    }
    response = requests.post(url, json=data, headers=ONLYOFFICE_HEADERS)
    if response.status_code == 200:
        user_id = response.json()['response']['id']
        print('User created successfully:', user_id)
        return user_id
    else:
        print('Failed to create user:', response.status_code, response.text)
        return None

if __name__ == '__main__':
    PASSWORD = 'DocSpace123' # Replace with a temporary password or generate unique

    trello_users = get_trello_users(TRELLO_BOARD_ID)

    for user in trello_users:
        add_user_to_docspace(user['name'], user['username'], PASSWORD)

Before you start

1. Replace your-docspace.onlyoffice.com and your_onlyoffice_api_key with your actual ONLYOFFICE Apps portal host and API key. Ensure you have the necessary permissions to perform user operations.
2. Before you can make requests to the API, you need to create an ONLYOFFICE Apps API key. Check out the API keys article to learn how to obtain and use API keys.
3. Create a Trello Developer App to obtain an API key and token. Grant read access to the boards.
4. Replace your_trello_api_key, your_trello_token, and your_board_id with your actual Trello API key, token, and board ID.

Step 1: Retrieve Trello users

Use a Trello API GET /boards/{board_id}/members request to get users from the Trello board.

# Step 1: Retrieve Trello users
def get_trello_users(board_id):
    url = f"{TRELLO_API_URL}/boards/{board_id}/members"
    params = {"key": TRELLO_API_KEY, "token": TRELLO_TOKEN}
    response = requests.get(url, params=params)

    if response.status_code == 200:
        users = response.json()
        return [{"name": user["fullName"], "username": user["username"]} for user in users]
    else:
        print(f"Failed to retrieve Trello users: {response.status_code} - {response.text}")
        return []

if __name__ == '__main__':
    trello_users = get_trello_users(TRELLO_BOARD_ID)

Step 2: Add Trello users to ONLYOFFICE Apps

Use a POST /api/2.0/people request to add new ONLYOFFICE Apps users.

# Step 2: Add Trello users to ONLYOFFICE Apps
def add_user_to_docspace(name, username, password):
    url = f'https://{ONLYOFFICE_API_HOST}/api/2.0/people'
    data = {
        'password': password,
        'firstName': name,
        'lastName': '',
        'email': f'{username}@docspace.com'
    }
    response = requests.post(url, json=data, headers=ONLYOFFICE_HEADERS)
    if response.status_code == 200:
        user_id = response.json()['response']['id']
        print('User created successfully:', user_id)
        return user_id
    else:
        print('Failed to create user:', response.status_code, response.text)
        return None

if __name__ == '__main__':
    PASSWORD = 'DocSpace123' # Replace with any temporary password or generate unique

    trello_users = get_trello_users(TRELLO_BOARD_ID)

    for user in trello_users:
        add_user_to_docspace(user['name'], user['username'], PASSWORD)