Unanswered

Extract data from webpage produces syntax error

(0) Share

Report

Posted on by PAD_Charles

The exact error is: Parameter 'Extraction parameters': Syntax error.

I'm going to https://finance.yahoo.com/quote/IJT/holdings in MS Edge and extracting the top 10 holdings table to the default variable of %DataFromWebPage%. I can't seem to get it as a table, but extracting as entire HTML table works, but gives the syntax error immediately, not even at runtime. I can't figure out what else to do. There don't seem to be any choices from the PAD UI.

Any thoughts?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Highboy 1,187 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Do you need the table or just the data?

Another example

--- Paste into Pad ---

WebAutomation.LaunchEdge.LaunchEdge Url: $'''https://finance.yahoo.com/quote/IJT/holdings?guccounter=1''' WindowState: WebAutomation.BrowserWindowState.Maximized ClearCache: False ClearCookies: False Timeout: 60 BrowserInstance=> Browser
WebAutomation.ExtractData.ExtractTable BrowserInstance: Browser Control: $'''html > body > div:eq(0) > div > div > div:eq(0) > div > div:eq(2) > div:eq(0) > div > div:eq(0) > div > div > section > div:eq(3) > table > tbody > tr''' ExtractionParameters: {[$'''td:eq(0)''', $'''Own Text''', $'''''', $'''Name'''], [$'''td:eq(1) > a''', $'''Own Text''', $'''''', $'''Symbol'''], [$'''td:eq(2)''', $'''Own Text''', $'''''', $'''Assets'''] } ExtractedData=> DataFromWebPage
WebAutomation.ExtractData.ExtractTable BrowserInstance: Browser Control: $'''html > body > div:eq(0) > div > div > div:eq(0) > div > div:eq(2) > div:eq(0) > div > div:eq(0) > div > div > section > div:eq(3) > table > tbody > tr''' ExtractionParameters: {[$'''td:eq(0)''', $'''Own Text''', $'''''', $'''Name'''], [$'''td:eq(1) > a''', $'''Own Text''', $'''''', $'''Symbol'''], [$'''td:eq(1) > a''', $'''Href''', $'''''', $'''URL'''], [$'''td:eq(2)''', $'''Own Text''', $'''''', $'''Assets'''] } ExtractedData=> DataFromWebPage2

Was this reply helpful? Yes No
PAD_Charles 9 on at

Like (0)

Report
Copy link

Link copied!

I forget how to get to the area where you can paste in code. This is power automate desktop, not web.

Was this reply helpful? Yes No
Highboy 1,187 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

?? Did you not want the answer for PAD?
Otherwise you have posted in the wrong forum.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

You just copy the text and paste it right into a subflow. It will show up as actions.

Was this reply helpful? Yes No
PAD_Charles 9 on at

Like (0)

Report
Copy link

Link copied!

Cool. I didn't know you can paste code into the window. Thanks!

I did that and still get the same syntax error. Oh well, I'll keep looking into it.

Was this reply helpful? Yes No