(PowerShell) Trello List Member Boards

Lists the boards that the user is a member of.

For more information, see https://developers.trello.com/reference#membersidboards

Chilkat .NET Downloads Chilkat .NET Assemblies

Add-Type -Path "C:\chilkat\ChilkatDotNet47-9.5.0-x64\ChilkatDotNet47.dll"

# This example assumes the Chilkat API to have been previously unlocked.
# See Global Unlock Sample for sample code.

# curl --request GET \
#   --url 'https://api.trello.com/1/members/{member_id}/boards?filter=all&fields=all&lists=none&memberships=none&organization=false&organization_fields=displayName'

# First get our previously obtained access token.
$jsonToken = New-Object Chilkat.JsonObject
$success = $jsonToken.LoadFile("qa_data/tokens/trello.json")

$oauth1 = New-Object Chilkat.OAuth1
$oauth1.ConsumerKey = "TRELLO_CONSUMER_KEY"
$oauth1.ConsumerSecret = "TRELLO_CONSUMER_SECRET"
$oauth1.Token = $jsonToken.StringOf("oauth_token")
$oauth1.TokenSecret = $jsonToken.StringOf("oauth_token_secret")

$rest = New-Object Chilkat.Rest

# Connect using TLS.
# A single REST object, once connected, can be used for many Trello REST API calls.
# The auto-reconnect indicates that if the already-established HTTPS connection is closed,
# then it will be automatically re-established as needed.
$bAutoReconnect = $true
$success = $rest.Connect("api.trello.com",443,$true,$bAutoReconnect)
if ($success -ne $true) {
    $($rest.LastErrorText)
    exit
}

$rest.SetAuthOAuth1($oauth1,$false)

$rest.AddQueryParam("filter","all")
$rest.AddQueryParam("fields","all")
$rest.AddQueryParam("lists","none")
$rest.AddQueryParam("memberships","normal")
$rest.AddQueryParam("organization","false")
$rest.AddQueryParam("organization_fields","name,displayName")

$rest.AddHeader("Accept","application/json")

$responseBody = $rest.FullRequestNoBody("GET","/1/members/member_id/boards")
if ($rest.LastMethodSuccess -ne $true) {
    $($rest.LastErrorText)
    exit
}

# We should expect a 200 response if successful.
if ($rest.ResponseStatusCode -ne 200) {
    $("Request Header: ")
    $($rest.LastRequestHeader)
    $("----")
    $("Response StatusCode = " + $rest.ResponseStatusCode)
    $("Response StatusLine: " + $rest.ResponseStatusText)
    $("Response Header:")
    $($rest.ResponseHeader)
    $($responseBody)
    exit
}

$jarr = New-Object Chilkat.JsonArray
$jarr.Load($responseBody)
$jarr.EmitCompact = $false
$($jarr.Emit())
$("Success.")

# A sample JSON response:
# (See the parsing code below...)

# Use this online tool to generate parsing code from sample JSON: 
# Generate Parsing Code from JSON

# [
#   {
#     "name": "House Projects",
#     "desc": "",
#     "descData": null,
#     "closed": false,
#     "idOrganization": null,
#     "limits": null,
#     "pinned": null,
#     "shortLink": "j1hkQKKS",
#     "powerUps": [
#     ],
#     "dateLastActivity": null,
#     "idTags": [
#     ],
#     "datePluginDisable": null,
#     "creationMethod": null,
#     "ixUpdate": null,
#     "id": "5cc5fe862106bb8e05aa41e7",
#     "starred": false,
#     "url": "https://trello.com/b/j1hkQKKS/house-projects",
#     "prefs": {
#       "permissionLevel": "private",
#       "voting": "disabled",
#       "comments": "members",
#       "invitations": "members",
#       "selfJoin": false,
#       "cardCovers": true,
#       "cardAging": "regular",
#       "calendarFeedEnabled": false,
#       "background": "5cc344f6ba4cdc5f5cfc7d81",
#       "backgroundImage": "https://trello-backgrounds.s3.amazonaws.com/SharedBackground/2560x1709/4418c78f2f66d26932fef88aead2aff5/photo-1555985202-12975b0235dc",
#       "backgroundImageScaled": [
#         {
#           "width": 140,
#           "height": 93,
#           "url": "https://trello-backgrounds.s3.amazonaws.com/SharedBackground/140x93/0aebced0ac2d8c9c4b9231b1960d28c2/photo-1555985202-12975b0235dc.jpg"
#         },
#  ...
#         {
#           "width": 2560,
#           "height": 1709,
#           "url": "https://trello-backgrounds.s3.amazonaws.com/SharedBackground/2560x1709/4418c78f2f66d26932fef88aead2aff5/photo-1555985202-12975b0235dc"
#         }
#       ],
#       "backgroundTile": false,
#       "backgroundBrightness": "dark",
#       "backgroundBottomColor": "#412f23",
#       "backgroundTopColor": "#a99d97",
#       "canBePublic": true,
#       "canBeEnterprise": true,
#       "canBeOrg": true,
#       "canBePrivate": true,
#       "canInvite": true
#     },
#     "subscribed": false,
#     "labelNames": {
#       "green": "",
#       "yellow": "",
#       "orange": "",
#       "red": "",
#       "purple": "",
#       "blue": "",
#       "sky": "",
#       "lime": "",
#       "pink": "",
#       "black": ""
#     },
#     "dateLastView": "2019-04-28T19:28:18.159Z",
#     "shortUrl": "https://trello.com/b/j1hkQKKS",
#     "memberships": [
#       {
#         "id": "5cc5fe862106bb8e05aa41e8",
#         "idMember": "5cc5c74067d5215921ca7677",
#         "memberType": "admin",
#         "unconfirmed": false,
#         "deactivated": false
#       }
#     ]
#   },
#   {
#     "name": "Vacation Planning",
#     "desc": "",
#     "descData": null,
#     "closed": false,
#     "idOrganization": null,
#     "limits": null,
#     "pinned": null,
#     "shortLink": "QqIHvQyz",
#     "powerUps": [
#     ],
#     "dateLastActivity": "2019-04-28T15:32:20.134Z",
#     "idTags": [
#     ],
#     "datePluginDisable": null,
#     "creationMethod": "assisted",
#     "ixUpdate": null,
#     "id": "5cc5c783f5b10f8717a6b3d6",
#     "starred": false,
#     "url": "https://trello.com/b/QqIHvQyz/vacation-planning",
#     "prefs": {
#       "permissionLevel": "private",
#       "voting": "disabled",
#       "comments": "members",
#       "invitations": "members",
#       "selfJoin": true,
#       "cardCovers": true,
#       "cardAging": "regular",
#       "calendarFeedEnabled": false,
#       "background": "lime",
#       "backgroundImage": null,
#       "backgroundImageScaled": null,
#       "backgroundTile": false,
#       "backgroundBrightness": "dark",
#       "backgroundColor": "#4BBF6B",
#       "backgroundBottomColor": "#4BBF6B",
#       "backgroundTopColor": "#4BBF6B",
#       "canBePublic": true,
#       "canBeEnterprise": true,
#       "canBeOrg": true,
#       "canBePrivate": true,
#       "canInvite": true
#     },
#     "subscribed": false,
#     "labelNames": {
#       "green": "",
#       "yellow": "",
#       "orange": "",
#       "red": "",
#       "purple": "",
#       "blue": "",
#       "sky": "",
#       "lime": "",
#       "pink": "",
#       "black": ""
#     },
#     "dateLastView": "2019-04-28T19:32:21.009Z",
#     "shortUrl": "https://trello.com/b/QqIHvQyz",
#     "memberships": [
#       {
#         "id": "5cc5c783f5b10f8717a6b3d7",
#         "idMember": "5cc5c74067d5215921ca7677",
#         "memberType": "admin",
#         "unconfirmed": false,
#         "deactivated": false
#       }
#     ]
#   }
# ]

$i = 0
$count_i = $jarr.Size
while ($i -lt $count_i) {
    $json = $jarr.ObjectAt($i)
    $name = $json.StringOf("name")
    $desc = $json.StringOf("desc")
    $descData = $json.StringOf("descData")
    $closed = $json.BoolOf("closed")
    $idOrganization = $json.StringOf("idOrganization")
    $limits = $json.StringOf("limits")
    $pinned = $json.StringOf("pinned")
    $shortLink = $json.StringOf("shortLink")
    $dateLastActivity = $json.StringOf("dateLastActivity")
    $datePluginDisable = $json.StringOf("datePluginDisable")
    $creationMethod = $json.StringOf("creationMethod")
    $ixUpdate = $json.StringOf("ixUpdate")
    $id = $json.StringOf("id")
    $starred = $json.BoolOf("starred")
    $url = $json.StringOf("url")
    $prefsPermissionLevel = $json.StringOf("prefs.permissionLevel")
    $prefsVoting = $json.StringOf("prefs.voting")
    $prefsComments = $json.StringOf("prefs.comments")
    $prefsInvitations = $json.StringOf("prefs.invitations")
    $prefsSelfJoin = $json.BoolOf("prefs.selfJoin")
    $prefsCardCovers = $json.BoolOf("prefs.cardCovers")
    $prefsCardAging = $json.StringOf("prefs.cardAging")
    $prefsCalendarFeedEnabled = $json.BoolOf("prefs.calendarFeedEnabled")
    $prefsBackground = $json.StringOf("prefs.background")
    $prefsBackgroundImage = $json.StringOf("prefs.backgroundImage")
    $prefsBackgroundTile = $json.BoolOf("prefs.backgroundTile")
    $prefsBackgroundBrightness = $json.StringOf("prefs.backgroundBrightness")
    $prefsBackgroundBottomColor = $json.StringOf("prefs.backgroundBottomColor")
    $prefsBackgroundTopColor = $json.StringOf("prefs.backgroundTopColor")
    $prefsCanBePublic = $json.BoolOf("prefs.canBePublic")
    $prefsCanBeEnterprise = $json.BoolOf("prefs.canBeEnterprise")
    $prefsCanBeOrg = $json.BoolOf("prefs.canBeOrg")
    $prefsCanBePrivate = $json.BoolOf("prefs.canBePrivate")
    $prefsCanInvite = $json.BoolOf("prefs.canInvite")
    $subscribed = $json.BoolOf("subscribed")
    $labelNamesGreen = $json.StringOf("labelNames.green")
    $labelNamesYellow = $json.StringOf("labelNames.yellow")
    $labelNamesOrange = $json.StringOf("labelNames.orange")
    $labelNamesRed = $json.StringOf("labelNames.red")
    $labelNamesPurple = $json.StringOf("labelNames.purple")
    $labelNamesBlue = $json.StringOf("labelNames.blue")
    $labelNamesSky = $json.StringOf("labelNames.sky")
    $labelNamesLime = $json.StringOf("labelNames.lime")
    $labelNamesPink = $json.StringOf("labelNames.pink")
    $labelNamesBlack = $json.StringOf("labelNames.black")
    $dateLastView = $json.StringOf("dateLastView")
    $shortUrl = $json.StringOf("shortUrl")
    $prefsBackgroundImageScaled = $json.StringOf("prefs.backgroundImageScaled")
    $prefsBackgroundColor = $json.StringOf("prefs.backgroundColor")
    $j = 0
    $count_j = $json.SizeOfArray("powerUps")
    while ($j -lt $count_j) {
        $json.J = $j
        # ...
        $j = $j + 1
    }

    $j = 0
    $count_j = $json.SizeOfArray("idTags")
    while ($j -lt $count_j) {
        $json.J = $j
        # ...
        $j = $j + 1
    }

    $j = 0
    $count_j = $json.SizeOfArray("prefs.backgroundImageScaled")
    while ($j -lt $count_j) {
        $json.J = $j
        $width = $json.IntOf("prefs.backgroundImageScaled[j].width")
        $height = $json.IntOf("prefs.backgroundImageScaled[j].height")
        $url = $json.StringOf("prefs.backgroundImageScaled[j].url")
        $j = $j + 1
    }

    $j = 0
    $count_j = $json.SizeOfArray("memberships")
    while ($j -lt $count_j) {
        $json.J = $j
        $id = $json.StringOf("memberships[j].id")
        $idMember = $json.StringOf("memberships[j].idMember")
        $memberType = $json.StringOf("memberships[j].memberType")
        $unconfirmed = $json.BoolOf("memberships[j].unconfirmed")
        $deactivated = $json.BoolOf("memberships[j].deactivated")
        $j = $j + 1
    }

    $i = $i + 1
}