326 lines
24 KiB
Plaintext
326 lines
24 KiB
Plaintext
{
|
|
"cells": [
|
|
{
|
|
"metadata": {},
|
|
"cell_type": "markdown",
|
|
"source": "## 查询门店id",
|
|
"id": "5557d4f4c85d53cc"
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"id": "initial_id",
|
|
"metadata": {
|
|
"collapsed": true,
|
|
"ExecuteTime": {
|
|
"end_time": "2025-12-12T07:29:41.157240Z",
|
|
"start_time": "2025-12-12T07:29:08.460285Z"
|
|
}
|
|
},
|
|
"source": [
|
|
"import requests\n",
|
|
"import pandas as pd\n",
|
|
"\n",
|
|
"\n",
|
|
"cookies = {\n",
|
|
" 'hive-adminSESSIONID': 'f9cb47f4-1282-486d-96d6-1982d34c49c8',\n",
|
|
" '_oauth2_proxy': 'mvL_QOjGIp355OrsfOtv2-EXi9A8Haa-FH4i42oHvXmocOybyqQxzb14MRzWbSWWMKi_TqmJ_trJiwNiNg-RLH5CPgiEC5kR5Vyhul334UJzcCpna1smqWB9mrZNkrwOwEUl44NzMo5AVJwf6W3FIircGegvlY6IX7ZVO75x7dZhZVjrKFMBLfRLJo3FMPJkiOueQ7lMgnMWdyevGvPIeVMotvmTh9Zr-z1xqlFHUsbdA4Q5Lr-D22uX8ZnnmoPNAhAnXr0gZZQAvbYx3SJ3ZkipWTEO_Nitwn0qB2ucIYnm1BdhTUpzivM-cJy-nRM2oYExSZbgsDk4oQjdhdUNJ6D3kmM9spAxgxYqRrSpbGeRKQte3wu8phcYJrTw0N5mOrtz65qNdp7GpQWwbc-4RGo8iNFXBG2J0W6TphDyrm10ZpSdNolVcCQcyNU4u92QURcIPK65HGLDGcTrbz4ckqNlI3km-LyxVNZEj-QmXaKZdJxh7RhjoyQaPXONDS6AkBuXSOaSbshqgAjHABi0jIPAHyyF776AG04m7iWBSSdZjmAtw0nrwJ_O6s1R32TdNIyu1bFaAfl16S2lwEpe_xGJm9POAhFsbQNqmCrjlJ1nBcU5Ady-oP1bahlajxkIkOIklnSfwxHwFoAh4FeHteAWl2QhE-JxveZNNdi9g4BcHhxOInUMGnDFff8T9Vu5-K3wcjtsNCSCLSL3GLH2VD4rtNd5e72aFOcdKzx_dFXlAZN8ufUEAx8UQ_V5Z2wxSrx2yAgcyVJGH-02HE3zHwbi-if_iIZbIbZZHMsKmjunA1--t5EVhVk2ZmipA5GMP8zWUjaD0fVI6s-bRJrx2rLta6TRJVsi2zLONoe_3q9b9CvN0IN8VSCFAp6mqluuapM9skXuUWfEckn1qn07hEbHX6Te2Z__CSg5EJpatMnpufV3zMZA74g9cVKRclIM-gwIV4hrEF0CIGt5MHQWUl1m1VZAg_s9XjrQtgYUqqaRnc-8VEA-7os7YAQwIZnxB9sZh_S0P9-YnzzwS3aTZRZHQMCSap8Eaio6IpI9pdENLqTOaciErtQgsaNBlFctVkh3IPOpyMdmhew1I6mJHcXYCxWxUnJ7pQXYtMXcVq1OYM7hWnyCr3m96n3iB8k2X3-RwcrLuppIo9UW5zoF-o9Zmmy1XD4zvseyO_UihyIkdX1L4JdRGvAlpRfBfnKsw2S6Dc1kDn7bB581hDyz450n0cxr3A1X4iiW9ZNHiER5MUB6E7D61JNNyJsq1r6CV-xCBaVoCSSufFPegeUEoh45ibJrZSCaMqD6d386qdsPUqUu9vllXhuOQVU3K_39Ax90aPN0akpqaEym0UVzRuzWiAkVE-Ggt2ieVjIMgBQN11ZlVv7iFqlcdySe6aEoflNOW5Y0Jw3PjkNy6qhgN9trD_mAEH3P4Axh8pc6ttBXFKTsR3dephbZyy7z7iRFD46Yp-2fPCSWbsVvvxvBMLoyX1ll38m9MVH7vsQ2WIxQf8IL0DEHxwrmk8REOc9hs8maVNl2GkMmkMvO80tYo-OONXvUbtune_CwyLHs2Wy1GxQ2ZP5I3KfUVgr-7H3sULEv1oxpf6LH8jcILqsN8qRKov2B9bmoHj7qQuTIkCeQ-i34RAWGfdX-yLphhyNTswzry1JbdOPd6hXXRClb0YYgK7sdV_O4rCsuj_on3uxWIiSdMsJ7lWQn99mxb8iQCV6Bhr_2GNvUWcHsLNVBc7BhOmvqMtnfKxpV5QKEtN_nB27EBoNYp6DB0v2JcZyAW2CLR7mGMWAiYbU285R-NYVPsy-gJBhFKIL_GF8S6Yh8M4IwvRXjz_YfSjST6ac3JtvBOsqQaA1rarUli9ZAGY04Q93YqAZty3HXotk3KcnO3ML_y_Wckenwl3sdwRRiIcRI3Tu_ZKDV4IwLmPQ2WHX1LkIREfKMaWIyYaMjB9xK33ob16OixMOAdVhVo3K8a-it1G2atBwa6uBbTt1A6Pya7O0ciDKEzBN4_ygYqFCAPKbENjpKCsWOMp9fJT8CU3QAG_XX6G1yRsQzgq4_ouzf3Et6U_DTyJxso_YZp3NU0exvvaOpyDAm7jlTiT6XQcstw__ZA8sn5-8IAX2gT9yu82tten7C-0fJZ7K9gjRfBNRKW2YBbfaogQArIyyV9c54mCGUM2TXnTbCkrQa0Ge515StQPky5P7Oax7AJb_NOiyoIVylwl2rxZV385RudCWO2KdjdJiVLMANcT6gRX5v4zrtJSyY_1VynaBSsyf-sbuiDajm5vRmipZY1qvsJx80eGfHGcflz1vfZ0AGZExML2kvVgF9SIlNylOZW1c6FPHvzYo4TyJMOBtjBjtCbsbIvVSpIljrgO1glY9oGjQYud81hRkFi4FCPHuANHL06Cco2MY54iQYNNAKUfDGtYx3_YKbGKuJN1rpGIc2XTL-Ql7PmybpZCuWA-VJcVkPVKdOJppGMR7-rNuDub2BvfMQ9_TLcsuwsN7H6cbhbS34bhZ2P8WZh4OU4VN2BUnqMGALwRB22xqjqPvAWtpUbAFrss4YknkGu3mqV-SR5_VVVQqKSnOWaKYYDI2r9txeU08XemV7Tudqg-_jAS8-ru7wiMG0c-ZX81apHQWR3W4E8K7exI2IyizvmaLCpCivAZvFeOsAkZ80pYdUoJ185J779nelbtbNdbu_RSyFmsac9Re4Y-VqvwhR08-XLMBYRySlqMuIEzSA4BQ81Atvo1lCETWWllC-IRoXRH57KdKiQAS6lKZpESYVN77z0ddHUmiMUozXfnkzEfHgMVP3-Dn2v5NMerVO0bKuvejEPVE6OO8jobSCUZMKKuBXTSrlPoFdku1KBKPHZj26GEQq7D-LA1eZQfpPzl9z6xo=|1765163743|j3Qeb4IdoqUSvZjDKgFNIA7YsTGvXpZ1Y2r49L91gI4=',\n",
|
|
" 'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%224210192048793363%22%2C%22first_id%22%3A%221989d4783646e1-07c9f1a149173e8-4c657b58-2073600-1989d4783651ade%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%221989d4783646e1-07c9f1a149173e8-4c657b58-2073600-1989d4783651ade%22%7D',\n",
|
|
" '_yg_prod': 'EkX_f7K7eYt61spccZtpCE7FGQAxK5DfP_4PB6A0jCrCT1LYfszIPQQqjcJjPPEZL0J2pO07cfp8VG-4XSPkBfYzvRdjXVIjT2D0f57Q80efwwIJ0oqvVma_W4j__vTE3I3zSTbNFRCPiizeGHdACvMyZCP3EwNH',\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",
|
|
" 'cache-control': 'no-cache',\n",
|
|
" 'content-type': 'application/json;charset=UTF-8',\n",
|
|
" 'origin': 'https://manage.f6yc.com',\n",
|
|
" 'pragma': 'no-cache',\n",
|
|
" 'priority': 'u=1, i',\n",
|
|
" 'referer': 'https://manage.f6yc.com/',\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-requested-with': 'XMLHttpRequest',\n",
|
|
" # 'cookie': 'hive-adminSESSIONID=f9cb47f4-1282-486d-96d6-1982d34c49c8; _oauth2_proxy=mvL_QOjGIp355OrsfOtv2-EXi9A8Haa-FH4i42oHvXmocOybyqQxzb14MRzWbSWWMKi_TqmJ_trJiwNiNg-RLH5CPgiEC5kR5Vyhul334UJzcCpna1smqWB9mrZNkrwOwEUl44NzMo5AVJwf6W3FIircGegvlY6IX7ZVO75x7dZhZVjrKFMBLfRLJo3FMPJkiOueQ7lMgnMWdyevGvPIeVMotvmTh9Zr-z1xqlFHUsbdA4Q5Lr-D22uX8ZnnmoPNAhAnXr0gZZQAvbYx3SJ3ZkipWTEO_Nitwn0qB2ucIYnm1BdhTUpzivM-cJy-nRM2oYExSZbgsDk4oQjdhdUNJ6D3kmM9spAxgxYqRrSpbGeRKQte3wu8phcYJrTw0N5mOrtz65qNdp7GpQWwbc-4RGo8iNFXBG2J0W6TphDyrm10ZpSdNolVcCQcyNU4u92QURcIPK65HGLDGcTrbz4ckqNlI3km-LyxVNZEj-QmXaKZdJxh7RhjoyQaPXONDS6AkBuXSOaSbshqgAjHABi0jIPAHyyF776AG04m7iWBSSdZjmAtw0nrwJ_O6s1R32TdNIyu1bFaAfl16S2lwEpe_xGJm9POAhFsbQNqmCrjlJ1nBcU5Ady-oP1bahlajxkIkOIklnSfwxHwFoAh4FeHteAWl2QhE-JxveZNNdi9g4BcHhxOInUMGnDFff8T9Vu5-K3wcjtsNCSCLSL3GLH2VD4rtNd5e72aFOcdKzx_dFXlAZN8ufUEAx8UQ_V5Z2wxSrx2yAgcyVJGH-02HE3zHwbi-if_iIZbIbZZHMsKmjunA1--t5EVhVk2ZmipA5GMP8zWUjaD0fVI6s-bRJrx2rLta6TRJVsi2zLONoe_3q9b9CvN0IN8VSCFAp6mqluuapM9skXuUWfEckn1qn07hEbHX6Te2Z__CSg5EJpatMnpufV3zMZA74g9cVKRclIM-gwIV4hrEF0CIGt5MHQWUl1m1VZAg_s9XjrQtgYUqqaRnc-8VEA-7os7YAQwIZnxB9sZh_S0P9-YnzzwS3aTZRZHQMCSap8Eaio6IpI9pdENLqTOaciErtQgsaNBlFctVkh3IPOpyMdmhew1I6mJHcXYCxWxUnJ7pQXYtMXcVq1OYM7hWnyCr3m96n3iB8k2X3-RwcrLuppIo9UW5zoF-o9Zmmy1XD4zvseyO_UihyIkdX1L4JdRGvAlpRfBfnKsw2S6Dc1kDn7bB581hDyz450n0cxr3A1X4iiW9ZNHiER5MUB6E7D61JNNyJsq1r6CV-xCBaVoCSSufFPegeUEoh45ibJrZSCaMqD6d386qdsPUqUu9vllXhuOQVU3K_39Ax90aPN0akpqaEym0UVzRuzWiAkVE-Ggt2ieVjIMgBQN11ZlVv7iFqlcdySe6aEoflNOW5Y0Jw3PjkNy6qhgN9trD_mAEH3P4Axh8pc6ttBXFKTsR3dephbZyy7z7iRFD46Yp-2fPCSWbsVvvxvBMLoyX1ll38m9MVH7vsQ2WIxQf8IL0DEHxwrmk8REOc9hs8maVNl2GkMmkMvO80tYo-OONXvUbtune_CwyLHs2Wy1GxQ2ZP5I3KfUVgr-7H3sULEv1oxpf6LH8jcILqsN8qRKov2B9bmoHj7qQuTIkCeQ-i34RAWGfdX-yLphhyNTswzry1JbdOPd6hXXRClb0YYgK7sdV_O4rCsuj_on3uxWIiSdMsJ7lWQn99mxb8iQCV6Bhr_2GNvUWcHsLNVBc7BhOmvqMtnfKxpV5QKEtN_nB27EBoNYp6DB0v2JcZyAW2CLR7mGMWAiYbU285R-NYVPsy-gJBhFKIL_GF8S6Yh8M4IwvRXjz_YfSjST6ac3JtvBOsqQaA1rarUli9ZAGY04Q93YqAZty3HXotk3KcnO3ML_y_Wckenwl3sdwRRiIcRI3Tu_ZKDV4IwLmPQ2WHX1LkIREfKMaWIyYaMjB9xK33ob16OixMOAdVhVo3K8a-it1G2atBwa6uBbTt1A6Pya7O0ciDKEzBN4_ygYqFCAPKbENjpKCsWOMp9fJT8CU3QAG_XX6G1yRsQzgq4_ouzf3Et6U_DTyJxso_YZp3NU0exvvaOpyDAm7jlTiT6XQcstw__ZA8sn5-8IAX2gT9yu82tten7C-0fJZ7K9gjRfBNRKW2YBbfaogQArIyyV9c54mCGUM2TXnTbCkrQa0Ge515StQPky5P7Oax7AJb_NOiyoIVylwl2rxZV385RudCWO2KdjdJiVLMANcT6gRX5v4zrtJSyY_1VynaBSsyf-sbuiDajm5vRmipZY1qvsJx80eGfHGcflz1vfZ0AGZExML2kvVgF9SIlNylOZW1c6FPHvzYo4TyJMOBtjBjtCbsbIvVSpIljrgO1glY9oGjQYud81hRkFi4FCPHuANHL06Cco2MY54iQYNNAKUfDGtYx3_YKbGKuJN1rpGIc2XTL-Ql7PmybpZCuWA-VJcVkPVKdOJppGMR7-rNuDub2BvfMQ9_TLcsuwsN7H6cbhbS34bhZ2P8WZh4OU4VN2BUnqMGALwRB22xqjqPvAWtpUbAFrss4YknkGu3mqV-SR5_VVVQqKSnOWaKYYDI2r9txeU08XemV7Tudqg-_jAS8-ru7wiMG0c-ZX81apHQWR3W4E8K7exI2IyizvmaLCpCivAZvFeOsAkZ80pYdUoJ185J779nelbtbNdbu_RSyFmsac9Re4Y-VqvwhR08-XLMBYRySlqMuIEzSA4BQ81Atvo1lCETWWllC-IRoXRH57KdKiQAS6lKZpESYVN77z0ddHUmiMUozXfnkzEfHgMVP3-Dn2v5NMerVO0bKuvejEPVE6OO8jobSCUZMKKuBXTSrlPoFdku1KBKPHZj26GEQq7D-LA1eZQfpPzl9z6xo=|1765163743|j3Qeb4IdoqUSvZjDKgFNIA7YsTGvXpZ1Y2r49L91gI4=; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%224210192048793363%22%2C%22first_id%22%3A%221989d4783646e1-07c9f1a149173e8-4c657b58-2073600-1989d4783651ade%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%221989d4783646e1-07c9f1a149173e8-4c657b58-2073600-1989d4783651ade%22%7D; _yg_prod=EkX_f7K7eYt61spccZtpCE7FGQAxK5DfP_4PB6A0jCrCT1LYfszIPQQqjcJjPPEZL0J2pO07cfp8VG-4XSPkBfYzvRdjXVIjT2D0f57Q80efwwIJ0oqvVma_W4j__vTE3I3zSTbNFRCPiizeGHdACvMyZCP3EwNH',\n",
|
|
"}\n",
|
|
"\n",
|
|
"df = pd.read_excel(fr\"C:\\Users\\zy187\\Downloads\\经销商客户档案_20251212150454.xlsx\", sheet_name='Sheet1')\n",
|
|
"\n",
|
|
"all_data = []\n",
|
|
"for index, row in df.iterrows():\n",
|
|
"\n",
|
|
" json_data = {\n",
|
|
" 'currentPage': 1,\n",
|
|
" 'pageSize': 10,\n",
|
|
" 'licenseNo': '',\n",
|
|
" 'licenseName': '',\n",
|
|
" 'groupName': '',\n",
|
|
" 'code': '',\n",
|
|
" 'name': row[\"经销商名称\"],\n",
|
|
" 'orgId': '',\n",
|
|
" 'busiType': '',\n",
|
|
" 'saasVersion': '',\n",
|
|
" 'saasStatus': '',\n",
|
|
" 'province': '',\n",
|
|
" 'city': '',\n",
|
|
" 'area': '',\n",
|
|
" 'orgStatus': 0,\n",
|
|
" 'orgScale': '',\n",
|
|
" 'mainOrgOnly': 0,\n",
|
|
" 'saasEdition': '',\n",
|
|
" 'storeId': '',\n",
|
|
" 'franchiseGroupId': '',\n",
|
|
" 'minCreateTime': '',\n",
|
|
" 'maxCreateTime': '',\n",
|
|
" 'serviceImplPrincipalList': [],\n",
|
|
" 'containTest': True,\n",
|
|
" }\n",
|
|
"\n",
|
|
" response = requests.post('https://manage.f6yc.com/hive-admin/org/getAllOrgList', cookies=cookies, headers=headers, json=json_data)\n",
|
|
"\n",
|
|
"\n",
|
|
"\n",
|
|
" res_list = response.json().get(\"data\").get(\"records\",[])\n",
|
|
"\n",
|
|
" if len(res_list)>0:\n",
|
|
" idOwnOrg =res_list[0].get(\"pkId\")\n",
|
|
" print(\"idOwnOrg\",idOwnOrg)\n",
|
|
"\n",
|
|
" all_data.extend([(row[\"经销商名称\"],idOwnOrg)])\n",
|
|
"\n",
|
|
"\n",
|
|
"\n",
|
|
"\n"
|
|
],
|
|
"outputs": [
|
|
{
|
|
"name": "stdout",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"idOwnOrg 11240984669918316541\n",
|
|
"idOwnOrg 11240984669918263069\n",
|
|
"idOwnOrg 11240984669918134517\n",
|
|
"idOwnOrg 11240984669918353555\n",
|
|
"idOwnOrg 11240984669918245561\n",
|
|
"idOwnOrg 11240984669918327023\n",
|
|
"idOwnOrg 11240984669918356608\n",
|
|
"idOwnOrg 11240984669918150516\n",
|
|
"idOwnOrg 11240984669918117536\n",
|
|
"idOwnOrg 11240984669918343550\n",
|
|
"idOwnOrg 11240984669918194600\n",
|
|
"idOwnOrg 11240984669918344526\n",
|
|
"idOwnOrg 11240984669918360107\n",
|
|
"idOwnOrg 11240984669918235523\n",
|
|
"idOwnOrg 11240984669918196608\n",
|
|
"idOwnOrg 11240984669918261535\n",
|
|
"idOwnOrg 11240984669918071029\n",
|
|
"idOwnOrg 11240984669918381027\n",
|
|
"idOwnOrg 11240984669918120034\n",
|
|
"idOwnOrg 11240984669918358028\n",
|
|
"idOwnOrg 11240984669918347039\n",
|
|
"idOwnOrg 11240984669918394591\n",
|
|
"idOwnOrg 11240984669918131020\n",
|
|
"idOwnOrg 11240984669918237041\n",
|
|
"idOwnOrg 11240984669918357128\n",
|
|
"idOwnOrg 11240984669918396023\n",
|
|
"idOwnOrg 11240984669918374524\n",
|
|
"idOwnOrg 11240984669918245017\n",
|
|
"idOwnOrg 11240984669918168540\n",
|
|
"idOwnOrg 11240984669918116039\n",
|
|
"idOwnOrg 11240984669918258533\n"
|
|
]
|
|
}
|
|
],
|
|
"execution_count": 32
|
|
},
|
|
{
|
|
"metadata": {
|
|
"ExecuteTime": {
|
|
"end_time": "2025-12-12T07:29:47.534205Z",
|
|
"start_time": "2025-12-12T07:29:47.529652Z"
|
|
}
|
|
},
|
|
"cell_type": "code",
|
|
"source": "all_data",
|
|
"id": "4dd3af75970d1af3",
|
|
"outputs": [
|
|
{
|
|
"data": {
|
|
"text/plain": [
|
|
"[('松和汽车配件', '11240984669918316541'),\n",
|
|
" ('徐州真品汇', '11240984669918263069'),\n",
|
|
" ('仁和汽配', '11240984669918134517'),\n",
|
|
" ('良盛优配汽车配件', '11240984669918353555'),\n",
|
|
" ('泗县优配', '11240984669918245561'),\n",
|
|
" ('济南奥联汽配', '11240984669918327023'),\n",
|
|
" ('兴诚长江汽配', '11240984669918356608'),\n",
|
|
" ('沈阳小车优品', '11240984669918150516'),\n",
|
|
" ('蒙城百年盛汽配', '11240984669918117536'),\n",
|
|
" ('昆明宇纵商贸', '11240984669918343550'),\n",
|
|
" ('义守汽配', '11240984669918194600'),\n",
|
|
" ('美恒汽配连锁', '11240984669918344526'),\n",
|
|
" ('东勉商贸汽配', '11240984669918360107'),\n",
|
|
" ('丰之瑞汽配', '11240984669918235523'),\n",
|
|
" ('华伟汽配', '11240984669918196608'),\n",
|
|
" ('好快全汽配信宜店报价机器人', '11240984669918261535'),\n",
|
|
" ('临泉福贵汽配哈弗售后', '11240984669918071029'),\n",
|
|
" ('天门雄发汽配', '11240984669918381027'),\n",
|
|
" ('安庆庆飞汽配', '11240984669918120034'),\n",
|
|
" ('山东易联汽配', '11240984669918358028'),\n",
|
|
" ('山西恩知途', '11240984669918347039'),\n",
|
|
" ('泰安市启滕汽车配件有限公司', '11240984669918394591'),\n",
|
|
" ('阜阳恒汇汽配', '11240984669918131020'),\n",
|
|
" ('成都申泓汽配', '11240984669918237041'),\n",
|
|
" ('沙洋康众汽配', '11240984669918357128'),\n",
|
|
" ('南京喆冠汽配有限公司', '11240984669918396023'),\n",
|
|
" ('沭阳优配汽配', '11240984669918374524'),\n",
|
|
" ('王三汽配', '11240984669918245017'),\n",
|
|
" ('翔瑞达汽配', '11240984669918168540'),\n",
|
|
" ('赣榆天顺汽配', '11240984669918116039'),\n",
|
|
" ('顶刮刮汽配', '11240984669918258533')]"
|
|
]
|
|
},
|
|
"execution_count": 33,
|
|
"metadata": {},
|
|
"output_type": "execute_result"
|
|
}
|
|
],
|
|
"execution_count": 33
|
|
},
|
|
{
|
|
"metadata": {
|
|
"ExecuteTime": {
|
|
"end_time": "2025-12-12T07:31:28.480590Z",
|
|
"start_time": "2025-12-12T07:31:21.323033Z"
|
|
}
|
|
},
|
|
"cell_type": "code",
|
|
"source": [
|
|
"import requests\n",
|
|
"\n",
|
|
"cookies = {\n",
|
|
" 'hive-adminSESSIONID': 'f9cb47f4-1282-486d-96d6-1982d34c49c8',\n",
|
|
" '_oauth2_proxy': 'mvL_QOjGIp355OrsfOtv2-EXi9A8Haa-FH4i42oHvXmocOybyqQxzb14MRzWbSWWMKi_TqmJ_trJiwNiNg-RLH5CPgiEC5kR5Vyhul334UJzcCpna1smqWB9mrZNkrwOwEUl44NzMo5AVJwf6W3FIircGegvlY6IX7ZVO75x7dZhZVjrKFMBLfRLJo3FMPJkiOueQ7lMgnMWdyevGvPIeVMotvmTh9Zr-z1xqlFHUsbdA4Q5Lr-D22uX8ZnnmoPNAhAnXr0gZZQAvbYx3SJ3ZkipWTEO_Nitwn0qB2ucIYnm1BdhTUpzivM-cJy-nRM2oYExSZbgsDk4oQjdhdUNJ6D3kmM9spAxgxYqRrSpbGeRKQte3wu8phcYJrTw0N5mOrtz65qNdp7GpQWwbc-4RGo8iNFXBG2J0W6TphDyrm10ZpSdNolVcCQcyNU4u92QURcIPK65HGLDGcTrbz4ckqNlI3km-LyxVNZEj-QmXaKZdJxh7RhjoyQaPXONDS6AkBuXSOaSbshqgAjHABi0jIPAHyyF776AG04m7iWBSSdZjmAtw0nrwJ_O6s1R32TdNIyu1bFaAfl16S2lwEpe_xGJm9POAhFsbQNqmCrjlJ1nBcU5Ady-oP1bahlajxkIkOIklnSfwxHwFoAh4FeHteAWl2QhE-JxveZNNdi9g4BcHhxOInUMGnDFff8T9Vu5-K3wcjtsNCSCLSL3GLH2VD4rtNd5e72aFOcdKzx_dFXlAZN8ufUEAx8UQ_V5Z2wxSrx2yAgcyVJGH-02HE3zHwbi-if_iIZbIbZZHMsKmjunA1--t5EVhVk2ZmipA5GMP8zWUjaD0fVI6s-bRJrx2rLta6TRJVsi2zLONoe_3q9b9CvN0IN8VSCFAp6mqluuapM9skXuUWfEckn1qn07hEbHX6Te2Z__CSg5EJpatMnpufV3zMZA74g9cVKRclIM-gwIV4hrEF0CIGt5MHQWUl1m1VZAg_s9XjrQtgYUqqaRnc-8VEA-7os7YAQwIZnxB9sZh_S0P9-YnzzwS3aTZRZHQMCSap8Eaio6IpI9pdENLqTOaciErtQgsaNBlFctVkh3IPOpyMdmhew1I6mJHcXYCxWxUnJ7pQXYtMXcVq1OYM7hWnyCr3m96n3iB8k2X3-RwcrLuppIo9UW5zoF-o9Zmmy1XD4zvseyO_UihyIkdX1L4JdRGvAlpRfBfnKsw2S6Dc1kDn7bB581hDyz450n0cxr3A1X4iiW9ZNHiER5MUB6E7D61JNNyJsq1r6CV-xCBaVoCSSufFPegeUEoh45ibJrZSCaMqD6d386qdsPUqUu9vllXhuOQVU3K_39Ax90aPN0akpqaEym0UVzRuzWiAkVE-Ggt2ieVjIMgBQN11ZlVv7iFqlcdySe6aEoflNOW5Y0Jw3PjkNy6qhgN9trD_mAEH3P4Axh8pc6ttBXFKTsR3dephbZyy7z7iRFD46Yp-2fPCSWbsVvvxvBMLoyX1ll38m9MVH7vsQ2WIxQf8IL0DEHxwrmk8REOc9hs8maVNl2GkMmkMvO80tYo-OONXvUbtune_CwyLHs2Wy1GxQ2ZP5I3KfUVgr-7H3sULEv1oxpf6LH8jcILqsN8qRKov2B9bmoHj7qQuTIkCeQ-i34RAWGfdX-yLphhyNTswzry1JbdOPd6hXXRClb0YYgK7sdV_O4rCsuj_on3uxWIiSdMsJ7lWQn99mxb8iQCV6Bhr_2GNvUWcHsLNVBc7BhOmvqMtnfKxpV5QKEtN_nB27EBoNYp6DB0v2JcZyAW2CLR7mGMWAiYbU285R-NYVPsy-gJBhFKIL_GF8S6Yh8M4IwvRXjz_YfSjST6ac3JtvBOsqQaA1rarUli9ZAGY04Q93YqAZty3HXotk3KcnO3ML_y_Wckenwl3sdwRRiIcRI3Tu_ZKDV4IwLmPQ2WHX1LkIREfKMaWIyYaMjB9xK33ob16OixMOAdVhVo3K8a-it1G2atBwa6uBbTt1A6Pya7O0ciDKEzBN4_ygYqFCAPKbENjpKCsWOMp9fJT8CU3QAG_XX6G1yRsQzgq4_ouzf3Et6U_DTyJxso_YZp3NU0exvvaOpyDAm7jlTiT6XQcstw__ZA8sn5-8IAX2gT9yu82tten7C-0fJZ7K9gjRfBNRKW2YBbfaogQArIyyV9c54mCGUM2TXnTbCkrQa0Ge515StQPky5P7Oax7AJb_NOiyoIVylwl2rxZV385RudCWO2KdjdJiVLMANcT6gRX5v4zrtJSyY_1VynaBSsyf-sbuiDajm5vRmipZY1qvsJx80eGfHGcflz1vfZ0AGZExML2kvVgF9SIlNylOZW1c6FPHvzYo4TyJMOBtjBjtCbsbIvVSpIljrgO1glY9oGjQYud81hRkFi4FCPHuANHL06Cco2MY54iQYNNAKUfDGtYx3_YKbGKuJN1rpGIc2XTL-Ql7PmybpZCuWA-VJcVkPVKdOJppGMR7-rNuDub2BvfMQ9_TLcsuwsN7H6cbhbS34bhZ2P8WZh4OU4VN2BUnqMGALwRB22xqjqPvAWtpUbAFrss4YknkGu3mqV-SR5_VVVQqKSnOWaKYYDI2r9txeU08XemV7Tudqg-_jAS8-ru7wiMG0c-ZX81apHQWR3W4E8K7exI2IyizvmaLCpCivAZvFeOsAkZ80pYdUoJ185J779nelbtbNdbu_RSyFmsac9Re4Y-VqvwhR08-XLMBYRySlqMuIEzSA4BQ81Atvo1lCETWWllC-IRoXRH57KdKiQAS6lKZpESYVN77z0ddHUmiMUozXfnkzEfHgMVP3-Dn2v5NMerVO0bKuvejEPVE6OO8jobSCUZMKKuBXTSrlPoFdku1KBKPHZj26GEQq7D-LA1eZQfpPzl9z6xo=|1765163743|j3Qeb4IdoqUSvZjDKgFNIA7YsTGvXpZ1Y2r49L91gI4=',\n",
|
|
" 'sensorsdata2015jssdkcross': '%7B%22distinct_id%22%3A%224210192048793363%22%2C%22first_id%22%3A%221989d4783646e1-07c9f1a149173e8-4c657b58-2073600-1989d4783651ade%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%221989d4783646e1-07c9f1a149173e8-4c657b58-2073600-1989d4783651ade%22%7D',\n",
|
|
" '_yg_prod': 'EkX_f7K7eYt61spccZtpCE7FGQAxK5DfP_4PB6A0jCrCT1LYfszIPQQqjcJjPPEZL0J2pO07cfp8VG-4XSPkBfYzvRdjXVIjT2D0f57Q80efwwIJ0oqvVma_W4j__vTE3I3zSTbNFRCPiizeGHdACvMyZCP3EwNH',\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",
|
|
" 'cache-control': 'no-cache',\n",
|
|
" 'pragma': 'no-cache',\n",
|
|
" 'priority': 'u=1, i',\n",
|
|
" 'referer': 'https://manage.f6yc.com/',\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",
|
|
" # 'cookie': 'hive-adminSESSIONID=f9cb47f4-1282-486d-96d6-1982d34c49c8; _oauth2_proxy=mvL_QOjGIp355OrsfOtv2-EXi9A8Haa-FH4i42oHvXmocOybyqQxzb14MRzWbSWWMKi_TqmJ_trJiwNiNg-RLH5CPgiEC5kR5Vyhul334UJzcCpna1smqWB9mrZNkrwOwEUl44NzMo5AVJwf6W3FIircGegvlY6IX7ZVO75x7dZhZVjrKFMBLfRLJo3FMPJkiOueQ7lMgnMWdyevGvPIeVMotvmTh9Zr-z1xqlFHUsbdA4Q5Lr-D22uX8ZnnmoPNAhAnXr0gZZQAvbYx3SJ3ZkipWTEO_Nitwn0qB2ucIYnm1BdhTUpzivM-cJy-nRM2oYExSZbgsDk4oQjdhdUNJ6D3kmM9spAxgxYqRrSpbGeRKQte3wu8phcYJrTw0N5mOrtz65qNdp7GpQWwbc-4RGo8iNFXBG2J0W6TphDyrm10ZpSdNolVcCQcyNU4u92QURcIPK65HGLDGcTrbz4ckqNlI3km-LyxVNZEj-QmXaKZdJxh7RhjoyQaPXONDS6AkBuXSOaSbshqgAjHABi0jIPAHyyF776AG04m7iWBSSdZjmAtw0nrwJ_O6s1R32TdNIyu1bFaAfl16S2lwEpe_xGJm9POAhFsbQNqmCrjlJ1nBcU5Ady-oP1bahlajxkIkOIklnSfwxHwFoAh4FeHteAWl2QhE-JxveZNNdi9g4BcHhxOInUMGnDFff8T9Vu5-K3wcjtsNCSCLSL3GLH2VD4rtNd5e72aFOcdKzx_dFXlAZN8ufUEAx8UQ_V5Z2wxSrx2yAgcyVJGH-02HE3zHwbi-if_iIZbIbZZHMsKmjunA1--t5EVhVk2ZmipA5GMP8zWUjaD0fVI6s-bRJrx2rLta6TRJVsi2zLONoe_3q9b9CvN0IN8VSCFAp6mqluuapM9skXuUWfEckn1qn07hEbHX6Te2Z__CSg5EJpatMnpufV3zMZA74g9cVKRclIM-gwIV4hrEF0CIGt5MHQWUl1m1VZAg_s9XjrQtgYUqqaRnc-8VEA-7os7YAQwIZnxB9sZh_S0P9-YnzzwS3aTZRZHQMCSap8Eaio6IpI9pdENLqTOaciErtQgsaNBlFctVkh3IPOpyMdmhew1I6mJHcXYCxWxUnJ7pQXYtMXcVq1OYM7hWnyCr3m96n3iB8k2X3-RwcrLuppIo9UW5zoF-o9Zmmy1XD4zvseyO_UihyIkdX1L4JdRGvAlpRfBfnKsw2S6Dc1kDn7bB581hDyz450n0cxr3A1X4iiW9ZNHiER5MUB6E7D61JNNyJsq1r6CV-xCBaVoCSSufFPegeUEoh45ibJrZSCaMqD6d386qdsPUqUu9vllXhuOQVU3K_39Ax90aPN0akpqaEym0UVzRuzWiAkVE-Ggt2ieVjIMgBQN11ZlVv7iFqlcdySe6aEoflNOW5Y0Jw3PjkNy6qhgN9trD_mAEH3P4Axh8pc6ttBXFKTsR3dephbZyy7z7iRFD46Yp-2fPCSWbsVvvxvBMLoyX1ll38m9MVH7vsQ2WIxQf8IL0DEHxwrmk8REOc9hs8maVNl2GkMmkMvO80tYo-OONXvUbtune_CwyLHs2Wy1GxQ2ZP5I3KfUVgr-7H3sULEv1oxpf6LH8jcILqsN8qRKov2B9bmoHj7qQuTIkCeQ-i34RAWGfdX-yLphhyNTswzry1JbdOPd6hXXRClb0YYgK7sdV_O4rCsuj_on3uxWIiSdMsJ7lWQn99mxb8iQCV6Bhr_2GNvUWcHsLNVBc7BhOmvqMtnfKxpV5QKEtN_nB27EBoNYp6DB0v2JcZyAW2CLR7mGMWAiYbU285R-NYVPsy-gJBhFKIL_GF8S6Yh8M4IwvRXjz_YfSjST6ac3JtvBOsqQaA1rarUli9ZAGY04Q93YqAZty3HXotk3KcnO3ML_y_Wckenwl3sdwRRiIcRI3Tu_ZKDV4IwLmPQ2WHX1LkIREfKMaWIyYaMjB9xK33ob16OixMOAdVhVo3K8a-it1G2atBwa6uBbTt1A6Pya7O0ciDKEzBN4_ygYqFCAPKbENjpKCsWOMp9fJT8CU3QAG_XX6G1yRsQzgq4_ouzf3Et6U_DTyJxso_YZp3NU0exvvaOpyDAm7jlTiT6XQcstw__ZA8sn5-8IAX2gT9yu82tten7C-0fJZ7K9gjRfBNRKW2YBbfaogQArIyyV9c54mCGUM2TXnTbCkrQa0Ge515StQPky5P7Oax7AJb_NOiyoIVylwl2rxZV385RudCWO2KdjdJiVLMANcT6gRX5v4zrtJSyY_1VynaBSsyf-sbuiDajm5vRmipZY1qvsJx80eGfHGcflz1vfZ0AGZExML2kvVgF9SIlNylOZW1c6FPHvzYo4TyJMOBtjBjtCbsbIvVSpIljrgO1glY9oGjQYud81hRkFi4FCPHuANHL06Cco2MY54iQYNNAKUfDGtYx3_YKbGKuJN1rpGIc2XTL-Ql7PmybpZCuWA-VJcVkPVKdOJppGMR7-rNuDub2BvfMQ9_TLcsuwsN7H6cbhbS34bhZ2P8WZh4OU4VN2BUnqMGALwRB22xqjqPvAWtpUbAFrss4YknkGu3mqV-SR5_VVVQqKSnOWaKYYDI2r9txeU08XemV7Tudqg-_jAS8-ru7wiMG0c-ZX81apHQWR3W4E8K7exI2IyizvmaLCpCivAZvFeOsAkZ80pYdUoJ185J779nelbtbNdbu_RSyFmsac9Re4Y-VqvwhR08-XLMBYRySlqMuIEzSA4BQ81Atvo1lCETWWllC-IRoXRH57KdKiQAS6lKZpESYVN77z0ddHUmiMUozXfnkzEfHgMVP3-Dn2v5NMerVO0bKuvejEPVE6OO8jobSCUZMKKuBXTSrlPoFdku1KBKPHZj26GEQq7D-LA1eZQfpPzl9z6xo=|1765163743|j3Qeb4IdoqUSvZjDKgFNIA7YsTGvXpZ1Y2r49L91gI4=; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%224210192048793363%22%2C%22first_id%22%3A%221989d4783646e1-07c9f1a149173e8-4c657b58-2073600-1989d4783651ade%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%221989d4783646e1-07c9f1a149173e8-4c657b58-2073600-1989d4783651ade%22%7D; _yg_prod=EkX_f7K7eYt61spccZtpCE7FGQAxK5DfP_4PB6A0jCrCT1LYfszIPQQqjcJjPPEZL0J2pO07cfp8VG-4XSPkBfYzvRdjXVIjT2D0f57Q80efwwIJ0oqvVma_W4j__vTE3I3zSTbNFRCPiizeGHdACvMyZCP3EwNH',\n",
|
|
"}\n",
|
|
"\n",
|
|
"new_all_data = []\n",
|
|
"for data,id in all_data:\n",
|
|
" id = int(id)\n",
|
|
" params = {\n",
|
|
" 'orgId': id,\n",
|
|
" }\n",
|
|
"\n",
|
|
" response = requests.get(\n",
|
|
" 'https://manage.f6yc.com/hive-admin/org/getOrgDetail',\n",
|
|
" params=params,\n",
|
|
" cookies=cookies,\n",
|
|
" headers=headers,\n",
|
|
" )\n",
|
|
"\n",
|
|
" new_data = response.json().get(\"data\").get(\"baseInfo\",{})\n",
|
|
"\n",
|
|
" new_all_data.append(new_data)\n",
|
|
"\n",
|
|
"df2 = pd.DataFrame(new_all_data)\n",
|
|
"df2.to_excel('经销商数据.xlsx', index=False)\n",
|
|
"\n"
|
|
],
|
|
"id": "c8936141d1266073",
|
|
"outputs": [],
|
|
"execution_count": 44
|
|
},
|
|
{
|
|
"metadata": {
|
|
"ExecuteTime": {
|
|
"end_time": "2025-12-12T07:30:37.248809Z",
|
|
"start_time": "2025-12-12T07:30:37.245187Z"
|
|
}
|
|
},
|
|
"cell_type": "code",
|
|
"source": [
|
|
"new_data = response.json()\n",
|
|
"print(new_data)"
|
|
],
|
|
"id": "43dd73dcd6d287df",
|
|
"outputs": [
|
|
{
|
|
"name": "stdout",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"{'code': 400, 'data': None, 'message': '请指定门店id'}\n"
|
|
]
|
|
}
|
|
],
|
|
"execution_count": 41
|
|
},
|
|
{
|
|
"metadata": {
|
|
"ExecuteTime": {
|
|
"end_time": "2025-12-12T07:31:02.404497Z",
|
|
"start_time": "2025-12-12T07:31:02.400528Z"
|
|
}
|
|
},
|
|
"cell_type": "code",
|
|
"source": "id",
|
|
"id": "6724695ec918fb78",
|
|
"outputs": [
|
|
{
|
|
"data": {
|
|
"text/plain": [
|
|
"11240984669918316541"
|
|
]
|
|
},
|
|
"execution_count": 43,
|
|
"metadata": {},
|
|
"output_type": "execute_result"
|
|
}
|
|
],
|
|
"execution_count": 43
|
|
}
|
|
],
|
|
"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
|
|
}
|