Skip to main content
Question

Hi Community, I am trying to fetch data from website http://www.rushydro.ru/hydrology/informer/ , parse it and save data to excel in separate cells. How can this be done? i have attached my workbench, also can someone help with xquery?


nurbek
Contributor
Forum|alt.badge.img+3

ExcelCan you please implement XQuery, i think this will be the best way. I want to save like in attachment.

2 replies

danilo_fme
Evangelist
Forum|alt.badge.img+44
  • Evangelist
  • March 2, 2022

Hi @nurbek​ 

 

I changed transformer for XMLFlattener:

 

XMLFlattener 

In the FME Data Inspector you can see the attributes that I mean is important for you:

 

Attributes 

 

Thanks in Advance,

Danilo

 

 

 


nurbek
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • March 10, 2022
danilo_fme wrote:

Hi @nurbek​ 

 

I changed transformer for XMLFlattener:

 

XMLFlattener 

In the FME Data Inspector you can see the attributes that I mean is important for you:

 

Attributes 

 

Thanks in Advance,

Danilo

 

 

 

Hi Danilo,

 

Thanks a lot, it worked for me. But, the website where i get info has applied captcha. Now i receive errors, as a workaround i tried to save each web page as html file, how can i bulk read inside info of these web pages?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings