|
Chilkat • HOME • .NET Core C# • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi ActiveX • Delphi DLL • Go • Java • Lianja • Mono C# • Node.js • Objective-C • PHP ActiveX • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift 2 • Swift 3,4,5... • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(Classic ASP) Trello List Member BoardsLists the boards that the user is a member of. For more information, see https://developers.trello.com/reference#membersidboards
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> </head> <body> <% ' 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. ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject") set jsonToken = Server.CreateObject("Chilkat.JsonObject") success = jsonToken.LoadFile("qa_data/tokens/trello.json") ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.OAuth1") set oauth1 = Server.CreateObject("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") ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Rest") set rest = Server.CreateObject("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 = 1 success = rest.Connect("api.trello.com",443,1,bAutoReconnect) If (success <> 1) Then Response.Write "<pre>" & Server.HTMLEncode( rest.LastErrorText) & "</pre>" Response.End End If success = rest.SetAuthOAuth1(oauth1,0) success = rest.AddQueryParam("filter","all") success = rest.AddQueryParam("fields","all") success = rest.AddQueryParam("lists","none") success = rest.AddQueryParam("memberships","normal") success = rest.AddQueryParam("organization","false") success = rest.AddQueryParam("organization_fields","name,displayName") success = rest.AddHeader("Accept","application/json") responseBody = rest.FullRequestNoBody("GET","/1/members/member_id/boards") If (rest.LastMethodSuccess <> 1) Then Response.Write "<pre>" & Server.HTMLEncode( rest.LastErrorText) & "</pre>" Response.End End If ' We should expect a 200 response if successful. If (rest.ResponseStatusCode <> 200) Then Response.Write "<pre>" & Server.HTMLEncode( "Request Header: ") & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( rest.LastRequestHeader) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "----") & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "Response StatusCode = " & rest.ResponseStatusCode) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "Response StatusLine: " & rest.ResponseStatusText) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "Response Header:") & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( rest.ResponseHeader) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( responseBody) & "</pre>" Response.End End If ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonArray") set jarr = Server.CreateObject("Chilkat.JsonArray") success = jarr.Load(responseBody) jarr.EmitCompact = 0 Response.Write "<pre>" & Server.HTMLEncode( jarr.Emit()) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( "Success.") & "</pre>" ' 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 Do While i < count_i ' json is a Chilkat.JsonObject Set 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") Do While j < count_j json.J = j ' ... j = j + 1 Loop j = 0 count_j = json.SizeOfArray("idTags") Do While j < count_j json.J = j ' ... j = j + 1 Loop j = 0 count_j = json.SizeOfArray("prefs.backgroundImageScaled") Do 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 Loop j = 0 count_j = json.SizeOfArray("memberships") Do 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 Loop i = i + 1 Loop %> </body> </html> |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.