Salesforce Integration: Pulling lists into SF Dashboard

[Jason Roth]

With SF>Trello integration, is it possible to pull a "Trello list" into a Salesforce dashboard? Thanks, Jason

[Neha Jain]

Using Rest api we can get lists from trello to salesforce using apex, and then we can show those records in report and dashboard.

I have tried this successfully using both postman and salesforce with trello api.

https://developer.atlassian.com/cloud/trello/rest/api-group-lists/ 
https://developer.atlassian.com/cloud/trello/rest/api-group-cards/#api-cards-id-get

For Getting List Info

Request: https://api.trello.com/1/lists/{id}?key=APIKey&token=APIToken

Response:
{
"id": "6433cd0139f7fae3c0c8b483",
"name": "myList",
"closed": false,
"idBoard": "6433b351b3a818b8018b6ea0",
"pos": 114688,
"subscribed": false,
"softLimit": null,
"status": null,
"limits": {
"cards": {
"openPerList": {
"status": "ok",
"disableAt": 5000,
"warnAt": 4000
},
"totalPerList": {
"status": "ok",
"disableAt": 1000000,
"warnAt": 800000
}
}
},
"creationMethod": null,
"idOrganization": "6433b34bfa0fa3ceb6955c51"
}
For Getting Cards In a List
Request: https://api.trello.com/1/lists/{id}/cards?key=APIKey&token=APIToken
Response:
[
{
"id": "6433cd07cb13ecab2ee89734",
"badges": {
"attachmentsByType": {
"trello": {
"board": 0,
"card": 0
}
},
"location": false,
"votes": 0,
"viewingMemberVoted": false,
"subscribed": false,
"fogbugz": "",
"checkItems": 0,
"checkItemsChecked": 0,
"checkItemsEarliestDue": null,
"comments": 0,
"attachments": 0,
"description": false,
"due": null,
"dueComplete": false,
"start": null
},
"checkItemStates": null,
"closed": false,
"dueComplete": false,
"dateLastActivity": "2023-04-10T08:47:03.930Z",
"desc": "",
"descData": {
"emoji": {}
},
"due": null,
"dueReminder": null,
"email": null,
"idBoard": "6433b351b3a818b8018b6ea0",
"idChecklists": [],
"idList": "6433cd0139f7fae3c0c8b483",
"idMembers": [],
"idMembersVoted": [],
"idShort": 7,
"idAttachmentCover": null,
"labels": [],
"idLabels": [],
"manualCoverAttachment": false,
"name": "card1",
"pos": 65535,
"shortLink": "TgyIZaIo",
"shortUrl": "https://trello.com/c/TgyIZaIo",
"start": null,
"subscribed": false,
"url": "https://trello.com/c/TgyIZaIo/7-sddasdasd",
"cover": {
"idAttachment": null,
"color": null,
"idUploadedBackground": null,
"size": "normal",
"brightness": "dark",
"idPlugin": null
},
"isTemplate": false,
"cardRole": null
},
{
"id": "6433cd0aedb1ce8cb1d64672",
"badges": {
"attachmentsByType": {
"trello": {
"board": 0,
"card": 0
}
},
"location": false,
"votes": 0,
"viewingMemberVoted": false,
"subscribed": false,
"fogbugz": "",
"checkItems": 0,
"checkItemsChecked": 0,
"checkItemsEarliestDue": null,
"comments": 0,
"attachments": 0,
"description": false,
"due": null,
"dueComplete": false,
"start": null
},
"checkItemStates": null,
"closed": false,
"dueComplete": false,
"dateLastActivity": "2023-04-10T08:47:06.544Z",
"desc": "",
"descData": {
"emoji": {}
},
"due": null,
"dueReminder": null,
"email": null,
"idBoard": "6433b351b3a818b8018b6ea0",
"idChecklists": [],
"idList": "6433cd0139f7fae3c0c8b483",
"idMembers": [],
"idMembersVoted": [],
"idShort": 8,
"idAttachmentCover": null,
"labels": [],
"idLabels": [],
"manualCoverAttachment": false,
"name": "card name 2",
"pos": 131071,
"shortLink": "uSkqoDme",
"shortUrl": "https://trello.com/c/uSkqoDme",
"start": null,
"subscribed": false,
"url": "https://trello.com/c/uSkqoDme/8-as",
"cover": {
"idAttachment": null,
"color": null,
"idUploadedBackground": null,
"size": "normal",
"brightness": "dark",
"idPlugin": null
},
"isTemplate": false,
"cardRole": null
},
{
"id": "6433cd0cce04ab156553be28",
"badges": {
"attachmentsByType": {
"trello": {
"board": 0,
"card": 0
}
},
"location": false,
"votes": 0,
"viewingMemberVoted": false,
"subscribed": false,
"fogbugz": "",
"checkItems": 0,
"checkItemsChecked": 0,
"checkItemsEarliestDue": null,
"comments": 0,
"attachments": 0,
"description": false,
"due": null,
"dueComplete": false,
"start": null
},
"checkItemStates": null,
"closed": false,
"dueComplete": false,
"dateLastActivity": "2023-04-10T08:47:08.103Z",
"desc": "",
"descData": {
"emoji": {}
},
"due": null,
"dueReminder": null,
"email": null,
"idBoard": "6433b351b3a818b8018b6ea0",
"idChecklists": [],
"idList": "6433cd0139f7fae3c0c8b483",
"idMembers": [],
"idMembersVoted": [],
"idShort": 9,
"idAttachmentCover": null,
"labels": [],
"idLabels": [],
"manualCoverAttachment": false,
"name": "a",
"pos": 196607,
"shortLink": "hfxcEUhB",
"shortUrl": "https://trello.com/c/hfxcEUhB",
"start": null,
"subscribed": false,
"url": "https://trello.com/c/hfxcEUhB/9-a",
"cover": {
"idAttachment": null,
"color": null,
"idUploadedBackground": null,
"size": "normal",
"brightness": "dark",
"idPlugin": null
},
"isTemplate": false,
"cardRole": null
},
{
"id": "6433cd0db0c129ba97844a19",
"badges": {
"attachmentsByType": {
"trello": {
"board": 0,
"card": 0
}
},
"location": false,
"votes": 0,
"viewingMemberVoted": false,
"subscribed": false,
"fogbugz": "",
"checkItems": 0,
"checkItemsChecked": 0,
"checkItemsEarliestDue": null,
"comments": 0,
"attachments": 0,
"description": false,
"due": null,
"dueComplete": false,
"start": null
},
"checkItemStates": null,
"closed": false,
"dueComplete": false,
"dateLastActivity": "2023-04-10T08:47:09.803Z",
"desc": "",
"descData": {
"emoji": {}
},
"due": null,
"dueReminder": null,
"email": null,
"idBoard": "6433b351b3a818b8018b6ea0",
"idChecklists": [],
"idList": "6433cd0139f7fae3c0c8b483",
"idMembers": [],
"idMembersVoted": [],
"idShort": 10,
"idAttachmentCover": null,
"labels": [],
"idLabels": [],
"manualCoverAttachment": false,
"name": "s",
"pos": 262143,
"shortLink": "P59cCHXU",
"shortUrl": "https://trello.com/c/P59cCHXU",
"start": null,
"subscribed": false,
"url": "https://trello.com/c/P59cCHXU/10-s",
"cover": {
"idAttachment": null,
"color": null,
"idUploadedBackground": null,
"size": "normal",
"brightness": "dark",
"idPlugin": null
},
"isTemplate": false,
"cardRole": null
},
{
"id": "6433cd615fa949a9bef375a9",
"badges": {
"attachmentsByType": {
"trello": {
"board": 0,
"card": 0
}
},
"location": false,
"votes": 0,
"viewingMemberVoted": false,
"subscribed": false,
"fogbugz": "",
"checkItems": 0,
"checkItemsChecked": 0,
"checkItemsEarliestDue": null,
"comments": 0,
"attachments": 1,
"description": true,
"due": null,
"dueComplete": false,
"start": null
},
"checkItemStates": null,
"closed": false,
"dueComplete": false,
"dateLastActivity": "2023-04-10T08:49:19.039Z",
"desc": "hello descriotion",
"descData": {
"emoji": {}
},
"due": null,
"dueReminder": null,
"email": null,
"idBoard": "6433b351b3a818b8018b6ea0",
"idChecklists": [],
"idList": "6433cd0139f7fae3c0c8b483",
"idMembers": [],
"idMembersVoted": [],
"idShort": 11,
"idAttachmentCover": "6433cd8e19d18b4ab7d33dd8",
"labels": [],
"idLabels": [],
"manualCoverAttachment": false,
"name": "d",
"pos": 327679,
"shortLink": "ulEv8Ybi",
"shortUrl": "https://trello.com/c/ulEv8Ybi",
"start": null,
"subscribed": false,
"url": "https://trello.com/c/ulEv8Ybi/11-d",
"cover": {
"idAttachment": "6433cd8e19d18b4ab7d33dd8",
"color": null,
"idUploadedBackground": null,
"size": "normal",
"brightness": "dark",
"idPlugin": null
},
"isTemplate": false,
"cardRole": null
}
]

For more APIs, u can refer to the below link.
https://developer.atlassian.com/cloud/trello/rest/api-group-actions/

[Rafael Dill]

Hi Jason, welcome to the community! Are you using the Power-up? Looking at our guide I could see that the information only comes from SF and goes to Trello, not the other way around.

Hope the information helps!

[Jason Roth]

OK thanks.