Dear All, I have a list of URLs in an excel sheet. When clicked on each link, it opens into a browser but the URL in browser is different. For example, a link in excel is “https://management.work.com/9/08FA1065-0BC2-9F1F-9534E6/ebi/pdf/?productID=13403” but when click on it, it opens in browser with URL " (https://management.work.com/9/08FA1065-0BC2-4CF7-9F1F-95345B8D80E6/pdf/IPQ597)". I need to extract a URL after the link is open in browser. To be precise, I need to get the code which appears last in open URL. In above example the code I want is “IPQ597”. I need these codes for all the URLs in my excel sheet. Is there a way I could get in quick time? Power automate desktop can do it but it takes longer time. Thanks a lot in advance.
Thanks for your feedback. I guess I got a way to get the details which I intend. The code i used is below
url = “https://management.work.com/9/08FA1065-0BC2-9F1F-9534E6/ebi/pdf/?productID=13403”
r = requests.get(url)
Using this code i got the desired url i:e (https://management.work.com/9/08FA1065-0BC2-4CF7-9F1F-95345B8D80E6/pdf/IPQ597)".
Now i just need to loop this code for each url. Could you please help me with code for looping all these URLs. I think of 2 ways,
1st way : All of my initial url are same except the product ID in the end. In above case its “13403”. So I kept this as Prefix. Then I created a suffix for all the 1k+ product ID. For example - suffix = (“13403” + “13404” + “13405”…so on. Then I ran the code, as you can guess its not working.
2nd way : To loop through all the url from excel one by one. I dont know how to write code for that.
could you please help.
PS: for business security, all my urls mentioned here are incomplete. I hope you understand.