Hello team,
Is it possible to get table information from a web page?
Regards
Vaibhav
1 Like
EasyMorph doesn’t import from HTML files natively yet. You can try parsing an HTML file as just a text file using the regular text functions and actions, but that can be tedious.
If you post a link to the page you’d like to parse I’ll try to make an example.
Hi @dgudkov,
Thanks for the prompt response as usual!
Its an internal organisation sharepoint page so wont be able to you. Apologies for any inconvenience caused.
Hi @vaibhavtandon87,
Another possible approach is to use the “PowerShell” action with the Invoke-WebRequest cmdlet.
Here is a simplified example project which parses HTML from the Pricing page on our website.
It’s based on the following article:
https://www.leeholmes.com/blog/2015/01/05/extracting-tables-from-powershells-invoke-webrequest/
The example captures cell values, outputted by the PowerShell script and then uses the “Split delimited text into columns” action to restore table structure.
Production example will definitely require more complex PowerShell script with values escaping, etc.
Parse HTML table.morph (2.5 KB)
2 Likes
I will try this @andrew.rybka.
thanks again to you and community in providing ideas and solutions to a problem, really appreciate that!
Hi @andrew.rybka ,
Do you have any good news on getting web table natively?
Today I come across this requirement:
Get the 2 digits country codes of EU countries from this web page:
It would be great if EasyMorph could get the table with simple actions.
Or else I have to get the table by Excel, save the Excel, import the Excel.
Thanks.
Hi @Cambridge,
There is nothing new on this topic from our side. But you can try to copy-paste the table directly to EasyMorph and then save it as a DSET file.
maybe try with the chatgpt action or you can go on the opendatasoft hub and use their api to connect with EM and extract what you want