google脚本编辑器mailchimp - fetch segment subscriber

Question

我目前正在尝试使用脚本编辑器将预定义的自动更新部分中的订阅者总数的mailchimp数据提取到Google sheets中。然而，我必须承认，我在这方面的知识不是很多，并且尝试过各种自定义代码的方法，但都没有成功。我已经看过关于这一点的Mailchimps文档，但似乎仍然不能得到这项工作。

function chimpSubscribers() {
var API_KEY = ''; // MailChimp API Key
var LIST_ID = ''; // MailChimp List ID
var SEGMENT_ID =''; //Mailchimp Segment ID

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Subscribers");

var dc = API_KEY.split('-')[1];
var api = 'https://'+ dc +'.api.mailchimp.com/3.0';

  var memberList = '/lists/'+LIST_ID
  var memberSegment = '/segments/'+SEGMENT_ID
    var apiCall = function(endpoint){
    options = {"headers": {"authorization": 'apikey '+API_KEY}};
        apiResponseMembers = UrlFetchApp.fetch(api+endpoint,options);
        json = JSON.parse(apiResponseMembers);
        return json
    }

var members = apiCall ("memberList", "memberSegment");
if (members) {

  var d = new Date();
  var member_count = members.stats.member_count;
  var unsubscribe_count = members.stats.unsubscribe_count;
  var open_rate = members.stats.open_rate;
  var click_rate = members.stats.click_rate;

  var report = [d, member_count, unsubscribe_count, open_rate, click_rate,];

Logger.log(report);

// Clear MailChimp data in Spreadsheet
   sheet.clear();
// Append MailChimp data to Spreadsheet
   sheet.appendRow(["Date", "Total Subscribers", "Unsubscribe Count", "Open Rate", "Click Rate"]);
   sheet.appendRow(report);
 }  
}

Answer 1

弄清楚了--对于任何其他可能需要它的人，代码如下：

function chimpSubscribers() {
var API_KEY = ''; // MailChimp API Key
var LIST_ID = ''; // MailChimp List ID
var SEGMENT_ID = ''; // Mailchimp Segment ID

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Subscribers");

var dc = API_KEY.split('-')[1];
var api = 'https://'+ dc +'.api.mailchimp.com/3.0';

var memberList = '/lists/'+LIST_ID +'/segments/'+ SEGMENT_ID
    options = {"headers": {"authorization": 'apikey '+API_KEY}};
    var apiCall = function(endpoint){
        apiResponseMembers = UrlFetchApp.fetch(api+endpoint,options);
        json = JSON.parse(apiResponseMembers);
        return json
    }

var members = apiCall(memberList);
if (members) {

  var d = new Date();
  var member_count = members.member_count;

  var report = [d,member_count,];

Logger.log(report);

// Clear MailChimp data in Spreadsheet
   sheet.clear();
// Append MailChimp data to Spreadsheet
   sheet.appendRow(["Date", "Total Subscribers"]);
   sheet.appendRow(report);
 }  
}