Closed

Create Excel VBA function to interact with JSON Web service API - 21/03/2018 18:25 EDT

We want to validate the times in transit capabilities of our shipping carriers. We do not want to do this per shipment, but rather as a periodic check on master data (hence we will store some default values for the shipment information)

You are to write an excel VBA macro/function that calls the [url removed, login to view] API (uses JSON and returns the transit time for different service offerings for UPS and DHL. See [url removed, login to view]

Please review the specification and ask any questions.

Please do not bid $50. The project is worth more than that.

Please do not bid $500+. This project is not that difficult. This is VBA, JSON and a very well documented API.

We are using Excel 2016.

Please see the attached specification for additional details and MUST FOLLOW instructions for your bid to be considered.

Skills: Excel, VB.NET, Visual Basic, Visual Basic for Apps, Web Services

See more: json web service api, json web service iphone app, net json web service, wcf json web service, restful json web service wcf, excel vba function stock price, excel vba function return blank null, create excel rate function java, android json web service, excel vba function return blank cell, vbs create excel vba, using json web service iphone app, create excel rate function, forms create excel vba, create excel vba project

About the Employer:
( 20 reviews ) faridabad, India

Project ID: #16536924

18 freelancers are bidding on average $198 for this job

lukaszoz

Hello, I'm a developer with over 5 years of experience and work as a regular .Net developer on daily basics. I work with technology like : 1) Access and whole office stack (Excel, Word, Outlook) in terms of V More

$150 NZD in 10 days
(33 Reviews)
6.9
chriskerpini

Hello, My name is Chrys. As you can see from my profile, I have 17+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. Please c More

$230 NZD in 3 days
(73 Reviews)
6.5
ReflexiveData

Hi, Thanks for posting the project. I am sure, I can easy work on this project as I have experience working on fetching data to excel and other reporting tools like Power BI using API. For more details and past p More

$250 NZD in 6 days
(16 Reviews)
5.4
$155 NZD in 3 days
(27 Reviews)
5.4
sorinacho88

Hello, I have done this type of work in the past and I can successfully parse JSON in Excel VBA. Please open a chat with me so we can discuss more details. Kind regards, Sorin

$100 NZD in 3 days
(36 Reviews)
4.8
dvcontact

Hi, I have read very carefully your project details about developing an Excel macro that calls the [url removed, login to view] API and returns the transit time. I am absolutely sure that I can do the project very well. I am conf More

$155 NZD in 3 days
(21 Reviews)
5.0
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twelve excel vba projects in the past three months. Have exactly worked on JSON api for another project. Willing to take up yo More

$250 NZD in 3 days
(22 Reviews)
4.5
khoddam

Hello, I had a similar project here: https://www.freelancer.com/projects/Excel/Create-code-Excel-that-will/ I can not see specifications you mentioned. Would you please send them to have a look? Thanks Mehrz More

$300 NZD in 5 days
(12 Reviews)
4.2
supper5guy

Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can do More

$120 NZD in 3 days
(24 Reviews)
4.1
hanlan

Hey, I'm interested in your project for JSON interacting with rocketship API. Please send me a message so that we can discuss more. Best Regards

$330 NZD in 3 days
(2 Reviews)
3.3
$155 NZD in 3 days
(2 Reviews)
2.9
nvbishr

I cant see any attachment, please send me the attached file.....................................................................

$300 NZD in 2 days
(5 Reviews)
3.0
$155 NZD in 3 days
(4 Reviews)
3.0
anilpurswani

I am holding around 13 years of professional experience on Development in multiple technologies, .Net Architect, Microsoft Azure (Service Fabric, Service Bus, WebJob [TimeTrigger/QueueTrigger], WebApp, VM, Storage Acco More

$244 NZD in 5 days
(0 Reviews)
0.0
$111 NZD in 5 days
(0 Reviews)
0.0
kailasjoshi

Hi Even though I have newly joined on this portal, I have multiple years of professional experience on VB 6.0 and .NET technology. Already worked on couple of projects on VBA as well. I am postgrad from India's top More

$122 NZD in 5 days
(0 Reviews)
0.0
IMSystems

Hello sir/madam, my name is Ilko Masaldzhiyski and i am a Microsoft certified Data Analyst and Data Scientist. I am currently employed in the freight forwarding analytics industry in Oslo, Norway. On a daily basis i am More

$222 NZD in 3 days
(0 Reviews)
0.0
danielaspin

I am an MBA graduate from Indian Institute of Management [IIM] Lucknow. Currently on my vacation, waiting to join a bank as a product manager in May. I have done multiple courses on spreadsheet modeling and VBA coding More

$211 NZD in 3 days
(0 Reviews)
0.0