andyburnett
andyburnett
/ Trello to Google Spreadsheet
Created
November 9, 2014 13:11
Convert Trello's JSON feed into simple Google Spreadsheet - this abstracts the text of the card, and the list name.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| temp1 := ZnEasy get: 'address in here'. | |
| trello := NeoJSONReader fromString: temp1 entity. | |
| trelloLists := trello at:'lists'. | |
| trelloCards := trello at:'cards'. | |
| trelloLists do: [ :each|| listId | | |
| listId := each at:'id'. | |
| each at:'cards' put: ((trelloCards select:[:item|(( item at:'idList')=listId)])collect:[:item| item at:'name']). | |
| ]. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ### Keybase proof | |
| I hereby claim: | |
| * I am andyburnett on github. | |
| * I am andyburnett (https://keybase.io/andyburnett) on keybase. | |
| * I have a public key ASAveegfxa-3SYA90BuXvNjXq63p2DR0o4DEEp5ruMKB_Qo | |
| To claim this, I am signing this object: |