question

GaniTPT avatar image
0 Votes"
GaniTPT asked KalyanChanumolu-MSFT commented

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

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
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Anyone can give idea about this...

0 Votes 0 ·

@GaniTPT Adding "Azure-sql-database" to see if others can help you.

0 Votes 0 ·

1 Answer

KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered KalyanChanumolu-MSFT commented

@GaniTPT 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://docs.microsoft.com/en-in/azure/app-service/app-service-web-tutorial-rest-api
https://docs.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://docs.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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

where to handle the .NET portion. To download the data, we are using .NET code and kept it on server.

Source point : Cloud system
Destination Point : our domain server.

Here, we want to avoid to store directly in our domain server. Instead we want to store some where in the middle, and then pull it to our server.

How to handle the middle ware. like executing the dot net code in the middleware..?

0 Votes 0 ·

The middleware you are referring to would be Azure Function App and the storage location would be Azure blob storage.
I have provided samples for both.


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.

0 Votes 0 ·