I'm trying to pare Trello boards in order to highlight differences. You can easily download a board in JSON format from Trello by replacing the board's name with ".json" in the url:
.json
This requires you to be authenticated with Trello, however. Is there a way to get this exact JSON output directly out of the Trello API? There are ways of getting each of the child objects from the API, but I don't see a way to extract an entire JSON representation of the board and everything related to it.
Any help greatly appreciated!
I'm trying to pare Trello boards in order to highlight differences. You can easily download a board in JSON format from Trello by replacing the board's name with ".json" in the url:
http://trello./b/board_id_here.json
This requires you to be authenticated with Trello, however. Is there a way to get this exact JSON output directly out of the Trello API? There are ways of getting each of the child objects from the API, but I don't see a way to extract an entire JSON representation of the board and everything related to it.
Any help greatly appreciated!
Share Improve this question edited Jul 7, 2023 at 6:33 Brian Tompsett - 汤莱恩 5,89372 gold badges61 silver badges133 bronze badges asked Jul 13, 2015 at 18:02 sillfishessillfishes 3903 silver badges9 bronze badges 1- 1 Were you ever able to resolve this? I'm trying to do the same thing so I can work with it in Power BI and it's getting really frustrating. – SqlRyan Commented Jul 13, 2018 at 18:20
1 Answer
Reset to default 7That backup route is just a synonym for GET
ting /1/boards/board_id_here
with the following parameters:
fields: "all"
actions: "all"
action_fields: "all"
actions_limit: 1000
cards: "all"
card_fields: "all"
card_attachments: true
labels: "all"
lists: "all"
list_fields: "all"
members: "all"
member_fields: "all"
checklists: "all"
checklist_fields: "all"
organization: false
Summing everything up in a cURL request*:
curl --location --request GET 'https://api.trello./1/boards/{{ BOARD_ID }}/?filters=all&actions=all&action_fields=all&actions_limit=1000&cards=all&card_fields=all&card_attachments=true&labels=all&lists=all&list_fields=all&members=all&member_fields=all&checklists=all&checklist_fields=all&organization=false' \
--header 'Content-Type: application/json' \
--data '{
"key": "{{ KEY }}",
"token": "{{ TOKEN }}"
}'
- You can easily import and execute this request in POSTMAN: First, replace the 3 {{ dynamic }} variables with the Board ID, API KEY and TOKEN, then go to
Import > Raw Text
then paste the code above and execute.