No Subscription to this function
GET /handball/get_tables
Returns the league, home & away tables per season or round.
Request URL
https://dsg-api.com/clients/{client_name}/handball/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
bonus_points
number of bonus points
form
performance of the last 5 matches in the particular round (W = win, D = draw, L = loss)
matches_draw
value for total draw 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
points
value for total points gained
position
current table position
prev_season
defines last season achievements ('C','CW','P','R')
run_difference
value for total run difference
score_against
value for total scores against
short_name
short name of the team.
team_id
Unique identifier for team.
team_name
current team name
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}/handball/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}/handball/get_tables?type={type}&id={id}&client={client_name}&authkey={client_authkey}"
response = requests.get("https://dsg-api.com/clients/{client_name}/handball/get_tables?type={type}&id={id}&client={client_name}&authkey={client_authkey}", auth=("User", "Password"))
Response Example
200 Success
{"datasportsgroup":{"version":"1.0","sport":"handball","lang":"en","method":{"method_id":"146","name":"get_tables"},"competition":{"competition_id":"1491","name":"Handball Bundesliga","teamtype":"male","type":"club","format":"domestic_league","area_id":"80","area_name":"Germany","last_updated":"2019-08-07 09:59:25","season":{"season_id":"17053","title":"2018\/2019","original_name":"DKB Handball Bundesliga","start_date":"2018-08-23","end_date":"2019-06-09","logo":"https:\/\/www.dsg-images.com\/comps\/200x200\/1491.png","last_updated":"2018-08-17 14:43:06","rounds":{"round_id":"22877","name":"Regular Season","start_date":"2018-08-23","end_date":"2019-06-09","type":"table","last_updated":"2018-07-02 22:38:23","total":{"table":[{"position":"1","team_id":"26512","team_name":"SG Flensburg-Handewitt","short_name":"Flensburg","original_team_name":"SG Flensburg-Handewitt","zone":"EHF Champions League","zone_id":"ehf_cl","prev_season":"Double","form":"W,W,W,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"32","matches_draw":"0","matches_lost":"2","score_for":"958","score_against":"768","score_difference":"190","points":"64"},{"position":"2","team_id":"26514","team_name":"THW Kiel","short_name":"THW Kiel","original_team_name":"THW Kiel","zone":"EHF Champions League","zone_id":"ehf_cl","prev_season":"","form":"W,W,W,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"31","matches_draw":"0","matches_lost":"3","score_for":"1018","score_against":"806","score_difference":"212","points":"62"},{"position":"3","team_id":"26506","team_name":"SC Magdeburg","short_name":"SC Magdeburg","original_team_name":"SC Magdeburg","zone":"EHF-Cup","zone_id":"ehf_cup","prev_season":"","form":"W,W,W,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"27","matches_draw":"0","matches_lost":"7","score_for":"1010","score_against":"867","score_difference":"143","points":"54"},{"position":"4","team_id":"26511","team_name":"Rhein-Neckar Löwen","short_name":"RN Löwen","original_team_name":"Rhein-Neckar Löwen","zone":"EHF-Cup","zone_id":"ehf_cup","prev_season":"Cup Winner","form":"L,L,L,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"24","matches_draw":"2","matches_lost":"8","score_for":"960","score_against":"851","score_difference":"109","points":"50"},{"position":"5","team_id":"26516","team_name":"MT Melsungen","short_name":"MT Melsungen","original_team_name":"MT Melsungen","zone":"EHF-Cup","zone_id":"ehf_cup","prev_season":"","form":"W,W,W,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"21","matches_draw":"0","matches_lost":"13","score_for":"922","score_against":"900","score_difference":"22","points":"42"},{"position":"6","team_id":"26505","team_name":"Füchse Berlin","short_name":"Füchse Berlin","original_team_name":"Füchse Berlin","zone":"","zone_id":"","prev_season":"","form":"L,L,W,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"19","matches_draw":"0","matches_lost":"15","score_for":"923","score_against":"898","score_difference":"25","points":"38"},{"position":"7","team_id":"26518","team_name":"Bergischer HC","short_name":"Bergischer HC","original_team_name":"Bergischer HC","zone":"","zone_id":"","prev_season":"Promotion","form":"L,W,L,D,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"18","matches_draw":"2","matches_lost":"14","score_for":"891","score_against":"880","score_difference":"11","points":"38"},{"position":"8","team_id":"26504","team_name":"FRISCH AUF! Göppingen","short_name":"FA Göppingen","original_team_name":"FRISCH AUF! Göppingen","zone":"","zone_id":"","prev_season":"","form":"L,W,L,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"17","matches_draw":"2","matches_lost":"15","score_for":"901","score_against":"899","score_difference":"2","points":"36"},{"position":"9","team_id":"32592","team_name":"HC Erlangen","short_name":"HC Erlangen","original_team_name":"HC Erlangen","zone":"","zone_id":"","prev_season":"","form":"W,L,L,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"14","matches_draw":"2","matches_lost":"18","score_for":"853","score_against":"882","score_difference":"-29","points":"30"},{"position":"10","team_id":"26509","team_name":"HSG Wetzlar","short_name":"HSG Wetzlar","original_team_name":"HSG Wetzlar","zone":"","zone_id":"","prev_season":"","form":"W,W,W,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"14","matches_draw":"1","matches_lost":"19","score_for":"859","score_against":"883","score_difference":"-24","points":"29"},{"position":"11","team_id":"26519","team_name":"SC DHfK Leipzig","short_name":"DHfK Leipzig","original_team_name":"SC DHfK Leipzig","zone":"","zone_id":"","prev_season":"","form":"W,L,W,W,D","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"12","matches_draw":"3","matches_lost":"19","score_for":"861","score_against":"871","score_difference":"-10","points":"27"},{"position":"12","team_id":"26513","team_name":"TBV Lemgo Lippe","short_name":"TBV Lemgo","original_team_name":"TBV Lemgo","zone":"","zone_id":"","prev_season":"","form":"L,L,L,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"11","matches_draw":"4","matches_lost":"19","score_for":"861","score_against":"885","score_difference":"-24","points":"26"},{"position":"13","team_id":"26515","team_name":"TSV Hannover-Burgdorf","short_name":"Hannover","original_team_name":"TSV Hannover-Burgdorf","zone":"","zone_id":"","prev_season":"","form":"L,W,L,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"12","matches_draw":"2","matches_lost":"20","score_for":"935","score_against":"960","score_difference":"-25","points":"26"},{"position":"14","team_id":"32591","team_name":"GWD Minden","short_name":"GWD Minden","original_team_name":"GWD Minden","zone":"","zone_id":"","prev_season":"","form":"L,L,L,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"12","matches_draw":"1","matches_lost":"21","score_for":"941","score_against":"976","score_difference":"-35","points":"25"},{"position":"15","team_id":"26520","team_name":"TVB 1898 Stuttgart","short_name":"TVB Stuttgart","original_team_name":"TVB 1898 Stuttgart","zone":"","zone_id":"","prev_season":"","form":"L,L,L,D,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"10","matches_draw":"3","matches_lost":"21","score_for":"912","score_against":"998","score_difference":"-86","points":"23"},{"position":"16","team_id":"32593","team_name":"Die Eulen Ludwigshafen","short_name":"Die Eulen","original_team_name":"Die Eulen Ludwigshafen","zone":"","zone_id":"","prev_season":"","form":"W,W,W,D,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"5","matches_draw":"4","matches_lost":"25","score_for":"802","score_against":"955","score_difference":"-153","points":"14"},{"position":"17","team_id":"26517","team_name":"VfL Gummersbach","short_name":"Gummersbach","original_team_name":"VfL Gummersbach","zone":"Relegation","zone_id":"relegation","prev_season":"","form":"D,L,L,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"6","matches_draw":"2","matches_lost":"26","score_for":"809","score_against":"963","score_difference":"-154","points":"14"},{"position":"18","team_id":"33052","team_name":"SG BBM Bietigheim","short_name":"BBM Bietigheim","original_team_name":"SG BBM Bietigheim","zone":"Relegation","zone_id":"relegation","prev_season":"Promotion","form":"D,L,W,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"34","matches_won":"6","matches_draw":"2","matches_lost":"26","score_for":"809","score_against":"983","score_difference":"-174","points":"14"}]},"home":{"table":[{"position":"1","team_id":"26512","team_name":"SG Flensburg-Handewitt","short_name":"Flensburg","original_team_name":"SG Flensburg-Handewitt","matches_total":"17","matches_won":"17","matches_draw":"0","matches_lost":"0","score_for":"491","score_against":"384","score_difference":"107","points":"34"},{"position":"2","team_id":"26514","team_name":"THW Kiel","short_name":"THW Kiel","original_team_name":"THW Kiel","matches_total":"17","matches_won":"16","matches_draw":"0","matches_lost":"1","score_for":"513","score_against":"382","score_difference":"131","points":"32"},{"position":"3","team_id":"26506","team_name":"SC Magdeburg","short_name":"SC Magdeburg","original_team_name":"SC Magdeburg","matches_total":"17","matches_won":"14","matches_draw":"0","matches_lost":"3","score_for":"521","score_against":"439","score_difference":"82","points":"28"},{"position":"4","team_id":"26511","team_name":"Rhein-Neckar Löwen","short_name":"RN Löwen","original_team_name":"Rhein-Neckar Löwen","matches_total":"17","matches_won":"13","matches_draw":"1","matches_lost":"3","score_for":"489","score_against":"414","score_difference":"75","points":"27"},{"position":"5","team_id":"26516","team_name":"MT Melsungen","short_name":"MT Melsungen","original_team_name":"MT Melsungen","matches_total":"17","matches_won":"12","matches_draw":"0","matches_lost":"5","score_for":"457","score_against":"427","score_difference":"30","points":"24"},{"position":"6","team_id":"26518","team_name":"Bergischer HC","short_name":"Bergischer HC","original_team_name":"Bergischer HC","matches_total":"17","matches_won":"12","matches_draw":"0","matches_lost":"5","score_for":"459","score_against":"431","score_difference":"28","points":"24"},{"position":"7","team_id":"26505","team_name":"Füchse Berlin","short_name":"Füchse Berlin","original_team_name":"Füchse Berlin","matches_total":"17","matches_won":"11","matches_draw":"0","matches_lost":"6","score_for":"470","score_against":"446","score_difference":"24","points":"22"},{"position":"8","team_id":"26519","team_name":"SC DHfK Leipzig","short_name":"DHfK Leipzig","original_team_name":"SC DHfK Leipzig","matches_total":"17","matches_won":"9","matches_draw":"2","matches_lost":"6","score_for":"447","score_against":"417","score_difference":"30","points":"20"},{"position":"9","team_id":"32592","team_name":"HC Erlangen","short_name":"HC Erlangen","original_team_name":"HC Erlangen","matches_total":"17","matches_won":"9","matches_draw":"2","matches_lost":"6","score_for":"435","score_against":"416","score_difference":"19","points":"20"},{"position":"10","team_id":"26513","team_name":"TBV Lemgo Lippe","short_name":"TBV Lemgo","original_team_name":"TBV Lemgo","matches_total":"17","matches_won":"8","matches_draw":"2","matches_lost":"7","score_for":"452","score_against":"426","score_difference":"26","points":"18"},{"position":"11","team_id":"26515","team_name":"TSV Hannover-Burgdorf","short_name":"Hannover","original_team_name":"TSV Hannover-Burgdorf","matches_total":"17","matches_won":"8","matches_draw":"1","matches_lost":"8","score_for":"478","score_against":"473","score_difference":"5","points":"17"},{"position":"12","team_id":"26504","team_name":"FRISCH AUF! Göppingen","short_name":"FA Göppingen","original_team_name":"FRISCH AUF! Göppingen","matches_total":"17","matches_won":"8","matches_draw":"1","matches_lost":"8","score_for":"448","score_against":"443","score_difference":"5","points":"17"},{"position":"13","team_id":"26509","team_name":"HSG Wetzlar","short_name":"HSG Wetzlar","original_team_name":"HSG Wetzlar","matches_total":"17","matches_won":"8","matches_draw":"0","matches_lost":"9","score_for":"445","score_against":"444","score_difference":"1","points":"16"},{"position":"14","team_id":"32591","team_name":"GWD Minden","short_name":"GWD Minden","original_team_name":"GWD Minden","matches_total":"17","matches_won":"7","matches_draw":"0","matches_lost":"10","score_for":"497","score_against":"484","score_difference":"13","points":"14"},{"position":"15","team_id":"26520","team_name":"TVB 1898 Stuttgart","short_name":"TVB Stuttgart","original_team_name":"TVB 1898 Stuttgart","matches_total":"17","matches_won":"6","matches_draw":"2","matches_lost":"9","score_for":"479","score_against":"501","score_difference":"-22","points":"14"},{"position":"16","team_id":"26517","team_name":"VfL Gummersbach","short_name":"Gummersbach","original_team_name":"VfL Gummersbach","matches_total":"17","matches_won":"5","matches_draw":"1","matches_lost":"11","score_for":"403","score_against":"452","score_difference":"-49","points":"11"},{"position":"17","team_id":"33052","team_name":"SG BBM Bietigheim","short_name":"BBM Bietigheim","original_team_name":"SG BBM Bietigheim","matches_total":"17","matches_won":"4","matches_draw":"2","matches_lost":"11","score_for":"412","score_against":"487","score_difference":"-75","points":"10"},{"position":"18","team_id":"32593","team_name":"Die Eulen Ludwigshafen","short_name":"Die Eulen","original_team_name":"Die Eulen Ludwigshafen","matches_total":"17","matches_won":"4","matches_draw":"1","matches_lost":"12","score_for":"402","score_against":"461","score_difference":"-59","points":"9"}]},"away":{"table":[{"position":"1","team_id":"26512","team_name":"SG Flensburg-Handewitt","short_name":"Flensburg","original_team_name":"SG Flensburg-Handewitt","matches_total":"17","matches_won":"15","matches_draw":"0","matches_lost":"2","score_for":"467","score_against":"384","score_difference":"83","points":"30"},{"position":"2","team_id":"26514","team_name":"THW Kiel","short_name":"THW Kiel","original_team_name":"THW Kiel","matches_total":"17","matches_won":"15","matches_draw":"0","matches_lost":"2","score_for":"505","score_against":"424","score_difference":"81","points":"30"},{"position":"3","team_id":"26506","team_name":"SC Magdeburg","short_name":"SC Magdeburg","original_team_name":"SC Magdeburg","matches_total":"17","matches_won":"13","matches_draw":"0","matches_lost":"4","score_for":"489","score_against":"428","score_difference":"61","points":"26"},{"position":"4","team_id":"26511","team_name":"Rhein-Neckar Löwen","short_name":"RN Löwen","original_team_name":"Rhein-Neckar Löwen","matches_total":"17","matches_won":"11","matches_draw":"1","matches_lost":"5","score_for":"471","score_against":"437","score_difference":"34","points":"23"},{"position":"5","team_id":"26504","team_name":"FRISCH AUF! Göppingen","short_name":"FA Göppingen","original_team_name":"FRISCH AUF! Göppingen","matches_total":"17","matches_won":"9","matches_draw":"1","matches_lost":"7","score_for":"453","score_against":"456","score_difference":"-3","points":"19"},{"position":"6","team_id":"26516","team_name":"MT Melsungen","short_name":"MT Melsungen","original_team_name":"MT Melsungen","matches_total":"17","matches_won":"9","matches_draw":"0","matches_lost":"8","score_for":"465","score_against":"473","score_difference":"-8","points":"18"},{"position":"7","team_id":"26505","team_name":"Füchse Berlin","short_name":"Füchse Berlin","original_team_name":"Füchse Berlin","matches_total":"17","matches_won":"8","matches_draw":"0","matches_lost":"9","score_for":"453","score_against":"452","score_difference":"1","points":"16"},{"position":"8","team_id":"26518","team_name":"Bergischer HC","short_name":"Bergischer HC","original_team_name":"Bergischer HC","matches_total":"17","matches_won":"6","matches_draw":"2","matches_lost":"9","score_for":"432","score_against":"449","score_difference":"-17","points":"14"},{"position":"9","team_id":"26509","team_name":"HSG Wetzlar","short_name":"HSG Wetzlar","original_team_name":"HSG Wetzlar","matches_total":"17","matches_won":"6","matches_draw":"1","matches_lost":"10","score_for":"414","score_against":"439","score_difference":"-25","points":"13"},{"position":"10","team_id":"32591","team_name":"GWD Minden","short_name":"GWD Minden","original_team_name":"GWD Minden","matches_total":"17","matches_won":"5","matches_draw":"1","matches_lost":"11","score_for":"444","score_against":"492","score_difference":"-48","points":"11"},{"position":"11","team_id":"32592","team_name":"HC Erlangen","short_name":"HC Erlangen","original_team_name":"HC Erlangen","matches_total":"17","matches_won":"5","matches_draw":"0","matches_lost":"12","score_for":"418","score_against":"466","score_difference":"-48","points":"10"},{"position":"12","team_id":"26515","team_name":"TSV Hannover-Burgdorf","short_name":"Hannover","original_team_name":"TSV Hannover-Burgdorf","matches_total":"17","matches_won":"4","matches_draw":"1","matches_lost":"12","score_for":"457","score_against":"487","score_difference":"-30","points":"9"},{"position":"13","team_id":"26520","team_name":"TVB 1898 Stuttgart","short_name":"TVB Stuttgart","original_team_name":"TVB 1898 Stuttgart","matches_total":"17","matches_won":"4","matches_draw":"1","matches_lost":"12","score_for":"433","score_against":"497","score_difference":"-64","points":"9"},{"position":"14","team_id":"26513","team_name":"TBV Lemgo Lippe","short_name":"TBV Lemgo","original_team_name":"TBV Lemgo","matches_total":"17","matches_won":"3","matches_draw":"2","matches_lost":"12","score_for":"409","score_against":"459","score_difference":"-50","points":"8"},{"position":"15","team_id":"26519","team_name":"SC DHfK Leipzig","short_name":"DHfK Leipzig","original_team_name":"SC DHfK Leipzig","matches_total":"17","matches_won":"3","matches_draw":"1","matches_lost":"13","score_for":"414","score_against":"454","score_difference":"-40","points":"7"},{"position":"16","team_id":"32593","team_name":"Die Eulen Ludwigshafen","short_name":"Die Eulen","original_team_name":"Die Eulen Ludwigshafen","matches_total":"17","matches_won":"1","matches_draw":"3","matches_lost":"13","score_for":"400","score_against":"494","score_difference":"-94","points":"5"},{"position":"17","team_id":"33052","team_name":"SG BBM Bietigheim","short_name":"BBM Bietigheim","original_team_name":"SG BBM Bietigheim","matches_total":"17","matches_won":"2","matches_draw":"0","matches_lost":"15","score_for":"397","score_against":"496","score_difference":"-99","points":"4"},{"position":"18","team_id":"26517","team_name":"VfL Gummersbach","short_name":"Gummersbach","original_team_name":"VfL Gummersbach","matches_total":"17","matches_won":"1","matches_draw":"1","matches_lost":"15","score_for":"406","score_against":"511","score_difference":"-105","points":"3"}]}}}}}}