All integrations
OpenLigaDB logo

OpenLigaDB

Sports

Pull German football results and fixtures from OpenLigaDB, the open sports database behind the Bundesliga, its second and third tiers, the DFB-Pokal, the women's Bundesliga, national-team tournaments and hundreds of other competitions, ice hockey and handball among them. Read a matchday's scores goal by goal, a league's table, its scoring charts, one team's fixtures across every competition it plays in, or the record between two clubs. No account or API key is required.

16 actions

Actions

Steps your workflow can run in OpenLigaDB.

List sportsList the sports OpenLigaDB holds leagues for: football first and foremost, but also ice hockey, handball, basketball and several more. Each comes back with the id that filters the league list.
List leaguesFind a competition and the shortcut that addresses it. OpenLigaDB holds over 800 league seasons, from the Bundesliga and the DFB-Pokal down to local amateur competitions, so narrow the list by season, sport or a word from the name. Every other action takes the shortcut and season this returns.
List teamsList the teams in a league's season, with the crest and the team id that the head-to-head and team fixture actions take. In a tournament each team also comes back with the group it was drawn into.
List matchdaysList the rounds a league's season is played over, each with its number and its name. A German league calls a round a Spieltag and numbers them; a cup names them instead, so a quarter-final comes back under that name.
Get the current matchdayFind which round a league is on right now. This is the one action that needs no season: OpenLigaDB works out which season is running and which round of it is next, which is what a weekly digest needs before it can ask for the fixtures.
List matchesGet the fixtures and results of a league's season, each with its kick-off, its score at half-time and full time, and every goal that was scored. Narrow it to one matchday, to one team's whole season, or to the days a weekend covers, and keep only the matches that have finished, are being played, or are still to come.
Get a matchGet one match by its id, with its goals minute by minute, the score at each stage it was recorded at, the venue and the attendance. Match ids come back from List matches and from the next and last match actions.
Get the next matchGet the next match still to be played in a league, or the next one for a single team. With no team this is the league's next kick-off whoever is playing, and no season is needed. This is the action a reminder workflow runs on a schedule.
Get the last matchGet the most recently played match in a league, or the last one a single team played. With no team this is the league's last kick-off and no season is needed. Pair it with the table for a results round-up.
List a team's matchesGet one club's matches around today across every competition OpenLigaDB holds, so a cup tie, a friendly and a league fixture come back together. Pick the team from a league to get its id, or type part of its name to search without one. Two dates set the window.
Get head to headGet every match two teams have played against each other, with the record worked out: how many each has won, how many were drawn, and the goals either way. OpenLigaDB answers with their whole shared history across every competition it holds.
Get the league tableGet a league's table for a season: every team with its points, its played, won, drawn and lost, its goals either way and its goal difference, in the order OpenLigaDB ranks them.
Get group tablesGet the standings of a tournament that plays in groups, one table per group, as at a World Cup or a European Championship. Only a competition with a group stage has these.
List top scorersGet a league season's scoring charts, most goals first, each player with their goal count and their id. This is the Torjaegerliste OpenLigaDB keeps for the competition.
List result typesList the stages a score can be recorded at. With no league this is the five OpenLigaDB shares across the whole database; with one it is the stages that league actually records, usually half-time and full time.
Get the last change dateFind when a matchday's data last changed. This is the cheap check to run on a schedule: compare the answer with the one from the previous run and only fetch the matches when it has moved, rather than pulling a whole matchday every few minutes.

Connect in a few clicks

Authenticate once and every action and trigger for the app is ready to drop into a workflow. No glue code, no maintenance.

Automate across your stack

Chain apps together with triggers, actions, and logic that move data between your tools automatically, so work happens without you.

Secure by default

Credentials are encrypted and scoped per workspace. Connect the tools your team already trusts with confidence.

Automate OpenLigaDB with Lodol.

Connect OpenLigaDB and build your first workflow in minutes. No credit card required.

Free plan available · No credit card required