Find Jobs
Hire Freelancers

Create program to manipulate and post data to a web API from Excel

€30-250 EUR

Completed
Posted almost 6 years ago

€30-250 EUR

Paid on delivery
We use an outsourced parcel tracking system. Today, we extract data from our BI system daily and then using excel, manipulate that data into the proper format to upload via CSV file to our tracking system. We have now scheduled a daily report and want it to be automatically uploaded via and API to the tracking system. The program will read the excel file, perform some minor manipulations (concatenation, convert to numbers, and minor lookups (eg: convert a supplier number into a transport carrier), then post each row to an API. The program must work behind an authenticated proxy server and run on windows. It must be able to be run daily without user intervention. Be sure to fully read the Project Specifications PDF file before you bid on this project. Feel free to ask questions. I am very responsive.
Project ID: 17041383

About the project

21 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
Malmö FF. Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
€150 EUR in 3 days
4.9 (32 reviews)
4.4
4.4
21 freelancers are bidding on average €240 EUR for this job
User Avatar
Hello, I can help with you in your project Create program to manipulate and post data to a web API from Excel. I have more than 5 years of experience in Excel, Software Architecture, VB.NET, Visual Basic. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
€250 EUR in 3 days
4.9 (302 reviews)
7.7
7.7
User Avatar
hi. glad to meet you, my client. I read your job posting and am so excited. because I have a good skill building windows application such as yours. I think your project is quite simple and I can finish it in 3 days. Please give me a chance to work for you. I will do my best. Thanks.
€155 EUR in 3 days
5.0 (74 reviews)
6.9
6.9
User Avatar
Malmö FF I have read through the Project Spec, API doc and sample Excel data files. I recommend to implement a solution by developing stand-alone Windows/WPF application that will do all: 1. Open and parse the Excel data 2. Parse the Excel data 3. Call Parcel Perform API to add parcels. It will deployed on the server and it will be run by the Task Scheduler. I will be using C# and Visual Studio 2017. Third-party library will be use for parsing the Excel. I used before NPOI but still need to look if there are better ones. .NET have built-in WebProxy class which handle HTTP connection through your proxy server. I have place my bid amount and time line. I got some questions: 1. How is the Excel file will be manage? Is on daily basis, new Excel file is created, and is after reading the Excel file, it will be deleted or move to other location for archiving? 2. The API doc did not mention if there is Sandbox server to be use for my developer testing? Looking forward to hear from you, Daniel F
€250 EUR in 5 days
4.9 (218 reviews)
6.0
6.0
User Avatar
Hello Sir, I have gone through your requirements regarding Create program to manipulate and post data to a web API from Excel. we brief and understand your idea and preference for job as you are looking for. I have more than 7+ years of experience in .NET, c#.net, vb.net, asp.net, MVC, sql, mysql, Oracle, Azure, Entity Framework, Linq, Umbraco, JQuery, Angularjs, CSS, HTML, Kendo UI, RDLC Report, Crystal Report, BioMetric Integration, Microsoft Outlook. I have developed more than 20 projects. Please send me message for further conversation. Thanks,
€246 EUR in 10 days
4.9 (31 reviews)
5.8
5.8
User Avatar
Malmö FF, Hi! I'm python script developer that can do tasks with automation. Speed & 100% accuracy guaranteed! Question : - Do you want to run it manually (By double-clicking) or schedule it on Windows server? Note: - In python, as far as i know, it only allow CSV file only. Not XLSX. CSV limit only 1 sheet, so we will need to seperate the sheets (input,process,result). If this okay with you, let me know. Thank you and i'm looking forward to working with you! -Vincent
€200 EUR in 5 days
5.0 (50 reviews)
5.5
5.5
User Avatar
Hi, My programming langage : JAVA (Talend Open Studio) My Experience handling API : https://www.freelancer.com/projects/php/Talend-Open-Studio-Job-template/ We use Talend in the company for which I work to load more than 400 millions records per day in our oracle Data Warehouse. If you pay extra 100 Euro, I will add : - log file (or mysql table ) that provide a summary of each execution (number of records in file, number of records loaded, ...) - Email notification after each execution or in case of an issue. Please, check my profile to have more information on my esperience in data engineering. Sincerely Maurice
€333 EUR in 10 days
5.0 (6 reviews)
5.4
5.4
User Avatar
Malmö FF I 've already read your document carefully and I'm sure to done your work using c# and openxml to read excel file from server, then do following work as you want then upload it.
€155 EUR in 5 days
4.9 (45 reviews)
5.2
5.2
User Avatar
Hello, Malmö FF I read both Parcel Perform API document and the project specification document quickly. I can develop an application using C# to implement this parcel tracking project as described. It will probably take 2 weeks to get familiar with the API, implement the project as required and then test. At this point, and as a rough estimate, it will cost 1000 euros. Thanks
€1,000 EUR in 14 days
5.0 (5 reviews)
4.9
4.9
User Avatar
Dear sir, I am very interested for this Web API work. I have 6+ Year of Experience in this field and I can surely do this project , i work with my team who always looking for such type of project . so please sir try to give me one chance to prove my strength and quality of work. Actually sir money is not a matter i only want to do this project if you feel good with my work then only after you can award me and pay for this project , me and my experienced team believe in accuracy and quality of work. Trust me sir i never disappoint you at least you can give me one chance. Please check my profile in freelancer.com https://www.freelancer.com/u/mdubey.html Please message me on PM for further discussion. Thanks & Regards Mohit
€300 EUR in 7 days
5.0 (24 reviews)
4.7
4.7
User Avatar
Malmo FF java spring
€200 EUR in 25 days
4.9 (30 reviews)
4.8
4.8
User Avatar
Hello Sir! I think I'm a great fit for this project because I have an interest in your project and can deliver on time, according to your specifications…
€100 EUR in 4 days
5.0 (1 review)
1.1
1.1
User Avatar
Malmö FF Hi there, I have more than 3 years of experienced in ASP.NET, ASP.NET MVC using both c# and VB, MS SQL. I have also worked on project where you have to use some API to fetch and send product details. I have recently finished a project where we need to fetch parcel details using Parcel Hub API and work around those parcel from invoicing to report. Hope to hear you back. Thanks.
€250 EUR in 30 days
5.0 (1 review)
0.8
0.8

About the client

Flag of SWEDEN
Lund, Sweden
5.0
4
Payment method verified
Member since Jul 31, 2016

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.