为什么我没有定义“ userId”。

Question

您能帮我提供以下脚本吗？我得到的“未定义”。

我正在尝试根据 https://wwww.youtube.com/watch？ v = e4ktaytoeya

function updateLicenses() {
    var updateSheet = SpreadsheetApp.getActive() .getSheetByName("Update Licenses")
    var data = updateSheet.getRange(2, 1, updateSheet.getLastRow() - 1, 3).getValues()
  var fileArray = [
        ["License Update Status"]
    ]


    // Loop through all user provided google sheet rows and call Directy API with it

    data.forEach(function(item) {
        var status = "License Assigned Successfully"
        try {
            var userId = item[0]
            var apiCall = AdminLicenseManager.LicenseAssignments.patch({
          
            // enter new license details here
                "productID": "Google-Apps",
                "skuID": "1010020027",
                "userID": userID
           }, "Google-Apps", "1010020028", userId)  // enter exiting/assigned license details here
              
      } catch (e) {
          var status = e.message
      }
      fileArray.push([status])
    })
      
    updateSheet.getRange(1, 2, fileArray.length, fileArray[0].length).setValues(fileArray)

    //AdminLicenseManager.LicenseAssignments.patch()
}

Answer 1

基于该视频。您是否将表的点击命名为更新许可证？

如视频中所示的A列中的用户ID是否是？ （如果您更改了电子邮件的列，是var data指向该列吗？）

我在视频所有者的页面，他更新了代码：

function assignLicenses() {

    // Add SKU details here, below ones are for frontline worker
    var productId = "Google-Apps"
    var skuId = 1010020030

    // Get Google Sheet and read the user emails from it, we'll use these to assign licenses

    var assignmentSheet = SpreadsheetApp.getActive().getSheetByName("Assign Frontline Licenses")
    var data = assignmentSheet.getRange(2, 1, assignmentSheet.getLastRow() - 1, 2).getValues()

    // Create an array to store the results from API, instead of appendRow, we'll rather save output to this array, and then write back to sheet at once
    var fileArray = [
        ["License Assignment Status"]
    ]

    // Loop through the google sheet values, and call License API to assign the given license
    data.forEach(function(item) {
        var status = "Licese Assigned Successfully"
        try {
            //var productId = getSkuDetails(item[1])
            var apiCall = AdminLicenseManager.LicenseAssignments.insert({
                "userId": item[0]
            }, productId, skuId)
        }

        // Catch Errors (if any)
        catch (e) {
            var status = e.message
        }

        // Write the output data back to our array
        fileArray.push([status])
    })


    // Write the results from array to our google sheet
    assignmentSheet.getRange(1, 2, fileArray.length, fileArray[0].length).setValues(fileArray)
}

如果您有疑问，请告诉我。