trello + GAS する時の関数たち
//trelloの指定のボードIDを取得する関数 | |
function getTrelloBoardID(trello_API_KEY, trello_TOKEN, trello_USERNAME, boardName){ | |
var url = 'https://trello.com/1/members/' + trello_USERNAME + '/boards?key=' + trello_API_KEY + '&token=' + trello_TOKEN + '&fields=name'; | |
var fetch = UrlFetchApp.fetch(url, {'method':'get'}); | |
var json = JSON.parse(fetch); | |
for(var i in json){ | |
if(json[i].name == boardName){ | |
return json[i].id; | |
} | |
} | |
return null; | |
} | |
//trelloの指定のListIDを取得する関数 | |
function getTrelloListID(trello_API_KEY, trello_TOKEN, boardId, listName){ | |
var url = 'https://trello.com/1/boards/' + boardId + '/lists?key=' + trello_API_KEY + '&token=' + trello_TOKEN + '&fields=name'; | |
var fetch = UrlFetchApp.fetch(url, {'method':'get'}); | |
var json = JSON.parse(fetch); | |
for(var i in json){ | |
if(json[i].name == listName){ | |
return json[i].id; | |
} | |
} | |
return null; | |
} | |
//trelloにカードを追加する関数 | |
function addTrelloCard(trello_API_KEY, trello_TOKEN, listId, text){ | |
var url = 'https://api.trello.com/1/cards/?key=' + trello_API_KEY + '&token=' + trello_TOKEN; | |
var options = { | |
'method' : 'post', | |
'muteHttpExceptions' : true, | |
'payload' : { | |
'name' : text, | |
'desc' : '', | |
'due' : '', | |
'idList' : listId, | |
'urlSource' : '' | |
} | |
} | |
UrlFetchApp.fetch(url, options); | |
} | |
//trelloのカードを削除する関数 | |
function deleteTrelloCard(trello_API_KEY, trello_TOKEN, listId, text){ | |
var url = 'https://api.trello.com/1/lists/' + listId + '/cards/?key=' + trello_API_KEY + '&token=' + trello_TOKEN; | |
var fetch = UrlFetchApp.fetch(url, {'method':'get'}); | |
var json = JSON.parse(fetch); | |
for(var i in json){ | |
if(json[i].name == text){ | |
url = 'https://api.trello.com/1/cards/' + json[i].id +'?key=' + trello_API_KEY + '&token=' + trello_TOKEN; | |
fetch = UrlFetchApp.fetch(url, {'method':'delete'}); | |
json = JSON.parse(fetch); | |
break; | |
} | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment