Cmdlets for Trello

Build 21.0.7930

Fine-Tuning Data Access

Custom Connection Properties

OrganizationId

The Trello OrganizationId when you specify it in the connection string, references a specific Trello organization. If specified the range of some queries will be bound to that organization for ex.

SELECT * FROM Lists
will return all lists of the boards on that organization.
SELECT * FROM Memberships
will return all members of the organization.
SELECT * FROM Actions
will return all actions actions on the organization.

BoardId

The Trello BoardId when you specify it in the connection string, references a specific Trello board. If specified the range of some queries will be bound to that board for ex.

SELECT * FROM Lists
will return all lists of the board.
SELECT * FROM Memberships
will return all members of the board.
SELECT * FROM Actions
will return all Actions of the board. Because a board can have many actions the query may take a while wto execute.

MemberId

The Trello MemberId when you specify it in the connection string, references a specific Trello member. If specified the range of some queries will be bound to that member for ex.

SELECT * FROM Actions
will return all actions of that member
SELECT * FROM Boards
will return all boards that both the logged user and member specified have in common.

IncludeCustomFields

Custom Fields is one of the most popular power ups found on Trello. To begin using Custom fields first activate the power up in your Trello board and create/add custom fields to your cards. In order to use IncludeCustomFields set it to true and specify the BoardId in the connection string. This connection property is used for retrieving custom fields that have been created on Trellos cards.

SELECT * FROM Cards
Running the query above will list all the custom fields created as table columns. The column name will be the custom field name and the row value will be the value of the custom field. In case of a custom field of type dropdown list the name of the option selected will be shown.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930