Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

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