TheCocktailDB.com - An Open Cocktail Database with API

  Thread Rating:
  • 2 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
docwra Offline
Fan
Posts: 482
Joined: Nov 2014
Reputation: 20
Post: #136
(2017-01-17 16:34)dberov Wrote:  API is returning wrong format atm. One of the methods its not working. Will post latter wich one.


Ok Feedback: http://www.thecocktaildb.com/api/json/v1/!!!KEY!!!/list.php?i=list is returning error:


<br />
<b>Warning</b>: Incorrect usage of UNION and LIMIT in <b>C:\inetpub\thecocktaildb\includes\ez_sql_mysqli.php</b> on line <b>272</b><br />
{"drinks":null}

Whoops! thanks for the heads-up. I've limited it to the first ingredient set now and it should work again.

[Image: cook.png] Formally chef Zag
find quote
enen92 Offline
Team-Kodi Member
Posts: 1,509
Joined: Nov 2012
Reputation: 94
Location: Portugal
Post: #137
Hey zag, it would be nice to add ingredient descriptions once you find some time. Also need to fix the errors with the screensaver
find quote
docwra Offline
Fan
Posts: 482
Joined: Nov 2014
Reputation: 20
Post: #138
(2017-01-18 18:07)enen92 Wrote:  Hey zag, it would be nice to add ingredient descriptions once you find some time. Also need to fix the errors with the screensaver

Its been a while since I had a request Smile

Here you go:

Code:
http://www.thecocktaildb.com/api/json/v1/1/search.php?i=vodka

NOTE: I've only filled in about 10 descriptions so far, but more to come soon.

I limited the results to 1 as I assume you only want to look it up from the drink recipe.

[Image: cook.png] Formally chef Zag
(This post was last modified: 2017-01-18 19:51 by docwra.)
find quote
docwra Offline
Fan
Posts: 482
Joined: Nov 2014
Reputation: 20
Post: #139
And just in case anyone wants a full list like i did in themealdb thread

Code:
151 proof rum
7-up
Absinthe
Absolut citron
Absolut Kurant
Absolut Peppar
Absolut Vodka
Advocaat
Aejo rum
Aftershock
Agave syrup
Ale
Allspice
Almond Extract
Almond flavoring
Almond
Amaretto
Angelica Root
Angostura Bitters
Anis
Anise
Anisette
Aperol
Apfelkorn
Apple Brandy
Apple Cider
Apple Juice
Apple schnapps
Apple
Applejack
Apricot Brandy
Apricot nectar
Apricot
Aquavit
Asafoetida
A?ejo rum
Baby Plum Tomatoes
Bacardi Limon
Bacardi
Bacon
Bailey's irish cream
Baileys irish cream
Banana liqueur
Banana rum
Banana syrup
Banana
Barenjager
Basil
Beef bouillon
Beef Stock
Beer
Benedictine
Berries
Bitter lemon
Bitters
Black Pepper
Black rum
Black Sambuca
Blackberries
Blackberry Brandy
Blackberry schnapps
Blackcurrant cordial
Blackcurrant schnapps
Blackcurrant squash
Blended Whiskey
Blue Curacao
Blue Maui
Blueberries
Blueberry schnapps
Bourbon
Bow Tie Pasta
Bramley Apples
Brandy
Bread
Brown Rice
Brown Sugar
Butter, softened
Butter
Butterscotch schnapps
Cachaca
Calvados
Campari
Canadian whisky
Candy
Cantaloupe
Caramel coloring
Carbonated soft drink
Carbonated water
Cardamom
Carrot
Caster Sugar
Cayenne pepper
Celery salt
Celery
Chambord raspberry liqueur
Champagne
Cheese
Cherries
Cherry Brandy
Cherry cola
Cherry Grenadine
Cherry Heering
Cherry juice
Cherry liqueur
Cherry
Chicken Breasts
Chicken Stock
Chicken
Chilled Butter
Chinese Broccoli
Chocolate ice-cream
Chocolate liqueur
Chocolate milk
Chocolate syrup
Chocolate
Chopped Garlic
Chopped Onion
Chopped Tomatoes
Cider
Cinnamon schnapps
Cinnamon
Citrus vodka
Clamato juice
Clove
Cloves
Club Soda
Coca-Cola
Cocktail Olive
Cocktail onion
Cocoa Powder
Coconut cream
Coconut liqueur
Coconut Milk
Coconut rum
Coconut syrup
Coffee brandy
Coffee liqueur
Coffee
Coffeemate
Cognac
Cointreau
Cola
Cold Water
Condensed milk
Coriander Leaves
Coriander
Corn Starch
Corn syrup
Corn Tortillas
Cornstarch
Corona
Courgette
Cranberries
Cranberry Juice
Cranberry liqueur
Cranberry vodka
Cream of Coconut
Cream Sherry
Cream soda
Cream
Creme de Almond
Creme De Banane
Creme de Cacao
Creme de Cassis
Creme de Noyaux
Creme Fraiche
Crown Royal
Crystal light
Cubed Feta Cheese
Cucumber
Cumin powder
Cumin seed
Curacao
Cynar
Daiquiri mix
Dark Chocolate
Dark Creme de Cacao
Dark Rum
Dark Soy Sauce
demerara sugar
Digestive Biscuits
Dijon Mustard
Doner Meat
Dr Pepper
Dr. Pepper
Drambuie
Dried Oregano
Dry Vermouth
Dubonnet blanc
Dubonnet Rouge
Egg White
Egg Yolk
Egg
Eggnog
Eggs
Enchilada Sauce
English Mustard-Small .png
Erin Cream
Espresso
Everclear
Extra Virgin Olive Oil
Fanta
Farfalle
Fennel Seeds
Feta Cheese
Firewater
Flaked Almonds
Flour
Food coloring
Forbidden Fruit
Frangelico
Free-range Egg, Beaten
Free-range Eggs, Beaten
Fresca
Fresh Basil
Fresh Lemon Juice
Freshly Chopped Parsley
Fries
Fruit juice
Fruit punch
Fruit
Galliano
Garlic Sauce
Garlic
Gatorade
Gin
Ginger Ale
Ginger beer
Ginger
Glycerine
Godiva liqueur
Gold rum
Gold Tequila
Goldschlager
Gouda Cheese
Grain Alcohol
Grand Marnier
Granulated Sugar
Grape juice
Grape soda
Grapefruit Juice
Grapes
Grated Cheese
Green Chartreuse
Green Creme de Menthe
Green Ginger Wine
Green Olives
Green Red Lentils
Grenadine
Ground Almonds
Ground Ginger
Guava juice
Guinness stout
Guinness
Half-and-half
Hawaiian punch
Hazelnut liqueur
Heavy cream
Honey
Hooch
Hoopers Hooch
Hot Beef Stock
Hot Chocolate
Hot Damn
Hot Sauce
Hotsauce
Hpnotiq
Ice-Cream
Ice
Iced tea
Irish cream
Irish Whiskey
Italian Seasoning
Jack Daniels
Jello
Jelly
Jgermeister
Jim Beam
Johnnie Walker
J?ermeister
Kahlua
Key Largo Schnapps
Kirschwasser
Kiwi liqueur
Kiwi
Kool-Aid
Kummel
Lager
Lasagne Sheets
Lasagne
Lean Minced Beef
Lemon Juice
Lemon Peel
Lemon soda
Lemon vodka
Lemon-lime soda
lemon-lime
lemon
Lemonade
Lentils
Lettuce
Licorice Root
Light Cream
Light Rum
Lillet
Lime juice cordial
Lime Juice
Lime liqueur
Lime peel
Lime vodka
Lime
Limeade
Madeira
Malibu Rum
Malt Vinegar
Mandarin
Mandarine napoleon
Mango
Maple syrup
Maraschino cherry juice
Maraschino Cherry
Maraschino Liqueur
Margarita mix
Marjoram leaves
Marshmallows
Maui
Melon liqueur
Melon vodka
Mezcal
Midori melon liqueur
Midori-Small .png
Milk
Minced Beef
Minced Garlic
Mint syrup
Mint
Mountain Dew
Mozzarella Balls
Mozzarella
Mushroom
Mushrooms
Mustard
Nutmeg
Nuts
Olive Oil
Olive
Onion
Onions
Orange Bitters
Orange Curacao
Orange Juice
Orange liqueur
Orange Peel
Orange rum
Orange Soda
Orange spiral
Orange vodka
Orange
Oregano
Oreo cookie
Orgeat Syrup
Ouzo
Oyster Sauce
Papaya juice
Papaya
Parfait d' amour
Parmesan Cheese
Parmesan
Parmigiano-Reggiano
Parsley
Passion fruit juice
Passion fruit syrup
Passoa
Peach brandy
Peach juice
Peach liqueur
Peach Nectar
Peach Schnapps
Peach Vodka
Peach
Peachtree schnapps
Peanut Oil
Peas
Penne Rigate
Pepper
Peppermint extract
Peppermint Schnapps
Pepsi Cola
Pernod
Peychaud bitters
Pina colada mix
Pineapple Juice
Pineapple rum
Pineapple vodka
Pineapple-orange-banana juice
Pineapple
Pink lemonade
Pisang Ambon
Pisco
Pi?a colada
Plain Chocolate
Plain Flour
Plum Tomatoes
Plums
Port
Potato
Potatoes
Powdered Sugar
Prawns
Purple passion
Raisins
Raspberry cordial
Raspberry Jam
Raspberry juice
Raspberry liqueur
Raspberry schnapps
Raspberry syrup
Raspberry Vodka
Raw King Prawns
Red Chile Flakes
Red Chili Flakes
Red Hot Chili Flakes
Red Lentils
Red Wine
Rhubarb
Ricard
Rice Stick Noodles
Rock Salt
Root beer schnapps
Root beer
Roses sweetened lime juice
Rosewater
Rum
Rumple Minze
Rye whiskey
Sake
Salmon
Salt
Sambuca
Sarsaparilla
Schnapps
Schweppes Lemon
Schweppes Russchian
Schweppes Russchiani
Scotch
Sesame Seed
Sherbet
Sherry
Shredded Cheese
Shredded Monterey Jack Cheese
Sirup of roses
Sloe Gin
Small.png
Soda Water
Sour Apple Pucker
Sour Mix
Southern Comfort
Soy Milk
Soy Sauce
Soya Milk
Soya Sauce
Spaghetti
Spiced Rum
Spinach
Sprite
Squeezed Orange
Squirt
Stir-fry Vegetables
Strawberries
Strawberry juice
Strawberry liqueur
Strawberry Schnapps
Strawberry syrup
Sugar Syrup
Sugar
Sunny delight
Surge
Swedish punsch
Sweet and Sour
Sweet Cream
Sweet Vermouth
Tabasco Sauce
Tang
Tawny port
Tea
Tennessee whiskey
Tequila rose
Tequila
Tia Maria
Tinned Tuna
Tomato Juice
Tomato Puree
Tomato
Tomatoe
Tomatoes
Tonic Water
Triple Sec
Tropicana
Tuaca
Tuna
Vanilla extract
Vanilla Ice-Cream
Vanilla liqueur
Vanilla schnapps
Vanilla syrup
Vanilla vodka
Vanilla
Vegan Butter
Vermouth
Vinegar
Vodka
Water
Watermelon schnapps
Whipped Cream
Whipping Cream
Whiskey
Whisky
White chocolate liqueur
White Creme de Menthe
White grape juice
White port
White Rum
White Vinegar
White Wine
Wild Turkey
Wildberry schnapps
Wine
Worcestershire Sauce
Wormwood
Yeast
Yellow Chartreuse
Yoghurt
Yukon Jack
Zima
Zucchini

[Image: cook.png] Formally chef Zag
(This post was last modified: 2017-01-18 20:02 by docwra.)
find quote
endisisto Offline
Junior Member
Posts: 2
Joined: Dec 2016
Reputation: 0
Post: #140
Hey zag there is a way to combine search and filters?
For example search drinks with strawberry that are with alcohol, or search by name but only drinks that are Non Alcoholic?
find quote
Nikhil B Offline
Junior Member
Posts: 4
Joined: Dec 2016
Reputation: 0
Post: #141
Hi, I developed an application using the database cocktail db database. The app allows you to save your favorite cocktails for later viewing. If u want to feel inspired to try something new or want a surprise, use the randomixer, swiping down in the randomixer will show a random cocktail. There is a widget to show the saved cocktails and tablets are also supported. Please download the app and give it a try. Feedback is always welcome and strongly encouraged.

https://play.google.com/store/apps/detai...k.mixology
find quote
portia79 Offline
Junior Member
Posts: 1
Joined: Feb 2017
Reputation: 0
Post: #142
Hi Zag,

Thanks for a great API. I'm playing with React-native - would you be able to PM me the key. I can't PM you. I guess it's because I've just signed up with this forum and don't have required permissions.

Thanks.
find quote
julesgarcia Offline
Junior Member
Posts: 1
Joined: Feb 2017
Reputation: 0
Post: #143
Hi Zag,

I was wondering if you could provide me with a key?
I have an uni project, and I'd like to use your API. They only gave me a week, so I'd greatly appreciate it if you could help me out with the key promptly. Thanks again! I'll send you the link to my website when finished Smile
find quote
docwra Offline
Fan
Posts: 482
Joined: Nov 2014
Reputation: 20
Post: #144
You can us the test key "1" for all personal projects.

[Image: cook.png] Formally chef Zag
find quote
pettittmj Offline
Junior Member
Posts: 1
Joined: Apr 2017
Reputation: 0
Post: #145
I am creating a "personal project" IE: i will not make any money off of it but it will be published for Amazon's Alexa. Would using the test key 1 be appropriate for this or should i request a special key? Thank you very much and thanks to all who have contributed.
find quote
HarounHajem Offline
Junior Member
Posts: 2
Joined: Apr 2017
Reputation: 0
Rainbow  RE: TheCocktailDB.com - An Open Cocktail Database with API
Post: #146
Is there a way to query multiple ingridients?

Ex:
Code:
http://www.thecocktaildb.com/api/json/v1/1/filter.php?i=Vodka&i=Tequila

Thanks in advance for any help
find quote
docwra Offline
Fan
Posts: 482
Joined: Nov 2014
Reputation: 20
Post: #147
Not at this time, sorry.

I've uploaded another 50 hires images though so we are at 400 now Smile

[Image: cook.png] Formally chef Zag
find quote
HarounHajem Offline
Junior Member
Posts: 2
Joined: Apr 2017
Reputation: 0
Thumbs Up  RE: TheCocktailDB.com - An Open Cocktail Database with API
Post: #148
I'm currently working on an BarBot, drink mixing machine, and want to integrate it with TheCoctailDB. The goal is to use an Android app for sending cocktail order, based on cocktail db's recommendation, through bluetooth communication.

Do i need a personal key for quering cocktail DB? Since I'm developing and iterrating over methods i could be "spamming" the DB.
Is it better to have a seperate key?

Of course I'll open source the code when its done.

Here is the drinking machine my project is based on, [url= http://www.instructables.com/id/6-Shoote...tion/]here[/url]
find quote
docwra Offline
Fan
Posts: 482
Joined: Nov 2014
Reputation: 20
Post: #149
You can use the test key "1" until you release something to the public. Thats fine.

Cool machine!

[Image: cook.png] Formally chef Zag
find quote
RockerC Offline
Posting Freak
Posts: 1,486
Joined: May 2011
Reputation: 28
Post: #150
(2017-04-29 18:15)HarounHajem Wrote:  I'm currently working on an BarBot, drink mixing machine, and want to integrate it with TheCoctailDB.
Slightly off-topic but I would love to see TheCocktailDB integrated into some of the other open source DIY robotic drink-mixing machines out there as well.


For example, Mocktails Mixer is an open source DIY robotic drink-mixing machine, similar to BarBot:

https://github.com/deeplocal/mocktailsmixer

http://deeplocal.com/mocktailsmixer/


A simpler DIY robotic bartender is OpenElectronics Drink Maker

https://www.open-electronics.org/the-sou...-software/

https://www.open-electronics.org/the-dri...-cocktail/

https://github.com/open-electronics/drink-maker

(2017-04-29 18:15)HarounHajem Wrote:  The goal is to use an Android app for sending cocktail order, based on cocktail db's recommendation
Again off-topic but did you hear about Google Assistant SDK to enable voice control AI bartender to any such drink-mixing machine?

http://www.cnx-software.com/2017/05/03/g...ogle-home/

Google actually created the Mocktails Mixer together with Deeplocal as a demo and proof-of-concept example for Google Assistant integration:

https://developers.googleblog.com/2017/0...t-sdk.html



(This post was last modified: 2017-05-11 12:40 by RockerC.)
find quote
Post Reply