Skip to main content

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

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


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

 

 

 


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!


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 :)


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