(VB.NET) 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 Framework Chilkat for .NET Core

' 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.
Dim jsonToken As New Chilkat.JsonObject
Dim success As Boolean = jsonToken.LoadFile("qa_data/tokens/trello.json")

Dim oauth1 As New 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")

Dim rest As New 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.
Dim bAutoReconnect As Boolean = True
success = rest.Connect("api.trello.com",443,True,bAutoReconnect)
If (success <> True) Then
    Debug.WriteLine(rest.LastErrorText)
    Exit Sub
End If


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")

Dim responseBody As String = rest.FullRequestNoBody("GET","/1/members/member_id/boards")
If (rest.LastMethodSuccess <> True) Then
    Debug.WriteLine(rest.LastErrorText)
    Exit Sub
End If


' We should expect a 200 response if successful.
If (rest.ResponseStatusCode <> 200) Then
    Debug.WriteLine("Request Header: ")
    Debug.WriteLine(rest.LastRequestHeader)
    Debug.WriteLine("----")
    Debug.WriteLine("Response StatusCode = " & rest.ResponseStatusCode)
    Debug.WriteLine("Response StatusLine: " & rest.ResponseStatusText)
    Debug.WriteLine("Response Header:")
    Debug.WriteLine(rest.ResponseHeader)
    Debug.WriteLine(responseBody)
    Exit Sub
End If


Dim jarr As New Chilkat.JsonArray
jarr.Load(responseBody)
jarr.EmitCompact = False
Debug.WriteLine(jarr.Emit())
Debug.WriteLine("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
'       }
'     ]
'   }
' ]


Dim i As Integer
Dim count_i As Integer
Dim json As Chilkat.JsonObject
Dim name As String
Dim desc As String
Dim descData As String
Dim closed As Boolean
Dim idOrganization As String
Dim limits As String
Dim pinned As String
Dim shortLink As String
Dim dateLastActivity As String
Dim datePluginDisable As String
Dim creationMethod As String
Dim ixUpdate As String
Dim id As String
Dim starred As Boolean
Dim url As String
Dim prefsPermissionLevel As String
Dim prefsVoting As String
Dim prefsComments As String
Dim prefsInvitations As String
Dim prefsSelfJoin As Boolean
Dim prefsCardCovers As Boolean
Dim prefsCardAging As String
Dim prefsCalendarFeedEnabled As Boolean
Dim prefsBackground As String
Dim prefsBackgroundImage As String
Dim prefsBackgroundTile As Boolean
Dim prefsBackgroundBrightness As String
Dim prefsBackgroundBottomColor As String
Dim prefsBackgroundTopColor As String
Dim prefsCanBePublic As Boolean
Dim prefsCanBeEnterprise As Boolean
Dim prefsCanBeOrg As Boolean
Dim prefsCanBePrivate As Boolean
Dim prefsCanInvite As Boolean
Dim subscribed As Boolean
Dim labelNamesGreen As String
Dim labelNamesYellow As String
Dim labelNamesOrange As String
Dim labelNamesRed As String
Dim labelNamesPurple As String
Dim labelNamesBlue As String
Dim labelNamesSky As String
Dim labelNamesLime As String
Dim labelNamesPink As String
Dim labelNamesBlack As String
Dim dateLastView As String
Dim shortUrl As String
Dim prefsBackgroundImageScaled As String
Dim prefsBackgroundColor As String
Dim j As Integer
Dim count_j As Integer
Dim width As Integer
Dim height As Integer
Dim idMember As String
Dim memberType As String
Dim unconfirmed As Boolean
Dim deactivated As Boolean

i = 0
count_i = jarr.Size
While i < 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 < count_j
        json.J = j
        ' ...
        j = j + 1
    End While
    j = 0
    count_j = json.SizeOfArray("idTags")
    While j < count_j
        json.J = j
        ' ...
        j = j + 1
    End While
    j = 0
    count_j = json.SizeOfArray("prefs.backgroundImageScaled")
    While j < 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
    End While
    j = 0
    count_j = json.SizeOfArray("memberships")
    While j < 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
    End While

    i = i + 1
End While