JSON structure - Card history

[Vantroeyen Eric]

Hello

I'd like to use JSON export to analyse retrospectively the activity of each card (from one list to an other). I haven't seen any add-on tool that would allow me to do this.

If there is something, please let me know.

Where can I find a documentation about the data returned by an export ?

and/or what are the objects I should analyse to find the card history ?

Thanks in advance

[Mike · Accepted solution]

Hi there,

We've got some information here on how to use the JSON export, but it's not exhaustive: http://help.trello.com/article/924-making-sense-of-trellos-json-export

Generally speaking, the best way to build advanced reporting in Trello is via the API. If you haven't checked it out already, I'd recommend checking out the 'Getting Started' section of our developer documentation site: https://developers.trello.com. It will walk you through using the API to access your data in Trello.

Once you have gone through that and understand how to use a key and token to access data in the API, you may find the following query as a good starting place. It includes almost all of the information about a board, including pluginData: https://api.trello.com/1/boards/[boardId]?fields=all&cards=all&card_fields=all&pluginData=true&card_pluginData=true. You'd just need to replace [boardId] with the ID of your board.