How to merge CSV link and CSV file with Refresh Interval

HingFungChan

https://opendata.esrichina.hk/maps/e1a8354a73e2442a94cf0de7722ac095/explore?location=22.415654%2C114.196390%2C11.56
The above link is the result I want to get. Real-Time Temperature in map.

Now I got a csv link with "StationName" and "StationTemperature"
https://data.weather.gov.hk/weatherAPI/hko_data/regional-weather/latest_1min_temperature.csv

And a csv file with "StationName", "StationLatitude" and "StationLongitude"
https://portal.csdi.gov.hk/server/rest/services/common/hko_rcd_1634874829534_64181/FeatureServer

I want to merge the two layer.
But it will either not refreshing the data and displayed in the wrong area.
Or showing "One or more layers from the map are not listed here because they are either not shared with you or not publicly accessible." and not listing my CSV link