From Excel VBA, we need to call the Keepa API to get data about a specific ASIN. Specifically, the data items will be in a nested JSON response in the Stats data. You will need to pass the Amazon ASIN as a variable to Keepa. It is likely that you will use Python to achieve this, but we are open to other methods.
It must be possible to convert the JSON response into a data dictionary, from which we can assign certain items to Excel variables. For example, we want the average selling price over the last 180 days.
Your code must then pass this data back to Excel VBA, where we will take over with our code.
We have had a lot of time wasters on [login to view URL], so please read the very short specification attached. You will know what VBA, Python, JSON, ASIN and Keepa are since you will have experience of writing an interface to the Keepa API already.
Please do not offer to do website development or Keepa/Amazon website scraping. Your solution MUST go through the Keepa API and MUST be initiated from Excel VBA and MUST return the requested data to Excel VBA.
If you have done this before, it will be a simple project for you, so we would expect results in 2-3 days. The coding is not extensive.
The successful person will be asked to do several further pieces of similar work if this one is successful.
Timewasters will be blocked.
Hi there,I'm biddin on your project "Keepa API Data Extraction from Excel VBA"
I have read your project description and i'm an expert in Python and machine learning therefore i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project.
Thanks.
..
.
By using power queries in excel, i can integrate keepa api data into excel. I have checked the keepa api documentation. Please let me know the required data end points.Thanks.
Hello:
My name is Anthony Muñoz, I express my interest in working on your project after carefully reading the requirements and concluding that they match my area of knowledge and skills.
I am currently the lead engineer for the IT agency DSPro and I have more than 10 years of experience in the field. I have successfully completed a large number of similar jobs on this and other Freelance platforms and I consider your project to be a challenge in which I would like to work and be able to make it a reality.
Please feel free to contact me, it will be my pleasure to help you. I greatly appreciate the time provided and I remain attentive to any questions or concerns.
Greetings
Hi,
I am a python programmer since 10 years. I will be able to give you real app. I used Python, Json API REST, API Gateway, excel. You can trust me to delivery good code.
Kind regards
DATABASE EXPERT
SOFTWARE DEVELOPER
DEAR EMPLOYER,
I can assure you 100% that we are fully capable of executing any level of task/project based on the skill required. I am fully confident about our skills and my understanding of the project description and we are ready to go through any test or sample task you assign to acquire your trust. Let me know when are you available for an initial 15-30 minutes discussion (free of charge) so we can discuss the requirement in detail and I can walk you through the mentioned systems to acquire your trust in my skill Rest assured your work is in very safe and professional hands.
THANK YOU
Hi, I am an associate degree professional in essays and dissertations with skills as well as Excel, Excel VBA. Excel macro program, data analysis with CSV.
I'm interested to hear more about the project. If you award me the project I'd be very happy to discuss this further and get started for you as soon as possible. Thanks! N S