1195 lines
69 KiB
Plaintext
1195 lines
69 KiB
Plaintext
{
|
|
"cells": [
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 2,
|
|
"metadata": {},
|
|
"outputs": [
|
|
{
|
|
"name": "stdout",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"0 8887118501 cc3085b9-b11c-43b3-940b-652f0e3b2c97 195159084238961158 {}\n",
|
|
"1 8885039152 519ad0aa-b6a9-4f11-b753-1d76bd0d416d 110740004537832492 {}\n",
|
|
"2 8884752023 c4c7646b-349f-43ce-a26e-c354067604b7 110740004537832492 {}\n",
|
|
"3 8880048546 c007a239-54bd-4d00-a036-c3e3f2ad8df8 3048162260682931 {}\n",
|
|
"4 8879624865 fdd076f1-bbf4-4e6c-89c7-b979b61fdaea 110740004537832492 {}\n",
|
|
"5 8878995409 fc70a6d5-fa72-40cd-b72a-da8e2f53787e 195159084238961158 {}\n",
|
|
"6 8874545917 565f3ab1-ef14-46bd-bd25-1baafe3fd49a 195159084238961158 {}\n",
|
|
"7 8874571832 81a05033-e9da-4615-ac2a-992408e77713 195159084238961158 {}\n",
|
|
"8 8874607148 5fb86527-d575-4ede-aae4-6120fe906cd8 195159084238961158 {}\n",
|
|
"9 8874614003 aa017c17-c8e0-419a-9542-545f066fb40e 195159084238961158 {}\n",
|
|
"10 8856077278 49c3a85f-08f4-46ad-ae8c-2042081870f1 110740004537832492 {}\n",
|
|
"11 8854123881 60448685-f737-4390-a6fb-33c7665d1c83 110740004537832492 {}\n",
|
|
"12 8853983147 ada52be5-53a5-4fe2-ac8d-015fca3ffd68 110740004537832492 {}\n",
|
|
"13 8853044837 2f2092d9-7177-4d45-ac09-a45c7cdee86c 3048162260682931 {}\n",
|
|
"14 8849860474 d8f8f0f7-c090-4c94-8f65-e937e42b8918 3048162260682931 {}\n",
|
|
"15 8848962894 de275c44-0312-4753-bc3a-37d4516dad46 110740004537832492 {}\n",
|
|
"16 8842131346 54967ba4-c407-4443-a4db-72fe4591045e 195159084238961158 {}\n",
|
|
"17 8841099739 6c6ac95a-614b-47d8-85c0-db95041b3ee5 195159084238961158 {}\n",
|
|
"18 8838129952 fe11ea39-871e-416a-9ec4-8999042b9dc1 195159084238961158 {}\n",
|
|
"19 8837629691 bdf3e336-035c-42c9-a7fc-462a7fe9ff7c 3048162260682931 {}\n",
|
|
"20 8837219863 044ee15e-9e7d-4f07-abae-e2eb81346ef8 110740004537832492 {}\n",
|
|
"21 8827176682 e6659810-1bd6-4987-8f5f-9a941a079e91 110740004537832492 {}\n",
|
|
"22 8826048388 4a545a53-12fe-402c-844b-812f35346455 110740004537832492 {}\n",
|
|
"23 8825179905 e2dbe0b3-d44c-4301-af7f-ae744c53d1c4 195159084238961158 {}\n",
|
|
"24 8823568837 02f4e7ef-7586-4e7d-9f58-06ce661dceec 110740004537832492 {}\n",
|
|
"25 8821696003 e9e58011-e523-4eca-9eab-be127103d6e0 110740004537832492 {}\n",
|
|
"26 8821607981 f0576c07-5a41-4397-8d15-ab91a98c6975 195159084238961158 {}\n",
|
|
"27 8821284943 ed6dcc82-3339-4ed6-86ed-ac9938d71b41 3048162260682931 {}\n",
|
|
"28 8819972490 37f9fbd6-1fb7-4c66-82e3-a544e5e79a94 3048162260682931 {}\n",
|
|
"29 8809878770 725ae951-bd00-4956-a073-cf7935742f20 3048162260682931 {}\n",
|
|
"30 8809473264 e1b4a710-ea26-43e6-935f-9e8e74db8cfb 110740004537832492 {}\n",
|
|
"31 8809201083 0fb6d3e2-adc3-4629-bec1-3ba738616640 195159084238961158 {}\n",
|
|
"32 8805613600 5a1e3149-ab55-4dde-b72b-06b12aa3da34 110740004537832492 {}\n",
|
|
"33 8801828402 cbddb0ae-2b4f-4869-a10d-3bda55ef4057 110740004537832492 {}\n",
|
|
"34 8779883386 b2d7227f-00dc-4dc4-ab83-975359de3a5a 3048162260682931 {}\n",
|
|
"35 8777422117 c834252d-05d0-474d-abfd-33020c7fef34 110740004537832492 {}\n",
|
|
"36 8777293599 46ec4f33-b06d-4bec-b021-e9092f097764 110740004537832492 {}\n",
|
|
"37 8774892961 d4da02d4-c84c-402f-b4f0-e287ebf30562 110740004537832492 {}\n",
|
|
"38 8774409830 4a71bbb1-aa73-4fd2-b07b-25498dddd433 3048162260682931 {}\n",
|
|
"39 8765043986 309d20a8-dca0-493d-bf0d-00f3a856e303 110740004537832492 {}\n",
|
|
"40 8761742958 c8c55d38-6984-4756-949b-cd1ea69afb18 195159084238961158 {}\n",
|
|
"41 8760255271 14806071-751c-4768-a982-9655b61b64b5 110740004537832492 {}\n",
|
|
"42 8758514031 c9a6c9e4-71e7-4bd4-a532-b9e393067fba 3048162260682931 {}\n",
|
|
"43 8758388942 2bba7c6c-e088-45d8-9eeb-d2aabb4e372d 3048162260682931 {}\n",
|
|
"44 8756383665 e39cc159-9d2b-47c1-a563-5f30c0a4aa10 110740004537832492 {}\n",
|
|
"45 8754376458 4454e868-3c66-44a1-a6ab-dd724be26c96 3048162260682931 {}\n",
|
|
"46 8754284849 95bd1675-c101-4a1f-a45a-cdb4b786a47d 195159084238961158 {}\n",
|
|
"47 8753899866 59cc4487-53ab-417b-877c-ac3776933bb4 110740004537832492 {}\n",
|
|
"48 8751665854 7a397e10-35fc-4330-b707-0ea90134ba87 110740004537832492 {}\n",
|
|
"49 8751031286 d5dda179-66b8-4fb3-9e8a-f8196dbac32a 110740004537832492 {}\n",
|
|
"50 8746616508 cd4cd31b-69f0-4720-b3fd-79e16dd110d5 110740004537832492 {}\n",
|
|
"51 8745663789 9114a7db-408d-4119-9f65-db51acaebd6e 195159084238961158 {}\n",
|
|
"52 8745572150 657133ea-25fd-4eb7-ad23-dec853f3c453 195159084238961158 {}\n",
|
|
"53 8730740814 6128783a-ce7c-4933-95a6-0e23ca3efbb6 110740004537832492 {}\n",
|
|
"54 8728271960 a5c58a7d-062e-4fe6-9566-be4700ed492a 110740004537832492 {}\n",
|
|
"55 8722140578 a8f8f5dc-e012-42e5-aba6-c8215a59205e 195159084238961158 {}\n",
|
|
"56 8718782855 c7b8652f-1754-4239-9621-ae76c3f4a85a 110740004537832492 {}\n",
|
|
"57 8714749863 64361840-bc9f-4521-a3da-50ad0ccf04c6 110740004537832492 {}\n",
|
|
"58 8714478994 a4b0de8a-e8b2-403d-9e15-668f97c695f1 3048162260682931 {}\n",
|
|
"59 8714397705 d39dc01b-0d02-44a7-a953-afed43251fba 3048162260682931 {}\n",
|
|
"60 8714238295 aaf70bf6-6096-412d-aef7-8e35fb48b8d1 3048162260682931 {}\n",
|
|
"61 8712537868 8c7ffb8d-faeb-4ee6-bc0c-b64f58eaf464 110740004537832492 {}\n",
|
|
"62 8711607973 b1e9aaf6-9cb0-4f83-8d9f-cbfa5147d8bb 110740004537832492 {}\n",
|
|
"63 8710727061 53c741a3-2064-4ae6-9817-428265abe5e5 110740004537832492 {}\n",
|
|
"64 8710446048 433aa2d3-a396-49d4-a90f-2e078bf92403 195159084238961158 {}\n",
|
|
"65 8709009130 e9919d4f-2514-4dc5-8156-e9ae1bbe3847 110740004537832492 {}\n",
|
|
"66 8701964644 dbf27f22-f531-4d41-9d08-4ab414073848 195159084238961158 {}\n",
|
|
"67 8701628778 0d199725-6dc6-4a6b-965b-51ce74c82d94 195159084238961158 {}\n",
|
|
"68 8701023479 58ddc49c-96c1-4ed0-8190-09f14b20a74e 3048162260682931 {}\n",
|
|
"69 8690438067 b3c9ac2f-aee2-4931-ae3c-cce87108a28b 110740004537832492 {}\n",
|
|
"70 8690435216 2283eb97-6c2f-40a7-aff3-b4bc612751bb 110740004537832492 {}\n",
|
|
"71 8688985039 c514cf6a-d07e-4e89-a5aa-0e9e8b320889 110740004537832492 {}\n",
|
|
"72 8686117476 5b008aa0-2977-4c08-a402-bae9a35cccb8 3048162260682931 {}\n",
|
|
"73 8683054364 db6dcd26-98b3-49b2-b10c-434b3ed93bb9 3048162260682931 {}\n",
|
|
"74 8679690515 60d08a1a-ca34-465a-924c-97bedc271621 110740004537832492 {}\n",
|
|
"75 8674628868 fd967f82-446d-4abc-8c8f-cb4e67f68026 195159084238961158 {}\n",
|
|
"76 8657831926 f870dc17-ef72-4f6e-9244-6b79ca9e7521 3048162260682931 {}\n",
|
|
"77 8652051288 1f8371a3-b2f5-405e-b3f0-68f94496bfd9 195159084238961158 {}\n",
|
|
"78 8651095460 62e9ff01-c631-4b28-8974-b189bc43e321 110740004537832492 {}\n",
|
|
"79 8650723932 fabd22ff-9f67-4867-a41b-7520f9d5618b 195159084238961158 {}\n",
|
|
"80 8650683908 4600f68e-6748-418a-bbdd-ef7b7a35db1c 195159084238961158 {}\n",
|
|
"81 8649845371 00a9759f-43ea-4435-ab47-53032e8eef14 195159084238961158 {}\n",
|
|
"82 8645407812 1c3bef7f-5a80-40d4-8db8-1467bce6ca68 3048162260682931 {}\n",
|
|
"83 8643501521 f20fcf32-e981-4c0d-902e-ef2976171253 195159084238961158 {}\n",
|
|
"84 8642960191 473a0d63-dca2-4660-bf31-fb492df21576 110740004537832492 {}\n",
|
|
"85 8641713478 15a3573e-f2fa-4847-a151-49a1eb51dca5 3048162260682931 {}\n",
|
|
"86 8639773708 590690df-79e7-4293-a2db-959aaa7aea03 110740004537832492 {}\n",
|
|
"87 8636742815 2c1640df-cadd-457b-9cf3-91bb02b37875 195159084238961158 {}\n",
|
|
"88 8633898691 890fb03c-6662-4aaf-b646-39deec9c6d34 110740004537832492 {}\n",
|
|
"89 8631076301 4dfa8f64-90fa-4e6c-8e48-a52ecd1dc22a 3048162260682931 {}\n",
|
|
"90 8618639551 31785661-8294-4ea2-83f3-47e1494321e5 110740004537832492 {}\n",
|
|
"91 8618098741 aedd3c4c-a49b-4361-8b22-e1f6634be306 110740004537832492 {}\n",
|
|
"92 8606536685 5a9c5633-bf90-4703-8170-3084d665e799 195159084238961158 {}\n",
|
|
"93 8603427793 93bbe2a8-564f-4d9e-b91e-e68c30c180c1 110740004537832492 {}\n",
|
|
"94 8599990094 c5ac8f62-6915-4284-8dc7-2aa7f2958e2c 195159084238961158 {}\n",
|
|
"95 8593799446 820c2a5a-6425-484f-a0fe-be73dc85d565 110740004537832492 {}\n",
|
|
"96 8584733564 7bb0fe78-8f01-4324-9eb4-b0608e08f5d5 195159084238961158 {}\n",
|
|
"97 8584408238 7917ac1a-ae53-48b9-8efb-4d55dbe02a47 110740004537832492 {}\n",
|
|
"98 8583540276 e86e34c5-bbe2-44d3-b18a-bd01f5385ed3 195159084238961158 {}\n",
|
|
"99 8581060704 ffdd98be-a9df-490b-9c67-5fa31929dddc 110740004537832492 {}\n",
|
|
"100 8580713186 d5be29a0-4321-44a2-8248-151b6051f43f 195159084238961158 {}\n",
|
|
"101 8578402477 c4a71fbd-ef57-41b1-9905-da302b82c941 110740004537832492 {}\n",
|
|
"102 8574942312 3fbe8c98-ac39-4046-a77b-5161a198cf71 195159084238961158 {}\n",
|
|
"103 8574477990 dbcef666-539a-481a-843d-d0f3d9d688e2 195159084238961158 {}\n",
|
|
"104 8574044675 9ca10cb6-c59f-429f-bc32-fff6ac15beb7 110740004537832492 {}\n",
|
|
"105 8572383587 ed43e5dd-cf8e-4b28-98a8-7e4d83858b86 110740004537832492 {}\n",
|
|
"106 8572383548 c038de6b-9ead-4d6d-81b2-a15f339041b5 110740004537832492 {}\n",
|
|
"107 8553614583 aa3a90b9-a21d-49be-90ee-06f79cb41525 195159084238961158 {}\n",
|
|
"108 8548145417 ec8a6ff4-df56-4c31-ac76-2b113a91bb36 110740004537832492 {}\n",
|
|
"109 8535647783 b18863c3-efb7-413e-8f4a-dd007c664120 110740004537832492 {}\n",
|
|
"110 8534924885 d8211f4e-f860-4f6d-bb7f-6b83870b4f77 110740004537832492 {}\n",
|
|
"111 8533284774 10c8840d-c2da-460e-9206-045f836e4a1b 110740004537832492 {}\n",
|
|
"112 8517577954 4bba5d30-3d86-41bb-bf6a-c57cf57cfe69 110740004537832492 {}\n",
|
|
"113 8515287011 ce861689-0cdd-449b-afe1-cf4404c073b6 110740004537832492 {}\n",
|
|
"114 8512989645 3e61d551-47b5-44f5-bd36-4223b8803bed 195159084238961158 {}\n",
|
|
"115 8509258846 ce5e94b9-33ac-4208-8405-d2a5e5f34a15 3048162260682931 {}\n",
|
|
"116 8508120155 46e53ed8-7591-4a69-b823-ca9cf0191eaf 110740004537832492 {}\n",
|
|
"117 8493705037 4546522e-58cd-4010-a725-7db2c6de0c8e 110740004537832492 {}\n",
|
|
"118 8490362852 07e91701-ef67-4637-9fe7-39f4215f1afc 110740004537832492 {}\n",
|
|
"119 8484202444 53bf09f8-72e1-41b8-b092-9bfce00fe795 195159084238961158 {}\n",
|
|
"120 8478013807 b485ca68-a756-4e36-8f6c-6b77a1126003 3048162260682931 {}\n",
|
|
"121 8474169237 d8418646-9702-4c46-ae84-adc300341ca1 195159084238961158 {}\n",
|
|
"122 8453942475 dd893c59-cea9-4510-9ce9-dcdc2afe60a5 110740004537832492 {}\n",
|
|
"123 8447842320 cf14748e-f7b3-4058-b4f5-3e4594828d03 3048162260682931 {}\n",
|
|
"124 8398516626 f061261a-7399-464a-b1da-f5402ef317a9 195159084238961158 {}\n",
|
|
"125 8387330507 2db79548-676a-4270-831d-9f684eedd6f5 195159084238961158 {}\n",
|
|
"126 8387255617 1942a0ca-645b-4c9d-858d-f49821db1b39 195159084238961158 {}\n",
|
|
"127 8367655607 730f23b4-66c6-4e14-b34a-14b5d485b0d7 195159084238961158 {}\n",
|
|
"128 8365473905 eba9e65a-1182-45b3-a671-cd37101cce67 195159084238961158 {}\n",
|
|
"129 8359536214 0f8a04e8-9062-4a52-b1b1-fafe0943a585 195159084238961158 {}\n",
|
|
"130 8354581584 49ed635a-ae78-43b2-a021-35d0203815d2 110740004537832492 {}\n",
|
|
"131 8354081544 ac566b51-9d7f-442a-83ed-703385b42742 110740004537832492 {}\n",
|
|
"132 8353806072 d6fdddac-c186-4a63-b1e5-c52ec1964194 195159084238961158 {}\n",
|
|
"133 8349856971 8e7733ef-d149-4253-8395-a3bc984b5fb8 110740004537832492 {}\n",
|
|
"134 8348350964 96277fda-0396-4309-9fd2-93474a3d22eb 3048162260682931 {}\n",
|
|
"135 8345380259 76a81554-74e8-41f9-8511-e5441f76ad97 110740004537832492 {}\n",
|
|
"136 8343794837 04cde647-b4bb-449f-a8c5-f0864e6ae55e 195159084238961158 {}\n",
|
|
"137 8330916609 712738dd-5443-455c-aa88-2d2967d715e6 3048162260682931 {}\n",
|
|
"138 8325714287 097f11d4-fbbf-422e-9896-4297032a058a 195159084238961158 {}\n",
|
|
"139 8322039273 5a8a3801-bb5b-4241-b26e-99bde0d1fefe 3048162260682931 {}\n",
|
|
"140 8321270939 95780d13-4c28-4615-b224-6a3097df90ba 195159084238961158 {}\n",
|
|
"141 8319929890 a2fc50e8-6b79-48c3-a867-834c978ed8a1 195159084238961158 {}\n",
|
|
"142 8319124411 39b494c2-bbe4-46b5-ac91-82155ad989e9 3048162260682931 {}\n",
|
|
"143 8316777300 ba0789ce-86c6-41d9-91e3-ac4ca3a50298 195159084238961158 {}\n",
|
|
"144 8316492327 6c6a6d85-5f70-4938-9600-539bb8ef5a24 195159084238961158 {}\n",
|
|
"145 8314309585 026a23ae-838b-40c2-8ee0-a523d52af3e7 110740004537832492 {}\n",
|
|
"146 8314111998 42e69c98-7bfb-413e-9c13-db3435b89eca 110740004537832492 {}\n",
|
|
"147 8313257572 21583e33-8185-4284-a78f-f6a3bd03b140 3048162260682931 {}\n",
|
|
"148 8313108500 0dd50a8b-172e-4adb-a76d-55bfac9dd73c 110740004537832492 {}\n",
|
|
"149 8304679013 6f4414d9-7b57-4dca-8d47-509a9b9e5028 195159084238961158 {}\n",
|
|
"150 8303596930 4ce17cac-6b4b-4095-a879-0e0118393532 110740004537832492 {}\n",
|
|
"151 8278182894 e030bb12-5c0a-49e6-9105-fcef42ed39c1 195159084238961158 {}\n",
|
|
"152 8276595667 6e69dec9-8538-4649-8bd0-62ab1dfe0fdf 195159084238961158 {}\n",
|
|
"153 8273869243 9f0a1937-49a7-4f74-ba53-e755878fafd9 3048162260682931 {}\n",
|
|
"154 8272224736 934db362-f40b-4e03-bd50-1c84ebba7e85 195159084238961158 {}\n",
|
|
"155 8265470142 c8f0cd22-9fb0-49a9-9bd0-2a36f5ade654 110740004537832492 {}\n",
|
|
"156 8265132615 29b11bf7-ad25-4131-a512-ab3ee2660a78 195159084238961158 {}\n",
|
|
"157 8261005637 8e05eecb-d057-4b7d-9373-34399ef9cad5 3048162260682931 {}\n",
|
|
"158 8260166551 10809c36-a1dc-4cf7-b3fa-26f2c0865fd8 195159084238961158 {}\n",
|
|
"159 8234899077 9fbf554e-4535-4cf9-989e-2b06f74bc0eb 195159084238961158 {}\n",
|
|
"160 8231487967 d3c74645-04ca-4d77-95b0-d01311275838 195159084238961158 {}\n",
|
|
"161 8230507003 45a4a00a-5fed-41c1-9842-cd609b0c2738 195159084238961158 {}\n",
|
|
"162 8229313667 b5574618-cff1-4c1b-ad14-7c9913550b63 110740004537832492 {}\n",
|
|
"163 8217465511 e4c3e573-ec78-4797-bca1-c43c7c1a8d5b 3048162260682931 {}\n",
|
|
"164 8214740426 76443773-1e3e-40a0-aa76-353224ecb58b 3048162260682931 {}\n",
|
|
"165 8212615022 a98ff61d-5a73-4870-888a-43bb3007d6a9 3048162260682931 {}\n",
|
|
"166 8210724405 7138e0e9-c932-43c8-b714-c10f30cd7e49 110740004537832492 {}\n",
|
|
"167 8195219358 1ca12457-69b1-4ce4-b3a7-b8c2534cea03 3048162260682931 {}\n",
|
|
"168 8184951947 e9315996-e93d-4550-b245-51ac1f142924 110740004537832492 {}\n",
|
|
"169 8183000369 ba9305c1-9fd8-4c0b-b207-3a2bfad812a3 110740004537832492 {}\n",
|
|
"170 8182619785 6185fd21-b199-41a6-823e-0b19f5a8b698 110740004537832492 {}\n",
|
|
"171 8182605082 dba0d8fd-c3dc-4210-b359-e2a5836b2447 3048162260682931 {}\n",
|
|
"172 8179604215 7054aeb6-852a-4086-83cd-fe201186022a 3048162260682931 {}\n",
|
|
"173 8179350667 68956c75-42b4-444d-964b-1624e75a6c8d 195159084238961158 {}\n",
|
|
"174 8175887891 ef9b59ea-afa0-4766-8f39-48c771eb8a48 110740004537832492 {}\n",
|
|
"175 8175167212 e36ba87c-3d50-42dd-a8ab-63d78b4de391 110740004537832492 {}\n",
|
|
"176 8175086187 f1fbea99-15f7-4cf8-9b04-452efae5b9e9 3048162260682931 {}\n",
|
|
"177 8174836843 6991108c-39dc-4344-8570-961c88b66197 195159084238961158 {}\n",
|
|
"178 8127253356 a8d2daff-e4c1-4a9d-8b38-e850dfceb13b 195159084238961158 {}\n",
|
|
"179 8124222351 f0fb8ece-2c6f-40ca-bbe8-958f4359ffe0 3048162260682931 {}\n",
|
|
"180 8124194337 4a72bd0d-a40a-427a-b91d-fb2e701e10ca 110740004537832492 {}\n",
|
|
"181 8122456895 f5dc37fc-1f5b-4b9d-81ba-b0442105d7ab 110740004537832492 {}\n",
|
|
"182 8122379853 f3c94ed1-baf9-4e61-aa35-adc9ad280f44 3048162260682931 {}\n",
|
|
"183 8121150203 1fb590d6-488e-4667-8450-022560ae5bdc 3048162260682931 {}\n",
|
|
"184 8119841459 9e4c50f7-977c-41fb-bf4a-fa60b8b65c00 195159084238961158 {}\n",
|
|
"185 8119050084 2f076885-6b54-4502-a3ed-d3b22f243e4a 110740004537832492 {}\n",
|
|
"186 8118948912 54c5bc31-a0ba-45a1-b4ca-b4a7b5ee53d3 3048162260682931 {}\n",
|
|
"187 8116726291 5b43e784-9323-41d4-933f-091e693e029b 3048162260682931 {}\n",
|
|
"188 8116353771 3c269b5b-1673-4007-90bd-61a765a5a97c 195159084238961158 {}\n",
|
|
"189 8115134394 b7337b7e-ad04-4736-8413-40f1aa0b7ee4 3048162260682931 {}\n",
|
|
"190 8114042107 eafc0647-a3c3-402c-811f-a0d95f1be795 110740004537832492 {}\n",
|
|
"191 8093777499 b0feb5b3-19e0-462e-8811-e62d7502c269 110740004537832492 {}\n",
|
|
"192 8092502866 6c1eefab-7cd8-4979-8bee-87f64eab48d8 110740004537832492 {}\n",
|
|
"193 8088537841 ebc89725-5d5a-4e37-82be-961ed8459294 3048162260682931 {}\n",
|
|
"194 8087969171 1e59120e-f7eb-46f6-9d49-022ae3c3e617 195159084238961158 {}\n",
|
|
"195 8084587731 01b43583-dd69-43d6-95f7-05ea4b7afc23 3048162260682931 {}\n",
|
|
"196 8082588025 bc24aedd-d77f-462a-9acc-e68afbd09b06 3048162260682931 {}\n",
|
|
"197 8073298771 e3c9d017-0e97-4931-9a18-b3d7de6d0a50 3048162260682931 {}\n",
|
|
"198 8067478662 7fb8e7f6-6a8f-421f-a851-b96150d00d7e 3048162260682931 {}\n",
|
|
"199 8057995354 68ea77ad-08b2-41be-a3f7-435d296c4ec4 110740004537832492 {}\n",
|
|
"200 7977062097 e0b9c038-2578-4953-a0df-35917709334b 110740004537832492 {}\n",
|
|
"201 7976614732 17ac6e4e-e325-40b2-ab35-6bb9f8885ea3 110740004537832492 {}\n",
|
|
"202 7958623302 f31d1908-aff1-4fbb-8dae-86b4866b038b 110740004537832492 {}\n",
|
|
"203 7956539471 fc196ddf-e5ef-47ce-9e56-569555028ebb 110740004537832492 {}\n",
|
|
"204 7931114164 929969ed-82ea-4583-b7b3-37a259002143 110740004537832492 {}\n",
|
|
"205 7921110493 150073d9-acc9-4c5b-bad3-b66086b35129 195159084238961158 {}\n",
|
|
"206 7918374803 3b515d02-e856-4551-8aa0-f34d6a4f8b7d 195159084238961158 {}\n",
|
|
"207 7911797141 d9b877ba-ddb9-4168-a60c-1046d7edfbaf 3048162260682931 {}\n",
|
|
"208 7910316788 ab19f631-a4df-403a-8607-a6aec24d65ea 110740004537832492 {}\n",
|
|
"209 7909934696 16b1922f-ecf1-434c-842b-cef9814c7d63 110740004537832492 {}\n",
|
|
"210 7909745324 e0700be2-21d0-4a16-8fa4-de7baa0b4e55 110740004537832492 {}\n",
|
|
"211 7893782268 699c1ab4-c32d-438f-b247-27ef7851105e 195159084238961158 {}\n",
|
|
"212 7887075063 f4909d06-632a-4010-8775-2f07d4880dc5 110740004537832492 {}\n",
|
|
"213 7884041385 d0984028-9e56-49f1-9ebc-fc7bd74195bb 3048162260682931 {}\n",
|
|
"214 7883561179 041b6bb2-fa8f-4873-aca9-4e550aa49527 110740004537832492 {}\n",
|
|
"215 7874241736 2f205334-c50b-4896-9fa9-d17797306ef4 3048162260682931 {}\n",
|
|
"216 7861528504 468a2a9b-a6b6-4173-99eb-389f19e7d504 110740004537832492 {}\n",
|
|
"217 7859998744 319b6e5c-3636-40aa-ab06-7acdd91f2d18 195159084238961158 {}\n",
|
|
"218 7858015085 8c286152-5d34-46d1-97e3-6815aab023e7 3048162260682931 {}\n",
|
|
"219 7857763314 8a69e854-c170-4b74-9b14-ccf2d88625f4 110740004537832492 {}\n",
|
|
"220 7857176755 574fc6b9-bcc4-41fa-9ba6-a22f4951cad8 195159084238961158 {}\n",
|
|
"221 7856144093 59195059-8f29-4687-9e2f-fe1f9bcb1ac7 110740004537832492 {}\n",
|
|
"222 7850164313 7c181eea-ef66-4edf-8a97-9fd2808ef10c 3048162260682931 {}\n",
|
|
"223 7844163505 b912018f-de1f-47c1-aec1-3873a078a643 195159084238961158 {}\n",
|
|
"224 7843172291 d9535d69-6370-419b-8ce2-0207500faabf 110740004537832492 {}\n",
|
|
"225 7841863818 fc12bea4-b393-4670-af4f-7851740fc4b0 195159084238961158 {}\n",
|
|
"226 7819935844 32e357fc-6f0c-4932-ae92-b903cc5d6a86 3048162260682931 {}\n",
|
|
"227 7818711540 0428c04c-c686-4cfa-a592-e932a98c5a2f 110740004537832492 {}\n",
|
|
"228 7817510604 4cadf03a-cf5e-4b02-b78a-38fdea66bfa8 3048162260682931 {}\n",
|
|
"229 7817344287 d32d1e4f-24bb-425c-96a8-2761f7ef51a5 195159084238961158 {}\n",
|
|
"230 7816546638 58de2f4e-4c03-4d23-b001-7c1025d8bcbb 195159084238961158 {}\n",
|
|
"231 7814833574 556e5c0a-633e-4dac-8c15-5fec6f0e792b 110740004537832492 {}\n",
|
|
"232 7814355866 f3d4c619-a868-4212-a94b-5eb2c9b43b47 195159084238961158 {}\n",
|
|
"233 7813045746 e34da5b6-c9ee-48dd-a0ec-a20b35a372d3 110740004537832492 {}\n",
|
|
"234 7811770104 d204932d-4d61-4d7e-b9ba-009bee2dcce5 110740004537832492 {}\n",
|
|
"235 7808123285 97a37f76-ca95-40a0-82da-050dfe29a328 110740004537832492 {}\n",
|
|
"236 7807467939 3dc22395-7435-48cc-a87d-292a65a55670 110740004537832492 {}\n",
|
|
"237 7804993633 b256453e-1449-4605-b979-4c64a796c920 3048162260682931 {}\n",
|
|
"238 7797803930 4675eafd-7001-40a1-b0ae-ac9fe8c191a0 3048162260682931 {}\n",
|
|
"239 7797591183 d58ef59a-f952-4992-b846-3eca5eb8fe43 3048162260682931 {}\n",
|
|
"240 7793099995 1d39121b-7aa1-4ca1-aa6a-ae01913ac1af 3048162260682931 {}\n",
|
|
"241 7791370729 2ef17496-65f6-4ecc-9518-ef4ceca71744 3048162260682931 {}\n",
|
|
"242 7787344605 8a4cec83-edf7-4e10-b3b6-78f60789294f 110740004537832492 {}\n",
|
|
"243 7785617804 c8e5ab59-5667-4b08-a35b-473a1f715808 195159084238961158 {}\n",
|
|
"244 7784648858 c29b66b7-1c9d-4bd5-971d-58c2ef19978a 110740004537832492 {}\n",
|
|
"245 7783368139 42c50c89-611a-465f-a4b8-3347d45881e0 110740004537832492 {}\n",
|
|
"246 7782856886 021953d0-a9e9-4d57-b04e-d61542dcf549 110740004537832492 {}\n",
|
|
"247 7781783676 4e86ab68-66c4-48b2-8936-c29954e2eae0 3048162260682931 {}\n",
|
|
"248 7780607896 3846791c-f3e0-4e1c-a255-b6662a4de7c0 3048162260682931 {}\n",
|
|
"249 7779581052 9b6837d0-204c-4353-bfb0-075631455ff3 110740004537832492 {}\n",
|
|
"250 7779282911 7f5aeefd-0396-493d-bd0d-081ebafe992f 110740004537832492 {}\n",
|
|
"251 7778621981 eef2d9c0-26da-45d7-98f8-edc7eb313d82 195159084238961158 {}\n",
|
|
"252 7766007028 b6933ffa-c99b-45bc-bfb6-7faabab7e557 110740004537832492 {}\n",
|
|
"253 7764886413 9678351d-732a-4b84-bccb-b8d4a23f70e6 195159084238961158 {}\n",
|
|
"254 7764746375 7072bfc8-1b72-42b4-bfc4-8e7d4fa3604f 195159084238961158 {}\n",
|
|
"255 7763635165 d016023b-e1e4-428a-a888-0505a3247ecd 110740004537832492 {}\n",
|
|
"256 7761405841 23662f27-80d9-4f3d-82a6-b726415c0672 110740004537832492 {}\n",
|
|
"257 7759197045 3c565988-a0d4-4a2f-afb9-cea339f3a8e1 110740004537832492 {}\n",
|
|
"258 7756096852 965b4974-49cc-4f64-90fd-5e911feb3b31 110740004537832492 {}\n",
|
|
"259 7754945346 0fdd36e2-5725-472d-9295-73a9762182b2 110740004537832492 {}\n",
|
|
"260 7734897700 a1ae5796-ff1f-42cb-9745-206c354e015e 110740004537832492 {}\n",
|
|
"261 7725899221 d46d16e6-d1c9-4863-a23e-ce81c2cba6b1 195159084238961158 {}\n",
|
|
"262 7725175479 5258a116-2e7f-4de3-8226-d6a670aa8ec2 110740004537832492 {}\n",
|
|
"263 7725047868 50205bf9-b8af-4a71-83c6-2928a7f4cd5d 195159084238961158 {}\n",
|
|
"264 7723274541 ebb2d2af-b299-4fbd-af87-cca2b1c1d094 110740004537832492 {}\n",
|
|
"265 7720989600 25759861-5f68-4a9e-b350-05716f34a216 110740004537832492 {}\n",
|
|
"266 7720678868 72f719be-18a2-4efd-82a9-d0970eed301b 110740004537832492 {}\n",
|
|
"267 7720179734 3aa4c65d-dedf-4d79-b3e8-96eb2c12cec0 110740004537832492 {}\n",
|
|
"268 7699359377 29973fdc-de05-4192-bb50-215263eb0459 110740004537832492 {}\n",
|
|
"269 7690945437 e3f56e83-b4b9-4532-8cf1-7041299c753e 110740004537832492 {}\n",
|
|
"270 7687579715 de89a3ab-ed1c-4056-a1c2-c2e6c3e40a27 110740004537832492 {}\n",
|
|
"271 7685533443 2600b511-849e-470c-80a1-37137cb9c8a5 110740004537832492 {}\n",
|
|
"272 7683109331 21de5d4c-5a6c-4f7b-8ff2-7f654f23e1ac 110740004537832492 {}\n",
|
|
"273 7681423802 b748460a-6cb9-45ca-accb-ddc6b4119c15 195159084238961158 {}\n",
|
|
"274 7681044525 f5b81bef-654f-4573-93bb-1d1b361d1a06 110740004537832492 {}\n",
|
|
"275 7680391987 8337e229-2c9f-4fa5-8042-4c55458a57c6 110740004537832492 {}\n",
|
|
"276 7679880589 e23ba813-1a95-42a6-a6a9-6b322b8fd49d 110740004537832492 {}\n",
|
|
"277 7679708893 93ef9110-328a-428c-80dd-5282411ba0fe 110740004537832492 {}\n",
|
|
"278 7678488366 8800c3d5-a3d4-4f4c-861e-c2b81b8bd93d 110740004537832492 {}\n",
|
|
"279 7677675026 af8a934f-5eea-4472-8f43-b649edc3c14a 110740004537832492 {}\n",
|
|
"280 7677560826 715b3b84-e528-485b-9b84-39264e1447ae 110740004537832492 {}\n",
|
|
"281 7656447507 29687875-0a5a-415b-8555-32ff7d5f9e1a 110740004537832492 {}\n",
|
|
"282 7654071486 b0620ff0-5c3e-475d-9aa6-094b784e11b4 3048162260682931 {}\n",
|
|
"283 7623015143 4d4e3589-3bc8-421f-9421-b9a24dba8da6 110740004537832492 {}\n",
|
|
"284 7617336697 49e8a121-992c-4d5a-ac10-5a41c31e1d11 3048162260682931 {}\n",
|
|
"285 7615045907 d3cdf546-a7f9-4815-bbbf-3656e581b8f6 195159084238961158 {}\n",
|
|
"286 7615115017 199a8d30-f7da-4dc1-906f-06419474524d 195159084238961158 {}\n",
|
|
"287 7614182896 1302628b-4aef-4974-ae9b-07fac67d61fb 110740004537832492 {}\n",
|
|
"288 7610199813 a8826704-d220-4f0c-974f-6aaec1c8ddb2 110740004537832492 {}\n",
|
|
"289 7584805483 23dd9933-12b4-4c78-a5a6-51b6fa957f6d 3048162260682931 {}\n",
|
|
"290 7581680269 31951407-50cc-4f2c-816a-411a674f7ee4 110740004537832492 {}\n",
|
|
"291 7581533065 2cabffc6-4860-4293-bfad-02b1193810ed 110740004537832492 {}\n",
|
|
"292 7565953268 4b73f41f-dd3f-4a5b-822a-f19f74612c70 195159084238961158 {}\n",
|
|
"293 7564073494 84fb0bd3-1642-455f-b358-8345f9daf59f 195159084238961158 {}\n",
|
|
"294 7530965199 122f48fa-1f30-46eb-ae04-08a46d2064fd 110740004537832492 {}\n",
|
|
"295 7503571824 9d5191c2-e998-4df9-8e25-ee1798cb9b44 110740004537832492 {}\n",
|
|
"296 7481241641 50a37f07-52ef-4db8-a9a6-116d96a5649b 195159084238961158 {}\n",
|
|
"297 7418166834 2f7496e1-364f-4afb-9d88-b08b0a055770 195159084238961158 {}\n",
|
|
"298 7399310739 6daf5130-89c5-49f5-bdf7-2a2481ddd8e4 3048162260682931 {}\n",
|
|
"299 7340357626 e1c996e5-b1ae-4e61-8be9-b005b723fbfb 3048162260682931 {}\n",
|
|
"300 7327249275 16764374-3b46-468b-989b-4b36ab2d9249 110740004537832492 {}\n",
|
|
"301 7327251106 a9f02304-99ad-40b4-a348-6e1aeb51c912 110740004537832492 {}\n",
|
|
"302 7326241066 cd2623a2-9daf-49d4-8c53-f7674b39bfc0 110740004537832492 {}\n",
|
|
"303 7326198212 5e89e516-f35e-4060-9893-ef763b70685f 110740004537832492 {}\n",
|
|
"304 7326159836 45d17f29-e456-4fe3-af5c-0249949d186b 110740004537832492 {}\n",
|
|
"305 7326092295 555bea0b-d39d-4c5e-b4ae-9c199dbfb2f5 110740004537832492 {}\n",
|
|
"306 7326098021 aea9de44-6de7-4c92-9fde-bf1caa982c24 110740004537832492 {}\n",
|
|
"307 7326056915 949a8f5c-d3ad-4c1c-882c-6c074e112d09 110740004537832492 {}\n",
|
|
"308 7325596265 b224417b-6dc3-4195-a5ed-4e6633fb7dd1 110740004537832492 {}\n",
|
|
"309 7325578612 6250acc0-f635-4485-8155-3cc19a65c0fa 110740004537832492 {}\n",
|
|
"310 7325596185 1b2791f6-2dad-44cd-a1d1-77fe08ce4aed 110740004537832492 {}\n",
|
|
"311 7325390744 abf015dd-5fd6-41ca-945c-744094419ae3 110740004537832492 {}\n",
|
|
"312 7325414123 e350074e-46ee-46b8-bcb5-49c4963b1ad3 110740004537832492 {}\n",
|
|
"313 7325305755 3a1d0d63-4073-44e7-b74a-37bdec20a80f 110740004537832492 {}\n",
|
|
"314 7271112600 fe47e528-4ae7-44b4-988e-bf6cfa222c95 195159084238961158 {}\n",
|
|
"315 7269559988 3d2e9a2c-65b0-4532-9233-26dd898fe757 195159084238961158 {}\n",
|
|
"316 7269462292 d7cd6fc7-9135-4872-bbf3-bbe2ba1047f7 110740004537832492 {}\n",
|
|
"317 7258409382 b01c06c1-3662-4c78-9d64-51788791b095 195159084238961158 {}\n",
|
|
"318 7257113956 be14662a-74dd-45f6-b8e3-cbf0b80f777f 3048162260682931 {}\n",
|
|
"319 7251409829 f843eed7-52db-4542-8c04-5a684b6fd667 3048162260682931 {}\n",
|
|
"320 7249587274 f68bba82-6c6b-4f82-b882-a9e25967b713 110740004537832492 {}\n",
|
|
"321 7247737987 a2763631-a60d-4c51-bdc2-9b47af4c8979 195159084238961158 {}\n",
|
|
"322 7243030215 a381db5d-3d7f-4c79-a1dd-820a87538332 110740004537832492 {}\n",
|
|
"323 7241859294 19afa33c-6deb-411e-82c8-1f03c6179a5f 3048162260682931 {}\n",
|
|
"324 7239288919 52ef33d5-613c-4690-a156-e2be6e8efc3c 195159084238961158 {}\n",
|
|
"325 7226982829 1e807a59-9e73-4459-99b7-7b967f4eb251 3048162260682931 {}\n",
|
|
"326 7226990223 889d2601-ac25-4b6d-ab6c-fa246045b151 3048162260682931 {}\n",
|
|
"327 7226194267 9a6b97cd-0746-4f20-9a20-9bf8ba6c4b09 110740004537832492 {}\n",
|
|
"328 7213300678 df8ca77c-8a26-44e5-8d69-262fd80790b3 3048162260682931 {}\n",
|
|
"329 7210472781 fbf9f19f-7b72-404b-b239-f6f62285e970 110740004537832492 {}\n",
|
|
"330 7209771790 f31f3d74-44b6-49ca-93bb-a7d35f8a552c 110740004537832492 {}\n",
|
|
"331 7191497778 d2b5c70f-4228-46ba-a7f0-fcdb2a32ccd4 110740004537832492 {}\n",
|
|
"332 7167030045 758a61cd-15a6-4147-80c3-b35f5bc317be 110740004537832492 {}\n",
|
|
"333 7163944466 06417ef2-2071-4232-a85a-1f049c05dff1 3048162260682931 {}\n",
|
|
"334 7160508454 ba86e32d-cbd1-4b62-8f37-84a956ce2404 3048162260682931 {}\n",
|
|
"335 7158987436 0ba15165-274f-424e-8046-2c2e62aeedd3 110740004537832492 {}\n",
|
|
"336 7148078165 b37ba0ef-2e32-4e0d-b235-426aa9c6604c 110740004537832492 {}\n",
|
|
"337 7147735824 034834e8-c76e-488b-979c-06c46a2ab569 3048162260682931 {}\n",
|
|
"338 7099696453 9a76104f-28b5-42ce-a62a-877eed61c9bb 195159084238961158 {}\n",
|
|
"339 7087299921 c14439af-e345-4f77-b72c-028be59ba7bc 110740004537832492 {}\n"
|
|
]
|
|
}
|
|
],
|
|
"source": [
|
|
"import pandas as pd\n",
|
|
"import pandas as pd\n",
|
|
"import numpy as np\n",
|
|
"import requests\n",
|
|
"import json\n",
|
|
"import time\n",
|
|
"import re\n",
|
|
"from datetime import datetime\n",
|
|
"from dateutil.relativedelta import relativedelta\n",
|
|
"from pathlib import Path\n",
|
|
"from urllib.parse import quote\n",
|
|
"from io import BytesIO\n",
|
|
"\n",
|
|
"ROOT = Path('.').absolute() # 当前工作目录\n",
|
|
"\n",
|
|
"\n",
|
|
"# 生成 token，参数不需要修改\n",
|
|
"def generateToken() -> str:\n",
|
|
" \"\"\" 生成 token \"\"\"\n",
|
|
"\n",
|
|
" token_api = 'https://api.dingtalk.com/v1.0/oauth2/accessToken'\n",
|
|
"\n",
|
|
" # 该信息在钉钉开放应用中\n",
|
|
" data = {\n",
|
|
" \"appKey\": \"ding5kqocon5s9oph5uq\",\n",
|
|
" \"appSecret\": 'HL1jgsIIfLAC0eTH0A1m4mwxUDqbgsiPeCCGGE3ocM6qJBTIW7Ivt9drxF_Z4Kb_'\n",
|
|
" }\n",
|
|
"\n",
|
|
" res = requests.post(token_api, json=data)\n",
|
|
" token = res.json()['accessToken']\n",
|
|
"\n",
|
|
" return token\n",
|
|
"\n",
|
|
"\n",
|
|
"class NpEncoder(json.JSONEncoder):\n",
|
|
" def default(self, obj):\n",
|
|
" if isinstance(obj, np.integer):\n",
|
|
" return int(obj)\n",
|
|
" elif isinstance(obj, np.floating):\n",
|
|
" return float(obj)\n",
|
|
" elif isinstance(obj, np.ndarray):\n",
|
|
" return obj.tolist()\n",
|
|
" else:\n",
|
|
" return super(NpEncoder, self).default(obj)\n",
|
|
"\n",
|
|
"\n",
|
|
"\"\"\" 处理流程开始 \"\"\"\n",
|
|
"# [正式]续约服务流程 —— 修改续约负责人 再进行转交 \n",
|
|
"FORMID = \"FORM-L89662816B04LXH893M4K50Q7MIZ1SVQI08ALU2\"\n",
|
|
"TOKEN = generateToken()\n",
|
|
"\n",
|
|
"df = pd.read_excel(r'C:\\Users\\admin\\Downloads\\新签节点化服务待办_20230307173209.xlsx',sheet_name='Sheet1',dtype='string')\n",
|
|
"for i in range(len(df)):\n",
|
|
" try:\n",
|
|
" a = df.loc[i,'实例ID']\n",
|
|
" b = df.loc[i,'待处理字段']\n",
|
|
"\n",
|
|
" \"\"\" 函数功能：获取流程表单的审批记录 --F6客户服务 应用 \"\"\"\n",
|
|
" appType = \"APP_UYZ0KG6L0CCNV80GZ66O\"\n",
|
|
" systemToken = \"XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2\"\n",
|
|
" userId = \"yida_pub_account\"\n",
|
|
"\n",
|
|
" api = f'https://api.dingtalk.com/v1.0/yida/processes/operationRecords?appType={appType}&systemToken={systemToken}&userId={userId}&language=zh_CN&processInstanceId={a}'\n",
|
|
"\n",
|
|
" headers = {\n",
|
|
" \"Content-Type\": \"application/json\",\n",
|
|
" \"x-acs-dingtalk-access-token\": TOKEN\n",
|
|
" }\n",
|
|
"\n",
|
|
" res = requests.get(api, headers=headers)\n",
|
|
" res_new = res.json()\n",
|
|
" records_new = res_new.get('result')\n",
|
|
"\n",
|
|
" records_new = [item for item in records_new if item.get('type') == \"TODO\"]\n",
|
|
" showName_new = records_new[0].get('showName')\n",
|
|
"\n",
|
|
" records_new = [item for item in records_new if item.get('type') == \"TODO\"]\n",
|
|
" taskId = records_new[0].get('taskId')\n",
|
|
"\n",
|
|
"\n",
|
|
"\n",
|
|
" \"\"\" 函数功能：转交审批节点 \"\"\"\n",
|
|
" api = f'https://api.dingtalk.com//v1.0/yida/tasks/redirect'\n",
|
|
"\n",
|
|
" headers = {\n",
|
|
" \"Content-Type\": \"application/json\",\n",
|
|
" \"x-acs-dingtalk-access-token\": TOKEN\n",
|
|
" }\n",
|
|
" payload = {\n",
|
|
" \"processInstanceId\" : a,\n",
|
|
" \"byManager\" : \"y\",\n",
|
|
" \"appType\" : \"APP_UYZ0KG6L0CCNV80GZ66O\",\n",
|
|
" \"systemToken\" : \"XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2\",\n",
|
|
" \"language\": \"zh_CN\",\n",
|
|
" \"remark\" : \"转交(接口自动)\",\n",
|
|
" \"nowActionExecutorId\" : b,\n",
|
|
" \"userId\" : \"2268275546837446\",\n",
|
|
" \"taskId\" : int(taskId)\n",
|
|
" }\n",
|
|
"\n",
|
|
" res = requests.post(api, headers=headers, json=payload)\n",
|
|
" print(i,taskId,a,b,res.text)\n",
|
|
" except:\n",
|
|
" pass"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 1,
|
|
"metadata": {},
|
|
"outputs": [
|
|
{
|
|
"name": "stdout",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"cc3085b9-b11c-43b3-940b-652f0e3b2c97 195159084238961158 {}\n",
|
|
"519ad0aa-b6a9-4f11-b753-1d76bd0d416d 110740004537832492 {}\n",
|
|
"c4c7646b-349f-43ce-a26e-c354067604b7 110740004537832492 {}\n",
|
|
"c007a239-54bd-4d00-a036-c3e3f2ad8df8 3048162260682931 {}\n",
|
|
"fdd076f1-bbf4-4e6c-89c7-b979b61fdaea 110740004537832492 {}\n",
|
|
"fc70a6d5-fa72-40cd-b72a-da8e2f53787e 195159084238961158 {}\n",
|
|
"565f3ab1-ef14-46bd-bd25-1baafe3fd49a 195159084238961158 {}\n",
|
|
"81a05033-e9da-4615-ac2a-992408e77713 195159084238961158 {}\n",
|
|
"5fb86527-d575-4ede-aae4-6120fe906cd8 195159084238961158 {}\n",
|
|
"aa017c17-c8e0-419a-9542-545f066fb40e 195159084238961158 {}\n",
|
|
"49c3a85f-08f4-46ad-ae8c-2042081870f1 110740004537832492 {}\n",
|
|
"60448685-f737-4390-a6fb-33c7665d1c83 110740004537832492 {}\n",
|
|
"ada52be5-53a5-4fe2-ac8d-015fca3ffd68 110740004537832492 {}\n",
|
|
"2f2092d9-7177-4d45-ac09-a45c7cdee86c 3048162260682931 {}\n",
|
|
"d8f8f0f7-c090-4c94-8f65-e937e42b8918 3048162260682931 {}\n",
|
|
"de275c44-0312-4753-bc3a-37d4516dad46 110740004537832492 {}\n",
|
|
"54967ba4-c407-4443-a4db-72fe4591045e 195159084238961158 {}\n",
|
|
"6c6ac95a-614b-47d8-85c0-db95041b3ee5 195159084238961158 {}\n",
|
|
"fe11ea39-871e-416a-9ec4-8999042b9dc1 195159084238961158 {}\n",
|
|
"bdf3e336-035c-42c9-a7fc-462a7fe9ff7c 3048162260682931 {}\n",
|
|
"044ee15e-9e7d-4f07-abae-e2eb81346ef8 110740004537832492 {}\n",
|
|
"e6659810-1bd6-4987-8f5f-9a941a079e91 110740004537832492 {}\n",
|
|
"4a545a53-12fe-402c-844b-812f35346455 110740004537832492 {}\n",
|
|
"e2dbe0b3-d44c-4301-af7f-ae744c53d1c4 195159084238961158 {}\n",
|
|
"02f4e7ef-7586-4e7d-9f58-06ce661dceec 110740004537832492 {}\n",
|
|
"e9e58011-e523-4eca-9eab-be127103d6e0 110740004537832492 {}\n",
|
|
"f0576c07-5a41-4397-8d15-ab91a98c6975 195159084238961158 {}\n",
|
|
"ed6dcc82-3339-4ed6-86ed-ac9938d71b41 3048162260682931 {}\n",
|
|
"37f9fbd6-1fb7-4c66-82e3-a544e5e79a94 3048162260682931 {}\n",
|
|
"725ae951-bd00-4956-a073-cf7935742f20 3048162260682931 {}\n",
|
|
"e1b4a710-ea26-43e6-935f-9e8e74db8cfb 110740004537832492 {}\n",
|
|
"0fb6d3e2-adc3-4629-bec1-3ba738616640 195159084238961158 {}\n",
|
|
"5a1e3149-ab55-4dde-b72b-06b12aa3da34 110740004537832492 {}\n",
|
|
"cbddb0ae-2b4f-4869-a10d-3bda55ef4057 110740004537832492 {}\n",
|
|
"b2d7227f-00dc-4dc4-ab83-975359de3a5a 3048162260682931 {}\n",
|
|
"c834252d-05d0-474d-abfd-33020c7fef34 110740004537832492 {}\n",
|
|
"46ec4f33-b06d-4bec-b021-e9092f097764 110740004537832492 {}\n",
|
|
"d4da02d4-c84c-402f-b4f0-e287ebf30562 110740004537832492 {}\n",
|
|
"4a71bbb1-aa73-4fd2-b07b-25498dddd433 3048162260682931 {}\n",
|
|
"309d20a8-dca0-493d-bf0d-00f3a856e303 110740004537832492 {}\n",
|
|
"c8c55d38-6984-4756-949b-cd1ea69afb18 195159084238961158 {}\n",
|
|
"14806071-751c-4768-a982-9655b61b64b5 110740004537832492 {}\n",
|
|
"c9a6c9e4-71e7-4bd4-a532-b9e393067fba 3048162260682931 {}\n",
|
|
"2bba7c6c-e088-45d8-9eeb-d2aabb4e372d 3048162260682931 {}\n",
|
|
"e39cc159-9d2b-47c1-a563-5f30c0a4aa10 110740004537832492 {}\n",
|
|
"4454e868-3c66-44a1-a6ab-dd724be26c96 3048162260682931 {}\n",
|
|
"95bd1675-c101-4a1f-a45a-cdb4b786a47d 195159084238961158 {}\n",
|
|
"59cc4487-53ab-417b-877c-ac3776933bb4 110740004537832492 {}\n",
|
|
"7a397e10-35fc-4330-b707-0ea90134ba87 110740004537832492 {}\n",
|
|
"d5dda179-66b8-4fb3-9e8a-f8196dbac32a 110740004537832492 {}\n",
|
|
"cd4cd31b-69f0-4720-b3fd-79e16dd110d5 110740004537832492 {}\n",
|
|
"9114a7db-408d-4119-9f65-db51acaebd6e 195159084238961158 {}\n",
|
|
"657133ea-25fd-4eb7-ad23-dec853f3c453 195159084238961158 {}\n",
|
|
"6128783a-ce7c-4933-95a6-0e23ca3efbb6 110740004537832492 {}\n",
|
|
"a5c58a7d-062e-4fe6-9566-be4700ed492a 110740004537832492 {}\n",
|
|
"a8f8f5dc-e012-42e5-aba6-c8215a59205e 195159084238961158 {}\n",
|
|
"c7b8652f-1754-4239-9621-ae76c3f4a85a 110740004537832492 {}\n",
|
|
"64361840-bc9f-4521-a3da-50ad0ccf04c6 110740004537832492 {}\n",
|
|
"a4b0de8a-e8b2-403d-9e15-668f97c695f1 3048162260682931 {}\n",
|
|
"d39dc01b-0d02-44a7-a953-afed43251fba 3048162260682931 {}\n",
|
|
"aaf70bf6-6096-412d-aef7-8e35fb48b8d1 3048162260682931 {}\n",
|
|
"8c7ffb8d-faeb-4ee6-bc0c-b64f58eaf464 110740004537832492 {}\n",
|
|
"b1e9aaf6-9cb0-4f83-8d9f-cbfa5147d8bb 110740004537832492 {}\n",
|
|
"53c741a3-2064-4ae6-9817-428265abe5e5 110740004537832492 {}\n",
|
|
"433aa2d3-a396-49d4-a90f-2e078bf92403 195159084238961158 {}\n",
|
|
"e9919d4f-2514-4dc5-8156-e9ae1bbe3847 110740004537832492 {}\n",
|
|
"dbf27f22-f531-4d41-9d08-4ab414073848 195159084238961158 {}\n",
|
|
"0d199725-6dc6-4a6b-965b-51ce74c82d94 195159084238961158 {}\n",
|
|
"58ddc49c-96c1-4ed0-8190-09f14b20a74e 3048162260682931 {}\n",
|
|
"b3c9ac2f-aee2-4931-ae3c-cce87108a28b 110740004537832492 {}\n",
|
|
"2283eb97-6c2f-40a7-aff3-b4bc612751bb 110740004537832492 {}\n",
|
|
"c514cf6a-d07e-4e89-a5aa-0e9e8b320889 110740004537832492 {}\n",
|
|
"5b008aa0-2977-4c08-a402-bae9a35cccb8 3048162260682931 {}\n",
|
|
"db6dcd26-98b3-49b2-b10c-434b3ed93bb9 3048162260682931 {}\n",
|
|
"60d08a1a-ca34-465a-924c-97bedc271621 110740004537832492 {}\n",
|
|
"fd967f82-446d-4abc-8c8f-cb4e67f68026 195159084238961158 {}\n",
|
|
"f870dc17-ef72-4f6e-9244-6b79ca9e7521 3048162260682931 {}\n",
|
|
"1f8371a3-b2f5-405e-b3f0-68f94496bfd9 195159084238961158 {}\n",
|
|
"62e9ff01-c631-4b28-8974-b189bc43e321 110740004537832492 {}\n",
|
|
"fabd22ff-9f67-4867-a41b-7520f9d5618b 195159084238961158 {}\n",
|
|
"4600f68e-6748-418a-bbdd-ef7b7a35db1c 195159084238961158 {}\n",
|
|
"00a9759f-43ea-4435-ab47-53032e8eef14 195159084238961158 {}\n",
|
|
"1c3bef7f-5a80-40d4-8db8-1467bce6ca68 3048162260682931 {}\n",
|
|
"f20fcf32-e981-4c0d-902e-ef2976171253 195159084238961158 {}\n",
|
|
"473a0d63-dca2-4660-bf31-fb492df21576 110740004537832492 {}\n",
|
|
"15a3573e-f2fa-4847-a151-49a1eb51dca5 3048162260682931 {}\n",
|
|
"590690df-79e7-4293-a2db-959aaa7aea03 110740004537832492 {}\n",
|
|
"2c1640df-cadd-457b-9cf3-91bb02b37875 195159084238961158 {}\n",
|
|
"890fb03c-6662-4aaf-b646-39deec9c6d34 110740004537832492 {}\n",
|
|
"4dfa8f64-90fa-4e6c-8e48-a52ecd1dc22a 3048162260682931 {}\n",
|
|
"31785661-8294-4ea2-83f3-47e1494321e5 110740004537832492 {}\n",
|
|
"aedd3c4c-a49b-4361-8b22-e1f6634be306 110740004537832492 {}\n",
|
|
"5a9c5633-bf90-4703-8170-3084d665e799 195159084238961158 {}\n",
|
|
"93bbe2a8-564f-4d9e-b91e-e68c30c180c1 110740004537832492 {}\n",
|
|
"c5ac8f62-6915-4284-8dc7-2aa7f2958e2c 195159084238961158 {}\n",
|
|
"820c2a5a-6425-484f-a0fe-be73dc85d565 110740004537832492 {}\n",
|
|
"7bb0fe78-8f01-4324-9eb4-b0608e08f5d5 195159084238961158 {}\n",
|
|
"7917ac1a-ae53-48b9-8efb-4d55dbe02a47 110740004537832492 {}\n",
|
|
"e86e34c5-bbe2-44d3-b18a-bd01f5385ed3 195159084238961158 {}\n",
|
|
"ffdd98be-a9df-490b-9c67-5fa31929dddc 110740004537832492 {}\n",
|
|
"d5be29a0-4321-44a2-8248-151b6051f43f 195159084238961158 {}\n",
|
|
"c4a71fbd-ef57-41b1-9905-da302b82c941 110740004537832492 {}\n",
|
|
"3fbe8c98-ac39-4046-a77b-5161a198cf71 195159084238961158 {}\n",
|
|
"dbcef666-539a-481a-843d-d0f3d9d688e2 195159084238961158 {}\n",
|
|
"9ca10cb6-c59f-429f-bc32-fff6ac15beb7 110740004537832492 {}\n",
|
|
"ed43e5dd-cf8e-4b28-98a8-7e4d83858b86 110740004537832492 {}\n",
|
|
"c038de6b-9ead-4d6d-81b2-a15f339041b5 110740004537832492 {}\n",
|
|
"aa3a90b9-a21d-49be-90ee-06f79cb41525 195159084238961158 {}\n",
|
|
"ec8a6ff4-df56-4c31-ac76-2b113a91bb36 110740004537832492 {}\n",
|
|
"b18863c3-efb7-413e-8f4a-dd007c664120 110740004537832492 {}\n",
|
|
"d8211f4e-f860-4f6d-bb7f-6b83870b4f77 110740004537832492 {}\n",
|
|
"10c8840d-c2da-460e-9206-045f836e4a1b 110740004537832492 {}\n",
|
|
"4bba5d30-3d86-41bb-bf6a-c57cf57cfe69 110740004537832492 {}\n",
|
|
"ce861689-0cdd-449b-afe1-cf4404c073b6 110740004537832492 {}\n",
|
|
"3e61d551-47b5-44f5-bd36-4223b8803bed 195159084238961158 {}\n",
|
|
"ce5e94b9-33ac-4208-8405-d2a5e5f34a15 3048162260682931 {}\n",
|
|
"46e53ed8-7591-4a69-b823-ca9cf0191eaf 110740004537832492 {}\n",
|
|
"4546522e-58cd-4010-a725-7db2c6de0c8e 110740004537832492 {}\n",
|
|
"07e91701-ef67-4637-9fe7-39f4215f1afc 110740004537832492 {}\n",
|
|
"53bf09f8-72e1-41b8-b092-9bfce00fe795 195159084238961158 {}\n",
|
|
"b485ca68-a756-4e36-8f6c-6b77a1126003 3048162260682931 {}\n",
|
|
"d8418646-9702-4c46-ae84-adc300341ca1 195159084238961158 {}\n",
|
|
"dd893c59-cea9-4510-9ce9-dcdc2afe60a5 110740004537832492 {}\n",
|
|
"cf14748e-f7b3-4058-b4f5-3e4594828d03 3048162260682931 {}\n",
|
|
"f061261a-7399-464a-b1da-f5402ef317a9 195159084238961158 {}\n",
|
|
"2db79548-676a-4270-831d-9f684eedd6f5 195159084238961158 {}\n",
|
|
"1942a0ca-645b-4c9d-858d-f49821db1b39 195159084238961158 {}\n",
|
|
"730f23b4-66c6-4e14-b34a-14b5d485b0d7 195159084238961158 {}\n",
|
|
"eba9e65a-1182-45b3-a671-cd37101cce67 195159084238961158 {}\n",
|
|
"0f8a04e8-9062-4a52-b1b1-fafe0943a585 195159084238961158 {}\n",
|
|
"49ed635a-ae78-43b2-a021-35d0203815d2 110740004537832492 {}\n",
|
|
"ac566b51-9d7f-442a-83ed-703385b42742 110740004537832492 {}\n",
|
|
"d6fdddac-c186-4a63-b1e5-c52ec1964194 195159084238961158 {}\n",
|
|
"8e7733ef-d149-4253-8395-a3bc984b5fb8 110740004537832492 {}\n",
|
|
"96277fda-0396-4309-9fd2-93474a3d22eb 3048162260682931 {}\n",
|
|
"76a81554-74e8-41f9-8511-e5441f76ad97 110740004537832492 {}\n",
|
|
"04cde647-b4bb-449f-a8c5-f0864e6ae55e 195159084238961158 {}\n",
|
|
"712738dd-5443-455c-aa88-2d2967d715e6 3048162260682931 {}\n",
|
|
"097f11d4-fbbf-422e-9896-4297032a058a 195159084238961158 {}\n",
|
|
"5a8a3801-bb5b-4241-b26e-99bde0d1fefe 3048162260682931 {}\n",
|
|
"95780d13-4c28-4615-b224-6a3097df90ba 195159084238961158 {}\n",
|
|
"a2fc50e8-6b79-48c3-a867-834c978ed8a1 195159084238961158 {}\n",
|
|
"39b494c2-bbe4-46b5-ac91-82155ad989e9 3048162260682931 {}\n",
|
|
"ba0789ce-86c6-41d9-91e3-ac4ca3a50298 195159084238961158 {}\n",
|
|
"6c6a6d85-5f70-4938-9600-539bb8ef5a24 195159084238961158 {}\n",
|
|
"026a23ae-838b-40c2-8ee0-a523d52af3e7 110740004537832492 {}\n",
|
|
"42e69c98-7bfb-413e-9c13-db3435b89eca 110740004537832492 {}\n",
|
|
"21583e33-8185-4284-a78f-f6a3bd03b140 3048162260682931 {}\n",
|
|
"0dd50a8b-172e-4adb-a76d-55bfac9dd73c 110740004537832492 {}\n",
|
|
"6f4414d9-7b57-4dca-8d47-509a9b9e5028 195159084238961158 {}\n",
|
|
"4ce17cac-6b4b-4095-a879-0e0118393532 110740004537832492 {}\n",
|
|
"e030bb12-5c0a-49e6-9105-fcef42ed39c1 195159084238961158 {}\n",
|
|
"6e69dec9-8538-4649-8bd0-62ab1dfe0fdf 195159084238961158 {}\n",
|
|
"9f0a1937-49a7-4f74-ba53-e755878fafd9 3048162260682931 {}\n",
|
|
"934db362-f40b-4e03-bd50-1c84ebba7e85 195159084238961158 {}\n",
|
|
"c8f0cd22-9fb0-49a9-9bd0-2a36f5ade654 110740004537832492 {}\n",
|
|
"29b11bf7-ad25-4131-a512-ab3ee2660a78 195159084238961158 {}\n",
|
|
"8e05eecb-d057-4b7d-9373-34399ef9cad5 3048162260682931 {}\n",
|
|
"10809c36-a1dc-4cf7-b3fa-26f2c0865fd8 195159084238961158 {}\n",
|
|
"9fbf554e-4535-4cf9-989e-2b06f74bc0eb 195159084238961158 {}\n",
|
|
"d3c74645-04ca-4d77-95b0-d01311275838 195159084238961158 {}\n",
|
|
"45a4a00a-5fed-41c1-9842-cd609b0c2738 195159084238961158 {}\n",
|
|
"b5574618-cff1-4c1b-ad14-7c9913550b63 110740004537832492 {}\n",
|
|
"e4c3e573-ec78-4797-bca1-c43c7c1a8d5b 3048162260682931 {}\n",
|
|
"76443773-1e3e-40a0-aa76-353224ecb58b 3048162260682931 {}\n",
|
|
"a98ff61d-5a73-4870-888a-43bb3007d6a9 3048162260682931 {}\n",
|
|
"7138e0e9-c932-43c8-b714-c10f30cd7e49 110740004537832492 {}\n",
|
|
"1ca12457-69b1-4ce4-b3a7-b8c2534cea03 3048162260682931 {}\n",
|
|
"e9315996-e93d-4550-b245-51ac1f142924 110740004537832492 {}\n",
|
|
"ba9305c1-9fd8-4c0b-b207-3a2bfad812a3 110740004537832492 {}\n",
|
|
"6185fd21-b199-41a6-823e-0b19f5a8b698 110740004537832492 {}\n",
|
|
"dba0d8fd-c3dc-4210-b359-e2a5836b2447 3048162260682931 {}\n",
|
|
"7054aeb6-852a-4086-83cd-fe201186022a 3048162260682931 {}\n",
|
|
"68956c75-42b4-444d-964b-1624e75a6c8d 195159084238961158 {}\n",
|
|
"ef9b59ea-afa0-4766-8f39-48c771eb8a48 110740004537832492 {}\n",
|
|
"e36ba87c-3d50-42dd-a8ab-63d78b4de391 110740004537832492 {}\n",
|
|
"f1fbea99-15f7-4cf8-9b04-452efae5b9e9 3048162260682931 {}\n",
|
|
"6991108c-39dc-4344-8570-961c88b66197 195159084238961158 {}\n",
|
|
"a8d2daff-e4c1-4a9d-8b38-e850dfceb13b 195159084238961158 {}\n",
|
|
"f0fb8ece-2c6f-40ca-bbe8-958f4359ffe0 3048162260682931 {}\n",
|
|
"4a72bd0d-a40a-427a-b91d-fb2e701e10ca 110740004537832492 {}\n",
|
|
"f5dc37fc-1f5b-4b9d-81ba-b0442105d7ab 110740004537832492 {}\n",
|
|
"f3c94ed1-baf9-4e61-aa35-adc9ad280f44 3048162260682931 {}\n",
|
|
"1fb590d6-488e-4667-8450-022560ae5bdc 3048162260682931 {}\n",
|
|
"9e4c50f7-977c-41fb-bf4a-fa60b8b65c00 195159084238961158 {}\n",
|
|
"2f076885-6b54-4502-a3ed-d3b22f243e4a 110740004537832492 {}\n",
|
|
"54c5bc31-a0ba-45a1-b4ca-b4a7b5ee53d3 3048162260682931 {}\n",
|
|
"5b43e784-9323-41d4-933f-091e693e029b 3048162260682931 {}\n",
|
|
"3c269b5b-1673-4007-90bd-61a765a5a97c 195159084238961158 {}\n",
|
|
"b7337b7e-ad04-4736-8413-40f1aa0b7ee4 3048162260682931 {}\n",
|
|
"eafc0647-a3c3-402c-811f-a0d95f1be795 110740004537832492 {}\n",
|
|
"b0feb5b3-19e0-462e-8811-e62d7502c269 110740004537832492 {}\n",
|
|
"6c1eefab-7cd8-4979-8bee-87f64eab48d8 110740004537832492 {}\n",
|
|
"ebc89725-5d5a-4e37-82be-961ed8459294 3048162260682931 {}\n",
|
|
"1e59120e-f7eb-46f6-9d49-022ae3c3e617 195159084238961158 {}\n",
|
|
"01b43583-dd69-43d6-95f7-05ea4b7afc23 3048162260682931 {}\n",
|
|
"bc24aedd-d77f-462a-9acc-e68afbd09b06 3048162260682931 {}\n",
|
|
"e3c9d017-0e97-4931-9a18-b3d7de6d0a50 3048162260682931 {}\n",
|
|
"7fb8e7f6-6a8f-421f-a851-b96150d00d7e 3048162260682931 {}\n",
|
|
"68ea77ad-08b2-41be-a3f7-435d296c4ec4 110740004537832492 {}\n",
|
|
"e0b9c038-2578-4953-a0df-35917709334b 110740004537832492 {}\n",
|
|
"17ac6e4e-e325-40b2-ab35-6bb9f8885ea3 110740004537832492 {}\n",
|
|
"f31d1908-aff1-4fbb-8dae-86b4866b038b 110740004537832492 {}\n",
|
|
"fc196ddf-e5ef-47ce-9e56-569555028ebb 110740004537832492 {}\n",
|
|
"929969ed-82ea-4583-b7b3-37a259002143 110740004537832492 {}\n",
|
|
"150073d9-acc9-4c5b-bad3-b66086b35129 195159084238961158 {}\n",
|
|
"3b515d02-e856-4551-8aa0-f34d6a4f8b7d 195159084238961158 {}\n",
|
|
"d9b877ba-ddb9-4168-a60c-1046d7edfbaf 3048162260682931 {}\n",
|
|
"ab19f631-a4df-403a-8607-a6aec24d65ea 110740004537832492 {}\n",
|
|
"16b1922f-ecf1-434c-842b-cef9814c7d63 110740004537832492 {}\n",
|
|
"e0700be2-21d0-4a16-8fa4-de7baa0b4e55 110740004537832492 {}\n",
|
|
"699c1ab4-c32d-438f-b247-27ef7851105e 195159084238961158 {}\n",
|
|
"f4909d06-632a-4010-8775-2f07d4880dc5 110740004537832492 {}\n",
|
|
"d0984028-9e56-49f1-9ebc-fc7bd74195bb 3048162260682931 {}\n",
|
|
"041b6bb2-fa8f-4873-aca9-4e550aa49527 110740004537832492 {}\n",
|
|
"2f205334-c50b-4896-9fa9-d17797306ef4 3048162260682931 {}\n",
|
|
"468a2a9b-a6b6-4173-99eb-389f19e7d504 110740004537832492 {}\n",
|
|
"319b6e5c-3636-40aa-ab06-7acdd91f2d18 195159084238961158 {}\n",
|
|
"8c286152-5d34-46d1-97e3-6815aab023e7 3048162260682931 {}\n",
|
|
"8a69e854-c170-4b74-9b14-ccf2d88625f4 110740004537832492 {}\n",
|
|
"574fc6b9-bcc4-41fa-9ba6-a22f4951cad8 195159084238961158 {}\n",
|
|
"59195059-8f29-4687-9e2f-fe1f9bcb1ac7 110740004537832492 {}\n",
|
|
"7c181eea-ef66-4edf-8a97-9fd2808ef10c 3048162260682931 {}\n",
|
|
"b912018f-de1f-47c1-aec1-3873a078a643 195159084238961158 {}\n",
|
|
"d9535d69-6370-419b-8ce2-0207500faabf 110740004537832492 {}\n",
|
|
"fc12bea4-b393-4670-af4f-7851740fc4b0 195159084238961158 {}\n",
|
|
"32e357fc-6f0c-4932-ae92-b903cc5d6a86 3048162260682931 {}\n",
|
|
"0428c04c-c686-4cfa-a592-e932a98c5a2f 110740004537832492 {}\n",
|
|
"4cadf03a-cf5e-4b02-b78a-38fdea66bfa8 3048162260682931 {}\n",
|
|
"d32d1e4f-24bb-425c-96a8-2761f7ef51a5 195159084238961158 {}\n",
|
|
"58de2f4e-4c03-4d23-b001-7c1025d8bcbb 195159084238961158 {}\n",
|
|
"556e5c0a-633e-4dac-8c15-5fec6f0e792b 110740004537832492 {}\n",
|
|
"f3d4c619-a868-4212-a94b-5eb2c9b43b47 195159084238961158 {}\n",
|
|
"e34da5b6-c9ee-48dd-a0ec-a20b35a372d3 110740004537832492 {}\n",
|
|
"d204932d-4d61-4d7e-b9ba-009bee2dcce5 110740004537832492 {}\n",
|
|
"97a37f76-ca95-40a0-82da-050dfe29a328 110740004537832492 {}\n",
|
|
"3dc22395-7435-48cc-a87d-292a65a55670 110740004537832492 {}\n",
|
|
"b256453e-1449-4605-b979-4c64a796c920 3048162260682931 {}\n",
|
|
"4675eafd-7001-40a1-b0ae-ac9fe8c191a0 3048162260682931 {}\n",
|
|
"d58ef59a-f952-4992-b846-3eca5eb8fe43 3048162260682931 {}\n",
|
|
"1d39121b-7aa1-4ca1-aa6a-ae01913ac1af 3048162260682931 {}\n",
|
|
"2ef17496-65f6-4ecc-9518-ef4ceca71744 3048162260682931 {}\n",
|
|
"8a4cec83-edf7-4e10-b3b6-78f60789294f 110740004537832492 {}\n",
|
|
"c8e5ab59-5667-4b08-a35b-473a1f715808 195159084238961158 {}\n",
|
|
"c29b66b7-1c9d-4bd5-971d-58c2ef19978a 110740004537832492 {}\n",
|
|
"42c50c89-611a-465f-a4b8-3347d45881e0 110740004537832492 {}\n",
|
|
"021953d0-a9e9-4d57-b04e-d61542dcf549 110740004537832492 {}\n",
|
|
"4e86ab68-66c4-48b2-8936-c29954e2eae0 3048162260682931 {}\n",
|
|
"3846791c-f3e0-4e1c-a255-b6662a4de7c0 3048162260682931 {}\n",
|
|
"9b6837d0-204c-4353-bfb0-075631455ff3 110740004537832492 {}\n",
|
|
"7f5aeefd-0396-493d-bd0d-081ebafe992f 110740004537832492 {}\n",
|
|
"eef2d9c0-26da-45d7-98f8-edc7eb313d82 195159084238961158 {}\n",
|
|
"b6933ffa-c99b-45bc-bfb6-7faabab7e557 110740004537832492 {}\n",
|
|
"9678351d-732a-4b84-bccb-b8d4a23f70e6 195159084238961158 {}\n",
|
|
"7072bfc8-1b72-42b4-bfc4-8e7d4fa3604f 195159084238961158 {}\n",
|
|
"d016023b-e1e4-428a-a888-0505a3247ecd 110740004537832492 {}\n",
|
|
"23662f27-80d9-4f3d-82a6-b726415c0672 110740004537832492 {}\n",
|
|
"3c565988-a0d4-4a2f-afb9-cea339f3a8e1 110740004537832492 {}\n",
|
|
"965b4974-49cc-4f64-90fd-5e911feb3b31 110740004537832492 {}\n",
|
|
"0fdd36e2-5725-472d-9295-73a9762182b2 110740004537832492 {}\n",
|
|
"a1ae5796-ff1f-42cb-9745-206c354e015e 110740004537832492 {}\n",
|
|
"d46d16e6-d1c9-4863-a23e-ce81c2cba6b1 195159084238961158 {}\n",
|
|
"5258a116-2e7f-4de3-8226-d6a670aa8ec2 110740004537832492 {}\n",
|
|
"50205bf9-b8af-4a71-83c6-2928a7f4cd5d 195159084238961158 {}\n",
|
|
"ebb2d2af-b299-4fbd-af87-cca2b1c1d094 110740004537832492 {}\n",
|
|
"25759861-5f68-4a9e-b350-05716f34a216 110740004537832492 {}\n",
|
|
"72f719be-18a2-4efd-82a9-d0970eed301b 110740004537832492 {}\n",
|
|
"3aa4c65d-dedf-4d79-b3e8-96eb2c12cec0 110740004537832492 {}\n",
|
|
"29973fdc-de05-4192-bb50-215263eb0459 110740004537832492 {}\n",
|
|
"e3f56e83-b4b9-4532-8cf1-7041299c753e 110740004537832492 {}\n",
|
|
"de89a3ab-ed1c-4056-a1c2-c2e6c3e40a27 110740004537832492 {}\n",
|
|
"2600b511-849e-470c-80a1-37137cb9c8a5 110740004537832492 {}\n",
|
|
"21de5d4c-5a6c-4f7b-8ff2-7f654f23e1ac 110740004537832492 {}\n",
|
|
"b748460a-6cb9-45ca-accb-ddc6b4119c15 195159084238961158 {}\n",
|
|
"f5b81bef-654f-4573-93bb-1d1b361d1a06 110740004537832492 {}\n",
|
|
"8337e229-2c9f-4fa5-8042-4c55458a57c6 110740004537832492 {}\n",
|
|
"e23ba813-1a95-42a6-a6a9-6b322b8fd49d 110740004537832492 {}\n",
|
|
"93ef9110-328a-428c-80dd-5282411ba0fe 110740004537832492 {}\n",
|
|
"8800c3d5-a3d4-4f4c-861e-c2b81b8bd93d 110740004537832492 {}\n",
|
|
"af8a934f-5eea-4472-8f43-b649edc3c14a 110740004537832492 {}\n",
|
|
"715b3b84-e528-485b-9b84-39264e1447ae 110740004537832492 {}\n",
|
|
"29687875-0a5a-415b-8555-32ff7d5f9e1a 110740004537832492 {}\n",
|
|
"b0620ff0-5c3e-475d-9aa6-094b784e11b4 3048162260682931 {}\n",
|
|
"4d4e3589-3bc8-421f-9421-b9a24dba8da6 110740004537832492 {}\n",
|
|
"49e8a121-992c-4d5a-ac10-5a41c31e1d11 3048162260682931 {}\n",
|
|
"d3cdf546-a7f9-4815-bbbf-3656e581b8f6 195159084238961158 {}\n",
|
|
"199a8d30-f7da-4dc1-906f-06419474524d 195159084238961158 {}\n",
|
|
"1302628b-4aef-4974-ae9b-07fac67d61fb 110740004537832492 {}\n",
|
|
"a8826704-d220-4f0c-974f-6aaec1c8ddb2 110740004537832492 {}\n",
|
|
"23dd9933-12b4-4c78-a5a6-51b6fa957f6d 3048162260682931 {}\n",
|
|
"31951407-50cc-4f2c-816a-411a674f7ee4 110740004537832492 {}\n",
|
|
"2cabffc6-4860-4293-bfad-02b1193810ed 110740004537832492 {}\n",
|
|
"4b73f41f-dd3f-4a5b-822a-f19f74612c70 195159084238961158 {}\n",
|
|
"84fb0bd3-1642-455f-b358-8345f9daf59f 195159084238961158 {}\n",
|
|
"122f48fa-1f30-46eb-ae04-08a46d2064fd 110740004537832492 {}\n",
|
|
"9d5191c2-e998-4df9-8e25-ee1798cb9b44 110740004537832492 {}\n",
|
|
"50a37f07-52ef-4db8-a9a6-116d96a5649b 195159084238961158 {}\n",
|
|
"2f7496e1-364f-4afb-9d88-b08b0a055770 195159084238961158 {}\n",
|
|
"6daf5130-89c5-49f5-bdf7-2a2481ddd8e4 3048162260682931 {}\n",
|
|
"e1c996e5-b1ae-4e61-8be9-b005b723fbfb 3048162260682931 {}\n",
|
|
"16764374-3b46-468b-989b-4b36ab2d9249 110740004537832492 {}\n",
|
|
"a9f02304-99ad-40b4-a348-6e1aeb51c912 110740004537832492 {}\n",
|
|
"cd2623a2-9daf-49d4-8c53-f7674b39bfc0 110740004537832492 {}\n",
|
|
"5e89e516-f35e-4060-9893-ef763b70685f 110740004537832492 {}\n",
|
|
"45d17f29-e456-4fe3-af5c-0249949d186b 110740004537832492 {}\n",
|
|
"555bea0b-d39d-4c5e-b4ae-9c199dbfb2f5 110740004537832492 {}\n",
|
|
"aea9de44-6de7-4c92-9fde-bf1caa982c24 110740004537832492 {}\n",
|
|
"949a8f5c-d3ad-4c1c-882c-6c074e112d09 110740004537832492 {}\n",
|
|
"b224417b-6dc3-4195-a5ed-4e6633fb7dd1 110740004537832492 {}\n",
|
|
"6250acc0-f635-4485-8155-3cc19a65c0fa 110740004537832492 {}\n",
|
|
"1b2791f6-2dad-44cd-a1d1-77fe08ce4aed 110740004537832492 {}\n",
|
|
"abf015dd-5fd6-41ca-945c-744094419ae3 110740004537832492 {}\n",
|
|
"e350074e-46ee-46b8-bcb5-49c4963b1ad3 110740004537832492 {}\n",
|
|
"3a1d0d63-4073-44e7-b74a-37bdec20a80f 110740004537832492 {}\n",
|
|
"fe47e528-4ae7-44b4-988e-bf6cfa222c95 195159084238961158 {}\n",
|
|
"3d2e9a2c-65b0-4532-9233-26dd898fe757 195159084238961158 {}\n",
|
|
"d7cd6fc7-9135-4872-bbf3-bbe2ba1047f7 110740004537832492 {}\n",
|
|
"b01c06c1-3662-4c78-9d64-51788791b095 195159084238961158 {}\n",
|
|
"be14662a-74dd-45f6-b8e3-cbf0b80f777f 3048162260682931 {}\n",
|
|
"f843eed7-52db-4542-8c04-5a684b6fd667 3048162260682931 {}\n",
|
|
"f68bba82-6c6b-4f82-b882-a9e25967b713 110740004537832492 {}\n",
|
|
"a2763631-a60d-4c51-bdc2-9b47af4c8979 195159084238961158 {}\n",
|
|
"a381db5d-3d7f-4c79-a1dd-820a87538332 110740004537832492 {}\n",
|
|
"19afa33c-6deb-411e-82c8-1f03c6179a5f 3048162260682931 {}\n",
|
|
"52ef33d5-613c-4690-a156-e2be6e8efc3c 195159084238961158 {}\n",
|
|
"1e807a59-9e73-4459-99b7-7b967f4eb251 3048162260682931 {}\n",
|
|
"889d2601-ac25-4b6d-ab6c-fa246045b151 3048162260682931 {}\n",
|
|
"9a6b97cd-0746-4f20-9a20-9bf8ba6c4b09 110740004537832492 {}\n",
|
|
"df8ca77c-8a26-44e5-8d69-262fd80790b3 3048162260682931 {}\n",
|
|
"fbf9f19f-7b72-404b-b239-f6f62285e970 110740004537832492 {}\n",
|
|
"f31f3d74-44b6-49ca-93bb-a7d35f8a552c 110740004537832492 {}\n",
|
|
"d2b5c70f-4228-46ba-a7f0-fcdb2a32ccd4 110740004537832492 {}\n",
|
|
"758a61cd-15a6-4147-80c3-b35f5bc317be 110740004537832492 {}\n",
|
|
"06417ef2-2071-4232-a85a-1f049c05dff1 3048162260682931 {}\n",
|
|
"ba86e32d-cbd1-4b62-8f37-84a956ce2404 3048162260682931 {}\n",
|
|
"0ba15165-274f-424e-8046-2c2e62aeedd3 110740004537832492 {}\n",
|
|
"b37ba0ef-2e32-4e0d-b235-426aa9c6604c 110740004537832492 {}\n",
|
|
"034834e8-c76e-488b-979c-06c46a2ab569 3048162260682931 {}\n",
|
|
"9a76104f-28b5-42ce-a62a-877eed61c9bb 195159084238961158 {}\n",
|
|
"c14439af-e345-4f77-b72c-028be59ba7bc 110740004537832492 {}\n"
|
|
]
|
|
}
|
|
],
|
|
"source": [
|
|
"import pandas as pd\n",
|
|
"import pandas as pd\n",
|
|
"import numpy as np\n",
|
|
"import requests\n",
|
|
"import json\n",
|
|
"import time\n",
|
|
"import re\n",
|
|
"from datetime import datetime\n",
|
|
"from dateutil.relativedelta import relativedelta\n",
|
|
"from pathlib import Path\n",
|
|
"from urllib.parse import quote\n",
|
|
"from io import BytesIO\n",
|
|
"\n",
|
|
"ROOT = Path('.').absolute() # 当前工作目录\n",
|
|
"\n",
|
|
"\n",
|
|
"# 生成 token，参数不需要修改\n",
|
|
"def generateToken() -> str:\n",
|
|
" \"\"\" 生成 token \"\"\"\n",
|
|
"\n",
|
|
" token_api = 'https://api.dingtalk.com/v1.0/oauth2/accessToken'\n",
|
|
"\n",
|
|
" # 该信息在钉钉开放应用中\n",
|
|
" data = {\n",
|
|
" \"appKey\": \"ding5kqocon5s9oph5uq\",\n",
|
|
" \"appSecret\": 'HL1jgsIIfLAC0eTH0A1m4mwxUDqbgsiPeCCGGE3ocM6qJBTIW7Ivt9drxF_Z4Kb_'\n",
|
|
" }\n",
|
|
"\n",
|
|
" res = requests.post(token_api, json=data)\n",
|
|
" token = res.json()['accessToken']\n",
|
|
"\n",
|
|
" return token\n",
|
|
"\n",
|
|
"\n",
|
|
"class NpEncoder(json.JSONEncoder):\n",
|
|
" def default(self, obj):\n",
|
|
" if isinstance(obj, np.integer):\n",
|
|
" return int(obj)\n",
|
|
" elif isinstance(obj, np.floating):\n",
|
|
" return float(obj)\n",
|
|
" elif isinstance(obj, np.ndarray):\n",
|
|
" return obj.tolist()\n",
|
|
" else:\n",
|
|
" return super(NpEncoder, self).default(obj)\n",
|
|
"\n",
|
|
"\n",
|
|
"\"\"\" 处理流程开始 \"\"\"\n",
|
|
"# [正式]续约服务流程 —— 修改续约负责人 再进行转交 \n",
|
|
"FORMID = \"FORM-L89662816B04LXH893M4K50Q7MIZ1SVQI08ALU2\"\n",
|
|
"TOKEN = generateToken()\n",
|
|
"\n",
|
|
"df = pd.read_excel(r'C:\\Users\\admin\\Downloads\\新签节点化服务待办_20230307173209.xlsx',sheet_name='Sheet1',dtype='string')\n",
|
|
"for i in range(len(df)):\n",
|
|
" a = df.loc[i,'实例ID']\n",
|
|
" b = df.loc[i,'待处理字段']\n",
|
|
"\n",
|
|
" \"\"\" 通过实例id 获取表单内容 \"\"\"\n",
|
|
"\n",
|
|
" api = f'https://api.dingtalk.com//v1.0/yida/forms/instances/{a}?appType=APP_UYZ0KG6L0CCNV80GZ66O&systemToken=XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2&userId=2268275546837446&language=zh_CN'\n",
|
|
"\n",
|
|
" headers = {\n",
|
|
" \"Content-Type\": \"application/json\",\n",
|
|
" \"x-acs-dingtalk-access-token\": TOKEN\n",
|
|
" }\n",
|
|
" payload = {\n",
|
|
" \"appType\" : \"APP_UYZ0KG6L0CCNV80GZ66O\",\n",
|
|
" \"systemToken\" : \"XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2\",\n",
|
|
" \"language\": \"zh_CN\",\n",
|
|
" \"userId\" : \"2268275546837446\",\n",
|
|
" }\n",
|
|
" # \n",
|
|
" res = requests.get(api, headers=headers)\n",
|
|
" res_new = res.json()\n",
|
|
" xiugaiId_new = res_new.get('formData').get('employeeField_la80kj0k_id')\n",
|
|
" xiugaiId_new\n",
|
|
" data_new = {\n",
|
|
" 'employeeField_la80kj0k':[b]\n",
|
|
" }\n",
|
|
"\n",
|
|
"\n",
|
|
" \"\"\" 函数功能：更新表单内容 \"\"\"\n",
|
|
" api = f'https://api.dingtalk.com//v1.0/yida/forms/instances'\n",
|
|
"\n",
|
|
" headers = {\n",
|
|
" \"Content-Type\": \"application/json\",\n",
|
|
" \"x-acs-dingtalk-access-token\": TOKEN\n",
|
|
" }\n",
|
|
"\n",
|
|
" payload = {\n",
|
|
" \"appType\" : \"APP_UYZ0KG6L0CCNV80GZ66O\",\n",
|
|
" \"systemToken\" : \"XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2\",\n",
|
|
" \"userId\" : \"2268275546837446\", # 曹伟 id\n",
|
|
" \"language\" : \"zh_CN\",\n",
|
|
" \"useLatestVersion\" : \"false\",\n",
|
|
" \"formInstanceId\" : a,\n",
|
|
" \"updateFormDataJson\" : json.dumps(data_new, cls=NpEncoder),\n",
|
|
" }\n",
|
|
"\n",
|
|
" res = requests.put(api, headers=headers, json=payload)\n",
|
|
" print(a,b,res.text)"
|
|
]
|
|
},
|
|
{
|
|
"attachments": {},
|
|
"cell_type": "markdown",
|
|
"metadata": {},
|
|
"source": [
|
|
"# 新签节点化服务待办"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 2,
|
|
"metadata": {},
|
|
"outputs": [
|
|
{
|
|
"name": "stdout",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"55f221a1-d9a1-4429-89b5-632636112e7f 171201105229666119 {}\n",
|
|
"67e989f7-c51a-4f05-bc5b-4ad9e5edc072 171201105229666119 {}\n",
|
|
"2ba7208b-fd65-4204-8988-cf3c3e688674 171201105229666119 {}\n",
|
|
"b7bc79d4-ed4d-4584-a4f4-280f0fbdd7f2 171201105229666119 {}\n",
|
|
"92dab52d-3092-444e-8543-a46d3b2fc783 171201105229666119 {}\n",
|
|
"5b777523-4f10-469d-be48-5517fdf3737d 171201105229666119 {}\n",
|
|
"30c86842-8cd7-4dcd-a272-01117143ab11 171201105229666119 {}\n",
|
|
"841791c7-570c-4796-bb6c-0e1b23601dbc 171201105229666119 {}\n",
|
|
"692701be-0d3c-4a9f-8786-88dd20fbe73f 171201105229666119 {}\n",
|
|
"9bdbc3c7-f1f6-430c-9ad7-87a8bf03ac4d 171201105229666119 {}\n",
|
|
"0bfaae3b-2bbb-43cd-b516-9b0cd596ad7c 084119070623372941 {}\n",
|
|
"e0cfb92c-4902-4119-abfe-9fa4b5efa931 084119070623372941 {}\n"
|
|
]
|
|
}
|
|
],
|
|
"source": [
|
|
"import pandas as pd\n",
|
|
"import pandas as pd\n",
|
|
"import numpy as np\n",
|
|
"import requests\n",
|
|
"import json\n",
|
|
"import time\n",
|
|
"import re\n",
|
|
"from datetime import datetime\n",
|
|
"from dateutil.relativedelta import relativedelta\n",
|
|
"from pathlib import Path\n",
|
|
"from urllib.parse import quote\n",
|
|
"from io import BytesIO\n",
|
|
"\n",
|
|
"ROOT = Path('.').absolute() # 当前工作目录\n",
|
|
"\n",
|
|
"\n",
|
|
"# 生成 token，参数不需要修改\n",
|
|
"def generateToken() -> str:\n",
|
|
" \"\"\" 生成 token \"\"\"\n",
|
|
"\n",
|
|
" token_api = 'https://api.dingtalk.com/v1.0/oauth2/accessToken'\n",
|
|
"\n",
|
|
" # 该信息在钉钉开放应用中\n",
|
|
" data = {\n",
|
|
" \"appKey\": \"ding5kqocon5s9oph5uq\",\n",
|
|
" \"appSecret\": 'HL1jgsIIfLAC0eTH0A1m4mwxUDqbgsiPeCCGGE3ocM6qJBTIW7Ivt9drxF_Z4Kb_'\n",
|
|
" }\n",
|
|
"\n",
|
|
" res = requests.post(token_api, json=data)\n",
|
|
" token = res.json()['accessToken']\n",
|
|
"\n",
|
|
" return token\n",
|
|
"\n",
|
|
"\n",
|
|
"class NpEncoder(json.JSONEncoder):\n",
|
|
" def default(self, obj):\n",
|
|
" if isinstance(obj, np.integer):\n",
|
|
" return int(obj)\n",
|
|
" elif isinstance(obj, np.floating):\n",
|
|
" return float(obj)\n",
|
|
" elif isinstance(obj, np.ndarray):\n",
|
|
" return obj.tolist()\n",
|
|
" else:\n",
|
|
" return super(NpEncoder, self).default(obj)\n",
|
|
"\n",
|
|
"\n",
|
|
"\"\"\" 处理流程开始 \"\"\"\n",
|
|
"FORMID = \"FORM-L89662816B04LXH893M4K50Q7MIZ1SVQI08ALU2\"\n",
|
|
"TOKEN = generateToken()\n",
|
|
"\n",
|
|
"df = pd.read_excel(r'C:\\Users\\admin\\Downloads\\新签节点化服务待办_20230601140457.xlsx',sheet_name='Sheet1',dtype='string')\n",
|
|
"for i in range(len(df)):\n",
|
|
" a = df.loc[i,'实例ID']\n",
|
|
" b = df.loc[i,'修改内容111']\n",
|
|
" c = df.loc[i,'唯一标识符']\n",
|
|
"\n",
|
|
" \"\"\" 通过实例id 获取表单内容 \"\"\"\n",
|
|
"\n",
|
|
" api = f'https://api.dingtalk.com//v1.0/yida/forms/instances/{a}?appType=APP_UYZ0KG6L0CCNV80GZ66O&systemToken=XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2&userId=2268275546837446&language=zh_CN'\n",
|
|
"\n",
|
|
" headers = {\n",
|
|
" \"Content-Type\": \"application/json\",\n",
|
|
" \"x-acs-dingtalk-access-token\": TOKEN\n",
|
|
" }\n",
|
|
" payload = {\n",
|
|
" \"appType\" : \"APP_UYZ0KG6L0CCNV80GZ66O\",\n",
|
|
" \"systemToken\" : \"XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2\",\n",
|
|
" \"language\": \"zh_CN\",\n",
|
|
" \"userId\" : \"2268275546837446\",\n",
|
|
" }\n",
|
|
" # \n",
|
|
" res = requests.get(api, headers=headers)\n",
|
|
" res_new = res.json()\n",
|
|
"\n",
|
|
" data_new = {\n",
|
|
" c:[b]\n",
|
|
" }\n",
|
|
"\n",
|
|
"\n",
|
|
" \"\"\" 函数功能：更新表单内容 \"\"\"\n",
|
|
" api = f'https://api.dingtalk.com//v1.0/yida/forms/instances'\n",
|
|
"\n",
|
|
" headers = {\n",
|
|
" \"Content-Type\": \"application/json\",\n",
|
|
" \"x-acs-dingtalk-access-token\": TOKEN\n",
|
|
" }\n",
|
|
"\n",
|
|
" payload = {\n",
|
|
" \"appType\" : \"APP_UYZ0KG6L0CCNV80GZ66O\",\n",
|
|
" \"systemToken\" : \"XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2\",\n",
|
|
" \"userId\" : \"2268275546837446\", # 曹伟 id\n",
|
|
" \"language\" : \"zh_CN\",\n",
|
|
" \"useLatestVersion\" : \"false\",\n",
|
|
" \"formInstanceId\" : a,\n",
|
|
" \"updateFormDataJson\" : json.dumps(data_new, cls=NpEncoder),\n",
|
|
" }\n",
|
|
"\n",
|
|
" res = requests.put(api, headers=headers, json=payload)\n",
|
|
" print(a,b,res.text)"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 2,
|
|
"metadata": {},
|
|
"outputs": [
|
|
{
|
|
"name": "stdout",
|
|
"output_type": "stream",
|
|
"text": [
|
|
"d87aa736-79ff-4648-8ffb-17105054aa95 171201105229666119 {}\n"
|
|
]
|
|
}
|
|
],
|
|
"source": [
|
|
"import pandas as pd\n",
|
|
"import pandas as pd\n",
|
|
"import numpy as np\n",
|
|
"import requests\n",
|
|
"import json\n",
|
|
"import time\n",
|
|
"import re\n",
|
|
"from datetime import datetime\n",
|
|
"from dateutil.relativedelta import relativedelta\n",
|
|
"from pathlib import Path\n",
|
|
"from urllib.parse import quote\n",
|
|
"from io import BytesIO\n",
|
|
"\n",
|
|
"ROOT = Path('.').absolute() # 当前工作目录\n",
|
|
"\n",
|
|
"\n",
|
|
"# 生成 token，参数不需要修改\n",
|
|
"def generateToken() -> str:\n",
|
|
" \"\"\" 生成 token \"\"\"\n",
|
|
"\n",
|
|
" token_api = 'https://api.dingtalk.com/v1.0/oauth2/accessToken'\n",
|
|
"\n",
|
|
" # 该信息在钉钉开放应用中\n",
|
|
" data = {\n",
|
|
" \"appKey\": \"ding5kqocon5s9oph5uq\",\n",
|
|
" \"appSecret\": 'HL1jgsIIfLAC0eTH0A1m4mwxUDqbgsiPeCCGGE3ocM6qJBTIW7Ivt9drxF_Z4Kb_'\n",
|
|
" }\n",
|
|
"\n",
|
|
" res = requests.post(token_api, json=data)\n",
|
|
" token = res.json()['accessToken']\n",
|
|
"\n",
|
|
" return token\n",
|
|
"\n",
|
|
"\n",
|
|
"class NpEncoder(json.JSONEncoder):\n",
|
|
" def default(self, obj):\n",
|
|
" if isinstance(obj, np.integer):\n",
|
|
" return int(obj)\n",
|
|
" elif isinstance(obj, np.floating):\n",
|
|
" return float(obj)\n",
|
|
" elif isinstance(obj, np.ndarray):\n",
|
|
" return obj.tolist()\n",
|
|
" else:\n",
|
|
" return super(NpEncoder, self).default(obj)\n",
|
|
"\n",
|
|
"\n",
|
|
"\"\"\" 处理流程开始 \"\"\"\n",
|
|
"FORMID = \"FORM-L89662816B04LXH893M4K50Q7MIZ1SVQI08ALU2\"\n",
|
|
"TOKEN = generateToken()\n",
|
|
"\n",
|
|
"# df = pd.read_excel(r'C:\\Users\\admin\\Downloads\\新签节点化服务待办_20230601140457.xlsx',sheet_name='Sheet1',dtype='string')\n",
|
|
"for i in range(0,1):\n",
|
|
" a = 'd87aa736-79ff-4648-8ffb-17105054aa95'\n",
|
|
" b = \"171201105229666119\"\n",
|
|
" c = \"employeeField_lc5wh9h4\"\n",
|
|
"\n",
|
|
" \"\"\" 通过实例id 获取表单内容 \"\"\"\n",
|
|
"\n",
|
|
" api = f'https://api.dingtalk.com//v1.0/yida/forms/instances/{a}?appType=APP_UYZ0KG6L0CCNV80GZ66O&systemToken=XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2&userId=2268275546837446&language=zh_CN'\n",
|
|
"\n",
|
|
" headers = {\n",
|
|
" \"Content-Type\": \"application/json\",\n",
|
|
" \"x-acs-dingtalk-access-token\": TOKEN\n",
|
|
" }\n",
|
|
" payload = {\n",
|
|
" \"appType\" : \"APP_UYZ0KG6L0CCNV80GZ66O\",\n",
|
|
" \"systemToken\" : \"XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2\",\n",
|
|
" \"language\": \"zh_CN\",\n",
|
|
" \"userId\" : \"2268275546837446\",\n",
|
|
" }\n",
|
|
" # \n",
|
|
" res = requests.get(api, headers=headers)\n",
|
|
" res_new = res.json()\n",
|
|
"\n",
|
|
" data_new = {\n",
|
|
" c:[b]\n",
|
|
" }\n",
|
|
"\n",
|
|
"\n",
|
|
" \"\"\" 函数功能：更新表单内容 \"\"\"\n",
|
|
" api = f'https://api.dingtalk.com//v1.0/yida/forms/instances'\n",
|
|
"\n",
|
|
" headers = {\n",
|
|
" \"Content-Type\": \"application/json\",\n",
|
|
" \"x-acs-dingtalk-access-token\": TOKEN\n",
|
|
" }\n",
|
|
"\n",
|
|
" payload = {\n",
|
|
" \"appType\" : \"APP_UYZ0KG6L0CCNV80GZ66O\",\n",
|
|
" \"systemToken\" : \"XA966F81JAJOFCVVVKO64E9MIIZV1EWE5SFMKJ2\",\n",
|
|
" \"userId\" : \"2268275546837446\", # 曹伟 id\n",
|
|
" \"language\" : \"zh_CN\",\n",
|
|
" \"useLatestVersion\" : \"false\",\n",
|
|
" \"formInstanceId\" : a,\n",
|
|
" \"updateFormDataJson\" : json.dumps(data_new, cls=NpEncoder),\n",
|
|
" }\n",
|
|
"\n",
|
|
" res = requests.put(api, headers=headers, json=payload)\n",
|
|
" print(a,b,res.text)"
|
|
]
|
|
}
|
|
],
|
|
"metadata": {
|
|
"kernelspec": {
|
|
"display_name": "F6processing",
|
|
"language": "python",
|
|
"name": "python3"
|
|
},
|
|
"language_info": {
|
|
"codemirror_mode": {
|
|
"name": "ipython",
|
|
"version": 3
|
|
},
|
|
"file_extension": ".py",
|
|
"mimetype": "text/x-python",
|
|
"name": "python",
|
|
"nbconvert_exporter": "python",
|
|
"pygments_lexer": "ipython3",
|
|
"version": "3.9.4"
|
|
},
|
|
"orig_nbformat": 4,
|
|
"vscode": {
|
|
"interpreter": {
|
|
"hash": "f83923c7d0b4d2e003073efbd633777fa3fd66b7578149f24f67f4796b9b3ac4"
|
|
}
|
|
}
|
|
},
|
|
"nbformat": 4,
|
|
"nbformat_minor": 2
|
|
}
|