steampipe plugin install trello

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,
initials
from
trello_my_member;
select
id,
username,
full_name,
email,
initials
from
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_name
from
trello_my_member m,
jsonb_array_elements_text(m.id_boards) idb,
trello_board b
where
b.id = idb;
select
m.id as member_id,
username,
b.id as board_id,
b.name as board_name
from
trello_my_member m,
json_each(m.id_boards) as idb,
trello_board b
where
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_name
from
trello_my_member m,
jsonb_array_elements_text(m.id_organizations) ido,
trello_organization o
where
o.id = ido;
select
m.id as member_id,
username,
o.id as organization_id,
o.name as organization_name
from
trello_my_member m,
json_each(m.id_organizations) as ido,
trello_organization o
where
o.id = ido.value;

Schema for trello_my_member

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
avatar_hashtextThe hash of the avatar of the member.
emailtextThe email address of the member.
full_nametextThe full name of the member.
idtextThe unique identifier of the member.
id_boardsjsonbAn array of board IDs that the member is on.
id_organizationsjsonbAn array of organization IDs that the member belongs to.
initialstextThe initials of the member.
titletextThe title of the member.
usernametextThe 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