Unanswered

Extract URL from source code

(0) Share

Report

Posted on by Yonah_

Hello,
in my flow, I would like to extract the URLs from a webcode.

My thought was to use python for this.
If I use python like this, it's not a problem.
Jeodch I get the following error in the power automate destop.
Parameter "Python script to run": syntax error.

My code is:

import re

text = '''
Material:Stoff",null,"https://www.amazon.de/CLP-B%C3%BCrostuhl-Amadora-H%C3%B6henverstellbarer-Schreibtischstuhl/dp/B09BYKRHCQ",[52159,null,0,"52159.0",0,[52159]],"amazon.de",null,null,null,"https://www.amazon.de/CLP-B%C3%BCrostuhl-Amadora-H%C3%B6henverstellbarer-Schreibtischstuhl/dp/B09BYKRHCQ",2,null,"amazon.de",["https://encrypted-tbn1.gstatic.com/favicon-tbn?q\u003dtbn:ANd9GcSL_uMPFp73A3GdEq8WXVyN2LebRL8zMmALc7cQGONrtiAWNQAd-
'''

urls = re.findall('http[s]?://(?:[a-zA-Z]|[0-9]|[$-_@.&+]|[!*\\(\\),]|(?:%[0-9a-fA-F][0-9a-fA-F]))+', text)

for url in urls:
 print(url)

My guess is that it has to do with

urls = re.findall('http[s]?://(?:[a-zA-Z]|[0-9]|[$-_@.&+]|[!*\\(\\),]|(?:%[0-9a-fA-F][0-9a-fA-F]))+', text)

So, I hoppe that some one can help me.
A Soloution with out using Python, would also be much appreciated.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Use the Parse text action with "Is regular expression" toggle enabled and use the following regex pattern: http[^"]+

Also make sure to set it to retrieve all results and not just the first one. This will return the URLs in a list variable.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

Was this reply helpful? Yes No
Yonah_ 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks
And it works too.
But since in the code also something like %3% or %c% occurs.
I get an error message that a variable is not defined.
But surely this can be switched off?
Sorry, that I probably ask such a simple question.
But I'm using Power Automate for the first time and have previously only worked with Power BI.
So I have a lot to learn.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

The percentage symbol is used for variable notation in PAD. It needs to be escaped by either using \% or %%.
However, I assume the value should be some kind of a dynamic input, right? If so, PAD shouldn't really care about percentage symbols. It only matters when you use a hard-coded value. But if you did that, you could simply hardcode the URLs right away, without the need to parse them?
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

Was this reply helpful? Yes No