Player Stats

Retrieves comprehensive match-by-match player performance statistics from the Football API. This node can work in two modes:

  • Standalone mode: Uses dialog settings to query player stats by fixture ID
  • Fixture IDs mode: Connects to Fixtures Selector output to retrieve player stats for specific fixtures

In Fixture IDs 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 first, then retrieve comprehensive player statistics for only the selected fixtures.

Returns detailed performance data including: minutes played, position, rating, goals, assists, shots, passes, tackles, dribbles, fouls, and cards. Each row represents one player's performance in one match.

Typical workflow:
1. Use Fixtures Selector to browse fixtures for a league/team/date range
2. Filter to interesting matches using KNIME's Row Filter
3. Connect filtered output to this node's optional input port
4. Retrieve detailed player statistics for only those matches

Options

Fixture ID
For standalone mode, specify the numeric fixture ID or comma-separated list of fixture IDs. This field is optional when the input port is connected.

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 player statistics for all players who participated in the specified fixtures, ignoring the dialog's Fixture ID setting. This is typically used with output from Fixtures Selector node after filtering.

Output Ports

Icon
Table containing detailed player performance statistics with 28 columns:
  • IDs: Fixture_ID, Player_ID, Team_ID
  • Info: Player_Name, Team_Name
  • Game: Minutes, Number, Position, Rating, Captain, Substitute
  • Goals: Goals_Total, Goals_Conceded, Assists, Saves
  • Shots: Shots_Total, Shots_On_Target
  • Passes: Passes_Total, Passes_Key, Passes_Accuracy
  • Tackles: Tackles_Total, Tackles_Blocks, Tackles_Interceptions
  • Dribbles: Dribbles_Attempts, Dribbles_Success
  • Discipline: Fouls_Drawn, Fouls_Committed, Yellow_Cards, Red_Cards
Each row represents one player's performance in one match.

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.