想要从Trello API响应中删除Id字段

作者: v-star*위위
发布时间: 2024-12-12 07:09:16 (14天前)
转自：

2 条回复

0#
回复此人
誓言 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 你可以尝试这样的东西......但你可能需要修改一下以满足你的需要。 </p> <pre> <code> function ImportJSON() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(); var url = "https://api.trello.com/1/boards/boardID/cards/cardId?fields=name&key=MYKEY&token=MYTOKEN"; var response = UrlFetchApp.fetch(url); // Get the raw JSON var dataSet = JSON.parse(response.getContentText()); // Parse it var rows = new Array(); for (i = 0; i < dataSet.length; i++) { var data = dataSet[i]; rows.push([data.name,data.email]); // your actual JSON entities here ... do not include "id" } dataRange = sheet.getRange(1, 1, rows.length, 3); // 3 being the total number of entities dataRange.setValues(rows); } </code> </pre> </DIV>

编辑

登录后才能参与评论