Build an Excel file that connects with an API

€30-250 EUR

Completed

Posted

almost 5 years ago

€30-250 EUR

Paid on delivery

We are a company that uses Tomtom webfleet to manage a large fleet. We currently have an Excel-list of drivers with their information and would like to have someone link our Excel sheet with an API that sends this information to the Tomtom webfleet tool (in bulk and on individual basis). The API has a complete documentation: [login to view URL] You will need to use [login to view URL] API documentation to build the tool. I assume you need these functions for drivers: insertDriverExtern, updateDriverExtern, deleteDriverExtern An example Excel file with an explanation of the columns is attached. We should be able to do: - Bulk upload ==> Delete all drivers, send the whole Excel file through the API (with a speed limit) and confirm if Tomtom accepted all the information - Individual upload ==> When a new line is added OR when a line (RFID code) is updated, it has to be pushed to Tomtom. Confirm if Tomtom received the information. High level: We have a list of drivers in Excel that we want to synchronize to Tomtom Webfleet. This is a one-direction sync, so the Excel file is the 'source of truth'. Lower level: List of drivers (see Excel file) which holds personal data and a RFID tag. These tags will be added in the following months. At least all drivers with a RFID-tag have to be in Tomtom Webfleet. However, the other drivers can be in Tomtom as well (optional). Priority if: - Quick delivery - Prior experience with connecting an Excel file to an API

Excel

Visual Basic

Software Architecture

Data Processing

API

Project ID: 20357308

About the project

25 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

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:

@sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully. I checked the attached workbook as well… I've wrote macros to talk to different APIs, I can write the macro as requested. Kindly get back to me if you wish to proceed. I am available to start your project immediately. Looking forward to discuss further and work on your project.

€150 EUR in 3 days

5.0

(108 reviews)

6.3

25 freelancers are bidding on average €172 EUR for this job

@schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

€150 EUR in 2 days

4.9

(381 reviews)

8.1

@zekovicm

Hi there,I am Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I can build an excel programm that will connect to this API without problems . Check out my profile and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan

€189 EUR in 5 days

4.9

(156 reviews)

7.5

@idragon712

Hello. I have read the description of your project and reviewed Tomtom API. I have rich experiences with making Excel file using Javascript, Bulk and Individual uploading tool. I am confident I can make a perfect tool what you are looking for. I am a senior web developer with 6 more than years of experiences. Let's discuss more detail via chatting. Will wait kindly for your favorable reply. Thank you. Yanying DIng.

€200 EUR in 7 days

4.9

(32 reviews)

7.1

@sourabhg98

Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at www.excelforum.com. I would like to provide my services for this project. I have a lot of experience integrating APIs into Excel. I can integrate both kind of APIs - with and without oAuth. The most recent APIs I integrated into excel were FreeAgent API and Google Sheets API. I am sure I can implement this API also in Excel just like you would need. I can begin now and deliver within 2 days at most. (Though most probably I'll be able to deliver within 24 hours.) I can implement both bulk and individual call functions just as you described. Feel free to text me if you have any questions from me. I look forward to a positive and prompt response from your end. Regards Sourabh

€149 EUR in 2 days

5.0

(136 reviews)

6.0

@alexwmsoft

100% Completion Rate and 5 Stars Hi, there. My name is Lee, and I am an experienced web developer. I read your job description, and I am interested in your project. I have 6+ years of experiences in developing websites using PHP, Python & several frameworks. As a dedicated full stack developer, I am always available for daily communication and ready for your full response. I am free now, I can start to work in your project immediately. I would love to have an opportunity to discuss with you for further details. Best regards.

€140 EUR in 7 days

5.0

(13 reviews)

5.2

@xiaomingming

Hello dear. I have read description and very interested. I m a senior web developer working for 6+ years and my skills and experiences are perfectly fitted on this project. It is my pleasure to work with you, and I ensure to deliver perfect source and kindness services. I am ready for you in any time. Don't hesitate to send message to me. Thanks

€140 EUR in 7 days

5.0

(5 reviews)

4.9

@sherazm

I can do this task. i have worked on many projects like this. ping me for more details and also check out my reviews. thanks

€222 EUR in 3 days

5.0

(11 reviews)

4.6

@Mezh

Hello, Is that a must, that it would work in Excel? I offer you to build an web-application, where the data will be imported from your Excel-files and processed there. Can you show me this Excel file? And describe how should be the data processed, what should be done through API? Thanks, Alex

€300 EUR in 10 days

4.9

(11 reviews)

4.9

@writingapp

Hi. Great app writer for your projects. I have writen excel, api app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile

€140 EUR in 5 days

4.8

(37 reviews)

5.1

@gpnr2017

Hello, Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project using my expertise in excel vba. I hope you already have setup account on webfleet connect api for usages. I have Over 12 years of experience in software development and support. On technical front I have good experience .net technologies, c#, Winforms, WPF, ASP .net MVC, MS SQL Server, MS Access, Excel VBA. I would very much enjoy having the opportunity to talk with you further to discuss the requirements and expectations regarding the project, and how I could use my skills to benefit you. Thank you for considering my application. I look forward to hearing from you. Regards, Naveen Upadhyay

€180 EUR in 7 days

5.0

(18 reviews)

4.7

@nguyenban88

Hello, My name: Bam I come from: Vietnam country I have 8 years of experience in developer , I have read your request description, and can complete your project well. So look forward to talking to you more sincerely thank

€140 EUR in 3 days

5.0

(2 reviews)

2.7

@muhammedahmad

Hey, I have gone through the requirements you mentioned. I can integrate the API with excel. Something i would like to discuss with you so if possible please come in chat. I will deliver this to you by end of this week. Looking forward to your response. Thanks, Muhammad Ahmed.

€166 EUR in 5 days

5.0

(1 review)

0.6

@Omdeep291290

Hi, I checked your new update and it is only possible through logic based on id which will check that if same id exists or not. I am working as .NET developer and having an experience in Excel and VB tool creation of 5+ years. Already built fleet management tools, Customer relationship management tools, Production management tools in excel and embedded them with web tools with the help of API's. I would like to see the database and details of drivers which are currently in the file and i am sure i will do this if you like my proposal. Please let me know if we can connect further on this. Thanks, Omdeep

€222 EUR in 7 days

0.0

(0 reviews)

0.0

@hindustantech0

As per your requirements

€155 EUR in 5 days

0.0

(0 reviews)

0.0

@jamalsuzan48

I am new here. So I attentively do your work that's why I need 7 days.

€155 EUR in 7 days

0.0

(0 reviews)

0.0

@shashwat1511

I am ready to accept your project and complete within 2-3 days as per the work. I am new in freelancer. But I have 5+ year experience in this work and achieved 10 computer certificates in this course so if you give me this project Then I will take my efforts in it.

€140 EUR in 2 days

0.0

(0 reviews)

0.0

@theukwebexpert

Hello there! My name is Chris, I'm a UK based and native English speaking web developer and app expert with 10 years experience building and maintaining complex web apps and websites. I've built and maintained applications/sites for large companies such as Coca Cola, Deutsche Bank, Easy Jet, Barclays, Vogue, Menzies, NHS, My specialist skills include: PHP, Javascript , MYSQL, Bootstrap, SEO, Digital Marketing, Laravel, IONIC, WooCommerce, Moodle, WordPress, Drupal, New Website Builds, Search Marketing, Graphic Design, NGINX, Apache2. I'm highly motivated, results driven and personable individual with a keen eye for details and getting projects finished in a quick timescale, whilst still delivering a world class customer experience. Chris Fairman

€250 EUR in 1 day