Find Jobs
Hire Freelancers

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

$750-1500 USD

Completed
Posted almost 6 years ago

$750-1500 USD

Paid on delivery
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
Project ID: 16961237

About the project

15 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, Greeting !! I have 12+ Years of experience in software Development and Project management. I have reviewed the details and API from where we need to fetch the data and insert into azure hosted database server . I will help in building the console application which will run in windows server and get data from API and save into the Azure DB A few I would like to highlight that would enable me to contribute to your bottom line are: • Extensive experience of working on C#.NET, Asp.Net Mvc5, API, ASP.NET Web forms, AJAX. • Expertise in SQL Server experience with SSIS, SSRS, database design, database optimization. • Expertise in Java script,HTML,CSS,REACT,Bootstrap etc and familiar with Web API, Entity Framework, angular. I look forward to speaking with you about this opportunity. Sincerely, Rajan Kumar
$1,400 USD in 7 days
4.8 (65 reviews)
6.5
6.5
15 freelancers are bidding on average $932 USD for this job
User Avatar
Hello sir I read your proposal and i am very interested in your project I have rich experience in C# programming and i am expert in windows desktop I am sure i can satisfy you on time I look forward to work in partnership on your project IBest regards
$1,000 USD in 20 days
5.0 (33 reviews)
6.4
6.4
User Avatar
The API documentation looks fine to me, I can build the functionality to go to 50,000 and then start from 50,001 and so on
$750 USD in 20 days
4.9 (50 reviews)
6.4
6.4
User Avatar
Hello, I have done many projects of the same type, and can do this and deliver within less than 2 days. I am an expert in C#/API-calling and will do it optimized. Regards
$1,000 USD in 2 days
5.0 (45 reviews)
5.5
5.5
User Avatar
Hi there, how are you today? Your project caught my attention and I'd like to work with you on it. From you detailed description, I can deduce that you need a C# Console app that can be called with some parameters and will automatically consume some api and insert the results into an Azure Db. I fully understand your requirement and I can provide you with the console app.
$750 USD in 10 days
4.9 (22 reviews)
4.9
4.9
User Avatar
Hi Myself expert in Dot net technologies with 12+yrs of experience in software development. Developed various web and desktop based projects in Finance, Insurance, Research, Education , Research and Retail Domains. Worked in technologies : Asp.net Mvc5.0/4.0/3.0 and Asp.net webforms 4.5/4/3.5/2.0 with c# as programming language, C#.net, wcf, webservices & web apis, Sql server, jquery, javascript, ajax, xml, json, linq, entity framework, ssrs & crystal reports, telerik & devexpress controls. Let me know your requirement in details. Payment terms: 1. 20% milestone release on awarding project. 2. 20% milestone release on phase1 Uat 3. 20% milestone release on phase2 Uat 4. 20% milestone release on Uat signoff. 5. 20% milestone release on project closure and source code handover. Awaiting for positive response. Thanks and Regards...
$750 USD in 15 days
4.6 (33 reviews)
5.4
5.4
User Avatar
A proposal has not yet been provided
$750 USD in 7 days
5.0 (21 reviews)
4.7
4.7
User Avatar
I am an expert in Azure Db and Rest API. I can provide you this work. Looking forward to be working with you.
$800 USD in 10 days
5.0 (14 reviews)
3.9
3.9
User Avatar
Hello I am an experienced .net developer , i have more then 5 years of experience , I have worked both in web and desktop application as well as in console . For details inbox me .
$833 USD in 12 days
4.9 (9 reviews)
3.4
3.4
User Avatar
A proposal has not yet been provided
$1,111 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$1,250 USD in 20 days
0.0 (1 review)
0.0
0.0

About the client

Flag of UNITED STATES
New York, United States
5.0
13
Payment method verified
Member since Jun 24, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.