REST Endpoints.sql

/*
create master key encryption by password = N'Tell me about the waters of your homeworld, Usul.';
go
create database scoped credential [https://<name>.azurewebsites.net]
with identity = N'Managed Identity'
   , secret = N'{ "resourceId": "<application-registration-id>" }';
go
create database scoped credential [https://<name>.blob.core.windows.net]
with identity = N'Managed Identity'
   , secret = N'{ "resourceId": "https://storage.azure.com" }';
go
create database scoped credential [https://<name>.eventgrid.azure.net]
with identity = N'Managed Identity'
   , secret = N'{ "resourceId": "https://eventgrid.azure.net" }';
go
create database scoped credential [https://<name>.servicebus.windows.net]
with identity = N'Managed Identity'
   , secret = N'{ "resourceId": "https://eventhubs.azure.net" }';
go
create database scoped credential [https://graph.microsoft.com]
with identity = N'Managed Identity'
   , secret = N'{ "resourceId": "https://graph.microsoft.com" }';
go

az ad app permission grant `
    --id '<managed-identity-object-id>' `
    --resource-id 'https://graph.microsoft.com' `
    --scope 'Directory.Read.All';
*/

declare @response nvarchar(max);

execute [dbo].[usp_PutAzureStorageBlob]
    @credential = [https://byteterrace.blob.core.windows.net]
  , @payload = N'{}'
  , @response = @response output
  , @url = N'https://byteterrace.blob.core.windows.net/temp/test.json';

select @response;
go
----------------------------------------------------------------
declare @response nvarchar(max);

execute [dbo].[usp_GetAzureStorageBlob]
    @credential = [https://byteterrace.blob.core.windows.net]
  , @response = @response output
  , @url = N'https://byteterrace.blob.core.windows.net/temp/test.json';

select Json_Query(@response, N'$.result')
go
----------------------------------------------------------------
declare @response nvarchar(max);

execute [dbo].[usp_DeleteAzureStorageBlob]
    @credential = [https://byteterrace.blob.core.windows.net]
  , @response = @response output
  , @url = N'https://byteterrace.blob.core.windows.net/temp/test.json';

select @response
go