PnP.js:如何获取文件夹下文件的SharePoint自定义查阅列值/标题

import { sp } from "@pnp/sp";

// 设置SharePoint站点的URL
const siteUrl = "https://your-sharepoint-site-url";

// 获取文件夹下文件的自定义查阅列值/标题
async function getFilesInFolder(folderUrl) {
  try {
    // 连接到SharePoint站点
    sp.setup({
      sp: {
        baseUrl: siteUrl,
      },
    });

    // 获取文件夹下的文件
    const files = await sp.web.getFolderByServerRelativeUrl(folderUrl).files.get();

    // 遍历文件并获取自定义查阅列值/标题
    for (const file of files) {
      const fileItem = await sp.web.getFileByServerRelativeUrl(file.ServerRelativeUrl).getItem();
      const customColumnValue = fileItem["CustomColumnName"];
      console.log(`文件名: ${file.Name}, 自定义查阅列值/标题: ${customColumnValue}`);
    }
  } catch (error) {
    console.log("获取文件夹下文件的自定义查阅列值/标题时出错:", error);
  }
}

// 调用函数并传入文件夹URL
getFilesInFolder("/sites/your-site/Shared Documents/FolderName");