Fixtures Selector

Lightweight node for querying basic fixture data (matches/games) from the Football API. This node returns essential fixture information only, making it ideal for browsing, filtering, and selecting fixtures for further analysis.

Unlike the full Fixtures node, this selector does NOT retrieve expensive additional data like statistics, lineups, player stats, or events. This makes queries faster and more efficient for browsing large fixture sets.

The output can be filtered using KNIME's Row Filter or other filtering nodes, then fed into the Fixtures Details node to retrieve comprehensive data for only the selected fixtures.

Supports multiple query types including by league, date range, team, fixture ID, live fixtures, and head-to-head comparisons.

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 (requires season)
  • 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. Required for League/Season, Date Range, and Head to Head queries.
Season
Select the season year. Populated from reference data input. Required for most query types.
Team
Select team for Team queries, or optional team filter for League/Season queries. For Head to Head queries, this is Team 1.
Team 2
For Head to Head queries only. Select the second team to compare.
From Date / To Date
For date range queries, specify the date range in YYYY-MM-DD or YYYY/MM/DD format. To date is optional (if omitted, queries from start date only).
Fixture ID
For fixture ID queries, specify the numeric fixture ID or comma-separated list of IDs.
Status Filter
Optional filter by fixture status:
  • NS = Not Started
  • FT = Finished
  • LIVE = In Progress
  • 1H, HT, 2H = First Half, Halftime, Second Half
  • PST, CANC, ABD = Postponed, Cancelled, Abandoned

Input Ports

Icon
API-Sports connection from the API-Connector node
Icon
Reference data (leagues, seasons, teams) from the Reference Data Loader node

Output Ports

Icon
Table containing basic fixture data with 15 columns: Fixture_ID, Date, Timestamp, Venue_Name, Status, League_ID, League_Name, Season, Round, Home_Team_ID, Home_Team_Name, Away_Team_ID, Away_Team_Name, Goals_Home, Goals_Away. This output can be filtered and fed into the Fixtures Details node to retrieve comprehensive statistics, lineups, player stats, and events for selected fixtures only.

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.