Sharepoint json如何将列值插入电子邮件正文

const nodemailer = require('nodemailer');

// 获取SharePoint列值
const columnValue = '这里是SharePoint列值';

// 创建JSON对象
const json = {
  columnName: columnValue
};

// 创建电子邮件正文
const emailBody = `SharePoint列值：${json.columnName}`;

// 配置邮件传输
const transporter = nodemailer.createTransport({
  service: 'your_email_service',
  auth: {
    user: 'your_email',
    pass: 'your_password'
  }
});

// 配置电子邮件选项
const mailOptions = {
  from: 'sender_email',
  to: 'recipient_email',
  subject: '邮件主题',
  text: emailBody
};

// 发送电子邮件
transporter.sendMail(mailOptions, (error, info) => {
  if (error) {
    console.log(error);
  } else {
    console.log('电子邮件已发送：' + info.response);
  }
});