飞书获取报表数据模板+二维数组降维处理模板

二维数组降维处理

     #假设是二维数组，进行降维处理
             ins_data_list_2 = []
             for y in ins_data_list:
                 ins_data_list_2.append(str(y).replace('[','').replace(']',''))

保存一下简单模板

import json
import requests
#from datetime import date
import time
import datetime
import pandas as pd
#import os
# 获取tenant_access_token
url = "https://open.feishu.cn/open-apis/auth/v3/tenant_access_token/internal/"
proxies = {
  "https": "*****.com:8080"
}
post_data = {"app_id": "****","app_secret": "*****"}
r = requests.post(url, data=post_data, proxies=proxies)
tat = r.json()["tenant_access_token"]
#print(tat)



# 获取用户维度的用户活跃和功能使用数据
yesterday = str(datetime.date.today() + datetime.timedelta(days=-1))
df01 = pd.DataFrame()
pg_token = 0
have_more = True
header = {"content-type": "application/json", "Authorization": "Bearer " + str(tat), 'Connection': 'keep-alive', 'Referer':'https://open.feishu.cn/open-apis/admin/v1/'}
while have_more:
  url = "https://open.feishu.cn/open-apis/admin/v1/admin_user_stats?department_id=0&department_id_type=department_id&end_date=2021-01-18&page_size=20&page_token="+str(pg_token)+"&start_date=2021-01-18"
  r = requests.get(url, params=None, proxies=proxies, headers=header)
#  print(r.json())
  pg_token = int(pg_token)+20
  print(r.json())
  reuser = r.json()["data"]
  print(pg_token)
#  pg_token = reuser["page_token"]
  have_more = reuser["has_more"]
  print(have_more)
#  print(pg_token)
  fsdt = r.json()["data"]["items"]
  df = pd.DataFrame(reuser["items"])
  df03 = df01.append(df)
  df01 = df03
#  print(df01)
#print(df01)
df01.to_csv('D:/飞书接口/fs_user_data'+str(time.strftime('%Y%m%d', time.localtime()))+'.csv', index=0, sep='|')
        }