Foxtable(狐表)用户栏目专家坐堂 → 获取企业微信审批单数据


  共有2651人关注过本帖平板打印复制链接

主题:获取企业微信审批单数据

帅哥哟,离线,有人找我吗?
13968559581
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:幼狐 帖子:185 积分:1526 威望:0 精华:0 注册:2017/7/23 17:17:00
获取企业微信审批单数据  发帖心情 Post By:2020/8/10 12:10:00 [只看该作者]

我代码这样的,但报错,什么原因

Dim ur As String = "https://qyapi.weixin.qq.com/cgi-bin/oa/getapprovaldetail?access_token={0}"
Dim hc As New HttpClient(CExp(ur,Functions.Execute("GetQYAccessTokensp")))
Dim jo As New JObject
jo("sp_no") =202007280001
图片点击可在新窗口打开查看此主题相关图片如下:898989.png
图片点击可在新窗口打开查看
hc.Content = jo.ToString()
jo = JObject.Parse(hc.GetData())
If jo("errcode") = "0" Then
    Dim nms() As String = {"sp_no","sp_name","sp_status"}
   '  Dim nms() As String = {"sp_no","sp_name","sp_status","template_id","apply_time","userid"}

    For Each jt As JToken In jo("info")
        Dim dr As DataRow = DataTables("企业微信审批单").AddNew()
        For Each nm As String In nms
            msgbox(nm)
            dr(nm) = jt(nm)
        Next
    Next
    DataTables("企业微信审批单").Save()
[此贴子已经被作者于2020/8/10 13:02:01编辑过]

 回到顶部