Skip to main content
Solved

Get Data from HTML in BPA Workflow


Furkan Zengin
Ultimate Hero (Partner)
Forum|alt.badge.img+21

Hello experts,

I need to get data from the below website. But the result is not JSON or XML. It it still possible to get data and create a record in IFS?

 

https://www.westmetall.com/en/markdaten.php?action=table&field=LME_Al_cash

 

Can anyone guide me please?

Thanks

Furkan

Best answer by kamnlk

Hi,

As another alternative at least in this case there seems to be an API call to get the data 

Its noticeable when we tried to go to the Datachart page 

westmetall . market data . prices/lme stocks . copper, tin, lead, zinc, aluminium, nickel, gold, fine silver

 

eg: The following api returns a XML output 

https://www.westmetall.com/api/marketdata/en/LME_Al_cash

 

 

 

View original

dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • April 28, 2025

Hi ​@Furkan Zengin 

 

Camunda http-connector could be useful when the response is non xml/json type.

I have once setup that for text based responses and below community post by ​@Sébastien DELAURE was extremely helpful.

BPA – Use of the Service Task http-connector | IFS Community

 

Hope it might work for reading a HTML but looks like your html returns large amount of data and that could be a problem inside a workflow.

 

Such a requirement can be easily achieved by a creating a azure function/logic app which would act as a proxy which would call the web page upon a request, process data and respond as a xml/json.

Inside the workflow, you can call the azure function/logic app which would return an acceptable response by the rest API call.

 

Hope it helps!

Damith


Forum|alt.badge.img+9
  • Hero (Employee)
  • April 28, 2025

Hi,

As another alternative at least in this case there seems to be an API call to get the data 

Its noticeable when we tried to go to the Datachart page 

westmetall . market data . prices/lme stocks . copper, tin, lead, zinc, aluminium, nickel, gold, fine silver

 

eg: The following api returns a XML output 

https://www.westmetall.com/api/marketdata/en/LME_Al_cash

 

 

 


Furkan Zengin
Ultimate Hero (Partner)
Forum|alt.badge.img+21

Hello Damith ​@dsj 

Is the azure function app something you mentioned on your blog? I should revisit the blog to see your posts.

Thanks for the idea!


dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • April 29, 2025
Furkan Zengin wrote:

Hello Damith ​@dsj 

Is the azure function app something you mentioned on your blog? I should revisit the blog to see your posts.

Thanks for the idea!

 

Hi ​@Furkan Zengin,

 

I don’t have any specifc examples in my blog ‘yet’

Check the suggestion from ​@kamnlk also. If you can find an endpoint which returns an xml, lot of time and extra work could be saved :)


Furkan Zengin
Ultimate Hero (Partner)
Forum|alt.badge.img+21

Hello  ​@kamnlk 

Thank you for noticing that API. I could manage to extract data from the API.

@dsj Thanks you for your contribution. I’d love to see samples of how to use service task on your blog :)

Furkan


Reply


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