create C# app to download file from REST API, based on config in SQL Server DB

Need a program written in C# that will automatically download the suppression list files from Optizmo. Here is an example Optizmo link: [login to view URL] The program will need to connect to a SQL Server database and query a table called SuppressionConfig (see table definition below) for records where logintype='optizmo' where lastlogin is null or not within the past 24 hours. It should get the exact Optizmo URL from the csvurl field. Upon successful download, update the lastlogin field in the table for the particular SCID record. A config file should specify the path/folder location to save the downloaded file to. The program should use the value in the downloadurl field in the table for the filename to save within that folder. Should be able to connect to multiple databases to process records in suppressionconfig. The config file should allow us to specify 1..N SQL Server connection strings for the various databases. The program could either use Optizmo's REST API (see documentation on that page) or automate the web interface. It would probably be more reliable to use the REST API. CREATE TABLE [dbo].[suppressionconfig]( [scid] [int] IDENTITY(1,1) NOT NULL, [csvname] [nvarchar](255) NULL, [downloadurl] [nvarchar](255) NULL, [csvseparator] [nvarchar](255) NULL, [emailfieldname] [nvarchar](255) NULL, [md5hashed] [bit] NOT NULL, [retrieved_automatically] [bit] NOT NULL, [whenadded] [datetime] NOT NULL, [processstatus] [varchar](4) NOT NULL, [whenupdated] [datetime] NULL, [whenlastprocessed] [datetime] NULL, [logintype] [nvarchar](25) NULL, [csvurl] [nvarchar](255) NULL, [username] [nvarchar](128) NULL, [password] [nvarchar](128) NULL, [lastlogin] [datetime] NULL, [loginsuccess] [nvarchar](255) NULL, CONSTRAINT [PK_suppressionconfig] PRIMARY KEY CLUSTERED ( [scid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT ((0)) FOR [md5hashed] GO ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT ((1)) FOR [retrieved_automatically] GO ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT (getdate()) FOR [whenadded] GO ALTER TABLE [dbo].[suppressionconfig] ADD DEFAULT ('N/A') FOR [processstatus] GO