{ "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 }