Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Web scraping table in Alteryx

alangsw
5 - Atom

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/

 

Capture.PNG

2 REPLIES 2
markcurry
12 - Quasar

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
5 - Atom

Thanks a lot Mark. It works like a charm!

Labels