C# Application To Download Data from Web API And Insert into Azure DB

We would like a C# "Console Application" of Framework 4.5 or higher to be built. The solution should be called "PJM_DataManagement". ****Freelancer must have a STATIC IP since Connection to Azure DB will be needed The application will accept 3 input parameters as follows Usage: PJM_DataManagement <startdate> <enddate> <RT/DA> Parameter 1 and 2 are dates and the 3rd parameter is a string, either RT or DA The User Guide to the API is available at [login to view URL]~/media/etools/data-miner-2/[login to view URL] We have gone through the API and we only need to use two GET calls. The two calls will return data in CSV format and this data needs to be then LOADED into the Azure DB. ***IMPORTANT: The response will only return a maximum of 50,000 rows of data, but the header will notify you of the total number of rows (I think header will have a field called "totalRows"). If the total rows are > 50,000, we need to loop the request and the subsequent GET requests will need to be made with the attribute "startRow" set to 50,001, 100,001, 150,001 and so on.. till we get all the rows mentioned in header "totalRows" 1st call to be made is: [login to view URL],pnode_subtype,pnode_type,pnode_name,voltage_level,zone&termination_date=03-14-2018 to 12/31/9999exact&format=csv&subscription-key=0d257cb5804e4d53930043ef16c9f75c This call is not dependent on a date range and most likely will not have 50,000 records but it is good to build in the functionality. This data should be loaded into the table dbo.Staging_PJM_Pricing_Node 2nd call to be made is: [login to view URL] 00:00 to 1-09-2018 23:59&format=csv&subscription-key=0d257cb5804e4d53930043ef16c9f75c The sample GET URL shown above has used a single date 1/9/2018. However, we need to build the application to be able to load multiple dates from the input parameters <startdate> till <enddate> Since the API will only allow 1 millions rows at a time, we need to probably only request 1 day or max 2 days at a time.. Again, we will need to loop through the 50,000 row max till we get to "TotalRows". So here we will have 2 loops, 1 loop that loops over all the dates from <startdate> till <enddate> and second loop that loops over startRow which will be set to 1, 50001, 100001, 150001, etc This data should be loaded into the table dbo.Staging_PJM_DA_LMP DB details will be provided to freelancer who is chosen for this project