I'm looking to implement a wine database API into my app. What are the most extensive and comprehensive databases to look for? I know about Wine-searcher.com API. Has anyone any experience with it and the data it outputs? What other APIs should I take a look at?
Software Engineer here (with experience in the liquor industry)... So, this is a bit of a tricky question to answer and entirely depends on what kind of data you're looking to extract. There's a lot of different data that could be extracted from different resources.
- Item name
- Tasting notes
- Region (it was created)
- Alcohol percentage
- Wine scores
- Grape variety
- User reviews (from whatever API you are using)
- Etc. etc.
It should also be noted that the values are entirely different, based on the vintage of the wine that is selected. Simply going by barcode won't help, as many wineries use the same barcode across multiple vintages.
There then comes the question -- what price are you trying to display? Do you want to show which locations nearby you can buy the product and their prices? Or are you trying to display the wholesaler pricing? From my experience, wholesalers will generally withhold this kind of information.
As far as wine-searcher.com, their data seems pretty good for the most part but according to their API developers page, it doesn't include everything I mentioned above. Going through wine-searcher also means 2 different APIs (Price Check API & Marketplace API), and you'd have to pay for each.
A lot of the other so-called "open source wine databases" online aren't kept up-to-date and don't contain much information. You could try contacting those in charge of CellarTracker, but I'm not sure if they have an API for use to the public.
Your question is pretty open-ended, but I think the data you are looking for (in relation to wine-searcher) would be found here. But once again, you're going to have to pay based on the amount of queries you are doing per day.