Calling REST API Service From SQL Server Using C# SQL CLR

Fulfilling a requirement where we need to get a data from other sources (REST-based Web Service) and sync with on-premises (local) database. This should be done using a SQL Server Stored Procedure.