Import table from web page

[bruss]

Hi all, I try to import the last table of this page https://understat.com/player/8981, the last one with red background:

but my workflow doesn’t works. I try with Webpage Retriever Nodes and XPath but there is something that doesn’t works. I need a help, thank you

this is my workflow
CSA.knwf (6.7 KB)

[ArjenEX]

Hi @bruss

Querying from Understat has come up before. This post contains a workflow that was confirmed by a user to be working

extracting JSON data from website--how to use string to JSON node?

Allright @Glenn_Kuly! Below workflow should get you moving forward. [image] I must admin that the mentioned website is quite strange in structure and how this data is processed. The workflow might only work for this specific tabel. After the webpage retriever, I opt for a Xpath node to extract the script section which contains the data via the query /html/body/div/div[3]/div[4]/div/script. It’s usually a bit more solid than Regex extraction. It will output that JSON.parse string as well [i…

If not, let us know and I’m sure someone will be able to help you out further.

[bruss]

Yes, I know this post but my table is in a different page with different structure and json. Can you help me please?

[Daniel_Weikert]

Hi,
you already checked for API? Just to make sure.
br

[ArjenEX]

It required very little change. It’s only one div[] further, some additional cleansing rules and adding all the collection queries again

See WF:

extract JSON data from football website - player page.knwf (123.9 KB)

[bruss]

thank you so much, now I also understand the logic of column expression.

[ArjenEX]

No problem, happy to hear!