How do we download data to sql server from cloud system using REST API

Question

We have vendor cloud system which has maintaining for images and videos.

They have link which is REST API to download and retrieve the doc's.

we have .NET code to retrieve the docs from REST API (from cloud).

But, we don't want to stored directly to our Sql server from Cloud system.

Due to cyber security, my company doesn't allow me to store directly to our sql server from cloud system.

We received, credential and API key for cloud system. but, we don't want to use this method.

Is it possible to move directly to middle layer (like another domain server) and then to our server...?

Answer 1

@BeUnique Thank you for reaching out.

Since you have the .Net code already to download the documents using a REST API, you should move the code to an Azure Function App or Azure API Service.

Here are a couple of tutorials to help you get started.

https://learn.microsoft.com/en-in/azure/app-service/app-service-web-tutorial-rest-api
https://learn.microsoft.com/en-in/azure/azure-functions/create-first-function-vs-code-csharp?tabs=in-process&pivots=programming-runtime-functions-v4

For storing the documents, you could use Azure blob storage

Here is a tutorial
https://learn.microsoft.com/en-us/azure/storage/blobs/storage-quickstart-blobs-dotnet

Please let us know if you have any further questions.

----------

If an answer is helpful, please click on or upvote which might help other community members reading this thread.