Web scraping table in Alteryx

[alangsw]

Hello I am trying to get the exchange rate table in the middle of this page. I have tried using the Download tool as suggested from some other posts and pages but it seems not working in this case. ☹️ Could someone provide some insights on if it is possible to do it in Alteryx, and if yes, how can it be done? Thank you.

https://www.hsbc.com.hk/investments/products/foreign-exchange/currency-rate/

[markcurry · Accepted solution]

Hi @alangsw 

Looking at the website, it uses the following API to get the FX rates.

https://rbwm-api.hsbc.com.hk/digital-pws-tools-investments-eapi-prod-proxy/v1/investments/exchange-r...

That will give you the FX Rates in JSON format, see the attached workflow.  Hope that helps,

Mark

[alangsw]

Thanks a lot Mark. It works like a charm!