In Microsoft technology platform, we can use SSIS package to consume the Web API. We need to use the script task to consume the Rest API. In the below example , we are trying to consume a Web API with Oauth authentication which provides the Weather Information for a place based on its longitute & latitute.
Below is the data flow diagram for consuming Web API using OAuth.
