Files
2026-04-18 09:22:23 +08:00

303 lines
35 KiB
Plaintext

{
"cells": [
{
"metadata": {},
"cell_type": "markdown",
"source": "# 订单导出请求",
"id": "360eeaa3edfeeea5"
},
{
"metadata": {},
"cell_type": "code",
"outputs": [],
"execution_count": null,
"source": [
"import requests\n",
"\n",
"cookies = {\n",
" 'hive-adminSESSIONID': '34068dac-9e90-4632-a7e5-48281f181d59',\n",
" '_oauth2_proxy': 'hBgKHp7tNo1IhJZBL2UqonqXc1V6HO7cdu0ldRAQeTz7I7_FJtZhnxQI5sLfWeRvWYI-6jA2oHgv284pIyK3MR2w6QPfhJgwJWuIvp5Cmt89M72kRzdpyYNaUjQVuMaR4x4cnOiyRe1gPR7e3eDtd8R7IkNmFSXjiK2ADU29o0Ay5QmN6GBmciJ0EwiWUtpwToOXldGn4vpgbxEdmxWLFEmucCK_2E3THUq2zjnje0P2OznxeQzVDUJ4xdfVFso1tiMicxevHLTOadyp2hdKFSjJ40dLlCX47JaWzWnth72pQBiUKejXkIeiO7iJ_xC21JwDdUT5sVZg2KHnG2p-BqUF9klUBhMaqozcodelKAg-62XuhrOYsk6BHV5ObIJ0jhqmq84n8mzuKNPeNERjZjNZ68-xwzT4uYi0Ffor3b7C64zmQ1LkTbOCQkF7B0Uh1tNv4ebDTDwffvaBN4JmbLm7BxGeymuLBiuWig3POpgUAQ00f7jXM78cWTD1G7B42IfokgiQHb9fWH_L7JOQ3_5hh-OD6heuqRu2vEkkgf8oGnS3ZCgL3YcExINio_jaO6qZjNR0A3nUvXApihvPn4JG7YWg2wYRM2yaXr_wA8ES3oklTDl7COldCLphaGzHntmWKK0hkQX2jZA4l94bfa7faDADiBi4B3A7U4UjoCJkmyXv0VOvke2Qmq7kodTi2A54LOm9UPZTaPlZ_vAt20nVYMiLTeXeLRjavaM70LclTKuHrYWZKhPREH3w255MqGiMiArmRUNHtzglYwdL4ncid-x3foLj3DZKwmZ5pdKXxV1aNPcvkewCMYNq19skv6goqU0KJ8urd46VjI1bKoquw6FdbmjRFNmHKBwAI3l-xzjYQrmFJYXUabmVeN7pqIULY46P640XngoElijcvYL7r6mo4rdmZwRXDc8oKOhh_A6QmEpvIQp47b6p-pJc9GOz1W221CLNG3O0hG5o7DfpHJBsy3pASJjjwiNedzbnyu57OTTu3JWr3epq0WyrmWBH0TAdmUyAoSDTka-7-Wo6bHcVThC6HzRSbc7-J9nAKkjEaostrfzKTHVZAaBUcyAjlqn1hz_-mRq8bYif3GQkzspQ-em0Em0pczfmOBwsmQJknE3oxi9safWmgqs9UIIrqECYzCJ-mhg-7GVN-tZYuHdYvzEoPh5kHXpRYgo1s8neh54HwcLj28BWD_34Dr2BhuReKH82GGJt5-WQzJ3JDsKLADDIx7mNW06GwLERit34I8T4KNU_5B8UgvDtkBGkGY9FeteROnuCaHGCLafLt6uNCdK6A7Gqa0oFDSZHfY-nJVXQPrSpZo19JlrirA5Xk6s2jCVSwi5LZAxR1EFzQjOZADfDmYKDU35B2wKAV5I-agUPokheCarDmotj4hffqKcGs9DnhwzHTe9O3enO8NV-RHkNRYcgb7DydMwhEG8FIlyQhPzuKainBdkySJNNGCyF8tp8k1EA0-b_aDnMjr7SNMyVqmzCNlq8GoLJ16L51B-LEMmpq_0LG3-fCZpqH-VcF4_eJqIAn4JsqwY8nZJZt2AjxEz4QmtAxunNeRnwPQgwimOfVpZJGDWO4TqY_gvtDqpOPt404Wb3Ln4DF9e_W6RS3gq5_X7QXKyadI1rcqJX8KRkZNw5PraU5Wr4OkGgTvGlaFyxkEoEB1AmxDk5Lhp10TYG6cGcQLcHKfXkpHCHlCVsJwFtbz6r4v0vzjM2Q9ZN1_t2eQ2t1uvwAUJdj9O1IM7OFNU3ru1xUihQMAyIdsTdyYPxd3q01U1kKhstR5oUWA2XsAu6aZGKQwG6sAcO4wumKbPc9He4OCPY10zcmBNJyx2aOVAuUXARYp5HX-0CwLXvKUf8DmV2L7aXCLtdCp1jFFmlufERyBopFFLRGptRqDSfG9Y7JvdemjuqcVQPswJEhWZKBb81eG-Mb2ouHBsnUdiKnBhn7P7B8iq5BgM1W0kqVLKU3LbSEULxM8FoN7jIzgTXbD0aNHqBuwu3kcGwtbU9w9mrgAGLHUy96n0L2Py-fhV_Vzz6D0u9nUWdN5uhOR-pDzFY5YBfrIS5BgEiqX-epXq7Ishdf2X6caM5G6zLnCRcE2HR31XyjGHfwVeeqIcJeQAP_Y6l6NquLu1xFH3fx_IyY5qsnyI_S6W4-9yItHK7jZ2N8pEaB0u6yCkAG82yjw8o3v0-z7KZbTWs5vtwK0vhpBl3TgFrtE_yTK1gY9GqsWj1GtrvBRyUXiHqF85oHRcjuH_GUGgewXEfDn4m6PvcTBk5A2NkHce-LpF96ZjMFrrnnKxXATVPzIvnqsjjwj8tEPhd5m5A3v6Qn-5J0cX_1PAHgQwDGXRVzq2O4E96JEKqZQgpQTCIkZs9XGVHUoEALezg0C2OLNVNRfch9hAEja9YN7pf21B52bmjH6W7wv3C9qiE-Q-RxNn17Xu8j-8GKNlmwz7TaHcUfRWlGsQIUJ4lMeCU78A9zfZBZASCLaDX0oUyaNn77xddpTb96R-RTJqzl3dyKXbDScPFRdkB5td-Jql_ByjetxcUuDhof4WXHdXSN1nv1L6cET7imShEFk-RvFD2qvQveXzqvjngqpV-C_X7Jd4iYmqPerXdW22_Wh_soFLYSLLiKzlZ5JSxZ_WLt5uYzvBv04YXVWam_O07vJPwePSRvT8QbvNCC58IiVAJOeCYSopPVaTdD9uw94ybE5F5Sy0XlAB23nWSjrEd6Zy7yYza02iTIX7idxvNb0VWogGoCBjb6FowXpS5wLOEtFIMNVHowJEV4MkLasF7LQled2T5AkSQFSZFSCkWD96bhvuIUi9_fttTUKtQoSrFjhtg21f8lHA2pwlFK7jLbLzDTYnODK2qu9N6b8WcZauWpaSrkTyOC0s=|1775179342|E8jGyUr-5HOtfbTYWCgElRa2gR6Yx3HFKSrSKJYLBZk=',\n",
" 'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%224210192048793363%22%2C%22first_id%22%3A%2219b6df4cc821138-0de2a4b89caaa9-4c657b58-1327104-19b6df4cc8319da%22%2C%22props%22%3A%7B%22%24latest_traffic_source_type%22%3A%22%E7%9B%B4%E6%8E%A5%E6%B5%81%E9%87%8F%22%2C%22%24latest_search_keyword%22%3A%22%E6%9C%AA%E5%8F%96%E5%88%B0%E5%80%BC_%E7%9B%B4%E6%8E%A5%E6%89%93%E5%BC%80%22%2C%22%24latest_referrer%22%3A%22%22%7D%2C%22%24device_id%22%3A%2219b6df4cc821138-0de2a4b89caaa9-4c657b58-1327104-19b6df4cc8319da%22%7D',\n",
" '_yg_pre': 'leYfk4cBTaeTaeIcuU0sC6XCYYmJSaD4MorRnro9uSMIP-Z5r1zrru_998WKASt_UFFGnCwPU98C6t_7V69MHHL-vlT1XQQim7M4X_8fi-PIHBKqE2UWzd2KGTF_8FMahKURVFkOSph1LsiEHwX_PtbxyGmy4cvPpyxJ',\n",
"}\n",
"\n",
"headers = {\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",
" 'priority': 'u=1, i',\n",
" 'referer': 'https://manage-pre.f6yc.com/',\n",
" 'sec-ch-ua': '\"Chromium\";v=\"146\", \"Not-A.Brand\";v=\"24\", \"Microsoft Edge\";v=\"146\"',\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/146.0.0.0 Safari/537.36 Edg/146.0.0.0',\n",
" 'x-requested-with': 'XMLHttpRequest',\n",
" # 'cookie': 'hive-adminSESSIONID=34068dac-9e90-4632-a7e5-48281f181d59; _oauth2_proxy=hBgKHp7tNo1IhJZBL2UqonqXc1V6HO7cdu0ldRAQeTz7I7_FJtZhnxQI5sLfWeRvWYI-6jA2oHgv284pIyK3MR2w6QPfhJgwJWuIvp5Cmt89M72kRzdpyYNaUjQVuMaR4x4cnOiyRe1gPR7e3eDtd8R7IkNmFSXjiK2ADU29o0Ay5QmN6GBmciJ0EwiWUtpwToOXldGn4vpgbxEdmxWLFEmucCK_2E3THUq2zjnje0P2OznxeQzVDUJ4xdfVFso1tiMicxevHLTOadyp2hdKFSjJ40dLlCX47JaWzWnth72pQBiUKejXkIeiO7iJ_xC21JwDdUT5sVZg2KHnG2p-BqUF9klUBhMaqozcodelKAg-62XuhrOYsk6BHV5ObIJ0jhqmq84n8mzuKNPeNERjZjNZ68-xwzT4uYi0Ffor3b7C64zmQ1LkTbOCQkF7B0Uh1tNv4ebDTDwffvaBN4JmbLm7BxGeymuLBiuWig3POpgUAQ00f7jXM78cWTD1G7B42IfokgiQHb9fWH_L7JOQ3_5hh-OD6heuqRu2vEkkgf8oGnS3ZCgL3YcExINio_jaO6qZjNR0A3nUvXApihvPn4JG7YWg2wYRM2yaXr_wA8ES3oklTDl7COldCLphaGzHntmWKK0hkQX2jZA4l94bfa7faDADiBi4B3A7U4UjoCJkmyXv0VOvke2Qmq7kodTi2A54LOm9UPZTaPlZ_vAt20nVYMiLTeXeLRjavaM70LclTKuHrYWZKhPREH3w255MqGiMiArmRUNHtzglYwdL4ncid-x3foLj3DZKwmZ5pdKXxV1aNPcvkewCMYNq19skv6goqU0KJ8urd46VjI1bKoquw6FdbmjRFNmHKBwAI3l-xzjYQrmFJYXUabmVeN7pqIULY46P640XngoElijcvYL7r6mo4rdmZwRXDc8oKOhh_A6QmEpvIQp47b6p-pJc9GOz1W221CLNG3O0hG5o7DfpHJBsy3pASJjjwiNedzbnyu57OTTu3JWr3epq0WyrmWBH0TAdmUyAoSDTka-7-Wo6bHcVThC6HzRSbc7-J9nAKkjEaostrfzKTHVZAaBUcyAjlqn1hz_-mRq8bYif3GQkzspQ-em0Em0pczfmOBwsmQJknE3oxi9safWmgqs9UIIrqECYzCJ-mhg-7GVN-tZYuHdYvzEoPh5kHXpRYgo1s8neh54HwcLj28BWD_34Dr2BhuReKH82GGJt5-WQzJ3JDsKLADDIx7mNW06GwLERit34I8T4KNU_5B8UgvDtkBGkGY9FeteROnuCaHGCLafLt6uNCdK6A7Gqa0oFDSZHfY-nJVXQPrSpZo19JlrirA5Xk6s2jCVSwi5LZAxR1EFzQjOZADfDmYKDU35B2wKAV5I-agUPokheCarDmotj4hffqKcGs9DnhwzHTe9O3enO8NV-RHkNRYcgb7DydMwhEG8FIlyQhPzuKainBdkySJNNGCyF8tp8k1EA0-b_aDnMjr7SNMyVqmzCNlq8GoLJ16L51B-LEMmpq_0LG3-fCZpqH-VcF4_eJqIAn4JsqwY8nZJZt2AjxEz4QmtAxunNeRnwPQgwimOfVpZJGDWO4TqY_gvtDqpOPt404Wb3Ln4DF9e_W6RS3gq5_X7QXKyadI1rcqJX8KRkZNw5PraU5Wr4OkGgTvGlaFyxkEoEB1AmxDk5Lhp10TYG6cGcQLcHKfXkpHCHlCVsJwFtbz6r4v0vzjM2Q9ZN1_t2eQ2t1uvwAUJdj9O1IM7OFNU3ru1xUihQMAyIdsTdyYPxd3q01U1kKhstR5oUWA2XsAu6aZGKQwG6sAcO4wumKbPc9He4OCPY10zcmBNJyx2aOVAuUXARYp5HX-0CwLXvKUf8DmV2L7aXCLtdCp1jFFmlufERyBopFFLRGptRqDSfG9Y7JvdemjuqcVQPswJEhWZKBb81eG-Mb2ouHBsnUdiKnBhn7P7B8iq5BgM1W0kqVLKU3LbSEULxM8FoN7jIzgTXbD0aNHqBuwu3kcGwtbU9w9mrgAGLHUy96n0L2Py-fhV_Vzz6D0u9nUWdN5uhOR-pDzFY5YBfrIS5BgEiqX-epXq7Ishdf2X6caM5G6zLnCRcE2HR31XyjGHfwVeeqIcJeQAP_Y6l6NquLu1xFH3fx_IyY5qsnyI_S6W4-9yItHK7jZ2N8pEaB0u6yCkAG82yjw8o3v0-z7KZbTWs5vtwK0vhpBl3TgFrtE_yTK1gY9GqsWj1GtrvBRyUXiHqF85oHRcjuH_GUGgewXEfDn4m6PvcTBk5A2NkHce-LpF96ZjMFrrnnKxXATVPzIvnqsjjwj8tEPhd5m5A3v6Qn-5J0cX_1PAHgQwDGXRVzq2O4E96JEKqZQgpQTCIkZs9XGVHUoEALezg0C2OLNVNRfch9hAEja9YN7pf21B52bmjH6W7wv3C9qiE-Q-RxNn17Xu8j-8GKNlmwz7TaHcUfRWlGsQIUJ4lMeCU78A9zfZBZASCLaDX0oUyaNn77xddpTb96R-RTJqzl3dyKXbDScPFRdkB5td-Jql_ByjetxcUuDhof4WXHdXSN1nv1L6cET7imShEFk-RvFD2qvQveXzqvjngqpV-C_X7Jd4iYmqPerXdW22_Wh_soFLYSLLiKzlZ5JSxZ_WLt5uYzvBv04YXVWam_O07vJPwePSRvT8QbvNCC58IiVAJOeCYSopPVaTdD9uw94ybE5F5Sy0XlAB23nWSjrEd6Zy7yYza02iTIX7idxvNb0VWogGoCBjb6FowXpS5wLOEtFIMNVHowJEV4MkLasF7LQled2T5AkSQFSZFSCkWD96bhvuIUi9_fttTUKtQoSrFjhtg21f8lHA2pwlFK7jLbLzDTYnODK2qu9N6b8WcZauWpaSrkTyOC0s=|1775179342|E8jGyUr-5HOtfbTYWCgElRa2gR6Yx3HFKSrSKJYLBZk=; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%224210192048793363%22%2C%22first_id%22%3A%2219b6df4cc821138-0de2a4b89caaa9-4c657b58-1327104-19b6df4cc8319da%22%2C%22props%22%3A%7B%22%24latest_traffic_source_type%22%3A%22%E7%9B%B4%E6%8E%A5%E6%B5%81%E9%87%8F%22%2C%22%24latest_search_keyword%22%3A%22%E6%9C%AA%E5%8F%96%E5%88%B0%E5%80%BC_%E7%9B%B4%E6%8E%A5%E6%89%93%E5%BC%80%22%2C%22%24latest_referrer%22%3A%22%22%7D%2C%22%24device_id%22%3A%2219b6df4cc821138-0de2a4b89caaa9-4c657b58-1327104-19b6df4cc8319da%22%7D; _yg_pre=leYfk4cBTaeTaeIcuU0sC6XCYYmJSaD4MorRnro9uSMIP-Z5r1zrru_998WKASt_UFFGnCwPU98C6t_7V69MHHL-vlT1XQQim7M4X_8fi-PIHBKqE2UWzd2KGTF_8FMahKURVFkOSph1LsiEHwX_PtbxyGmy4cvPpyxJ',\n",
"}\n",
"\n",
"params = {\n",
" 'orderTypeList': '',\n",
" 'buyerGroupId': '',\n",
" 'reservationNumber': '',\n",
" 'payChannel': '',\n",
" 'priceMin': '',\n",
" 'priceMax': '',\n",
" 'userContactTel': '',\n",
" 'idEmployee': '',\n",
" 'dealUserId': '',\n",
" 'orderSource': '',\n",
" 'idManager': '',\n",
" 'orderStatusStr': '',\n",
" 'orderReserveTimeStart': '',\n",
" 'orderReserveTimeEnd': '',\n",
" 'orderPayFinishTimeStart': '1775100171457', # 开始时间\n",
" 'orderPayFinishTimeEnd': '1775704971457', # 结束时间\n",
" 'dealTimeStart': '',\n",
" 'dealTimeEnd': '',\n",
" 'invoiceStatusList': '',\n",
" 'openTimeStartTime': '',\n",
" 'openTimeEndTime': '',\n",
"}\n",
"\n",
"response = requests.get('https://manage-pre.f6yc.com/hive-admin/order/export', params=params, cookies=cookies, headers=headers)\n",
"print(response.json())"
],
"id": "910dc9bf840168d2"
},
{
"metadata": {},
"cell_type": "markdown",
"source": "# 优惠券发放记录请求导出",
"id": "4612b9c083aecec1"
},
{
"metadata": {},
"cell_type": "code",
"outputs": [],
"execution_count": null,
"source": [
"import requests\n",
"\n",
"cookies = {\n",
" 'hive-adminSESSIONID': '7d9d2c6c-6ef4-4dba-8371-68d23a486dd2',\n",
" '_oauth2_proxy': 'hBgKHp7tNo1IhJZBL2UqonqXc1V6HO7cdu0ldRAQeTz7I7_FJtZhnxQI5sLfWeRvWYI-6jA2oHgv284pIyK3MR2w6QPfhJgwJWuIvp5Cmt89M72kRzdpyYNaUjQVuMaR4x4cnOiyRe1gPR7e3eDtd8R7IkNmFSXjiK2ADU29o0Ay5QmN6GBmciJ0EwiWUtpwToOXldGn4vpgbxEdmxWLFEmucCK_2E3THUq2zjnje0P2OznxeQzVDUJ4xdfVFso1tiMicxevHLTOadyp2hdKFSjJ40dLlCX47JaWzWnth72pQBiUKejXkIeiO7iJ_xC21JwDdUT5sVZg2KHnG2p-BqUF9klUBhMaqozcodelKAg-62XuhrOYsk6BHV5ObIJ0jhqmq84n8mzuKNPeNERjZjNZ68-xwzT4uYi0Ffor3b7C64zmQ1LkTbOCQkF7B0Uh1tNv4ebDTDwffvaBN4JmbLm7BxGeymuLBiuWig3POpgUAQ00f7jXM78cWTD1G7B42IfokgiQHb9fWH_L7JOQ3_5hh-OD6heuqRu2vEkkgf8oGnS3ZCgL3YcExINio_jaO6qZjNR0A3nUvXApihvPn4JG7YWg2wYRM2yaXr_wA8ES3oklTDl7COldCLphaGzHntmWKK0hkQX2jZA4l94bfa7faDADiBi4B3A7U4UjoCJkmyXv0VOvke2Qmq7kodTi2A54LOm9UPZTaPlZ_vAt20nVYMiLTeXeLRjavaM70LclTKuHrYWZKhPREH3w255MqGiMiArmRUNHtzglYwdL4ncid-x3foLj3DZKwmZ5pdKXxV1aNPcvkewCMYNq19skv6goqU0KJ8urd46VjI1bKoquw6FdbmjRFNmHKBwAI3l-xzjYQrmFJYXUabmVeN7pqIULY46P640XngoElijcvYL7r6mo4rdmZwRXDc8oKOhh_A6QmEpvIQp47b6p-pJc9GOz1W221CLNG3O0hG5o7DfpHJBsy3pASJjjwiNedzbnyu57OTTu3JWr3epq0WyrmWBH0TAdmUyAoSDTka-7-Wo6bHcVThC6HzRSbc7-J9nAKkjEaostrfzKTHVZAaBUcyAjlqn1hz_-mRq8bYif3GQkzspQ-em0Em0pczfmOBwsmQJknE3oxi9safWmgqs9UIIrqECYzCJ-mhg-7GVN-tZYuHdYvzEoPh5kHXpRYgo1s8neh54HwcLj28BWD_34Dr2BhuReKH82GGJt5-WQzJ3JDsKLADDIx7mNW06GwLERit34I8T4KNU_5B8UgvDtkBGkGY9FeteROnuCaHGCLafLt6uNCdK6A7Gqa0oFDSZHfY-nJVXQPrSpZo19JlrirA5Xk6s2jCVSwi5LZAxR1EFzQjOZADfDmYKDU35B2wKAV5I-agUPokheCarDmotj4hffqKcGs9DnhwzHTe9O3enO8NV-RHkNRYcgb7DydMwhEG8FIlyQhPzuKainBdkySJNNGCyF8tp8k1EA0-b_aDnMjr7SNMyVqmzCNlq8GoLJ16L51B-LEMmpq_0LG3-fCZpqH-VcF4_eJqIAn4JsqwY8nZJZt2AjxEz4QmtAxunNeRnwPQgwimOfVpZJGDWO4TqY_gvtDqpOPt404Wb3Ln4DF9e_W6RS3gq5_X7QXKyadI1rcqJX8KRkZNw5PraU5Wr4OkGgTvGlaFyxkEoEB1AmxDk5Lhp10TYG6cGcQLcHKfXkpHCHlCVsJwFtbz6r4v0vzjM2Q9ZN1_t2eQ2t1uvwAUJdj9O1IM7OFNU3ru1xUihQMAyIdsTdyYPxd3q01U1kKhstR5oUWA2XsAu6aZGKQwG6sAcO4wumKbPc9He4OCPY10zcmBNJyx2aOVAuUXARYp5HX-0CwLXvKUf8DmV2L7aXCLtdCp1jFFmlufERyBopFFLRGptRqDSfG9Y7JvdemjuqcVQPswJEhWZKBb81eG-Mb2ouHBsnUdiKnBhn7P7B8iq5BgM1W0kqVLKU3LbSEULxM8FoN7jIzgTXbD0aNHqBuwu3kcGwtbU9w9mrgAGLHUy96n0L2Py-fhV_Vzz6D0u9nUWdN5uhOR-pDzFY5YBfrIS5BgEiqX-epXq7Ishdf2X6caM5G6zLnCRcE2HR31XyjGHfwVeeqIcJeQAP_Y6l6NquLu1xFH3fx_IyY5qsnyI_S6W4-9yItHK7jZ2N8pEaB0u6yCkAG82yjw8o3v0-z7KZbTWs5vtwK0vhpBl3TgFrtE_yTK1gY9GqsWj1GtrvBRyUXiHqF85oHRcjuH_GUGgewXEfDn4m6PvcTBk5A2NkHce-LpF96ZjMFrrnnKxXATVPzIvnqsjjwj8tEPhd5m5A3v6Qn-5J0cX_1PAHgQwDGXRVzq2O4E96JEKqZQgpQTCIkZs9XGVHUoEALezg0C2OLNVNRfch9hAEja9YN7pf21B52bmjH6W7wv3C9qiE-Q-RxNn17Xu8j-8GKNlmwz7TaHcUfRWlGsQIUJ4lMeCU78A9zfZBZASCLaDX0oUyaNn77xddpTb96R-RTJqzl3dyKXbDScPFRdkB5td-Jql_ByjetxcUuDhof4WXHdXSN1nv1L6cET7imShEFk-RvFD2qvQveXzqvjngqpV-C_X7Jd4iYmqPerXdW22_Wh_soFLYSLLiKzlZ5JSxZ_WLt5uYzvBv04YXVWam_O07vJPwePSRvT8QbvNCC58IiVAJOeCYSopPVaTdD9uw94ybE5F5Sy0XlAB23nWSjrEd6Zy7yYza02iTIX7idxvNb0VWogGoCBjb6FowXpS5wLOEtFIMNVHowJEV4MkLasF7LQled2T5AkSQFSZFSCkWD96bhvuIUi9_fttTUKtQoSrFjhtg21f8lHA2pwlFK7jLbLzDTYnODK2qu9N6b8WcZauWpaSrkTyOC0s=|1775179342|E8jGyUr-5HOtfbTYWCgElRa2gR6Yx3HFKSrSKJYLBZk=',\n",
" 'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%224210192048793363%22%2C%22first_id%22%3A%2219b6df4cc821138-0de2a4b89caaa9-4c657b58-1327104-19b6df4cc8319da%22%2C%22props%22%3A%7B%22%24latest_traffic_source_type%22%3A%22%E7%9B%B4%E6%8E%A5%E6%B5%81%E9%87%8F%22%2C%22%24latest_search_keyword%22%3A%22%E6%9C%AA%E5%8F%96%E5%88%B0%E5%80%BC_%E7%9B%B4%E6%8E%A5%E6%89%93%E5%BC%80%22%2C%22%24latest_referrer%22%3A%22%22%7D%2C%22%24device_id%22%3A%2219b6df4cc821138-0de2a4b89caaa9-4c657b58-1327104-19b6df4cc8319da%22%7D',\n",
" '_yg_pre': 'leYfk4cBTaeTaeIcuU0sC6XCYYmJSaD4MorRnro9uSMIP-Z5r1zrru_998WKASt_UFFGnCwPU98C6t_7V69MHHL-vlT1XQQim7M4X_8fi-PIHBKqE2UWzd2KGTF_8FMahKURVFkOSph1LsiEHwX_PtbxyGmy4cvPpyxJ',\n",
"}\n",
"\n",
"headers = {\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",
" 'content-type': 'application/json;charset=UTF-8',\n",
" 'origin': 'https://manage-pre.f6yc.com',\n",
" 'priority': 'u=1, i',\n",
" 'referer': 'https://manage-pre.f6yc.com/',\n",
" 'sec-ch-ua': '\"Chromium\";v=\"146\", \"Not-A.Brand\";v=\"24\", \"Microsoft Edge\";v=\"146\"',\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/146.0.0.0 Safari/537.36 Edg/146.0.0.0',\n",
" 'x-requested-with': 'XMLHttpRequest',\n",
" # 'cookie': 'hive-adminSESSIONID=7d9d2c6c-6ef4-4dba-8371-68d23a486dd2; _oauth2_proxy=hBgKHp7tNo1IhJZBL2UqonqXc1V6HO7cdu0ldRAQeTz7I7_FJtZhnxQI5sLfWeRvWYI-6jA2oHgv284pIyK3MR2w6QPfhJgwJWuIvp5Cmt89M72kRzdpyYNaUjQVuMaR4x4cnOiyRe1gPR7e3eDtd8R7IkNmFSXjiK2ADU29o0Ay5QmN6GBmciJ0EwiWUtpwToOXldGn4vpgbxEdmxWLFEmucCK_2E3THUq2zjnje0P2OznxeQzVDUJ4xdfVFso1tiMicxevHLTOadyp2hdKFSjJ40dLlCX47JaWzWnth72pQBiUKejXkIeiO7iJ_xC21JwDdUT5sVZg2KHnG2p-BqUF9klUBhMaqozcodelKAg-62XuhrOYsk6BHV5ObIJ0jhqmq84n8mzuKNPeNERjZjNZ68-xwzT4uYi0Ffor3b7C64zmQ1LkTbOCQkF7B0Uh1tNv4ebDTDwffvaBN4JmbLm7BxGeymuLBiuWig3POpgUAQ00f7jXM78cWTD1G7B42IfokgiQHb9fWH_L7JOQ3_5hh-OD6heuqRu2vEkkgf8oGnS3ZCgL3YcExINio_jaO6qZjNR0A3nUvXApihvPn4JG7YWg2wYRM2yaXr_wA8ES3oklTDl7COldCLphaGzHntmWKK0hkQX2jZA4l94bfa7faDADiBi4B3A7U4UjoCJkmyXv0VOvke2Qmq7kodTi2A54LOm9UPZTaPlZ_vAt20nVYMiLTeXeLRjavaM70LclTKuHrYWZKhPREH3w255MqGiMiArmRUNHtzglYwdL4ncid-x3foLj3DZKwmZ5pdKXxV1aNPcvkewCMYNq19skv6goqU0KJ8urd46VjI1bKoquw6FdbmjRFNmHKBwAI3l-xzjYQrmFJYXUabmVeN7pqIULY46P640XngoElijcvYL7r6mo4rdmZwRXDc8oKOhh_A6QmEpvIQp47b6p-pJc9GOz1W221CLNG3O0hG5o7DfpHJBsy3pASJjjwiNedzbnyu57OTTu3JWr3epq0WyrmWBH0TAdmUyAoSDTka-7-Wo6bHcVThC6HzRSbc7-J9nAKkjEaostrfzKTHVZAaBUcyAjlqn1hz_-mRq8bYif3GQkzspQ-em0Em0pczfmOBwsmQJknE3oxi9safWmgqs9UIIrqECYzCJ-mhg-7GVN-tZYuHdYvzEoPh5kHXpRYgo1s8neh54HwcLj28BWD_34Dr2BhuReKH82GGJt5-WQzJ3JDsKLADDIx7mNW06GwLERit34I8T4KNU_5B8UgvDtkBGkGY9FeteROnuCaHGCLafLt6uNCdK6A7Gqa0oFDSZHfY-nJVXQPrSpZo19JlrirA5Xk6s2jCVSwi5LZAxR1EFzQjOZADfDmYKDU35B2wKAV5I-agUPokheCarDmotj4hffqKcGs9DnhwzHTe9O3enO8NV-RHkNRYcgb7DydMwhEG8FIlyQhPzuKainBdkySJNNGCyF8tp8k1EA0-b_aDnMjr7SNMyVqmzCNlq8GoLJ16L51B-LEMmpq_0LG3-fCZpqH-VcF4_eJqIAn4JsqwY8nZJZt2AjxEz4QmtAxunNeRnwPQgwimOfVpZJGDWO4TqY_gvtDqpOPt404Wb3Ln4DF9e_W6RS3gq5_X7QXKyadI1rcqJX8KRkZNw5PraU5Wr4OkGgTvGlaFyxkEoEB1AmxDk5Lhp10TYG6cGcQLcHKfXkpHCHlCVsJwFtbz6r4v0vzjM2Q9ZN1_t2eQ2t1uvwAUJdj9O1IM7OFNU3ru1xUihQMAyIdsTdyYPxd3q01U1kKhstR5oUWA2XsAu6aZGKQwG6sAcO4wumKbPc9He4OCPY10zcmBNJyx2aOVAuUXARYp5HX-0CwLXvKUf8DmV2L7aXCLtdCp1jFFmlufERyBopFFLRGptRqDSfG9Y7JvdemjuqcVQPswJEhWZKBb81eG-Mb2ouHBsnUdiKnBhn7P7B8iq5BgM1W0kqVLKU3LbSEULxM8FoN7jIzgTXbD0aNHqBuwu3kcGwtbU9w9mrgAGLHUy96n0L2Py-fhV_Vzz6D0u9nUWdN5uhOR-pDzFY5YBfrIS5BgEiqX-epXq7Ishdf2X6caM5G6zLnCRcE2HR31XyjGHfwVeeqIcJeQAP_Y6l6NquLu1xFH3fx_IyY5qsnyI_S6W4-9yItHK7jZ2N8pEaB0u6yCkAG82yjw8o3v0-z7KZbTWs5vtwK0vhpBl3TgFrtE_yTK1gY9GqsWj1GtrvBRyUXiHqF85oHRcjuH_GUGgewXEfDn4m6PvcTBk5A2NkHce-LpF96ZjMFrrnnKxXATVPzIvnqsjjwj8tEPhd5m5A3v6Qn-5J0cX_1PAHgQwDGXRVzq2O4E96JEKqZQgpQTCIkZs9XGVHUoEALezg0C2OLNVNRfch9hAEja9YN7pf21B52bmjH6W7wv3C9qiE-Q-RxNn17Xu8j-8GKNlmwz7TaHcUfRWlGsQIUJ4lMeCU78A9zfZBZASCLaDX0oUyaNn77xddpTb96R-RTJqzl3dyKXbDScPFRdkB5td-Jql_ByjetxcUuDhof4WXHdXSN1nv1L6cET7imShEFk-RvFD2qvQveXzqvjngqpV-C_X7Jd4iYmqPerXdW22_Wh_soFLYSLLiKzlZ5JSxZ_WLt5uYzvBv04YXVWam_O07vJPwePSRvT8QbvNCC58IiVAJOeCYSopPVaTdD9uw94ybE5F5Sy0XlAB23nWSjrEd6Zy7yYza02iTIX7idxvNb0VWogGoCBjb6FowXpS5wLOEtFIMNVHowJEV4MkLasF7LQled2T5AkSQFSZFSCkWD96bhvuIUi9_fttTUKtQoSrFjhtg21f8lHA2pwlFK7jLbLzDTYnODK2qu9N6b8WcZauWpaSrkTyOC0s=|1775179342|E8jGyUr-5HOtfbTYWCgElRa2gR6Yx3HFKSrSKJYLBZk=; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%224210192048793363%22%2C%22first_id%22%3A%2219b6df4cc821138-0de2a4b89caaa9-4c657b58-1327104-19b6df4cc8319da%22%2C%22props%22%3A%7B%22%24latest_traffic_source_type%22%3A%22%E7%9B%B4%E6%8E%A5%E6%B5%81%E9%87%8F%22%2C%22%24latest_search_keyword%22%3A%22%E6%9C%AA%E5%8F%96%E5%88%B0%E5%80%BC_%E7%9B%B4%E6%8E%A5%E6%89%93%E5%BC%80%22%2C%22%24latest_referrer%22%3A%22%22%7D%2C%22%24device_id%22%3A%2219b6df4cc821138-0de2a4b89caaa9-4c657b58-1327104-19b6df4cc8319da%22%7D; _yg_pre=leYfk4cBTaeTaeIcuU0sC6XCYYmJSaD4MorRnro9uSMIP-Z5r1zrru_998WKASt_UFFGnCwPU98C6t_7V69MHHL-vlT1XQQim7M4X_8fi-PIHBKqE2UWzd2KGTF_8FMahKURVFkOSph1LsiEHwX_PtbxyGmy4cvPpyxJ',\n",
"}\n",
"\n",
"json_data = {\n",
" 'statusList': [],\n",
" 'couponName': '',\n",
" 'createBy': '',\n",
" 'takeSourceCode': '',\n",
" 'keyword': '',\n",
" 'takeTimeBegin': '2026-03-10', # 开始时间\n",
" 'takeTimeEnd': '2026-04-09', #结束时间\n",
"}\n",
"\n",
"response = requests.post('https://manage-pre.f6yc.com/hive-admin/coupon/export', cookies=cookies, headers=headers, json=json_data)\n",
"\n"
],
"id": "917b264f2d45a022"
},
{
"metadata": {},
"cell_type": "markdown",
"source": "# 获取导出列表",
"id": "109cfbab50a5f15"
},
{
"cell_type": "code",
"id": "4c4a36f3",
"metadata": {
"ExecuteTime": {
"end_time": "2026-04-09T05:58:42.655993700Z",
"start_time": "2026-04-09T05:58:42.133250300Z"
}
},
"source": [
"import requests\n",
"\n",
"cookies = {\n",
" 'hive-adminSESSIONID': 'cf22b8bf-1b92-43cf-946e-584d9b159cca',\n",
" '_oauth2_proxy': 'hBgKHp7tNo1IhJZBL2UqonqXc1V6HO7cdu0ldRAQeTz7I7_FJtZhnxQI5sLfWeRvWYI-6jA2oHgv284pIyK3MR2w6QPfhJgwJWuIvp5Cmt89M72kRzdpyYNaUjQVuMaR4x4cnOiyRe1gPR7e3eDtd8R7IkNmFSXjiK2ADU29o0Ay5QmN6GBmciJ0EwiWUtpwToOXldGn4vpgbxEdmxWLFEmucCK_2E3THUq2zjnje0P2OznxeQzVDUJ4xdfVFso1tiMicxevHLTOadyp2hdKFSjJ40dLlCX47JaWzWnth72pQBiUKejXkIeiO7iJ_xC21JwDdUT5sVZg2KHnG2p-BqUF9klUBhMaqozcodelKAg-62XuhrOYsk6BHV5ObIJ0jhqmq84n8mzuKNPeNERjZjNZ68-xwzT4uYi0Ffor3b7C64zmQ1LkTbOCQkF7B0Uh1tNv4ebDTDwffvaBN4JmbLm7BxGeymuLBiuWig3POpgUAQ00f7jXM78cWTD1G7B42IfokgiQHb9fWH_L7JOQ3_5hh-OD6heuqRu2vEkkgf8oGnS3ZCgL3YcExINio_jaO6qZjNR0A3nUvXApihvPn4JG7YWg2wYRM2yaXr_wA8ES3oklTDl7COldCLphaGzHntmWKK0hkQX2jZA4l94bfa7faDADiBi4B3A7U4UjoCJkmyXv0VOvke2Qmq7kodTi2A54LOm9UPZTaPlZ_vAt20nVYMiLTeXeLRjavaM70LclTKuHrYWZKhPREH3w255MqGiMiArmRUNHtzglYwdL4ncid-x3foLj3DZKwmZ5pdKXxV1aNPcvkewCMYNq19skv6goqU0KJ8urd46VjI1bKoquw6FdbmjRFNmHKBwAI3l-xzjYQrmFJYXUabmVeN7pqIULY46P640XngoElijcvYL7r6mo4rdmZwRXDc8oKOhh_A6QmEpvIQp47b6p-pJc9GOz1W221CLNG3O0hG5o7DfpHJBsy3pASJjjwiNedzbnyu57OTTu3JWr3epq0WyrmWBH0TAdmUyAoSDTka-7-Wo6bHcVThC6HzRSbc7-J9nAKkjEaostrfzKTHVZAaBUcyAjlqn1hz_-mRq8bYif3GQkzspQ-em0Em0pczfmOBwsmQJknE3oxi9safWmgqs9UIIrqECYzCJ-mhg-7GVN-tZYuHdYvzEoPh5kHXpRYgo1s8neh54HwcLj28BWD_34Dr2BhuReKH82GGJt5-WQzJ3JDsKLADDIx7mNW06GwLERit34I8T4KNU_5B8UgvDtkBGkGY9FeteROnuCaHGCLafLt6uNCdK6A7Gqa0oFDSZHfY-nJVXQPrSpZo19JlrirA5Xk6s2jCVSwi5LZAxR1EFzQjOZADfDmYKDU35B2wKAV5I-agUPokheCarDmotj4hffqKcGs9DnhwzHTe9O3enO8NV-RHkNRYcgb7DydMwhEG8FIlyQhPzuKainBdkySJNNGCyF8tp8k1EA0-b_aDnMjr7SNMyVqmzCNlq8GoLJ16L51B-LEMmpq_0LG3-fCZpqH-VcF4_eJqIAn4JsqwY8nZJZt2AjxEz4QmtAxunNeRnwPQgwimOfVpZJGDWO4TqY_gvtDqpOPt404Wb3Ln4DF9e_W6RS3gq5_X7QXKyadI1rcqJX8KRkZNw5PraU5Wr4OkGgTvGlaFyxkEoEB1AmxDk5Lhp10TYG6cGcQLcHKfXkpHCHlCVsJwFtbz6r4v0vzjM2Q9ZN1_t2eQ2t1uvwAUJdj9O1IM7OFNU3ru1xUihQMAyIdsTdyYPxd3q01U1kKhstR5oUWA2XsAu6aZGKQwG6sAcO4wumKbPc9He4OCPY10zcmBNJyx2aOVAuUXARYp5HX-0CwLXvKUf8DmV2L7aXCLtdCp1jFFmlufERyBopFFLRGptRqDSfG9Y7JvdemjuqcVQPswJEhWZKBb81eG-Mb2ouHBsnUdiKnBhn7P7B8iq5BgM1W0kqVLKU3LbSEULxM8FoN7jIzgTXbD0aNHqBuwu3kcGwtbU9w9mrgAGLHUy96n0L2Py-fhV_Vzz6D0u9nUWdN5uhOR-pDzFY5YBfrIS5BgEiqX-epXq7Ishdf2X6caM5G6zLnCRcE2HR31XyjGHfwVeeqIcJeQAP_Y6l6NquLu1xFH3fx_IyY5qsnyI_S6W4-9yItHK7jZ2N8pEaB0u6yCkAG82yjw8o3v0-z7KZbTWs5vtwK0vhpBl3TgFrtE_yTK1gY9GqsWj1GtrvBRyUXiHqF85oHRcjuH_GUGgewXEfDn4m6PvcTBk5A2NkHce-LpF96ZjMFrrnnKxXATVPzIvnqsjjwj8tEPhd5m5A3v6Qn-5J0cX_1PAHgQwDGXRVzq2O4E96JEKqZQgpQTCIkZs9XGVHUoEALezg0C2OLNVNRfch9hAEja9YN7pf21B52bmjH6W7wv3C9qiE-Q-RxNn17Xu8j-8GKNlmwz7TaHcUfRWlGsQIUJ4lMeCU78A9zfZBZASCLaDX0oUyaNn77xddpTb96R-RTJqzl3dyKXbDScPFRdkB5td-Jql_ByjetxcUuDhof4WXHdXSN1nv1L6cET7imShEFk-RvFD2qvQveXzqvjngqpV-C_X7Jd4iYmqPerXdW22_Wh_soFLYSLLiKzlZ5JSxZ_WLt5uYzvBv04YXVWam_O07vJPwePSRvT8QbvNCC58IiVAJOeCYSopPVaTdD9uw94ybE5F5Sy0XlAB23nWSjrEd6Zy7yYza02iTIX7idxvNb0VWogGoCBjb6FowXpS5wLOEtFIMNVHowJEV4MkLasF7LQled2T5AkSQFSZFSCkWD96bhvuIUi9_fttTUKtQoSrFjhtg21f8lHA2pwlFK7jLbLzDTYnODK2qu9N6b8WcZauWpaSrkTyOC0s=|1775179342|E8jGyUr-5HOtfbTYWCgElRa2gR6Yx3HFKSrSKJYLBZk=',\n",
" 'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%224210192048793363%22%2C%22first_id%22%3A%2219b6df4cc821138-0de2a4b89caaa9-4c657b58-1327104-19b6df4cc8319da%22%2C%22props%22%3A%7B%22%24latest_traffic_source_type%22%3A%22%E7%9B%B4%E6%8E%A5%E6%B5%81%E9%87%8F%22%2C%22%24latest_search_keyword%22%3A%22%E6%9C%AA%E5%8F%96%E5%88%B0%E5%80%BC_%E7%9B%B4%E6%8E%A5%E6%89%93%E5%BC%80%22%2C%22%24latest_referrer%22%3A%22%22%7D%2C%22%24device_id%22%3A%2219b6df4cc821138-0de2a4b89caaa9-4c657b58-1327104-19b6df4cc8319da%22%7D',\n",
" '_yg_pre': 'leYfk4cBTaeTaeIcuU0sC6XCYYmJSaD4MorRnro9uSMIP-Z5r1zrru_998WKASt_UFFGnCwPU98C6t_7V69MHHL-vlT1XQQim7M4X_8fi-PIHBKqE2UWzd2KGTF_8FMahKURVFkOSph1LsiEHwX_PtbxyGmy4cvPpyxJ',\n",
"}\n",
"\n",
"headers = {\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",
" 'priority': 'u=1, i',\n",
" 'referer': 'https://manage-pre.f6yc.com/',\n",
" 'sec-ch-ua': '\"Chromium\";v=\"146\", \"Not-A.Brand\";v=\"24\", \"Microsoft Edge\";v=\"146\"',\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/146.0.0.0 Safari/537.36 Edg/146.0.0.0',\n",
" 'x-requested-with': 'XMLHttpRequest',\n",
"}\n",
"\n",
"response = requests.get('https://manage-pre.f6yc.com/hive-admin/download/queryList', cookies=cookies, headers=headers)\n",
"download_list = response.json().get(\"data\")"
],
"outputs": [
{
"data": {
"text/plain": [
"{'code': 200,\n",
" 'data': [{'creationtime': 1775705041000,\n",
" 'id': '111',\n",
" 'statDesc': '导出完成',\n",
" 'state': 20,\n",
" 'type': 10,\n",
" 'typeDesc': '订单导出'},\n",
" {'creationtime': 1775704980000,\n",
" 'id': '110',\n",
" 'statDesc': '导出完成',\n",
" 'state': 20,\n",
" 'type': 10,\n",
" 'typeDesc': '订单导出'},\n",
" {'creationtime': 1775703259000,\n",
" 'id': '109',\n",
" 'statDesc': '导出完成',\n",
" 'state': 20,\n",
" 'type': 20,\n",
" 'typeDesc': '优惠券发放记录导出'},\n",
" {'creationtime': 1775703199000,\n",
" 'id': '108',\n",
" 'statDesc': '导出完成',\n",
" 'state': 20,\n",
" 'type': 10,\n",
" 'typeDesc': '订单导出'}],\n",
" 'message': 'SUCCESS'}"
]
},
"execution_count": 1,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 1
},
{
"metadata": {},
"cell_type": "markdown",
"source": "# 获取下载链接",
"id": "57bfbf72959cb37c"
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2026-04-09T06:00:49.811171700Z",
"start_time": "2026-04-09T06:00:49.449069900Z"
}
},
"cell_type": "code",
"source": [
"import requests\n",
"\n",
"cookies = {\n",
" 'hive-adminSESSIONID': '7d9d2c6c-6ef4-4dba-8371-68d23a486dd2',\n",
" '_oauth2_proxy': 'hBgKHp7tNo1IhJZBL2UqonqXc1V6HO7cdu0ldRAQeTz7I7_FJtZhnxQI5sLfWeRvWYI-6jA2oHgv284pIyK3MR2w6QPfhJgwJWuIvp5Cmt89M72kRzdpyYNaUjQVuMaR4x4cnOiyRe1gPR7e3eDtd8R7IkNmFSXjiK2ADU29o0Ay5QmN6GBmciJ0EwiWUtpwToOXldGn4vpgbxEdmxWLFEmucCK_2E3THUq2zjnje0P2OznxeQzVDUJ4xdfVFso1tiMicxevHLTOadyp2hdKFSjJ40dLlCX47JaWzWnth72pQBiUKejXkIeiO7iJ_xC21JwDdUT5sVZg2KHnG2p-BqUF9klUBhMaqozcodelKAg-62XuhrOYsk6BHV5ObIJ0jhqmq84n8mzuKNPeNERjZjNZ68-xwzT4uYi0Ffor3b7C64zmQ1LkTbOCQkF7B0Uh1tNv4ebDTDwffvaBN4JmbLm7BxGeymuLBiuWig3POpgUAQ00f7jXM78cWTD1G7B42IfokgiQHb9fWH_L7JOQ3_5hh-OD6heuqRu2vEkkgf8oGnS3ZCgL3YcExINio_jaO6qZjNR0A3nUvXApihvPn4JG7YWg2wYRM2yaXr_wA8ES3oklTDl7COldCLphaGzHntmWKK0hkQX2jZA4l94bfa7faDADiBi4B3A7U4UjoCJkmyXv0VOvke2Qmq7kodTi2A54LOm9UPZTaPlZ_vAt20nVYMiLTeXeLRjavaM70LclTKuHrYWZKhPREH3w255MqGiMiArmRUNHtzglYwdL4ncid-x3foLj3DZKwmZ5pdKXxV1aNPcvkewCMYNq19skv6goqU0KJ8urd46VjI1bKoquw6FdbmjRFNmHKBwAI3l-xzjYQrmFJYXUabmVeN7pqIULY46P640XngoElijcvYL7r6mo4rdmZwRXDc8oKOhh_A6QmEpvIQp47b6p-pJc9GOz1W221CLNG3O0hG5o7DfpHJBsy3pASJjjwiNedzbnyu57OTTu3JWr3epq0WyrmWBH0TAdmUyAoSDTka-7-Wo6bHcVThC6HzRSbc7-J9nAKkjEaostrfzKTHVZAaBUcyAjlqn1hz_-mRq8bYif3GQkzspQ-em0Em0pczfmOBwsmQJknE3oxi9safWmgqs9UIIrqECYzCJ-mhg-7GVN-tZYuHdYvzEoPh5kHXpRYgo1s8neh54HwcLj28BWD_34Dr2BhuReKH82GGJt5-WQzJ3JDsKLADDIx7mNW06GwLERit34I8T4KNU_5B8UgvDtkBGkGY9FeteROnuCaHGCLafLt6uNCdK6A7Gqa0oFDSZHfY-nJVXQPrSpZo19JlrirA5Xk6s2jCVSwi5LZAxR1EFzQjOZADfDmYKDU35B2wKAV5I-agUPokheCarDmotj4hffqKcGs9DnhwzHTe9O3enO8NV-RHkNRYcgb7DydMwhEG8FIlyQhPzuKainBdkySJNNGCyF8tp8k1EA0-b_aDnMjr7SNMyVqmzCNlq8GoLJ16L51B-LEMmpq_0LG3-fCZpqH-VcF4_eJqIAn4JsqwY8nZJZt2AjxEz4QmtAxunNeRnwPQgwimOfVpZJGDWO4TqY_gvtDqpOPt404Wb3Ln4DF9e_W6RS3gq5_X7QXKyadI1rcqJX8KRkZNw5PraU5Wr4OkGgTvGlaFyxkEoEB1AmxDk5Lhp10TYG6cGcQLcHKfXkpHCHlCVsJwFtbz6r4v0vzjM2Q9ZN1_t2eQ2t1uvwAUJdj9O1IM7OFNU3ru1xUihQMAyIdsTdyYPxd3q01U1kKhstR5oUWA2XsAu6aZGKQwG6sAcO4wumKbPc9He4OCPY10zcmBNJyx2aOVAuUXARYp5HX-0CwLXvKUf8DmV2L7aXCLtdCp1jFFmlufERyBopFFLRGptRqDSfG9Y7JvdemjuqcVQPswJEhWZKBb81eG-Mb2ouHBsnUdiKnBhn7P7B8iq5BgM1W0kqVLKU3LbSEULxM8FoN7jIzgTXbD0aNHqBuwu3kcGwtbU9w9mrgAGLHUy96n0L2Py-fhV_Vzz6D0u9nUWdN5uhOR-pDzFY5YBfrIS5BgEiqX-epXq7Ishdf2X6caM5G6zLnCRcE2HR31XyjGHfwVeeqIcJeQAP_Y6l6NquLu1xFH3fx_IyY5qsnyI_S6W4-9yItHK7jZ2N8pEaB0u6yCkAG82yjw8o3v0-z7KZbTWs5vtwK0vhpBl3TgFrtE_yTK1gY9GqsWj1GtrvBRyUXiHqF85oHRcjuH_GUGgewXEfDn4m6PvcTBk5A2NkHce-LpF96ZjMFrrnnKxXATVPzIvnqsjjwj8tEPhd5m5A3v6Qn-5J0cX_1PAHgQwDGXRVzq2O4E96JEKqZQgpQTCIkZs9XGVHUoEALezg0C2OLNVNRfch9hAEja9YN7pf21B52bmjH6W7wv3C9qiE-Q-RxNn17Xu8j-8GKNlmwz7TaHcUfRWlGsQIUJ4lMeCU78A9zfZBZASCLaDX0oUyaNn77xddpTb96R-RTJqzl3dyKXbDScPFRdkB5td-Jql_ByjetxcUuDhof4WXHdXSN1nv1L6cET7imShEFk-RvFD2qvQveXzqvjngqpV-C_X7Jd4iYmqPerXdW22_Wh_soFLYSLLiKzlZ5JSxZ_WLt5uYzvBv04YXVWam_O07vJPwePSRvT8QbvNCC58IiVAJOeCYSopPVaTdD9uw94ybE5F5Sy0XlAB23nWSjrEd6Zy7yYza02iTIX7idxvNb0VWogGoCBjb6FowXpS5wLOEtFIMNVHowJEV4MkLasF7LQled2T5AkSQFSZFSCkWD96bhvuIUi9_fttTUKtQoSrFjhtg21f8lHA2pwlFK7jLbLzDTYnODK2qu9N6b8WcZauWpaSrkTyOC0s=|1775179342|E8jGyUr-5HOtfbTYWCgElRa2gR6Yx3HFKSrSKJYLBZk=',\n",
" 'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%224210192048793363%22%2C%22first_id%22%3A%2219b6df4cc821138-0de2a4b89caaa9-4c657b58-1327104-19b6df4cc8319da%22%2C%22props%22%3A%7B%22%24latest_traffic_source_type%22%3A%22%E7%9B%B4%E6%8E%A5%E6%B5%81%E9%87%8F%22%2C%22%24latest_search_keyword%22%3A%22%E6%9C%AA%E5%8F%96%E5%88%B0%E5%80%BC_%E7%9B%B4%E6%8E%A5%E6%89%93%E5%BC%80%22%2C%22%24latest_referrer%22%3A%22%22%7D%2C%22%24device_id%22%3A%2219b6df4cc821138-0de2a4b89caaa9-4c657b58-1327104-19b6df4cc8319da%22%7D',\n",
" '_yg_pre': 'leYfk4cBTaeTaeIcuU0sC6XCYYmJSaD4MorRnro9uSMIP-Z5r1zrru_998WKASt_UFFGnCwPU98C6t_7V69MHHL-vlT1XQQim7M4X_8fi-PIHBKqE2UWzd2KGTF_8FMahKURVFkOSph1LsiEHwX_PtbxyGmy4cvPpyxJ',\n",
"}\n",
"\n",
"headers = {\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",
" 'priority': 'u=1, i',\n",
" 'referer': 'https://manage-pre.f6yc.com/',\n",
" 'sec-ch-ua': '\"Chromium\";v=\"146\", \"Not-A.Brand\";v=\"24\", \"Microsoft Edge\";v=\"146\"',\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/146.0.0.0 Safari/537.36 Edg/146.0.0.0',\n",
" 'x-requested-with': 'XMLHttpRequest',\n",
" # 'cookie': 'hive-adminSESSIONID=7d9d2c6c-6ef4-4dba-8371-68d23a486dd2; _oauth2_proxy=hBgKHp7tNo1IhJZBL2UqonqXc1V6HO7cdu0ldRAQeTz7I7_FJtZhnxQI5sLfWeRvWYI-6jA2oHgv284pIyK3MR2w6QPfhJgwJWuIvp5Cmt89M72kRzdpyYNaUjQVuMaR4x4cnOiyRe1gPR7e3eDtd8R7IkNmFSXjiK2ADU29o0Ay5QmN6GBmciJ0EwiWUtpwToOXldGn4vpgbxEdmxWLFEmucCK_2E3THUq2zjnje0P2OznxeQzVDUJ4xdfVFso1tiMicxevHLTOadyp2hdKFSjJ40dLlCX47JaWzWnth72pQBiUKejXkIeiO7iJ_xC21JwDdUT5sVZg2KHnG2p-BqUF9klUBhMaqozcodelKAg-62XuhrOYsk6BHV5ObIJ0jhqmq84n8mzuKNPeNERjZjNZ68-xwzT4uYi0Ffor3b7C64zmQ1LkTbOCQkF7B0Uh1tNv4ebDTDwffvaBN4JmbLm7BxGeymuLBiuWig3POpgUAQ00f7jXM78cWTD1G7B42IfokgiQHb9fWH_L7JOQ3_5hh-OD6heuqRu2vEkkgf8oGnS3ZCgL3YcExINio_jaO6qZjNR0A3nUvXApihvPn4JG7YWg2wYRM2yaXr_wA8ES3oklTDl7COldCLphaGzHntmWKK0hkQX2jZA4l94bfa7faDADiBi4B3A7U4UjoCJkmyXv0VOvke2Qmq7kodTi2A54LOm9UPZTaPlZ_vAt20nVYMiLTeXeLRjavaM70LclTKuHrYWZKhPREH3w255MqGiMiArmRUNHtzglYwdL4ncid-x3foLj3DZKwmZ5pdKXxV1aNPcvkewCMYNq19skv6goqU0KJ8urd46VjI1bKoquw6FdbmjRFNmHKBwAI3l-xzjYQrmFJYXUabmVeN7pqIULY46P640XngoElijcvYL7r6mo4rdmZwRXDc8oKOhh_A6QmEpvIQp47b6p-pJc9GOz1W221CLNG3O0hG5o7DfpHJBsy3pASJjjwiNedzbnyu57OTTu3JWr3epq0WyrmWBH0TAdmUyAoSDTka-7-Wo6bHcVThC6HzRSbc7-J9nAKkjEaostrfzKTHVZAaBUcyAjlqn1hz_-mRq8bYif3GQkzspQ-em0Em0pczfmOBwsmQJknE3oxi9safWmgqs9UIIrqECYzCJ-mhg-7GVN-tZYuHdYvzEoPh5kHXpRYgo1s8neh54HwcLj28BWD_34Dr2BhuReKH82GGJt5-WQzJ3JDsKLADDIx7mNW06GwLERit34I8T4KNU_5B8UgvDtkBGkGY9FeteROnuCaHGCLafLt6uNCdK6A7Gqa0oFDSZHfY-nJVXQPrSpZo19JlrirA5Xk6s2jCVSwi5LZAxR1EFzQjOZADfDmYKDU35B2wKAV5I-agUPokheCarDmotj4hffqKcGs9DnhwzHTe9O3enO8NV-RHkNRYcgb7DydMwhEG8FIlyQhPzuKainBdkySJNNGCyF8tp8k1EA0-b_aDnMjr7SNMyVqmzCNlq8GoLJ16L51B-LEMmpq_0LG3-fCZpqH-VcF4_eJqIAn4JsqwY8nZJZt2AjxEz4QmtAxunNeRnwPQgwimOfVpZJGDWO4TqY_gvtDqpOPt404Wb3Ln4DF9e_W6RS3gq5_X7QXKyadI1rcqJX8KRkZNw5PraU5Wr4OkGgTvGlaFyxkEoEB1AmxDk5Lhp10TYG6cGcQLcHKfXkpHCHlCVsJwFtbz6r4v0vzjM2Q9ZN1_t2eQ2t1uvwAUJdj9O1IM7OFNU3ru1xUihQMAyIdsTdyYPxd3q01U1kKhstR5oUWA2XsAu6aZGKQwG6sAcO4wumKbPc9He4OCPY10zcmBNJyx2aOVAuUXARYp5HX-0CwLXvKUf8DmV2L7aXCLtdCp1jFFmlufERyBopFFLRGptRqDSfG9Y7JvdemjuqcVQPswJEhWZKBb81eG-Mb2ouHBsnUdiKnBhn7P7B8iq5BgM1W0kqVLKU3LbSEULxM8FoN7jIzgTXbD0aNHqBuwu3kcGwtbU9w9mrgAGLHUy96n0L2Py-fhV_Vzz6D0u9nUWdN5uhOR-pDzFY5YBfrIS5BgEiqX-epXq7Ishdf2X6caM5G6zLnCRcE2HR31XyjGHfwVeeqIcJeQAP_Y6l6NquLu1xFH3fx_IyY5qsnyI_S6W4-9yItHK7jZ2N8pEaB0u6yCkAG82yjw8o3v0-z7KZbTWs5vtwK0vhpBl3TgFrtE_yTK1gY9GqsWj1GtrvBRyUXiHqF85oHRcjuH_GUGgewXEfDn4m6PvcTBk5A2NkHce-LpF96ZjMFrrnnKxXATVPzIvnqsjjwj8tEPhd5m5A3v6Qn-5J0cX_1PAHgQwDGXRVzq2O4E96JEKqZQgpQTCIkZs9XGVHUoEALezg0C2OLNVNRfch9hAEja9YN7pf21B52bmjH6W7wv3C9qiE-Q-RxNn17Xu8j-8GKNlmwz7TaHcUfRWlGsQIUJ4lMeCU78A9zfZBZASCLaDX0oUyaNn77xddpTb96R-RTJqzl3dyKXbDScPFRdkB5td-Jql_ByjetxcUuDhof4WXHdXSN1nv1L6cET7imShEFk-RvFD2qvQveXzqvjngqpV-C_X7Jd4iYmqPerXdW22_Wh_soFLYSLLiKzlZ5JSxZ_WLt5uYzvBv04YXVWam_O07vJPwePSRvT8QbvNCC58IiVAJOeCYSopPVaTdD9uw94ybE5F5Sy0XlAB23nWSjrEd6Zy7yYza02iTIX7idxvNb0VWogGoCBjb6FowXpS5wLOEtFIMNVHowJEV4MkLasF7LQled2T5AkSQFSZFSCkWD96bhvuIUi9_fttTUKtQoSrFjhtg21f8lHA2pwlFK7jLbLzDTYnODK2qu9N6b8WcZauWpaSrkTyOC0s=|1775179342|E8jGyUr-5HOtfbTYWCgElRa2gR6Yx3HFKSrSKJYLBZk=; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%224210192048793363%22%2C%22first_id%22%3A%2219b6df4cc821138-0de2a4b89caaa9-4c657b58-1327104-19b6df4cc8319da%22%2C%22props%22%3A%7B%22%24latest_traffic_source_type%22%3A%22%E7%9B%B4%E6%8E%A5%E6%B5%81%E9%87%8F%22%2C%22%24latest_search_keyword%22%3A%22%E6%9C%AA%E5%8F%96%E5%88%B0%E5%80%BC_%E7%9B%B4%E6%8E%A5%E6%89%93%E5%BC%80%22%2C%22%24latest_referrer%22%3A%22%22%7D%2C%22%24device_id%22%3A%2219b6df4cc821138-0de2a4b89caaa9-4c657b58-1327104-19b6df4cc8319da%22%7D; _yg_pre=leYfk4cBTaeTaeIcuU0sC6XCYYmJSaD4MorRnro9uSMIP-Z5r1zrru_998WKASt_UFFGnCwPU98C6t_7V69MHHL-vlT1XQQim7M4X_8fi-PIHBKqE2UWzd2KGTF_8FMahKURVFkOSph1LsiEHwX_PtbxyGmy4cvPpyxJ',\n",
"}\n",
"\n",
"params = {\n",
" 'id': download_list[0].get(\"id\"),\n",
"}\n",
"\n",
"response = requests.get(\n",
" 'https://manage-pre.f6yc.com/hive-admin/download/getFilePath',\n",
" params=params,\n",
" cookies=cookies,\n",
" headers=headers,\n",
")\n",
"response.json()\n",
"download_url = response.json().get(\"data\")"
],
"id": "d2a8883a6a563a45",
"outputs": [],
"execution_count": 2
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2026-04-09T06:01:04.066051500Z",
"start_time": "2026-04-09T06:01:03.978024500Z"
}
},
"cell_type": "code",
"source": "response.json()",
"id": "8b35e2d9f511f79d",
"outputs": [
{
"data": {
"text/plain": [
"{'code': 200,\n",
" 'data': 'https://f.f6yc.com/hive-admin/pre/coupon/97ebd3b858254f7885cba4e7000dd899.xls?Expires=1775715048&OSSAccessKeyId=LTAI5t6DU5niE8MN7hYh8AVs&Signature=J0nPbFraDmNmoWhr21u51NA61CQ%3D',\n",
" 'message': 'SUCCESS'}"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 4
}
],
"metadata": {
"kernelspec": {
"display_name": "F6+宜搭+其它",
"language": "python",
"name": "python3"
},
"language_info": {
"name": "python",
"version": "3.13.11"
}
},
"nbformat": 4,
"nbformat_minor": 5
}