基于产品ID更新条带产品图像的JavaScript命中错误

我正在try 使用条纹API来更新基于产品ID的条纹产品形象.

我已经创建了一个包含两列的Google工作表

ProductId           ImageUrl
-----------------------------------------------------------------------------------------------
prod_PV3k2gGM3GrmqO https://img.freepik.com/free-vector/sketch-plain-travelling_1308-86639.jpg
prod_PV3kLlPyxmwcy7 https://img.freepik.com/free-vector/sketch-plain-travelling_1308-86639.jpg
prod_PV3kubG9uCMsFR https://img.freepik.com/free-vector/sketch-plain-travelling_1308-86639.jpg

我在Google的操作脚本中有以下代码:

// Define your Stripe API key here
const STRIPE_API_KEY = 'hidden';

function insertImageIntoStripeProduct() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const data = sheet.getDataRange().getValues();

  for (let i = 1; i < data.length; i++) {
    const productId = data[i][0]; // Assuming ProductID is in the first column
    const imageUrl = data[i][1]; // Assuming ImageURL is in the second column

    if (productId && imageUrl) {
      updateStripeProduct(productId, imageUrl);
    }
  }
}

function updateStripeProduct(productId, imageUrl) {
  const apiUrl = `https://api.stripe.com/v1/products/${productId}`;
  const productData = {
    images: [imageUrl],
  };

  makeStripeRequest(apiUrl, 'POST', productData);
}

function makeStripeRequest(apiUrl, method, requestData) {
  const formData = Object.entries(requestData)
    .map(([key, value]) => `${encodeURIComponent(key)}=${encodeURIComponent(value)}`)
    .join('&');

  const response = UrlFetchApp.fetch(apiUrl, {
    method,
    headers: {
      Authorization: `Bearer ${STRIPE_API_KEY}`,
      'Content-Type': 'application/x-www-form-urlencoded',
    },
    payload: formData,
  });

  if (response.getResponseCode() !== 200) {
    throw new Error(`Stripe API Error: ${response.getContentText()}`);
  }

  return JSON.parse(response.getContentText());
}

然而，在执行之后，它遇到了以下错误:

Exception: Request failed for https://api.stripe.com returned code 400. Truncated server response: {
  "error": {
    "message": "Invalid array",
    "param": "images",
    "request_log_url": "https://dashboard.stripe.com/logs/req_Ux1hF7z4QsOtZ1?... (use muteHttpExceptions option to examine full response)
makeStripeRequest   @ Code.gs:32
updateStripeProduct @ Code.gs:24
insertImageIntoStripeProduct    @ Code.gs:13

你能帮我修改这段代码吗，让它正常工作？

提前谢谢您.

最好的，

罗马人

我试过使用ChatGPT.它提供了数十次代码修改，但都没有奏效.