Table: trello_organization - Query Trello Organizations using SQL

Trello Organizations represent a team or group within Trello. They are used to group together boards and users to create a shared workspace. They provide a way to manage permissions across several boards at once.

Table Usage Guide

The trello_organization table provides insights into Trello Organizations. As a project manager or team leader, explore organization-specific details through this table, including names, descriptions, and associated boards. Utilize it to uncover information about organizations, such as their membership, associated boards, and the level of visibility of each board within the organization.

Important Notes

You must specify Organization ID, id, in the where clause to query this table

Examples

Basic info

Explore basic information about a specific Trello organization, such as its name, description, and website. This can be useful for understanding the organization's online presence and identity.

select
  id,
  name,
  description,
  display_name,
  url,
  website
from
  trello_organization
where
  id = '123ace0f581f4de8a0dc184c';

select
  id,
  name,
  description,
  display_name,
  url,
  website
from
  trello_organization
where
  id = '123ace0f581f4de8a0dc184c';

List the members assigned to a particular organization

Explore which users are linked to a specific organization. This can be useful for assessing membership or participation within certain organizational structures.

select
  m.id as member_id,
  username,
  o.id as organization_id,
  o.name as organization_name
from
  trello_member m,
  jsonb_array_elements_text(m.id_organizations) ido,
  trello_organization o
where
  o.id = ido
  and o.id = '123ace0f581f4de8a0dc184c';

select
  m.id as member_id,
  username,
  o.id as organization_id,
  o.name as organization_name
from
  trello_member m,
  json_each(m.id_organizations) as ido,
  trello_organization o
where
  o.id = ido.value
  and o.id = '123ace0f581f4de8a0dc184c';

List details of the board associated to a particular organization

Explore the characteristics of a specific organization's board. This query is useful for gaining insights into the board's status, description, and accessibility, which can aid in organizational management and planning.

select
  b.id,
  b.name,
  b.description,
  b.id_organization,
  b.closed,
  b.url
from
  trello_board as b,
  trello_organization as o
where
  b.id_organization = o.id
  and b.id_organization = '1234ce0f581f4de8a0dc184c';

select
  b.id,
  b.name,
  b.description,
  b.id_organization,
  b.closed,
  b.url
from
  trello_board as b,
  trello_organization as o
where
  b.id_organization = o.id
  and b.id_organization = '1234ce0f581f4de8a0dc184c';

Schema for trello_organization

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
description	text		The description or summary of the organization.
display_name	text		The display name of the organization.
id	text	=	The unique identifier for the organization.
member_id	text	=, !=, ~~, ~~, !~~, !~~	The unique identifier of the member.
name	text		The name of the organization.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		The organization tags.
title	text		The title of the organization.
url	text		The URL of the organization.
website	text		The website associated with the organization.

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_organization