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

Gani_tpt 1,586 Reputation points
2021-10-28T10:27:02.14+00:00

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...?

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KalyanChanumolu-MSFT 8,316 Reputation points
    2021-10-29T10:09:23.957+00:00

    @Gani_tpt 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 130616-image.png or upvote 130671-image.png which might help other community members reading this thread.