No Subscription to this function
GET /field_hockey/get_tables
Returns the league, home & away tables per season or round.
Request URL
https://dsg-api.com/clients/{client_name}/field_hockey/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).
datasportsgroup
details about the API version, sport, language and generation timestamp
generated_utc
UTC timestamp when the API output was generated
lang
language of the API
sport
sport of the API
version
version of the API
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
form
performance of the last 5 matches in the particular round (W = win, D = draw, L = loss)
matches_draw
value for total drawn matches
matches_lost
value for total lost matches
matches_total
value for total played matches
matches_won
value for total won matches
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
position
current table position
prev_season
defines last season achievements ('C','CW','P','R')
score_against
value for total scores against
score_for
value for total scores made
score_percentage
percentage value of scores_for vs 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
Too Many Requests
Code Samples
<?php
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "https://dsg-api.com/clients/{client_name}/field_hockey/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}/field_hockey/get_tables?type={type}&id={id}&client={client_name}&authkey={client_authkey}"
response = requests.get("https://dsg-api.com/clients/{client_name}/field_hockey/get_tables?type={type}&id={id}&client={client_name}&authkey={client_authkey}", auth=("User", "Password"))
Response Example
200 Success
{"datasportsgroup":{"version":"1.0","sport":"field_hockey","lang":"en","method":{"method_id":"205","name":"get_tables"},"competition":{"competition_id":"1958","name":"Hockey Champions Trophy","teamtype":"male","type":"international","format":"international_cup","area_id":"1","area_name":"World","last_updated":"2018-09-08 11:55:41","season":{"season_id":"16921","title":"2018 Netherlands","original_name":"Rabobank Hockey Champions Trophy","start_date":"2018-06-23","end_date":"2018-07-01","logo":"https:\/\/www.dsg-images.com\/comps\/200x200\/1958.png","last_updated":"2018-06-23 00:32:00","rounds":{"round_id":"22620","name":"Final Round","start_date":"2018-06-23","end_date":"2018-06-30","type":"table","last_updated":"2018-06-23 11:10:22","total":{"table":[{"position":"1","team_id":"36640","team_name":"Australia","short_name":"Australia","original_team_name":"Australia","zone":"Final","zone_id":"final","prev_season":"","form":"L,W,W,W,D","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"5","matches_won":"3","matches_draw":"1","matches_lost":"1","score_for":"13","score_against":"10","score_difference":"3","points":"10"},{"position":"2","team_id":"36651","team_name":"India","short_name":"India","original_team_name":"India","zone":"Final","zone_id":"final","prev_season":"","form":"D,D,L,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"5","matches_won":"2","matches_draw":"2","matches_lost":"1","score_for":"10","score_against":"6","score_difference":"4","points":"8"},{"position":"3","team_id":"36646","team_name":"Netherlands","short_name":"Netherlands","original_team_name":"Netherlands","zone":"3rd Place","zone_id":"third_place","prev_season":"","form":"D,L,W,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"5","matches_won":"2","matches_draw":"1","matches_lost":"2","score_for":"13","score_against":"7","score_difference":"6","points":"7"},{"position":"4","team_id":"36644","team_name":"Argentina","short_name":"Argentina","original_team_name":"Argentina","zone":"3rd Place","zone_id":"third_place","prev_season":"","form":"W,L,D,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"5","matches_won":"2","matches_draw":"1","matches_lost":"2","score_for":"8","score_against":"10","score_difference":"-2","points":"7"},{"position":"5","team_id":"36648","team_name":"Belgium","short_name":"Belgium","original_team_name":"Belgium","zone":"5th Place","zone_id":"fifth_place","prev_season":"","form":"W,D,D,L,D","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"5","matches_won":"1","matches_draw":"3","matches_lost":"1","score_for":"10","score_against":"13","score_difference":"-3","points":"6"},{"position":"6","team_id":"36643","team_name":"Pakistan","short_name":"Pakistan","original_team_name":"Pakistan","zone":"5th Place","zone_id":"fifth_place","prev_season":"","form":"L,W,L,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"5","matches_won":"1","matches_draw":"0","matches_lost":"4","score_for":"7","score_against":"15","score_difference":"-8","points":"3"}]},"home":{"table":[{"position":"1","team_id":"36646","team_name":"Netherlands","short_name":"Netherlands","original_team_name":"Netherlands","matches_total":"5","matches_won":"2","matches_draw":"1","matches_lost":"2","score_for":"13","score_against":"7","score_difference":"6","points":"7"},{"position":"2","team_id":"36651","team_name":"India","short_name":"India","original_team_name":"India","matches_total":"4","matches_won":"2","matches_draw":"1","matches_lost":"1","score_for":"9","score_against":"5","score_difference":"4","points":"7"},{"position":"3","team_id":"36640","team_name":"Australia","short_name":"Australia","original_team_name":"Australia","matches_total":"2","matches_won":"1","matches_draw":"1","matches_lost":"0","score_for":"5","score_against":"4","score_difference":"1","points":"4"},{"position":"4","team_id":"36644","team_name":"Argentina","short_name":"Argentina","original_team_name":"Argentina","matches_total":"3","matches_won":"1","matches_draw":"1","matches_lost":"1","score_for":"5","score_against":"7","score_difference":"-2","points":"4"},{"position":"5","team_id":"36648","team_name":"Belgium","short_name":"Belgium","original_team_name":"Belgium","matches_total":"1","matches_won":"1","matches_draw":"0","matches_lost":"0","score_for":"4","score_against":"2","score_difference":"2","points":"3"},{"position":"6","team_id":"36643","team_name":"Pakistan","short_name":"Pakistan","original_team_name":"Pakistan","matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}]},"away":{"table":[{"position":"1","team_id":"36640","team_name":"Australia","short_name":"Australia","original_team_name":"Australia","matches_total":"3","matches_won":"2","matches_draw":"0","matches_lost":"1","score_for":"8","score_against":"6","score_difference":"2","points":"6"},{"position":"2","team_id":"36644","team_name":"Argentina","short_name":"Argentina","original_team_name":"Argentina","matches_total":"2","matches_won":"1","matches_draw":"0","matches_lost":"1","score_for":"3","score_against":"3","score_difference":"0","points":"3"},{"position":"3","team_id":"36648","team_name":"Belgium","short_name":"Belgium","original_team_name":"Belgium","matches_total":"4","matches_won":"0","matches_draw":"3","matches_lost":"1","score_for":"6","score_against":"11","score_difference":"-5","points":"3"},{"position":"4","team_id":"36643","team_name":"Pakistan","short_name":"Pakistan","original_team_name":"Pakistan","matches_total":"5","matches_won":"1","matches_draw":"0","matches_lost":"4","score_for":"7","score_against":"15","score_difference":"-8","points":"3"},{"position":"5","team_id":"36651","team_name":"India","short_name":"India","original_team_name":"India","matches_total":"1","matches_won":"0","matches_draw":"1","matches_lost":"0","score_for":"1","score_against":"1","score_difference":"0","points":"1"},{"position":"6","team_id":"36646","team_name":"Netherlands","short_name":"Netherlands","original_team_name":"Netherlands","matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}]}}}}}}