120 lines
6.3 KiB
Plaintext
120 lines
6.3 KiB
Plaintext
{
|
||
"cells": [
|
||
{
|
||
"cell_type": "code",
|
||
"id": "initial_id",
|
||
"metadata": {
|
||
"collapsed": true,
|
||
"ExecuteTime": {
|
||
"end_time": "2025-12-22T08:20:25.119372Z",
|
||
"start_time": "2025-12-22T08:20:24.856990Z"
|
||
}
|
||
},
|
||
"source": [
|
||
"import requests\n",
|
||
"\n",
|
||
"cookies = {\n",
|
||
" 'cna': 'leEhIXXu0H8CAd3ikLT/9umX',\n",
|
||
" 'dd_l': 'zh_CN',\n",
|
||
" 'xlly_s': '1',\n",
|
||
" 'account': 'oauth_k1%3AOQ%2FaejhWDggPvyXETBco%2B2KNmaGD0D4duhrY8bd9DELyQuszzdFPnzyf%2BzY34P6xI8m5yjXEO4UBZ5ZD5GLEAfjFBdPDvctNnX8QaW7Kuuw%3D',\n",
|
||
" 'deviceid': '79ae290e384445ae8a19bb675a36fe81',\n",
|
||
" 'pub_uid': 'VXNmoDUekz2upENgBGGpOA%3D%3D',\n",
|
||
" 'doc_atoken': 'MTAxMTk0NDU0OAvtUiMDvrYwUAcejvlwvDxCgXhjtVhBxI',\n",
|
||
" 'pub_org_id': 'qMIIUPqpRC%2FMWXODmPplBg%3D%3D',\n",
|
||
" 'RECENT_OPEN_DOC_KEYS': 'Lk3lbmbBxLENGOm9%2C2M9qP5jzbWRdkO01',\n",
|
||
" 'cmouse': 's381d12e3-805a-4838-999d-456c2c96d1cb-1766390396196',\n",
|
||
" 'dt_s': 'u-3c510c64-9b45127526-b522302-81c70a-684f8e52-5ba013b6-5235-43dd-a26d-c525349a0977',\n",
|
||
" 'dt_org': '2706271',\n",
|
||
" 'dd_n': 'CN',\n",
|
||
" 'corp_id': 'dinga88e3d35525b86ca',\n",
|
||
" '_csrf_token_': '1766390416329',\n",
|
||
" 'dingtalk_corpid': 'dinga88e3d35525b86ca',\n",
|
||
" 'arms_uid': 'f70c3954-1c40-44d9-b625-83c56071f8ff',\n",
|
||
" 'tfstk': 'gXdSRU1Evuq5_D3-vuu4c4ByjWfBRqlawy_pSeFzJ_CROJtDmuWKxLJQAFxCT_8KqHOCDhLPLQSFO2tRmuJrK_CL9h8UzgnnEMUBAn0l8DABnWTM-QulT4fkr6fKbc5COUYlt7PqSedCMiQFPXyLe9ClMYMa6ccZ_UY8za3wkfJzoQLR-MCde9EADibQ9zKdejQAmwbL2wQKlEIcD7E8wwevkNQgwzKd9qTAmw7R9TKdMq_hDMCd9jc75wM5qUgZ1AcUPAPMfiNL9I_xxGYScJs2daNFbUsjYodbsTs9yZNKV1NnaMsD6mkXonJJ4ZxI1m1vWK1RPHhTQipXkQXN1AeWXE-k1_dsV77Vdg9vwtaL9ECvH9vBV0wl2L-fIZBYRfb2biLkwKg3DUKNV_QA3f36k9p2ZOArD719IU5ypnhbNhIyJ5S1rB2Qb6PdlGujlk2h4Wxx818w3zXRoa6qlqZJKTQclGujlJ2heZb50qgb2pf..',\n",
|
||
" 'isg': 'BExMEWhVSddeYl1rBDZrAzySHap-hfAvwNVVZ6YF2vaZMfA7zZDnvfbH0TkJfyiH',\n",
|
||
"}\n",
|
||
"\n",
|
||
"headers = {\n",
|
||
" '_csrf_token_': '1766390416329',\n",
|
||
" 'accept': 'application/json, text/plain, */*',\n",
|
||
" 'accept-language': 'zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6',\n",
|
||
" 'bx-v': '2.5.31',\n",
|
||
" 'cache-control': 'no-cache',\n",
|
||
" 'client-corpid': 'dinga88e3d35525b86ca',\n",
|
||
" 'content-type': 'application/x-www-form-urlencoded; charset=UTF-8',\n",
|
||
" 'origin': 'https://aflow.dingtalk.com',\n",
|
||
" 'pragma': 'no-cache',\n",
|
||
" 'priority': 'u=1, i',\n",
|
||
" 'referer': 'https://aflow.dingtalk.com/dingtalk/web/query/dashboard?t=1766390418322&dinghash=aflowSetting',\n",
|
||
" 'sec-ch-ua': '\"Microsoft Edge\";v=\"143\", \"Chromium\";v=\"143\", \"Not A(Brand\";v=\"24\"',\n",
|
||
" 'sec-ch-ua-mobile': '?0',\n",
|
||
" 'sec-ch-ua-platform': '\"Windows\"',\n",
|
||
" 'sec-fetch-dest': 'empty',\n",
|
||
" 'sec-fetch-mode': 'cors',\n",
|
||
" 'sec-fetch-site': 'same-origin',\n",
|
||
" 'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36 Edg/143.0.0.0',\n",
|
||
" 'x-client-corpid': 'dinga88e3d35525b86ca',\n",
|
||
" # 'cookie': 'cna=leEhIXXu0H8CAd3ikLT/9umX; dd_l=zh_CN; xlly_s=1; account=oauth_k1%3AOQ%2FaejhWDggPvyXETBco%2B2KNmaGD0D4duhrY8bd9DELyQuszzdFPnzyf%2BzY34P6xI8m5yjXEO4UBZ5ZD5GLEAfjFBdPDvctNnX8QaW7Kuuw%3D; deviceid=79ae290e384445ae8a19bb675a36fe81; pub_uid=VXNmoDUekz2upENgBGGpOA%3D%3D; doc_atoken=MTAxMTk0NDU0OAvtUiMDvrYwUAcejvlwvDxCgXhjtVhBxI; pub_org_id=qMIIUPqpRC%2FMWXODmPplBg%3D%3D; RECENT_OPEN_DOC_KEYS=Lk3lbmbBxLENGOm9%2C2M9qP5jzbWRdkO01; cmouse=s381d12e3-805a-4838-999d-456c2c96d1cb-1766390396196; dt_s=u-3c510c64-9b45127526-b522302-81c70a-684f8e52-5ba013b6-5235-43dd-a26d-c525349a0977; dt_org=2706271; dd_n=CN; corp_id=dinga88e3d35525b86ca; _csrf_token_=1766390416329; dingtalk_corpid=dinga88e3d35525b86ca; arms_uid=f70c3954-1c40-44d9-b625-83c56071f8ff; tfstk=gXdSRU1Evuq5_D3-vuu4c4ByjWfBRqlawy_pSeFzJ_CROJtDmuWKxLJQAFxCT_8KqHOCDhLPLQSFO2tRmuJrK_CL9h8UzgnnEMUBAn0l8DABnWTM-QulT4fkr6fKbc5COUYlt7PqSedCMiQFPXyLe9ClMYMa6ccZ_UY8za3wkfJzoQLR-MCde9EADibQ9zKdejQAmwbL2wQKlEIcD7E8wwevkNQgwzKd9qTAmw7R9TKdMq_hDMCd9jc75wM5qUgZ1AcUPAPMfiNL9I_xxGYScJs2daNFbUsjYodbsTs9yZNKV1NnaMsD6mkXonJJ4ZxI1m1vWK1RPHhTQipXkQXN1AeWXE-k1_dsV77Vdg9vwtaL9ECvH9vBV0wl2L-fIZBYRfb2biLkwKg3DUKNV_QA3f36k9p2ZOArD719IU5ypnhbNhIyJ5S1rB2Qb6PdlGujlk2h4Wxx818w3zXRoa6qlqZJKTQclGujlJ2heZb50qgb2pf..; isg=BExMEWhVSddeYl1rBDZrAzySHap-hfAvwNVVZ6YF2vaZMfA7zZDnvfbH0TkJfyiH',\n",
|
||
"}\n",
|
||
"\n",
|
||
"data = {\n",
|
||
" 'page': '1',\n",
|
||
" 'limit': '20',\n",
|
||
" 'transferee': '675366331293637',\n",
|
||
"}\n",
|
||
"\n",
|
||
"response = requests.post(\n",
|
||
" 'https://aflow.dingtalk.com/dingtalk/web/query/task/getTransfereeTodoTasks.json',\n",
|
||
" cookies=cookies,\n",
|
||
" headers=headers,\n",
|
||
" data=data,\n",
|
||
")\n",
|
||
"\n",
|
||
"data_list = response.json().get('data').get(\"values\")\n",
|
||
"import pandas as pd\n",
|
||
"\n",
|
||
"df = pd.DataFrame(data_list).astype(\"string\")\n",
|
||
"# 方法 1：先转为整数，再转 datetime（明确、安全）\n",
|
||
"df['datetime'] = pd.to_datetime(df['gmtCreate'].astype(int), unit='ms')\n",
|
||
"\n",
|
||
"# 方法 2：直接用 to_datetime + unit（pandas 会自动尝试转换字符串）\n",
|
||
"df['datetime'] = pd.to_datetime(df['gmtCreate'], unit='ms')\n",
|
||
"df.to_excel(\"1.xlsx\")"
|
||
],
|
||
"outputs": [
|
||
{
|
||
"name": "stderr",
|
||
"output_type": "stream",
|
||
"text": [
|
||
"C:\\Users\\zy187\\AppData\\Local\\Temp\\ipykernel_15160\\3239833454.py:69: FutureWarning: The behavior of 'to_datetime' with 'unit' when parsing strings is deprecated. In a future version, strings will be parsed as datetime strings, matching the behavior without a 'unit'. To retain the old behavior, explicitly cast ints or floats to numeric type before calling to_datetime.\n",
|
||
" df['datetime'] = pd.to_datetime(df['gmtCreate'], unit='ms')\n"
|
||
]
|
||
}
|
||
],
|
||
"execution_count": 10
|
||
}
|
||
],
|
||
"metadata": {
|
||
"kernelspec": {
|
||
"display_name": "Python 3",
|
||
"language": "python",
|
||
"name": "python3"
|
||
},
|
||
"language_info": {
|
||
"codemirror_mode": {
|
||
"name": "ipython",
|
||
"version": 2
|
||
},
|
||
"file_extension": ".py",
|
||
"mimetype": "text/x-python",
|
||
"name": "python",
|
||
"nbconvert_exporter": "python",
|
||
"pygments_lexer": "ipython2",
|
||
"version": "2.7.6"
|
||
}
|
||
},
|
||
"nbformat": 4,
|
||
"nbformat_minor": 5
|
||
}
|