【分享】用表格文本和图片创建语雀知识库

//信息获取(可自行设定需要的信息)
//取激活工作表的单元格Range
const B1 = Application.Range("B1")
const B2 = Application.Range("B2")
const B3 = Application.Range("B3")

//图片渲染（https://qrcode.icu 获取pid和pcid）
let resp = HTTP.post("https://k8s.qrcode.icu/render?a=render&pid=b46f41dc-6ab6-4bf0-87a7-0b50819df056&pcid=7874240a-e1b8-4f43-bce8-7ebc4ca68f93", 
  {
    "姓名": B1.Text,
    "年月日": B2.Text,
    "年月": B3.Text
   }
  )


//发送企业微信机器人图片信息
const imgUrl = resp.json().content[0].url
const resp2 = HTTP.get(imgUrl)
const body = resp2.binary()
console.log(imgUrl)
const text = "**这是用金山AirScript发送的一段文字**

这是表格中的图片![dcbaa6f0-effb-445b-b484-1c2a4fb86384.jpg](https://cdn.nlark.com/yuque/0/2023/jpeg/1592927/1680017835027-5e65b7e5-1bf4-41a5-aead-64d6c319b23f.jpeg#averageHue=%23c8b89f&clientId=ue1e9d9f6-ce01-4&from=ui&id=u805fafcf&name=dcbaa6f0-effb-445b-b484-1c2a4fb86384.jpg&originHeight=1440&originWidth=1080&originalType=binary&ratio=1.5&rotation=0&showTitle=false&size=1298532&status=done&style=none&taskId=u7b30541c-fa59-413c-97f0-6d7b6948a4c&title=)"
//发送json
const formresp = HTTP.post("https://www.yuque.com/api/v2/repos/glancegrin/ocf4ds/docs", 
{
    "key": "bar",
    "title": "金山链接测试",//文档标题
    "slug": "1233",//这里要设置一个随机数
    "format": "markdown",//文档类型
    "body": text//文档文本（换行符用
，插入图片用![](url)）
    }, 
{ headers: {
     "User-Agent": "hiflow",//应用名在语雀个人中心获取，下面同样
     "X-Auth-Token": "Auth-Token语雀获取",//Auth-Token
     "Content-Type": "application/json"
      } })
 console.log(formresp.text())  // this is an example.