Table: trello_my_member - Query Trello Members using SQL
Trello is a web-based, list-making application, originally made by Fog Creek Software in 2011. It operates via boards (which correspond to projects), lists (which correspond to task lists), and cards (which correspond to tasks). A Trello member refers to a user who has an account with Trello and can create and manage boards, lists, and cards.
Table Usage Guide
The trello_my_member
table provides insights into Trello members. As a project manager or team leader, explore member-specific details through this table, including full name, username, email, and avatar hash. Utilize it to uncover information about members, such as their activity on different boards and their interaction with various tasks.
Examples
Basic info
Explore which member details are available in your Trello account, such as user ID, username, full name, email, and initials. This can be useful in identifying and managing users, especially in a large team.
select id, username, full_name, email, initialsfrom trello_my_member;
select id, username, full_name, email, initialsfrom trello_my_member;
Get boards I have access to
Explore the various boards you have access to within Trello, allowing you to quickly identify and manage your permissions across different projects. This is particularly useful for understanding your involvement and access level across various team boards.
select m.id as member_id, username, b.id as board_id, b.name as board_namefrom trello_my_member m, jsonb_array_elements_text(m.id_boards) idb, trello_board bwhere b.id = idb;
select m.id as member_id, username, b.id as board_id, b.name as board_namefrom trello_my_member m, json_each(m.id_boards) as idb, trello_board bwhere b.id = idb.value;
Get organizations I have been assigned to
Explore which organizations you've been assigned to, providing a clear view of your involvement across different teams. This can help manage your tasks and collaborations more effectively.
select m.id as member_id, username, o.id as organization_id, o.name as organization_namefrom trello_my_member m, jsonb_array_elements_text(m.id_organizations) ido, trello_organization owhere o.id = ido;
select m.id as member_id, username, o.id as organization_id, o.name as organization_namefrom trello_my_member m, json_each(m.id_organizations) as ido, trello_organization owhere o.id = ido.value;
Schema for trello_my_member
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
avatar_hash | text | The hash of the avatar of the member. | |
text | The email address of the member. | ||
full_name | text | The full name of the member. | |
id | text | The unique identifier of the member. | |
id_boards | jsonb | An array of board IDs that the member is on. | |
id_organizations | jsonb | An array of organization IDs that the member belongs to. | |
initials | text | The initials of the member. | |
title | text | The title of the member. | |
username | text | The username of the member. |
Export
This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.
You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh
script:
/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- trello
You can pass the configuration to the command with the --config
argument:
steampipe_export_trello --config '<your_config>' trello_my_member