No Subscription to this function
GET /floorball/get_tables
Returns the league, home & away tables per season or round.
Request URL
https://dsg-api.com/clients/{client_name}/floorball/get_tables?type={type}&id={id}&client={client_name}&authkey={client_authkey}
Parameters
authkey
string Required
client authentification key
client
string Required
unique client ID
ftype
string
changes feed type from XML to json (ftype=json)
gameweek
int
gameweek value to get table from
lang
string
two-character language code, defaults to 'en'
live
string
only 'yes' is valid which will provide a live table
type
string Required
type is either "season" or "round"
Nodes
competition
Details about competition
area_id
unique identifier for area.
area_name
contains the area name.
competition_id
unique identifier for a competition.
format
competition format to filter out leagues or cups
last_updated
When record was last updated. Format YYYY-MM-DD HH:MM:SS in CET timezone.
name
name of the competition.
teamtype
determines the type of team/competition (male,female,male_youth,female_youth)
type
determines if a competition is between club teams (club) or national teams (international).
group
Details about group
group_id
unique identifier to the group.
last_updated
When group was last updated. Format YYYY-MM-DD HH:MM:SS in CET timezone.
name
name of group
method
details about the API function
method_id
unique ID of method.
name
name of method.
rounds
Details about round
current_gameweek
displays the gameweek of nearest match to today
end_date
end date, format 'yyyy-mm-dd'.
last_updated
When record was last updated. Format YYYY-MM-DD HH:MM:SS in CET timezone.
name
name of round
round_id
unique identifier of round.
start_date
start date, format 'yyyy-mm-dd'.
type
Determines if the round contains a table or a cup structure (knock-out).
season
Details about season
end_date
end date, format 'yyyy-mm-dd'.
last_updated
when record was last updated. Format YYYY-MM-DD HH:MM:SS in CET timezone.
logo
full path URL of logo for particular season
original_name
competition name during this season
season_id
unique identifier for season.
start_date
start date, format 'yyyy-mm-dd'.
title
title of season
table
Details about table position entry
ball
display which ball the commentary belongs to
commentary_id
unique global id for commentaries
created_at
timestamp of creation
form
performance of the last 5 matches in the particular round (W = win, D = draw, L = loss)
home
win-loss record for home matches
matches_lost
value for total lost matches
matches_total
value for total played matches
matches_won
value for total won matches
net_run_rate
value for net run rate (NRR)
next_match_id
match_id of the upcoming match in the particular round
next_opponent_name
current team name of the next opponent in the particular round
next_opponent_team_id
team_id of the next opponent in the particular round
original_team_name
original team name during the season
percentage
win percentage (win/loss)
period_type
only used for type = Live. determines which inning the commentary belongs to.
points
value for total points gained
points_against
value for total runs against
points_for
value for total points scored
position
current table position
prev_season
defines last season achievements ('C','CW','P','R')
road
win-loss record for away matches
run_difference
value for total run difference
short_name
short name of the team.
team_id
Unique identifier for team.
team_name
current team name
type
valid values are Live, Post-Match and Pre-Match.
zone
name of table zone
zone_id
Unique identifier for a table zone
Response Headers
200
Success
401
Unauthorized
429
Rate limit exceeded
Code Samples
<?php
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "https://dsg-api.com/clients/{client_name}/floorball/get_tables?type={type}&id={id}&client={client_name}&authkey={client_authkey}");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_USERPWD, "User:Password");
$content = curl_exec($ch);
curl_close($ch);
?>
curl GET -u "User:Password" "https://dsg-api.com/clients/{client_name}/floorball/get_tables?type={type}&id={id}&client={client_name}&authkey={client_authkey}"
response = requests.get("https://dsg-api.com/clients/{client_name}/floorball/get_tables?type={type}&id={id}&client={client_name}&authkey={client_authkey}", auth=("User", "Password"))
Response Example
200 Success
{"datasportsgroup":{"version":"1.0","sport":"floorball","lang":"en","method":{"method_id":"86","name":"get_tables"},"competition":{"competition_id":"2118","name":"Floorball World Championships","teamtype":"male","type":"international","format":"international_cup","area_id":"1","area_name":"World","last_updated":"2019-01-08 19:45:02","season":{"season_id":"19610","title":"2018 Praha","original_name":"World Floorball Championships","start_date":"2018-12-01","end_date":"2018-12-09","logo":"https:\/\/www.dsg-images.com\/comps\/200x200\/2118.png","last_updated":"2019-02-01 13:42:01","rounds":{"round_id":"26252","name":"Group Stage","start_date":"2018-12-01","end_date":"2018-12-09","type":"table","last_updated":"2018-12-11 01:17:40","group":[{"group_id":"6813","name":"Group A","last_updated":"2018-12-11 01:19:21","total":{"table":[{"position":"1","team_id":"38661","team_name":"Switzerland","short_name":"Switzerland","original_team_name":"Switzerland","zone":"Next Round","zone_id":"next_round","prev_season":"","form":"L,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"2","matches_draw":"0","matches_lost":"1","goals_for":"24","goals_against":"10","goals_difference":"14","points":"4"},{"position":"2","team_id":"38662","team_name":"Czech Republic","short_name":"Czech Republic","original_team_name":"Czech Republic","zone":"Next Round","zone_id":"next_round","prev_season":"","form":"W,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"2","matches_draw":"0","matches_lost":"1","goals_for":"19","goals_against":"13","goals_difference":"6","points":"4"},{"position":"3","team_id":"38663","team_name":"Latvia","short_name":"Latvia","original_team_name":"Latvia","zone":"Playoff","zone_id":"playoff","prev_season":"","form":"L,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"1","matches_draw":"0","matches_lost":"2","goals_for":"11","goals_against":"15","goals_difference":"-4","points":"2"},{"position":"4","team_id":"38664","team_name":"Germany","short_name":"Germany","original_team_name":"Germany","zone":"Playoff","zone_id":"playoff","prev_season":"","form":"W,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"1","matches_draw":"0","matches_lost":"2","goals_for":"11","goals_against":"27","goals_difference":"-16","points":"2"}]},"home":{"table":[{"position":"1","team_id":"38661","team_name":"Switzerland","short_name":"Switzerland","original_team_name":"Switzerland","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"2","team_id":"38662","team_name":"Czech Republic","short_name":"Czech Republic","original_team_name":"Czech Republic","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"3","team_id":"38663","team_name":"Latvia","short_name":"Latvia","original_team_name":"Latvia","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"4","team_id":"38664","team_name":"Germany","short_name":"Germany","original_team_name":"Germany","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"}]},"away":{"table":[{"position":"1","team_id":"38661","team_name":"Switzerland","short_name":"Switzerland","original_team_name":"Switzerland","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"2","team_id":"38662","team_name":"Czech Republic","short_name":"Czech Republic","original_team_name":"Czech Republic","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"3","team_id":"38663","team_name":"Latvia","short_name":"Latvia","original_team_name":"Latvia","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"4","team_id":"38664","team_name":"Germany","short_name":"Germany","original_team_name":"Germany","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"}]}},{"group_id":"6814","name":"Group B","last_updated":"2018-12-11 01:19:21","total":{"table":[{"position":"1","team_id":"38665","team_name":"Sweden","short_name":"Sweden","original_team_name":"Sweden","zone":"Next Round","zone_id":"next_round","prev_season":"","form":"W,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"3","matches_draw":"0","matches_lost":"0","goals_for":"39","goals_against":"5","goals_difference":"34","points":"6"},{"position":"2","team_id":"38666","team_name":"Finland","short_name":"Finland","original_team_name":"Finland","zone":"Next Round","zone_id":"next_round","prev_season":"","form":"W,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"2","matches_draw":"0","matches_lost":"1","goals_for":"20","goals_against":"7","goals_difference":"13","points":"4"},{"position":"3","team_id":"38667","team_name":"Norway","short_name":"Norway","original_team_name":"Norway","zone":"Playoff","zone_id":"playoff","prev_season":"","form":"L,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"1","matches_draw":"0","matches_lost":"2","goals_for":"11","goals_against":"21","goals_difference":"-10","points":"2"},{"position":"4","team_id":"38668","team_name":"Denmark","short_name":"Denmark","original_team_name":"Denmark","zone":"Playoff","zone_id":"playoff","prev_season":"","form":"L,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"0","matches_draw":"0","matches_lost":"3","goals_for":"4","goals_against":"41","goals_difference":"-37","points":"0"}]},"home":{"table":[{"position":"1","team_id":"38665","team_name":"Sweden","short_name":"Sweden","original_team_name":"Sweden","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"2","team_id":"38666","team_name":"Finland","short_name":"Finland","original_team_name":"Finland","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"3","team_id":"38667","team_name":"Norway","short_name":"Norway","original_team_name":"Norway","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"4","team_id":"38668","team_name":"Denmark","short_name":"Denmark","original_team_name":"Denmark","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"}]},"away":{"table":[{"position":"1","team_id":"38665","team_name":"Sweden","short_name":"Sweden","original_team_name":"Sweden","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"2","team_id":"38666","team_name":"Finland","short_name":"Finland","original_team_name":"Finland","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"3","team_id":"38667","team_name":"Norway","short_name":"Norway","original_team_name":"Norway","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"4","team_id":"38668","team_name":"Denmark","short_name":"Denmark","original_team_name":"Denmark","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"}]}},{"group_id":"6815","name":"Group C","last_updated":"2018-12-11 01:19:21","total":{"table":[{"position":"1","team_id":"38670","team_name":"Estonia","short_name":"Estonia","original_team_name":"Estonia","zone":"Playoff","zone_id":"playoff","prev_season":"","form":"W,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"3","matches_draw":"0","matches_lost":"0","goals_for":"26","goals_against":"12","goals_difference":"14","points":"6"},{"position":"2","team_id":"38669","team_name":"Australia","short_name":"Australia","original_team_name":"Australia","zone":"Playoff","zone_id":"playoff","prev_season":"","form":"W,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"2","matches_draw":"0","matches_lost":"1","goals_for":"13","goals_against":"16","goals_difference":"-3","points":"4"},{"position":"3","team_id":"38671","team_name":"Poland","short_name":"Poland","original_team_name":"Poland","zone":"","zone_id":"","prev_season":"","form":"L,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"1","matches_draw":"0","matches_lost":"2","goals_for":"10","goals_against":"10","goals_difference":"0","points":"2"},{"position":"4","team_id":"38672","team_name":"Thailand","short_name":"Thailand","original_team_name":"Thailand","zone":"","zone_id":"","prev_season":"","form":"L,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"0","matches_draw":"0","matches_lost":"3","goals_for":"9","goals_against":"20","goals_difference":"-11","points":"0"}]},"home":{"table":[{"position":"1","team_id":"38669","team_name":"Australia","short_name":"Australia","original_team_name":"Australia","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"2","team_id":"38670","team_name":"Estonia","short_name":"Estonia","original_team_name":"Estonia","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"3","team_id":"38671","team_name":"Poland","short_name":"Poland","original_team_name":"Poland","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"4","team_id":"38672","team_name":"Thailand","short_name":"Thailand","original_team_name":"Thailand","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"}]},"away":{"table":[{"position":"1","team_id":"38669","team_name":"Australia","short_name":"Australia","original_team_name":"Australia","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"2","team_id":"38670","team_name":"Estonia","short_name":"Estonia","original_team_name":"Estonia","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"3","team_id":"38671","team_name":"Poland","short_name":"Poland","original_team_name":"Poland","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"4","team_id":"38672","team_name":"Thailand","short_name":"Thailand","original_team_name":"Thailand","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"}]}},{"group_id":"6816","name":"Group D","last_updated":"2018-12-11 01:19:21","total":{"table":[{"position":"1","team_id":"38674","team_name":"Slovakia","short_name":"Slovakia","original_team_name":"Slovakia","zone":"Playoff","zone_id":"playoff","prev_season":"","form":"W,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"3","matches_draw":"0","matches_lost":"0","goals_for":"45","goals_against":"6","goals_difference":"39","points":"6"},{"position":"2","team_id":"38673","team_name":"Canada","short_name":"Canada","original_team_name":"Canada","zone":"Playoff","zone_id":"playoff","prev_season":"","form":"W,D,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"1","matches_draw":"1","matches_lost":"1","goals_for":"21","goals_against":"18","goals_difference":"3","points":"3"},{"position":"3","team_id":"38675","team_name":"Singapore","short_name":"Singapore","original_team_name":"Singapore","zone":"","zone_id":"","prev_season":"","form":"L,W,D","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"1","matches_draw":"1","matches_lost":"1","goals_for":"15","goals_against":"27","goals_difference":"-12","points":"3"},{"position":"4","team_id":"38676","team_name":"Japan","short_name":"Japan","original_team_name":"Japan","zone":"","zone_id":"","prev_season":"","form":"L,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_played":"3","matches_won":"0","matches_draw":"0","matches_lost":"3","goals_for":"8","goals_against":"38","goals_difference":"-30","points":"0"}]},"home":{"table":[{"position":"1","team_id":"38673","team_name":"Canada","short_name":"Canada","original_team_name":"Canada","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"2","team_id":"38674","team_name":"Slovakia","short_name":"Slovakia","original_team_name":"Slovakia","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"3","team_id":"38675","team_name":"Singapore","short_name":"Singapore","original_team_name":"Singapore","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"4","team_id":"38676","team_name":"Japan","short_name":"Japan","original_team_name":"Japan","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"}]},"away":{"table":[{"position":"1","team_id":"38673","team_name":"Canada","short_name":"Canada","original_team_name":"Canada","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"2","team_id":"38674","team_name":"Slovakia","short_name":"Slovakia","original_team_name":"Slovakia","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"3","team_id":"38675","team_name":"Singapore","short_name":"Singapore","original_team_name":"Singapore","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"},{"position":"4","team_id":"38676","team_name":"Japan","short_name":"Japan","original_team_name":"Japan","matches_played":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","goals_for":"0","goals_against":"0","goals_difference":"0","points":"0"}]}}]}}}}}