No Subscription to this function
GET /australian_football/get_tables
Returns the league, home & away tables per season or round.
Request URL
https://dsg-api.com/clients/{client_name}/australian_football/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}/australian_football/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}/australian_football/get_tables?type={type}&id={id}&client={client_name}&authkey={client_authkey}"
response = requests.get("https://dsg-api.com/clients/{client_name}/australian_football/get_tables?type={type}&id={id}&client={client_name}&authkey={client_authkey}", auth=("User", "Password"))
Response Example
200 Success
{"datasportsgroup":{"version":"1.0","sport":"australian_football","lang":"en","method":{"method_id":"187","name":"get_tables"},"competition":{"competition_id":"1522","name":"AFL","teamtype":"male","type":"club","format":"domestic_league","area_id":"19","area_name":"Australia","last_updated":"2018-06-08 00:40:13","season":{"season_id":"14450","title":"2018","original_name":"Toyota AFL Premiership","start_date":"2018-03-01","end_date":"2018-10-01","logo":"https:\/\/www.dsg-images.com\/comps\/200x200\/1522_1.png","last_updated":"2019-01-03 22:54:40","rounds":{"round_id":"17101","name":"Regular Season","start_date":"2018-03-23","end_date":"2018-08-27","type":"table","last_updated":"2017-11-29 13:55:57","total":{"table":[{"position":"1","team_id":"25521","team_name":"Richmond FC","short_name":"Richmond","original_team_name":"Richmond FC","zone":"Championship Playoffs","zone_id":"champ_playoffs","prev_season":"","form":"W,W,W,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"18","matches_draw":"0","matches_lost":"4","points":"72","score_for":"2143","score_against":"1574","score_difference":"569","score_percentage":"136.1"},{"position":"2","team_id":"25524","team_name":"West Coast Eagles","short_name":"West Coast Eag","original_team_name":"West Coast Eagles","zone":"Championship Playoffs","zone_id":"champ_playoffs","prev_season":"","form":"W,L,W,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"16","matches_draw":"0","matches_lost":"6","points":"64","score_for":"2012","score_against":"1657","score_difference":"355","score_percentage":"121.4"},{"position":"3","team_id":"25512","team_name":"Collingwood FC","short_name":"Collingwood","original_team_name":"Collingwood FC","zone":"Championship Playoffs","zone_id":"champ_playoffs","prev_season":"","form":"W,W,W,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"15","matches_draw":"0","matches_lost":"7","points":"60","score_for":"2046","score_against":"1699","score_difference":"347","score_percentage":"120.4"},{"position":"4","team_id":"25517","team_name":"Hawthorn FC","short_name":"Hawthorn","original_team_name":"Hawthorn FC","zone":"Championship Playoffs","zone_id":"champ_playoffs","prev_season":"","form":"W,W,W,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"15","matches_draw":"0","matches_lost":"7","points":"60","score_for":"1972","score_against":"1642","score_difference":"330","score_percentage":"120.1"},{"position":"5","team_id":"25518","team_name":"Melbourne FC","short_name":"Melbourne","original_team_name":"Melbourne FC","zone":"Championship Playoffs","zone_id":"champ_playoffs","prev_season":"","form":"W,W,L,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"14","matches_draw":"0","matches_lost":"8","points":"56","score_for":"2299","score_against":"1749","score_difference":"550","score_percentage":"131.4"},{"position":"6","team_id":"25523","team_name":"Sydney Swans FC","short_name":"Sydney Swans","original_team_name":"Sydney Swans FC","zone":"Championship Playoffs","zone_id":"champ_playoffs","prev_season":"","form":"L,W,W,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"14","matches_draw":"0","matches_lost":"8","points":"56","score_for":"1822","score_against":"1664","score_difference":"158","score_percentage":"109.5"},{"position":"7","team_id":"25526","team_name":"Greater Western Sydney","short_name":"Greater Wester","original_team_name":"Greater Western Sydney","zone":"Championship Playoffs","zone_id":"champ_playoffs","prev_season":"","form":"L,L,W,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"13","matches_draw":"1","matches_lost":"8","points":"54","score_for":"1898","score_against":"1661","score_difference":"237","score_percentage":"114.3"},{"position":"8","team_id":"25516","team_name":"Geelong FC","short_name":"Geelong","original_team_name":"Geelong FC","zone":"Championship Playoffs","zone_id":"champ_playoffs","prev_season":"","form":"W,W,L,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"13","matches_draw":"0","matches_lost":"9","points":"52","score_for":"2045","score_against":"1554","score_difference":"491","score_percentage":"131.6"},{"position":"9","team_id":"25519","team_name":"North Melbourne FC","short_name":"North Melbourn","original_team_name":"North Melbourne FC","zone":"","zone_id":"","prev_season":"","form":"W,L,L,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"12","matches_draw":"0","matches_lost":"10","points":"48","score_for":"1950","score_against":"1790","score_difference":"160","score_percentage":"108.9"},{"position":"10","team_id":"25520","team_name":"Port Adelaide FC","short_name":"Port Adelaide","original_team_name":"Port Adelaide FC","zone":"","zone_id":"","prev_season":"","form":"L,L,L,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"12","matches_draw":"0","matches_lost":"10","points":"48","score_for":"1780","score_against":"1654","score_difference":"126","score_percentage":"107.6"},{"position":"11","team_id":"25513","team_name":"Essendon FC","short_name":"Essendon","original_team_name":"Essendon FC","zone":"","zone_id":"","prev_season":"","form":"W,L,W,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"12","matches_draw":"0","matches_lost":"10","points":"48","score_for":"1932","score_against":"1838","score_difference":"94","score_percentage":"105.1"},{"position":"12","team_id":"25509","team_name":"Adelaide FC","short_name":"Adelaide","original_team_name":"Adelaide FC","zone":"","zone_id":"","prev_season":"","form":"W,W,L,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"12","matches_draw":"0","matches_lost":"10","points":"48","score_for":"1941","score_against":"1865","score_difference":"76","score_percentage":"104.1"},{"position":"13","team_id":"25525","team_name":"Western Bulldogs","short_name":"Western Bulld","original_team_name":"Western Bulldogs","zone":"","zone_id":"","prev_season":"","form":"L,W,W,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"8","matches_draw":"0","matches_lost":"14","points":"32","score_for":"1575","score_against":"2037","score_difference":"-462","score_percentage":"77.3"},{"position":"14","team_id":"25514","team_name":"Fremantle FC","short_name":"Fremantle","original_team_name":"Fremantle FC","zone":"","zone_id":"","prev_season":"","form":"L,L,W,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"8","matches_draw":"0","matches_lost":"14","points":"32","score_for":"1556","score_against":"2041","score_difference":"-485","score_percentage":"76.2"},{"position":"15","team_id":"25510","team_name":"Brisbane Lions AFC","short_name":"Brisbane Lions","original_team_name":"Brisbane Lions AFC","zone":"","zone_id":"","prev_season":"","form":"L,W,L,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"5","matches_draw":"0","matches_lost":"17","points":"20","score_for":"1825","score_against":"2049","score_difference":"-224","score_percentage":"89.1"},{"position":"16","team_id":"25522","team_name":"St Kilda FC","short_name":"St Kilda","original_team_name":"St Kilda FC","zone":"","zone_id":"","prev_season":"","form":"L,L,L,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"4","matches_draw":"1","matches_lost":"17","points":"18","score_for":"1606","score_against":"2125","score_difference":"-519","score_percentage":"75.6"},{"position":"17","team_id":"25515","team_name":"Gold Coast FC","short_name":"Gold Coast","original_team_name":"Gold Coast FC","zone":"","zone_id":"","prev_season":"","form":"L,L,L,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"4","matches_draw":"0","matches_lost":"18","points":"16","score_for":"1308","score_against":"2182","score_difference":"-874","score_percentage":"59.9"},{"position":"18","team_id":"25511","team_name":"Carlton FC","short_name":"Carlton","original_team_name":"Carlton FC","zone":"","zone_id":"","prev_season":"","form":"L,L,L,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"22","matches_won":"2","matches_draw":"0","matches_lost":"20","points":"8","score_for":"1353","score_against":"2282","score_difference":"-929","score_percentage":"59.3"}]},"home":{"table":[{"position":"1","team_id":"25521","team_name":"Richmond FC","short_name":"Richmond","original_team_name":"Richmond FC","matches_total":"11","matches_won":"11","matches_draw":"0","matches_lost":"0","points":"44","score_for":"1113","score_against":"761","score_difference":"352","score_percentage":"146.3"},{"position":"2","team_id":"25516","team_name":"Geelong FC","short_name":"Geelong","original_team_name":"Geelong FC","matches_total":"11","matches_won":"8","matches_draw":"0","matches_lost":"3","points":"32","score_for":"1136","score_against":"720","score_difference":"416","score_percentage":"157.8"},{"position":"3","team_id":"25526","team_name":"Greater Western Sydney","short_name":"Greater Wester","original_team_name":"Greater Western Sydney","matches_total":"11","matches_won":"8","matches_draw":"0","matches_lost":"3","points":"32","score_for":"973","score_against":"746","score_difference":"227","score_percentage":"130.4"},{"position":"4","team_id":"25517","team_name":"Hawthorn FC","short_name":"Hawthorn","original_team_name":"Hawthorn FC","matches_total":"11","matches_won":"8","matches_draw":"0","matches_lost":"3","points":"32","score_for":"927","score_against":"720","score_difference":"207","score_percentage":"128.8"},{"position":"5","team_id":"25524","team_name":"West Coast Eagles","short_name":"West Coast Eag","original_team_name":"West Coast Eagles","matches_total":"11","matches_won":"8","matches_draw":"0","matches_lost":"3","points":"32","score_for":"1124","score_against":"878","score_difference":"246","score_percentage":"128.0"},{"position":"6","team_id":"25509","team_name":"Adelaide FC","short_name":"Adelaide","original_team_name":"Adelaide FC","matches_total":"11","matches_won":"8","matches_draw":"0","matches_lost":"3","points":"32","score_for":"1014","score_against":"878","score_difference":"136","score_percentage":"115.5"},{"position":"7","team_id":"25519","team_name":"North Melbourne FC","short_name":"North Melbourn","original_team_name":"North Melbourne FC","matches_total":"11","matches_won":"7","matches_draw":"0","matches_lost":"4","points":"28","score_for":"1062","score_against":"778","score_difference":"284","score_percentage":"136.5"},{"position":"8","team_id":"25512","team_name":"Collingwood FC","short_name":"Collingwood","original_team_name":"Collingwood FC","matches_total":"11","matches_won":"7","matches_draw":"0","matches_lost":"4","points":"28","score_for":"1018","score_against":"820","score_difference":"198","score_percentage":"124.1"},{"position":"9","team_id":"25520","team_name":"Port Adelaide FC","short_name":"Port Adelaide","original_team_name":"Port Adelaide FC","matches_total":"11","matches_won":"7","matches_draw":"0","matches_lost":"4","points":"28","score_for":"922","score_against":"827","score_difference":"95","score_percentage":"111.5"},{"position":"10","team_id":"25513","team_name":"Essendon FC","short_name":"Essendon","original_team_name":"Essendon FC","matches_total":"11","matches_won":"7","matches_draw":"0","matches_lost":"4","points":"28","score_for":"988","score_against":"934","score_difference":"54","score_percentage":"105.8"},{"position":"11","team_id":"25518","team_name":"Melbourne FC","short_name":"Melbourne","original_team_name":"Melbourne FC","matches_total":"11","matches_won":"6","matches_draw":"0","matches_lost":"5","points":"24","score_for":"1171","score_against":"900","score_difference":"271","score_percentage":"130.1"},{"position":"12","team_id":"25514","team_name":"Fremantle FC","short_name":"Fremantle","original_team_name":"Fremantle FC","matches_total":"11","matches_won":"6","matches_draw":"0","matches_lost":"5","points":"24","score_for":"857","score_against":"875","score_difference":"-18","score_percentage":"97.9"},{"position":"13","team_id":"25523","team_name":"Sydney Swans FC","short_name":"Sydney Swans","original_team_name":"Sydney Swans FC","matches_total":"11","matches_won":"5","matches_draw":"0","matches_lost":"6","points":"20","score_for":"859","score_against":"817","score_difference":"42","score_percentage":"105.1"},{"position":"14","team_id":"25525","team_name":"Western Bulldogs","short_name":"Western Bulld","original_team_name":"Western Bulldogs","matches_total":"11","matches_won":"5","matches_draw":"0","matches_lost":"6","points":"20","score_for":"843","score_against":"992","score_difference":"-149","score_percentage":"85.0"},{"position":"15","team_id":"25522","team_name":"St Kilda FC","short_name":"St Kilda","original_team_name":"St Kilda FC","matches_total":"11","matches_won":"2","matches_draw":"1","matches_lost":"8","points":"10","score_for":"840","score_against":"1054","score_difference":"-214","score_percentage":"79.7"},{"position":"16","team_id":"25510","team_name":"Brisbane Lions AFC","short_name":"Brisbane Lions","original_team_name":"Brisbane Lions AFC","matches_total":"11","matches_won":"2","matches_draw":"0","matches_lost":"9","points":"8","score_for":"965","score_against":"983","score_difference":"-18","score_percentage":"98.2"},{"position":"17","team_id":"25515","team_name":"Gold Coast FC","short_name":"Gold Coast","original_team_name":"Gold Coast FC","matches_total":"11","matches_won":"1","matches_draw":"0","matches_lost":"10","points":"4","score_for":"636","score_against":"1040","score_difference":"-404","score_percentage":"61.2"},{"position":"18","team_id":"25511","team_name":"Carlton FC","short_name":"Carlton","original_team_name":"Carlton FC","matches_total":"11","matches_won":"1","matches_draw":"0","matches_lost":"10","points":"4","score_for":"676","score_against":"1216","score_difference":"-540","score_percentage":"55.6"}]},"away":{"table":[{"position":"1","team_id":"25523","team_name":"Sydney Swans FC","short_name":"Sydney Swans","original_team_name":"Sydney Swans FC","matches_total":"11","matches_won":"9","matches_draw":"0","matches_lost":"2","points":"36","score_for":"963","score_against":"847","score_difference":"116","score_percentage":"113.7"},{"position":"2","team_id":"25518","team_name":"Melbourne FC","short_name":"Melbourne","original_team_name":"Melbourne FC","matches_total":"11","matches_won":"8","matches_draw":"0","matches_lost":"3","points":"32","score_for":"1128","score_against":"849","score_difference":"279","score_percentage":"132.9"},{"position":"3","team_id":"25512","team_name":"Collingwood FC","short_name":"Collingwood","original_team_name":"Collingwood FC","matches_total":"11","matches_won":"8","matches_draw":"0","matches_lost":"3","points":"32","score_for":"1028","score_against":"879","score_difference":"149","score_percentage":"117.0"},{"position":"4","team_id":"25524","team_name":"West Coast Eagles","short_name":"West Coast Eag","original_team_name":"West Coast Eagles","matches_total":"11","matches_won":"8","matches_draw":"0","matches_lost":"3","points":"32","score_for":"888","score_against":"779","score_difference":"109","score_percentage":"114.0"},{"position":"5","team_id":"25521","team_name":"Richmond FC","short_name":"Richmond","original_team_name":"Richmond FC","matches_total":"11","matches_won":"7","matches_draw":"0","matches_lost":"4","points":"28","score_for":"1030","score_against":"813","score_difference":"217","score_percentage":"126.7"},{"position":"6","team_id":"25517","team_name":"Hawthorn FC","short_name":"Hawthorn","original_team_name":"Hawthorn FC","matches_total":"11","matches_won":"7","matches_draw":"0","matches_lost":"4","points":"28","score_for":"1045","score_against":"922","score_difference":"123","score_percentage":"113.3"},{"position":"7","team_id":"25526","team_name":"Greater Western Sydney","short_name":"Greater Wester","original_team_name":"Greater Western Sydney","matches_total":"11","matches_won":"5","matches_draw":"1","matches_lost":"5","points":"22","score_for":"925","score_against":"915","score_difference":"10","score_percentage":"101.1"},{"position":"8","team_id":"25516","team_name":"Geelong FC","short_name":"Geelong","original_team_name":"Geelong FC","matches_total":"11","matches_won":"5","matches_draw":"0","matches_lost":"6","points":"20","score_for":"909","score_against":"834","score_difference":"75","score_percentage":"109.0"},{"position":"9","team_id":"25513","team_name":"Essendon FC","short_name":"Essendon","original_team_name":"Essendon FC","matches_total":"11","matches_won":"5","matches_draw":"0","matches_lost":"6","points":"20","score_for":"944","score_against":"904","score_difference":"40","score_percentage":"104.4"},{"position":"10","team_id":"25520","team_name":"Port Adelaide FC","short_name":"Port Adelaide","original_team_name":"Port Adelaide FC","matches_total":"11","matches_won":"5","matches_draw":"0","matches_lost":"6","points":"20","score_for":"858","score_against":"827","score_difference":"31","score_percentage":"103.7"},{"position":"11","team_id":"25519","team_name":"North Melbourne FC","short_name":"North Melbourn","original_team_name":"North Melbourne FC","matches_total":"11","matches_won":"5","matches_draw":"0","matches_lost":"6","points":"20","score_for":"888","score_against":"1012","score_difference":"-124","score_percentage":"87.7"},{"position":"12","team_id":"25509","team_name":"Adelaide FC","short_name":"Adelaide","original_team_name":"Adelaide FC","matches_total":"11","matches_won":"4","matches_draw":"0","matches_lost":"7","points":"16","score_for":"927","score_against":"987","score_difference":"-60","score_percentage":"93.9"},{"position":"13","team_id":"25510","team_name":"Brisbane Lions AFC","short_name":"Brisbane Lions","original_team_name":"Brisbane Lions AFC","matches_total":"11","matches_won":"3","matches_draw":"0","matches_lost":"8","points":"12","score_for":"860","score_against":"1066","score_difference":"-206","score_percentage":"80.7"},{"position":"14","team_id":"25525","team_name":"Western Bulldogs","short_name":"Western Bulld","original_team_name":"Western Bulldogs","matches_total":"11","matches_won":"3","matches_draw":"0","matches_lost":"8","points":"12","score_for":"732","score_against":"1045","score_difference":"-313","score_percentage":"70.0"},{"position":"15","team_id":"25515","team_name":"Gold Coast FC","short_name":"Gold Coast","original_team_name":"Gold Coast FC","matches_total":"11","matches_won":"3","matches_draw":"0","matches_lost":"8","points":"12","score_for":"672","score_against":"1142","score_difference":"-470","score_percentage":"58.8"},{"position":"16","team_id":"25522","team_name":"St Kilda FC","short_name":"St Kilda","original_team_name":"St Kilda FC","matches_total":"11","matches_won":"2","matches_draw":"0","matches_lost":"9","points":"8","score_for":"766","score_against":"1071","score_difference":"-305","score_percentage":"71.5"},{"position":"17","team_id":"25514","team_name":"Fremantle FC","short_name":"Fremantle","original_team_name":"Fremantle FC","matches_total":"11","matches_won":"2","matches_draw":"0","matches_lost":"9","points":"8","score_for":"699","score_against":"1166","score_difference":"-467","score_percentage":"59.9"},{"position":"18","team_id":"25511","team_name":"Carlton FC","short_name":"Carlton","original_team_name":"Carlton FC","matches_total":"11","matches_won":"1","matches_draw":"0","matches_lost":"10","points":"4","score_for":"677","score_against":"1066","score_difference":"-389","score_percentage":"63.5"}]}}}}}}