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 [login to view URL] API (uses JSON and returns the transit time for different service offerings for UPS and DHL. See [login to view URL]

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, create json object in vba, vba rest api json, using excel and vba to get api data, vba json, excel vba web, vba sharepoint rest api, excel rest api json, calling rest api from excel vba, microsoft excel, 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

About the Employer:
( 32 reviews ) faridabad, India

Project ID: #16536924

16 freelancers are bidding on average $192 for this job


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
(35 Reviews)

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
(80 Reviews)
$155 NZD in 3 days
(54 Reviews)

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
(62 Reviews)

Hi, I have read very carefully your project details about developing an Excel macro that calls the [login to view URL] 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
(32 Reviews)

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
(68 Reviews)

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
(22 Reviews)

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
(43 Reviews)

Hello, I had a similar project here: I can not see specifications you mentioned. Would you please send them to have a look? Thanks Mehrz More

$300 NZD in 5 days
(20 Reviews)
$155 NZD in 3 days
(7 Reviews)

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

$300 NZD in 2 days
(6 Reviews)
$111 NZD in 5 days
(0 Reviews)

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)

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)

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)

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)