Syntax error when extracting data from web page

[aqyx]

Hi all,

I'm currently trying to extract an HTML table for a web page, but the "Extract data from web page" is giving me a syntax error without any further information. Using the live web helper, I can select the correct table, then set the Extract field in advanced settings to Entire HTML table and see the previewed extraction fine, but when saving the activity I get the syntax error.

I've taken the selector straight from the Edge F12 console, so I'm not sure what the issue is. Selector is copied below:

div#approvedEngagements > app-funded-engagements > div.card.p-1 > div.card-body.set-padding.pt-1 > div.card.ml-1 > div > div.row.mb-5 > div.col-12.pl-0 > div > table

I have also tried with the below and it's the same situation.

html > body > app-root > body > article > main > app-dashboard > div > div > div > div > div#approvedEngagements > app-funded-engagements > div > div > div > div > div > div > div > table

Thanks in advance

[chienhsianghung]

Hi @aqyx, 

I was facing the same problem then I found the following page and problem solved. Should you find it useful please mark it as solution.

Automation in the web - Power Automate | Microsoft Docs

Good luck, 

Hsiang

[poppat]

Dude the answer is not useful. what is the workaround. Is it not possible to extract it that way? why did the syntax error come

[patersos]

Hi Aqyx,

Did you ever figure out what was going wrong with the Syntax Error problem you were encountering?

I have an almost identical situation, where I am able to connect to the website to access the table data but am getting a Syntax Error. 

I'm trying to put the table into an Excel Spreadsheet. The system knows that this is a 10-column table.

The Live Web Helper appears to have captured the expected information.

But I'm getting a syntax error - without any details of what is wrong.

The CSS info is: html > body > div:eq(3) > div:eq(3) > div:eq(1) > div > div > div:eq(0) > div:eq(2) > div:eq(1) > div > div:eq(1) > div > div > div:eq(1) > table

If you've had any luck resolving the issue, please let me know. If not I'll try and escalate.

Cheers... Shaun

[jonathancavey]

Has anyone been able to solve this? 

I have a process where I am on a webpage, I then select a element which opens a new tab with the HTML table I want to pull. 
When I choose what I want to pull, it pulls all of the information. 

But when I go to run the process I get the error. "Parameter 'Extraction parameters': Syntax error." With no other information on it.

I have used this action many times without this error. 

[patersos]

I just thought I'd update readers on what I've found relating to my problem with a Syntax Error when trying to extract an HTML table. Incidentally I've modified the CSS selector - details below (it's relevant to the script mentioned further down)

So apparently the system creates scripts out of the instructions we've entered into PAD. I went to the folder below:

C:\Users\shaun\AppData\Local\Microsoft\Power Automate Desktop\Designer\Temp\lhsiwtcs.0si

Inside the folder is a file - script.robin. When you look at the script you'll see the instructions from your flow spelt out.

I've highlighted that this details the Extraction Parameters and I can see that one of my column headers includes a "%" symbol. From across the forum I've concluded that this symbol screws things up as PAD thinks it's denoting a variable. It has been treated totally differently to the other column headers. If there is a % symbol, you need to double up and make it %%.

I'm fairly certain that this is causing my problem. But I've no clue how to correct the ExtractionParameters to make things work going forward.

You just might find it useful for digging into your problems - you may be able to correct the problem if you at least know what it might be and where to look.

Cheers... Shaun

[patersos]

Hello again,

I just wanted to let you know that I've resolved my problem.

The long story short is that the error was due to a column header in the extract including a % symbol. In my case it was %Change.

I discovered that it's possible to Cut the offending column header and Paste a different header, without the % symbol. You cannot leave the column header blank - you do need to give it a value - just don't include %.

My extract is now working perfectly, without error.

Good luck resolving your errors... Shaun

[Anonymous]

Thanks. It worked and saved my lot of time.

[patersos]

That's great news. Good luck moving forward. 

Cheers...Shaun