cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
britagrace
Level: Powered On

Extract text from html via url

I am wanting to get weather data from this site:  {"source":"la-draft-clipboard","value":[{"tokenKey":"C7A5EEF3-4770-4EEA-A9AE-F4779E39CBDE","type":"literal","tokenExpression":"https://www.wunderground.com/history/airportfrompws/KMEM/2019/9/9/MonthlyHistory.html?req_city=&req_..."}]} Ideally the date portion (/KMEM/2019/9/9/Monthly) would default to today's date. 

 

But what I have really struggled with is pulling a portion of the html text from this url, so that I only retreive the desired table. 

The table I need is under header2 and is the last table on the page 

 

Any and all help is greatly appreciated, I have been at this for quite some time

6 REPLIES 6
britagrace
Level: Powered On

Re: Extract text from html via url

Anyone?

 

I am just wanting to get the last table found in the url link posted above added to the end of a pdf. Anyway that I pull that piece of code out into text, word doc, pdf, whatever? 

Community Support Team
Community Support Team

Re: Extract text from html via url

Hi @britagrace

 

I am afraid there is no direct action that could extract text from HTML.

Could you please share your Flow configuration? Could you share your output of the Http request?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

britagrace
Level: Powered On

Re: Extract text from html via url

I am unsure how to share my flow. 

 

I am using HTTP - post - then entering the URL 

here I can add headers, queries, and body - (I am thinking this is where I should pull the section of text) 

 

then it moves to initialize variable - here is another option I believe 

 

then moves to convert html to pdf, etc, etc 

Super User
Super User

Re: Extract text from html via url

@britagrace 

Hi there.  I did something similar a while back.  Are you looking to just get the aviation METAR's for that airport? Or was there some other specific thing you were looking for?  Reason I ask is there might be another way to approach it.

 

If you want to use HTTP, I think you'll want to try GET to grab information.  POST is usually for sending stuff.  You can pass parameters with GET.  We can mess with it once I have a better idea what you're after.

 

Thanks!

-Ed-

 

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

britagrace
Level: Powered On

Re: Extract text from html via url

Thank you so much Ed! I greatly appreciate your help. 

 

I am trying to acquire the weather oberservations for the entire month to date - really only need precipitation- from the Memphis International Airport rain gage data. Wanting to tack this table on the end of a SWPPP Pdf report 

 

Thanks again!!!

Super User
Super User

Re: Extract text from html via url

@britagrace 

Ok, awesome!  So, depending on your comfort level, there might be an 'easier' way.  In quotes because it may seem scary for a non-coder (not sure where you are on that spectrum), but will require much less clean-up after bringing the data in.  Anytime you are looking for bulk data, try looking for an API from a site you trust that may have the info you need.

Another thing to consider is if this is going to be a regular occurrence or a one-time thing.  If it's a one-shot deal, then an import vs. Flow might be a more prudent path.

 

A search for "Precipitation data API" found a bunch of sources, but I think I like the NOAA best because of the data availability.

 

Take a look at this article to get started on API's and custom connectors.  The example I used was for Yelp, but there is a standard for exchanging the information which makes it applicable to most other sites, as well.  The exciting part is once you've got the basics worked out, a bunch of information becomes available and you can 'level-up' your automation.

 

Keep at it, and let us know how it progresses.  

-Ed-

 

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 277 members 4,193 guests
Please welcome our newest community members: