Find Jobs
Hire Freelancers

Connect JSON API with Excel 2

$15-25 USD / hour

Completed
Posted almost 8 years ago

$15-25 USD / hour

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.
Project ID: 10820193

About the project

14 proposals
Remote project
Active 8 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
Hello, I'm a developer with over 5 years of experience. I work for Pratt and Whitney Canada where i'm responsible for process automation with tools like Access and Excel. I have extensive knowledge regarding C#, VBA, ABAP and T-SQL language i'm also proficient with databases like SQL server, Access and My Sql. If you find this offer interesting please contact me or if you want i could prepare a short presentation for you of what can i offer you regarding this project You could see example of my work here : [login to view URL]!1784&authkey=!AH-3RBrr5zOpUTQ&ithint=folder%2cmp4 (Those are presentations for my other clients but should give you perspective what can i do.) Hope to hear from you. Best Regards Lukasz Ozóg
$15 USD in 10 days
5.0 (30 reviews)
6.8
6.8
14 freelancers are bidding on average $21 USD/hour for this job
User Avatar
Hi there! I am an expert American programmer specializing in webscraping and web/data automation with experience developing custom applications and collecting data from hundreds of websites for clients here on Freelancer. I would create a simple windows based vb.net app which automates the data download to Excel using the API and credentials you provide. The app will also be able to upload data as well. The benefit of having me make an app versus a simple Excel macro is an app will be much more capable of handling this task while also being simple and lightweight. Please send me a message so we can speak further about the project details! Thanks, Mike
$15 USD in 40 days
5.0 (46 reviews)
6.4
6.4
User Avatar
Dear Sir, I have read your project description & understood the initial high level requirements but can you spare few minutes for a quick chat? Please initiate the one to one chat to discuss more in depth, so I can give you my high level understanding to make sure that we are both on the same page, I can then also revise our bid. Look forward to hearing from you. Regards, YK LEADconcept
$27 USD in 40 days
5.0 (2 reviews)
5.1
5.1
User Avatar
My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & experience that are required to complete this project. I can show you some examples of my work. Please contact me to discuss your project.
$22 USD in 10 days
5.0 (1 review)
3.6
3.6
User Avatar
Hello Sir /Ms, I have experience in this type of project. it is invoking the api, obtain data and dump to Excel and vice versa? Please talk to the chat Experience to apply: VB.NET / C # ASP.net / Win form MySql / Sql server Bootstrap About me I am a web developer focused on Microsoft technologies, I worked about 4 years developing web applications built using Asp.net and SQL Server 2005, 2008 and 2012.
$22 USD in 10 days
5.0 (6 reviews)
3.1
3.1
User Avatar
I have idea I can do this with php and mysqli .my step will be read data from api and create option for you click to import into excel sheet/csv click to export data in excel and csv simple and we can perform more operations on data.
$27 USD in 40 days
5.0 (1 review)
2.6
2.6
User Avatar
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
$25 USD in 10 days
5.0 (3 reviews)
2.4
2.4
User Avatar
Hello More 20 years programming experience. I would like suggest to estimate whole work, not per hourly rate and I need more details to set real price and time. Regards. ---------------------------------------------------------------------------------------------------------------------------------------------------
$22 USD in 10 days
5.0 (1 review)
2.0
2.0
User Avatar
i Have done a lot of such projects in university life . Now want to start my career on freelance . I am very hardworking and passionate to my work .
$20 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have done many of these projects connecting to WorkFront using REST API including authentication. So you may expect eh work to be done faster
$15 USD in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Nashville, United States
0.0
0
Payment method verified
Member since Mar 15, 2014

Client Verification

Other jobs from this client

Connect JSON API with Excel
$250-750 USD
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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.