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?

  • March 2, 2022
  • 2 replies
  • 14 views

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
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • 2077 replies
  • 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
  • 11 replies
  • March 10, 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

 

 

 

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?