Lianja
Lianja
Trello List Member Boards
See more Trello Examples
Lists the boards that the user is a member of.For more information, see https://developers.trello.com/reference#membersidboards
Chilkat Lianja Downloads
llSuccess = .F.
// 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.
loJsonToken = createobject("CkJsonObject")
llSuccess = loJsonToken.LoadFile("qa_data/tokens/trello.json")
loOauth1 = createobject("CkOAuth1")
loOauth1.ConsumerKey = "TRELLO_CONSUMER_KEY"
loOauth1.ConsumerSecret = "TRELLO_CONSUMER_SECRET"
loOauth1.Token = loJsonToken.StringOf("oauth_token")
loOauth1.TokenSecret = loJsonToken.StringOf("oauth_token_secret")
loRest = createobject("CkRest")
// 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.
llBAutoReconnect = .T.
llSuccess = loRest.Connect("api.trello.com",443,.T.,llBAutoReconnect)
if (llSuccess <> .T.) then
? loRest.LastErrorText
release loJsonToken
release loOauth1
release loRest
return
endif
loRest.SetAuthOAuth1(loOauth1,.F.)
loRest.AddQueryParam("filter","all")
loRest.AddQueryParam("fields","all")
loRest.AddQueryParam("lists","none")
loRest.AddQueryParam("memberships","normal")
loRest.AddQueryParam("organization","false")
loRest.AddQueryParam("organization_fields","name,displayName")
loRest.AddHeader("Accept","application/json")
lcResponseBody = loRest.FullRequestNoBody("GET","/1/members/member_id/boards")
if (loRest.LastMethodSuccess <> .T.) then
? loRest.LastErrorText
release loJsonToken
release loOauth1
release loRest
return
endif
// We should expect a 200 response if successful.
if (loRest.ResponseStatusCode <> 200) then
? "Request Header: "
? loRest.LastRequestHeader
? "----"
? "Response StatusCode = " + str(loRest.ResponseStatusCode)
? "Response StatusLine: " + loRest.ResponseStatusText
? "Response Header:"
? loRest.ResponseHeader
? lcResponseBody
release loJsonToken
release loOauth1
release loRest
return
endif
loJarr = createobject("CkJsonArray")
loJarr.Load(lcResponseBody)
loJarr.EmitCompact = .F.
? loJarr.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
lnCount_i = loJarr.Size
do while i < lnCount_i
loJson = loJarr.ObjectAt(i)
lcName = loJson.StringOf("name")
lcDesc = loJson.StringOf("desc")
lcDescData = loJson.StringOf("descData")
llClosed = loJson.BoolOf("closed")
lcIdOrganization = loJson.StringOf("idOrganization")
lcLimits = loJson.StringOf("limits")
lcPinned = loJson.StringOf("pinned")
lcShortLink = loJson.StringOf("shortLink")
lcDateLastActivity = loJson.StringOf("dateLastActivity")
lcDatePluginDisable = loJson.StringOf("datePluginDisable")
lcCreationMethod = loJson.StringOf("creationMethod")
lcIxUpdate = loJson.StringOf("ixUpdate")
lcId = loJson.StringOf("id")
llStarred = loJson.BoolOf("starred")
lcUrl = loJson.StringOf("url")
lcPrefsPermissionLevel = loJson.StringOf("prefs.permissionLevel")
lcPrefsVoting = loJson.StringOf("prefs.voting")
lcPrefsComments = loJson.StringOf("prefs.comments")
lcPrefsInvitations = loJson.StringOf("prefs.invitations")
llPrefsSelfJoin = loJson.BoolOf("prefs.selfJoin")
llPrefsCardCovers = loJson.BoolOf("prefs.cardCovers")
lcPrefsCardAging = loJson.StringOf("prefs.cardAging")
llPrefsCalendarFeedEnabled = loJson.BoolOf("prefs.calendarFeedEnabled")
lcPrefsBackground = loJson.StringOf("prefs.background")
lcPrefsBackgroundImage = loJson.StringOf("prefs.backgroundImage")
llPrefsBackgroundTile = loJson.BoolOf("prefs.backgroundTile")
lcPrefsBackgroundBrightness = loJson.StringOf("prefs.backgroundBrightness")
lcPrefsBackgroundBottomColor = loJson.StringOf("prefs.backgroundBottomColor")
lcPrefsBackgroundTopColor = loJson.StringOf("prefs.backgroundTopColor")
llPrefsCanBePublic = loJson.BoolOf("prefs.canBePublic")
llPrefsCanBeEnterprise = loJson.BoolOf("prefs.canBeEnterprise")
llPrefsCanBeOrg = loJson.BoolOf("prefs.canBeOrg")
llPrefsCanBePrivate = loJson.BoolOf("prefs.canBePrivate")
llPrefsCanInvite = loJson.BoolOf("prefs.canInvite")
llSubscribed = loJson.BoolOf("subscribed")
lcLabelNamesGreen = loJson.StringOf("labelNames.green")
lcLabelNamesYellow = loJson.StringOf("labelNames.yellow")
lcLabelNamesOrange = loJson.StringOf("labelNames.orange")
lcLabelNamesRed = loJson.StringOf("labelNames.red")
lcLabelNamesPurple = loJson.StringOf("labelNames.purple")
lcLabelNamesBlue = loJson.StringOf("labelNames.blue")
lcLabelNamesSky = loJson.StringOf("labelNames.sky")
lcLabelNamesLime = loJson.StringOf("labelNames.lime")
lcLabelNamesPink = loJson.StringOf("labelNames.pink")
lcLabelNamesBlack = loJson.StringOf("labelNames.black")
lcDateLastView = loJson.StringOf("dateLastView")
lcShortUrl = loJson.StringOf("shortUrl")
lcPrefsBackgroundImageScaled = loJson.StringOf("prefs.backgroundImageScaled")
lcPrefsBackgroundColor = loJson.StringOf("prefs.backgroundColor")
j = 0
lnCount_j = loJson.SizeOfArray("powerUps")
do while j < lnCount_j
loJson.J = j
// ...
j = j + 1
enddo
j = 0
lnCount_j = loJson.SizeOfArray("idTags")
do while j < lnCount_j
loJson.J = j
// ...
j = j + 1
enddo
j = 0
lnCount_j = loJson.SizeOfArray("prefs.backgroundImageScaled")
do while j < lnCount_j
loJson.J = j
lnWidth = loJson.IntOf("prefs.backgroundImageScaled[j].width")
lnHeight = loJson.IntOf("prefs.backgroundImageScaled[j].height")
lcUrl = loJson.StringOf("prefs.backgroundImageScaled[j].url")
j = j + 1
enddo
j = 0
lnCount_j = loJson.SizeOfArray("memberships")
do while j < lnCount_j
loJson.J = j
lcId = loJson.StringOf("memberships[j].id")
lcIdMember = loJson.StringOf("memberships[j].idMember")
lcMemberType = loJson.StringOf("memberships[j].memberType")
llUnconfirmed = loJson.BoolOf("memberships[j].unconfirmed")
llDeactivated = loJson.BoolOf("memberships[j].deactivated")
j = j + 1
enddo
release loJson
i = i + 1
enddo
release loJsonToken
release loOauth1
release loRest
release loJarr