I need to upload and download data from a software company's database which supports JSON using their current API. The API uses Curl or HTTP authentication. I will provided the need credentials to access their database. Also, pseudo code is available for authentication. It is very important that all the upload and download of JSON data in and out of Microsoft Excel occurs through macros coded in VBA within Excel.
So here is the breakdown of the task:
1. Form HTTP authentication between Excel and their API using the provided credentials
2. Write a macro to download JSON data into excel
3. Write a macro to upload Excel data into JSON.
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel, macros, VBA, databases and interaction with them through API, and JSON format. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to do your project. Please let me know the details.
Please have a look at some Excel projects I've done:
https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/
https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
Hello,
I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile.
I am ready to discuss and doing the project.
Regards,
Eyad
Hello,
I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional.
I have done project of modifying calendars using VBA which involved Google APIs and Data in JSON form. and Google Spreadsheet integration with Excel.
The project is Product based development and integration of the product with various already existing Products and processes..
Below are some key areas of my skills:
-- VBA and Excel,Word,Office Applications
-- Expert on C# using .NET framework using Visual Studio 2012 and 2013
-- Expert in ASP.NET,MVC
-- Expert in VB.NET using VS2012/VS2013
-- WPF and Windows Forms Application
I have experience in all the above areas and during my project work I have completed all of the above tasks.
As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best.
Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution.
Would be looking forward to work on this opportunity and will ensure to deliver best.
Regards,
Abhinov
Hello,
I have dealt with both JSON and HTTP authentication via VBA. Wrote my very first VBA application back in 1997 (it was Word VBA + Access + VB6 application for company registrations). In order to save some of your spare time I shall not speak about my past project. Instead, I would like to invite you to check out my profile here at freelancer.com.
In case you have complex JSON arrays (multidimensional) I would write recursive function to parse JSON arrays and the rest should be easy.
Some testing data would be nice to see as well...
Looking forward to hearing from you.
Hello mohsin002,
Greetings of the day.
- i have 5 years of working experience in developing web applications.
- have good knowledge in VBA & JSON Parsing in VBA
- have developed VBA scripts for connecting applications through HTTP authentications.
text me for further discussions.
Thanks,
karthik
Hi, I have not a very wide knowledge in word's macro programming, but I have already worked a lot with JSON and APIs... It'll not be a problem for me to do that job.
Hi,
I have more than 3 yrs of experience in developing vba application.
I have been in software industry for more than 4 years and have good knowledge of JavaSe, JavaEe, MySQL, SQL, Android, PHP, VBA.
Being new on freelancer I am bidding as low as possible but that does not mean that you have to compromise with work quality.
I will offer best quality product with 100% client satisfaction.
Please assign this to me and I will complete the work earlier than everyone and with less amount.
Thanks
I can help. I'm free NY time every evening this week (starting now) and probably tomorrow morning as well. I can talk on the phone at any time if needed.
Regards,
Joe
Let's discuss more about project to finalize the proper scope with estimated cost and time so ping me over the freelancer chat.
I am myself developer so you will directly work with me. No mediators. No managers. No subcontractors.
Please check my my recent work for the technical expertise along with reviews & feedback on my profile page.
Hi,
I have 5+ years experience with software programming and have created Excel macros before.
I have the project in mind and have a couple of questions and observations.
Drop me a message and let's talk about it!
George