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.
25 freelancere byder i gennemsnit $402 timen for dette job
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.
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