Sending parameters to REST API

Options
Frans Nylin
Frans Nylin Employee
Level 100: Foundations of Building in Board Level 200: Leveraging Board for Business Insights Photogenic First Comment
edited September 2022 in Idea Exchange

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
7 votes

Open For Voting · Last Updated