Use API to extract data from a database and develop a excel formulae

To order electronics components, we are using an Excel sheet to do the BOM. (Bill Of Material)

To fill up these BOM, we have to copy/paste some fields from the web site of the reseller to our Excel sheet.

This work takes time and the data aren’t up to date when we have to order components. So we’d like to

automatize some field like the Reseller’s amount in stock and unit price.

Most of reseller give APIs to access directly they database. With these APIs it is possible to extract the

amount in stock and price and so update our BOM with the last data.

We would like to develop an Excel formulae to do this

Excel formulae must use API to extract data directly from the supplier’s database.

A solution by Web-scrapping is not allowed.

Evner: Databaseudvikling, Excel

Om arbejdsgiveren:
( 0 bedømmelser ) Montreux, Switzerland

Projekt ID: #31490865

25 freelancere byder i gennemsnit $402 timen for dette job

(413 bedømmelser)

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA.

$250 USD in 5 dage
(115 bedømmelser)
(90 bedømmelser)
(136 bedømmelser)
(112 bedømmelser)
(65 bedømmelser)
(12 bedømmelser)

Hi. I check the file. three sites have API and forth not. I can do it with API or not. I will use VBA coding

$300 USD in 2 dage
(5 bedømmelser)

Hi, I applying for Use API to extract data from a database and develop a excel formulae. Profile Link: Hope you doing well. I am postgraduate in Economic and Econometrics and I Flere

$260 USD in 5 dage
(9 bedømmelser)

=== THIS IS NOT AUTO BID === Hi there! My name is Ugur Catak. I can use your reseller's APIs with in Excel macros. For this, VBA code must be written in macros. I am an expert on transforming workload to automation, E Flere

$500 USD in 4 dage
(5 bedømmelser)
(6 bedømmelser)

Hi client Thank you for your job posting. I am very interested in your project and I will provide you 100% quality work. My Main skill: VBA, Excel I am ready to start work immediately and can work full time for you. Flere

$500 USD in 7 dage
(2 bedømmelser)

I can achieve what you wanted (pull data by API, check sheet, find the item, if found replace price, if not found add the item. I can give you more automation like send the order to supplier (as signed PDF), maintain r Flere

$250 USD på 1 dag
(3 bedømmelser)

Hi There, I am a Data Entry/Data Processing, Web Scraping Expert, eBay Product Listing, eCommerce. I’m considering your job for me as I have these capabilities. I always respect quality, punctuality, and commitment to Flere

$250 USD in 7 dage
(1 bedømmelse)
(1 bedømmelse)
(1 bedømmelse)

Hi, I read the details about your project "Use API to extract data from a database and develop a excel formulae-".I can Design and Develop your Mobile & Web app within the given time and develop it using the Technolo Flere

$250 USD in 7 dage
(1 bedømmelse)

Hello! I am ready to work with you, I have read your requirements and I am confident that I will deliver you the task. I am professional developer with skills including Database Development and Excel and etc. Kindly Flere

$250 USD in 15 dage
(0 bedømmelser)

Hello, I am Alexandre, a senior data analyst living in France, I am working with Excel/VBA, PowerBi/PowerQuery, ETL Tools, SQL/Access and lot of other solutions for years now. You can find an example of API working on Flere

$600 USD in 7 dage
(0 bedømmelser)

I have strong excel skill, I can finish given task within time frame, and if you want your file in pavot format or any otherway, i can prepeared and send back to you

$550 USD in 8 dage
(0 bedømmelser)