mrw34/gist:b12531d1a8df25f6c170

Last active May 21, 2024 10:47

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mrw34/b12531d1a8df25f6c170.js"></script>
Save mrw34/b12531d1a8df25f6c170 to your computer and use it in GitHub Desktop.

Download ZIP

Trello JSON to CSV conversion using jq

Raw

gistfile1.sh

jq -r '["List", "Card"], ((reduce .lists[] as $list ({}; .[$list.id] = $list.name)) as $lists | .cards[] | select(.closed != true) | [$lists[.idList],.name]) | @csv' <nw3RUeLl.json

ndtreviv commented Jul 19, 2022 •

edited

Loading

Feature request: Include description, and labels?

jq -r '["List", "Card", "Description"], ((reduce .lists[] as $list ({}; .[$list.id] = $list.name)) as $lists | .cards[] | select(.closed != true) | [$lists[.idList],.name,.desc]) | @csv' <nw3RUeLl.json

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment