Fixtures

Queries comprehensive fixture data (matches/games) from the Football API. This node can work in two modes:

  • Standalone mode: Uses dialog settings to query fixtures by league, date range, team, etc.
  • Details mode: Connects to Fixtures Selector output to retrieve detailed data for specific fixtures (statistics, lineups, player stats, events).

In Details mode, the third optional input port accepts a table with a Fixture_ID column (typically from Fixtures Selector). This allows you to browse/filter fixtures in the selector, then retrieve comprehensive details for only the selected fixtures.

The node supports multiple query types including by league, date range, team, fixture ID, live fixtures, and head-to-head comparisons. Optionally includes detailed statistics, lineups, player stats, and match events.

Options

Query Type
Select how to query fixtures:
  • By League/Season: Get all fixtures for a specific league and season
  • By Date Range: Get fixtures within a date range
  • By Team: Get all fixtures for a specific team in a season
  • By Fixture ID: Get details for a specific fixture
  • Live Fixtures: Get all currently live fixtures
  • Head to Head: Compare past encounters between two teams
League
Select the league to query. Populated from reference data input.
Season
Select the season year. Populated from reference data input.
Team
Optional team filter. Leave blank to get fixtures for all teams in the league.
From Date / To Date
For date range queries, specify the date range in YYYY-MM-DD format. To date is optional.
Fixture ID
For fixture ID queries, specify the numeric fixture ID.
Status Filter
Optional filter by fixture status (NS=Not Started, FT=Finished, LIVE=In Progress, etc.).
Include Additional Data
Optionally include events, lineups, or statistics in the query. Note: This may increase API response time and data volume.

Input Ports

Icon
API-Sports connection from the API-Connector node
Icon
Reference data (leagues, seasons, teams) from the Reference Data Loader node
Icon
Optional input table containing a Fixture_ID column. When connected, the node retrieves detailed data for the specified fixtures, ignoring dialog query settings. This is typically used with output from Fixtures Selector node after filtering.

Output Ports

Icon
Table containing comprehensive fixture data. Column count varies based on "Include Additional Data" settings: 39 base columns (fixture, league, teams, scores), plus optional columns for events (18), statistics (32), lineups (20), and player stats (28). When input port is connected, retrieves detailed data for the specified Fixture IDs.

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.