How do I connect Open Brewery DB to Lodol?

Authenticate Open Brewery DB once from your workspace and every action and trigger it supports becomes available to drop into a workflow. There is no glue code to write or maintain.

All integrations

Open Brewery DB

Food & DrinkTravel & Places

Look up breweries, brewpubs, taprooms and cideries anywhere in the world from Open Brewery DB, the free open-source brewery dataset. Search by name, filter by country, state, city, postal code or brewery type, find the ones nearest a set of coordinates with the distance to each, pull a whole region in one step, count what matches before you fetch it, or pick one at random. No account or API key is required.

Get Started Browse all integrations

14 actions

Actions

Steps your workflow can run in Open Brewery DB.

List breweriesList breweries matching a filter: a country, a state or province, a city, a postal code, part of a name, and the brewery types to keep or leave out. Sort by any of seven fields in either direction, and page through the results. Every brewery comes back with its full address on one line, a map link, a readable phone number and whether it is open today, beside the fields Open Brewery DB itself returns.

List every matching breweryThe same search as 'List breweries', but followed across every page so one step returns the whole answer instead of a paging loop. It asks how many there are first, so the result says whether it returned all of them or stopped at the limit. Use it for 'every brewery in Vermont'; use 'List breweries' when one page is enough.

Find breweries nearbyFind the breweries closest to a latitude and longitude, nearest first, each with how far away it actually is. Set a radius to keep it to a neighbourhood, or leave it empty to get the nearest ones wherever they are. Open Brewery DB sorts by distance but never says what the distances are, so each one is measured here from the coordinates the record carries.

Get a breweryRead one brewery by its Open Brewery DB ID: its name, type, full address, coordinates, phone number and website. Type part of a name in the search box to pick one, or pass an ID an earlier step returned.

Get breweries by IDRead several breweries at once from a list of IDs, in the order you asked for them. Open Brewery DB looks up 6 at a time and returns them in its own order, dropping any ID it does not have; this step splits a longer list across requests, puts the order back and reports the IDs that are not in the dataset instead of losing them.

Get a random breweryPick one brewery at random from the whole dataset and return it as a flat record, so a message can use its name and address without reaching into a list. Good for a 'brewery of the day' post.

Get random breweriesPick up to 50 breweries at random from the whole dataset. The pick covers every country the dataset holds and cannot be filtered, which is what Open Brewery DB's random endpoint offers.

Search breweries by nameSearch brewery names for part of a name, in any case, and get the full record of each match. The search covers names only and takes no place or type filters, so use 'List breweries' with its Name filter to search names inside a city or a state.

Suggest breweriesThe same name search trimmed to an ID, a name and a place, with a ready-made label such as 'Dogfish Head Craft Brewery (Milton, Delaware, United States)'. Use it to offer a short list of choices in a chat reply, or to turn a name someone typed into the ID the other actions take.

Get brewery statisticsCount the breweries matching a filter and break the total down by type, by state or province and by country, each as ordered rows with the busiest first and the share of the total beside each type. One request, whatever the filter matches, so it is the cheap way to size a search before running it.

Count breweriesHow many breweries match a filter, as a single number, with a yes or no beside it for whether there are any at all. Built for a condition step: ask whether a town has a brewery before spending requests listing them.

List countriesEvery country the dataset covers, with how many breweries each has, busiest first. These are the exact names the country filter takes, and they are what fills the country dropdown on the other actions.

List states and provincesEvery state or province the dataset covers, with how many breweries each has, busiest first. Choose a country to narrow it, or leave it empty for all of them worldwide. These are the exact names the state filter takes, spelled the way the dataset spells them.

List brewery typesEvery brewery type the filters accept, what each one means, and how many of each the dataset holds. Four of the fourteen are accepted by the API but missing from its documentation, and two are deprecated; each row says which it is, so a filter can be built without guessing.