Sending parameters to REST API
Frans Nylin
Employee
I want to import weather data to an application. I have an api from the Swedish Weather center that allows me to retrieve min and max temperatures from several weather stations
https://opendata-download-metobs.smhi.se/api/version/latest/parameter/19/station/159880/period/latest-months/data.json
Parameter 19 is min temperature
Parameter 20 is max temperature
Station 159880 is max temperature.
Is there any way that I can send in these parameters from my SQL call in Board?
Either by having the set or parameters predefined, or having them in a SQL statement? For example SELECT * FROM Autorest.smhi_temp where parameter = 19 and station = 159880
UNION
For example SELECT * FROM Autorest.smhi_temp where parameter = 20 and station = 159880
UNION
....
7