Pipe Trello Data to CSV in PowerShell

Ready to get started?

Download for a free trial:

Download Now

Learn more:

Trello Cmdlets

An easy-to-use set of PowerShell Cmdlets offering real-time access to Trello data. The Cmdlets allow users to easily query live data - just like working with SQL server.

Use standard PowerShell cmdlets to access Trello tables.

The CData Cmdlets Module for Trello is a standard PowerShell module offering straightforward integration with Trello. Below, you will find examples of using our Trello Cmdlets with native PowerShell cmdlets.

Creating a Connection to Your Trello Data

Trello uses token-based authentication to grant third-party applications access to their API. When a user has granted an application access to their data, the application is given a token that can be used to make requests to Trello's API.

Trello's API can be accessed in 2 different ways. The first is using Trello's own Authorization Route, and the second is using OAuth1.0.

  • Authorization Route: At the moment of registration, Trello assigns an API key and Token to the account. See the Help documentation for information on how to connect via the Authorization route.
  • OAuth Route: Similar to using Authorization, OAuth creates an Application Id and Secret when you create your account. See the Help documentation for information on how to to connect.

$conn = Connect-Trello  -APIKey "$APIKey" -Token "$Token"

Selecting Data

Follow the steps below to retrieve data from the Boards table and pipe the result into to a CSV file:

Select-Trello -Connection $conn -Table Boards | Select -Property * -ExcludeProperty Connection,Table,Columns | Export-Csv -Path c:\myBoardsData.csv -NoTypeInformation

You will notice that we piped the results from Select-Trello into a Select-Object cmdlet and excluded some properties before piping them into an Export-Csv cmdlet. We do this because the CData Cmdlets append Connection, Table, and Columns information onto each "row" in the result set, and we do not necessarily want that information in our CSV file.

The Connection, Table, and Columns are appended to the results in order to facilitate piping results from one of the CData Cmdlets directly into another one.