Subscription to this function is not available for your account. To upgrade and receive access to this contact sales@datasportsgroup.com
v3 GET /rugby/get_tables
Returns the league, home & away tables per season or round.
Request URL
https://dsg-api.com/clients/{client_name}/rugby/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 an area
area_name
name of the area
competition_id
unique identifier for a competition
format
competition format (domestic_league, domestic_cup, domestic_league_cup, domestic_super_cup, international_cup, international_super_cup, playoff, tournament, race, unofficial)
gender
determines the gender of the competition (male or female)
last_updated
When record was last updated. Format YYYY-MM-DD HH:MM:SS in CET timezone.
name
name of the competition
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 call
sport
sport value
version
version of the API
list
details about list type
aggregation_type
aggregation type (scores or wins)
id
unique identifier for a group if type = group, if type = playoff then for a playoff
last_updated
When record was last updated. Format YYYY-MM-DD HH:MM:SS in CET timezone.
name
name of either a group or playoff
score_a
playoff score of team_a
score_b
playoff score of team_b
type
list type (regular, group or playoff)
winner_team_id
unique identifier for the winning team of the playoff
method
details about the API function
method_id
unique ID of method
name
name of method
round
details about the round
end_date
end date, format 'yyyy-mm-dd'
end_date_utc
end date in UTC timezone, format 'yyyy-mm-dd'
end_time
end time, format 'HH:mm:ss'
end_time_utc
end time in UTC timezone, format 'HH:mm:ss'
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'
start_date_utc
start date in UTC timezone, format 'yyyy-mm-dd'.
start_time
start time, format 'HH:mm:ss'
start_time_utc
start time in UTC timezone, format 'HH:mm:ss'
type
determines if the round contains a table or a cup structure (knock-out)
season
details about the 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 the table entry
area_id
unique identifier for an area
form
performance of the last 5 matches in the particular round (W = win, D = draw, L = loss)
live
indicates if there is a live game for the team
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
position value
prev_season
defines last season achievements ('C','CW','P','R')
short_name
shortened name of the person
team_id
unique identifier of the team
team_logo
full path URL of team logo
team_name
current team name
zone
name of table zone
zone_id
unique identifier for a table zone
tour
details about the tour
gender
gender of the tour
name
name of the particular tour
tour_id
unique tour identifier
tour_type
defines if the tournament is part of a tour or not. If not then value "non-tour"
tour_season
details about a tour season
logo
full path URL of logo for particular tour_season
name
name of the tour_season
title
title of the particular tour season
tour_season_id
unique identifier of a tour season
values
tables values of the team (rugby)
losing_bonus
bonus points for losing below a certain difference
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
points
value of the particular stat
points_against
value for total points against
points_difference
difference of points
points_for
value for total points made
tries_against
tries scored against the team
tries_for
tries scored
try_bonus
bonus points for tries scored
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}/rugby/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}/rugby/get_tables?type={type}&id={id}&client={client_name}&authkey={client_authkey}"
Imports System
Imports System.Net	
Imports System.IO
Imports System.Text

Public Module Module1
	Public Sub Main()
		Dim url As String = "https://dsg-api.com/clients/{client_name}/rugby/get_tables?type={type}&id={id}&client={client_name}&authkey={client_authkey}"
		Dim myReq As WebRequest = WebRequest.Create(url)
		myReq.Credentials = new System.Net.NetworkCredential("{User}", "{Password}")
		Dim wr As WebResponse = myReq.GetResponse()
		Dim receiveStream As Stream = wr.GetResponseStream()
		Dim reader As StreamReader = New StreamReader(receiveStream, Encoding.UTF8)
		Dim content As String = reader.ReadToEnd()
	End Sub
End Module
response = requests.get("https://dsg-api.com/clients/{client_name}/rugby/get_tables?type={type}&id={id}&client={client_name}&authkey={client_authkey}", auth=("User", "Password"))
Response Example
200 Success
{"datasportsgroup":{"version":"1.0","sport":"rugby","lang":"en","method":{"method_id":"108","name":"get_tables"},"competition":{"competition_id":"1034","name":"Top 14","teamtype":"male","type":"club","format":"domestic_league","area_id":"76","area_name":"France","last_updated":"2018-07-12 11:01:50","season":{"season_id":"17159","title":"2018\/2019","original_name":"Top 14","start_date":"2018-08-25","end_date":"2019-06-02","logo":"https:\/\/www.dsg-images.com\/comps\/200x200\/1034.png","last_updated":"2018-08-24 08:48:18","rounds":{"round_id":"23204","name":"Regular Season","start_date":"2018-08-25","end_date":"2019-06-02","type":"table","last_updated":"2018-08-24 08:48:42","total":{"table":[{"position":"1","team_id":"30753","team_name":"Stade Toulousain","short_name":"St. Toulousain","original_team_name":"Stade Toulousain","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":"26","matches_won":"21","matches_draw":"2","matches_lost":"3","points_for":"820","points_against":"508","points_difference":"312","tries_for":"102","tries_against":"57","try_bonus":"9","losing_bonus":"1","points":"98"},{"position":"2","team_id":"30744","team_name":"ASM Clermont Auvergne","short_name":"Clermont","original_team_name":"ASM Clermont Auvergne","zone":"Championship Playoffs","zone_id":"champ_playoffs","prev_season":"","form":"L,L,W,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"26","matches_won":"16","matches_draw":"3","matches_lost":"7","points_for":"828","points_against":"535","points_difference":"293","tries_for":"92","tries_against":"50","try_bonus":"9","losing_bonus":"4","points":"83"},{"position":"3","team_id":"30746","team_name":"Lyon OU","short_name":"Lyon OU","original_team_name":"Lyon OU","zone":"Championship Playoffs","zone_id":"champ_playoffs","prev_season":"","form":"W,W,W,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"26","matches_won":"17","matches_draw":"1","matches_lost":"8","points_for":"683","points_against":"525","points_difference":"158","tries_for":"72","tries_against":"56","try_bonus":"7","losing_bonus":"1","points":"78"},{"position":"4","team_id":"30749","team_name":"Racing 92","short_name":"Racing 92","original_team_name":"Racing 92","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":"26","matches_won":"15","matches_draw":"1","matches_lost":"10","points_for":"750","points_against":"563","points_difference":"187","tries_for":"95","tries_against":"55","try_bonus":"8","losing_bonus":"4","points":"74"},{"position":"5","team_id":"30750","team_name":"Stade Rochelais","short_name":"Stade Rochel.","original_team_name":"Stade Rochelais","zone":"Championship Playoffs","zone_id":"champ_playoffs","prev_season":"","form":"W,L,W,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"26","matches_won":"16","matches_draw":"0","matches_lost":"10","points_for":"719","points_against":"616","points_difference":"103","tries_for":"89","tries_against":"65","try_bonus":"6","losing_bonus":"1","points":"71"},{"position":"6","team_id":"30747","team_name":"Montpellier Hérault Rugby","short_name":"Montpellier","original_team_name":"Montpellier Hérault Rugby","zone":"Championship Playoffs","zone_id":"champ_playoffs","prev_season":"","form":"W,W,W,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"26","matches_won":"14","matches_draw":"1","matches_lost":"11","points_for":"659","points_against":"546","points_difference":"113","tries_for":"82","tries_against":"55","try_bonus":"6","losing_bonus":"6","points":"70"},{"position":"7","team_id":"30743","team_name":"Castres Olympique","short_name":"Castres Olymp.","original_team_name":"Castres Olympique","zone":"","zone_id":"","prev_season":"","form":"L,W,L,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"26","matches_won":"15","matches_draw":"0","matches_lost":"11","points_for":"508","points_against":"499","points_difference":"9","tries_for":"48","tries_against":"46","try_bonus":"4","losing_bonus":"5","points":"69"},{"position":"8","team_id":"30751","team_name":"Stade Français","short_name":"Stade Français","original_team_name":"Stade Français","zone":"","zone_id":"","prev_season":"","form":"W,L,W,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"26","matches_won":"14","matches_draw":"0","matches_lost":"12","points_for":"583","points_against":"579","points_difference":"4","tries_for":"58","tries_against":"62","try_bonus":"4","losing_bonus":"4","points":"64"},{"position":"9","team_id":"30752","team_name":"RC Toulonnais","short_name":"RC Toulonnais","original_team_name":"RC Toulonnais","zone":"","zone_id":"","prev_season":"","form":"W,W,L,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"26","matches_won":"12","matches_draw":"0","matches_lost":"14","points_for":"572","points_against":"542","points_difference":"30","tries_for":"69","tries_against":"56","try_bonus":"6","losing_bonus":"3","points":"57"},{"position":"10","team_id":"30741","team_name":"Union Bordeaux Bègles","short_name":"Union Bordeaux","original_team_name":"Union Bordeaux Bègles","zone":"","zone_id":"","prev_season":"","form":"L,L,L,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"26","matches_won":"12","matches_draw":"1","matches_lost":"13","points_for":"618","points_against":"711","points_difference":"-93","tries_for":"66","tries_against":"84","try_bonus":"4","losing_bonus":"3","points":"57"},{"position":"11","team_id":"30748","team_name":"Section Paloise","short_name":"Section Palois","original_team_name":"Section Paloise","zone":"","zone_id":"","prev_season":"","form":"L,W,L,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"26","matches_won":"9","matches_draw":"0","matches_lost":"17","points_for":"501","points_against":"763","points_difference":"-262","tries_for":"51","tries_against":"91","try_bonus":"2","losing_bonus":"5","points":"43"},{"position":"12","team_id":"37085","team_name":"SU Agen","short_name":"SU Agen","original_team_name":"SU Agen","zone":"","zone_id":"","prev_season":"","form":"L,L,W,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"26","matches_won":"8","matches_draw":"1","matches_lost":"17","points_for":"431","points_against":"654","points_difference":"-223","tries_for":"38","tries_against":"78","try_bonus":"0","losing_bonus":"4","points":"38"},{"position":"13","team_id":"30745","team_name":"FC Grenoble","short_name":"FC Grenoble","original_team_name":"FC Grenoble","zone":"Relegation Playoff","zone_id":"rel_playoff","prev_season":"","form":"L,L,L,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"26","matches_won":"5","matches_draw":"2","matches_lost":"19","points_for":"448","points_against":"691","points_difference":"-243","tries_for":"32","tries_against":"82","try_bonus":"0","losing_bonus":"5","points":"29"},{"position":"14","team_id":"35744","team_name":"USA Perpignan","short_name":"Perpignan","original_team_name":"USA Perpignan","zone":"Relegation","zone_id":"relegation","prev_season":"","form":"L,L,L,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","matches_total":"26","matches_won":"2","matches_draw":"0","matches_lost":"24","points_for":"433","points_against":"821","points_difference":"-388","tries_for":"41","tries_against":"98","try_bonus":"0","losing_bonus":"4","points":"12"}]},"home":{"table":[{"position":"1","team_id":"30753","team_name":"Stade Toulousain","short_name":"St. Toulousain","original_team_name":"Stade Toulousain","matches_total":"13","matches_won":"12","matches_draw":"0","matches_lost":"1","points_for":"509","points_against":"197","points_difference":"312","tries_for":"67","tries_against":"21","try_bonus":"7","losing_bonus":"1","points":"55"},{"position":"2","team_id":"30746","team_name":"Lyon OU","short_name":"Lyon OU","original_team_name":"Lyon OU","matches_total":"13","matches_won":"11","matches_draw":"1","matches_lost":"1","points_for":"446","points_against":"189","points_difference":"257","tries_for":"50","tries_against":"15","try_bonus":"7","losing_bonus":"0","points":"54"},{"position":"3","team_id":"30744","team_name":"ASM Clermont Auvergne","short_name":"Clermont","original_team_name":"ASM Clermont Auvergne","matches_total":"13","matches_won":"10","matches_draw":"2","matches_lost":"1","points_for":"485","points_against":"230","points_difference":"255","tries_for":"59","tries_against":"24","try_bonus":"7","losing_bonus":"1","points":"54"},{"position":"4","team_id":"30750","team_name":"Stade Rochelais","short_name":"Stade Rochel.","original_team_name":"Stade Rochelais","matches_total":"13","matches_won":"11","matches_draw":"0","matches_lost":"2","points_for":"455","points_against":"252","points_difference":"203","tries_for":"56","tries_against":"29","try_bonus":"4","losing_bonus":"1","points":"48"},{"position":"5","team_id":"30741","team_name":"Union Bordeaux Bègles","short_name":"Union Bordeaux","original_team_name":"Union Bordeaux Bègles","matches_total":"13","matches_won":"10","matches_draw":"1","matches_lost":"2","points_for":"395","points_against":"255","points_difference":"140","tries_for":"41","tries_against":"27","try_bonus":"4","losing_bonus":"1","points":"48"},{"position":"6","team_id":"30752","team_name":"RC Toulonnais","short_name":"RC Toulonnais","original_team_name":"RC Toulonnais","matches_total":"13","matches_won":"10","matches_draw":"0","matches_lost":"3","points_for":"358","points_against":"194","points_difference":"164","tries_for":"45","tries_against":"19","try_bonus":"6","losing_bonus":"2","points":"47"},{"position":"7","team_id":"30747","team_name":"Montpellier Hérault Rugby","short_name":"Montpellier","original_team_name":"Montpellier Hérault Rugby","matches_total":"13","matches_won":"8","matches_draw":"0","matches_lost":"5","points_for":"411","points_against":"256","points_difference":"155","tries_for":"55","tries_against":"25","try_bonus":"6","losing_bonus":"2","points":"42"},{"position":"8","team_id":"30749","team_name":"Racing 92","short_name":"Racing 92","original_team_name":"Racing 92","matches_total":"13","matches_won":"9","matches_draw":"0","matches_lost":"4","points_for":"447","points_against":"296","points_difference":"151","tries_for":"59","tries_against":"32","try_bonus":"4","losing_bonus":"2","points":"42"},{"position":"9","team_id":"30751","team_name":"Stade Français","short_name":"Stade Français","original_team_name":"Stade Français","matches_total":"13","matches_won":"8","matches_draw":"0","matches_lost":"5","points_for":"295","points_against":"245","points_difference":"50","tries_for":"29","tries_against":"27","try_bonus":"3","losing_bonus":"2","points":"37"},{"position":"10","team_id":"30743","team_name":"Castres Olympique","short_name":"Castres Olymp.","original_team_name":"Castres Olympique","matches_total":"13","matches_won":"7","matches_draw":"0","matches_lost":"6","points_for":"268","points_against":"212","points_difference":"56","tries_for":"27","tries_against":"17","try_bonus":"4","losing_bonus":"4","points":"33"},{"position":"11","team_id":"30748","team_name":"Section Paloise","short_name":"Section Palois","original_team_name":"Section Paloise","matches_total":"13","matches_won":"6","matches_draw":"0","matches_lost":"7","points_for":"270","points_against":"246","points_difference":"24","tries_for":"27","tries_against":"24","try_bonus":"2","losing_bonus":"5","points":"26"},{"position":"12","team_id":"30745","team_name":"FC Grenoble","short_name":"FC Grenoble","original_team_name":"FC Grenoble","matches_total":"13","matches_won":"5","matches_draw":"1","matches_lost":"7","points_for":"261","points_against":"303","points_difference":"-42","tries_for":"17","tries_against":"33","try_bonus":"0","losing_bonus":"3","points":"24"},{"position":"13","team_id":"37085","team_name":"SU Agen","short_name":"SU Agen","original_team_name":"SU Agen","matches_total":"13","matches_won":"5","matches_draw":"1","matches_lost":"7","points_for":"211","points_against":"253","points_difference":"-42","tries_for":"17","tries_against":"26","try_bonus":"0","losing_bonus":"2","points":"24"},{"position":"14","team_id":"35744","team_name":"USA Perpignan","short_name":"Perpignan","original_team_name":"USA Perpignan","matches_total":"13","matches_won":"1","matches_draw":"0","matches_lost":"12","points_for":"221","points_against":"393","points_difference":"-172","tries_for":"21","tries_against":"46","try_bonus":"0","losing_bonus":"2","points":"6"}]},"away":{"table":[{"position":"1","team_id":"30753","team_name":"Stade Toulousain","short_name":"St. Toulousain","original_team_name":"Stade Toulousain","matches_total":"13","matches_won":"9","matches_draw":"2","matches_lost":"2","points_for":"311","points_against":"311","points_difference":"0","tries_for":"35","tries_against":"36","try_bonus":"2","losing_bonus":"0","points":"43"},{"position":"2","team_id":"30743","team_name":"Castres Olympique","short_name":"Castres Olymp.","original_team_name":"Castres Olympique","matches_total":"13","matches_won":"8","matches_draw":"0","matches_lost":"5","points_for":"240","points_against":"287","points_difference":"-47","tries_for":"21","tries_against":"29","try_bonus":"0","losing_bonus":"1","points":"36"},{"position":"3","team_id":"30749","team_name":"Racing 92","short_name":"Racing 92","original_team_name":"Racing 92","matches_total":"13","matches_won":"6","matches_draw":"1","matches_lost":"6","points_for":"303","points_against":"267","points_difference":"36","tries_for":"36","tries_against":"23","try_bonus":"4","losing_bonus":"2","points":"32"},{"position":"4","team_id":"30744","team_name":"ASM Clermont Auvergne","short_name":"Clermont","original_team_name":"ASM Clermont Auvergne","matches_total":"13","matches_won":"6","matches_draw":"1","matches_lost":"6","points_for":"343","points_against":"305","points_difference":"38","tries_for":"33","tries_against":"26","try_bonus":"2","losing_bonus":"3","points":"29"},{"position":"5","team_id":"30747","team_name":"Montpellier Hérault Rugby","short_name":"Montpellier","original_team_name":"Montpellier Hérault Rugby","matches_total":"13","matches_won":"6","matches_draw":"1","matches_lost":"6","points_for":"248","points_against":"290","points_difference":"-42","tries_for":"27","tries_against":"30","try_bonus":"0","losing_bonus":"4","points":"28"},{"position":"6","team_id":"30751","team_name":"Stade Français","short_name":"Stade Français","original_team_name":"Stade Français","matches_total":"13","matches_won":"6","matches_draw":"0","matches_lost":"7","points_for":"288","points_against":"334","points_difference":"-46","tries_for":"29","tries_against":"35","try_bonus":"1","losing_bonus":"2","points":"27"},{"position":"7","team_id":"30746","team_name":"Lyon OU","short_name":"Lyon OU","original_team_name":"Lyon OU","matches_total":"13","matches_won":"6","matches_draw":"0","matches_lost":"7","points_for":"237","points_against":"336","points_difference":"-99","tries_for":"22","tries_against":"41","try_bonus":"0","losing_bonus":"1","points":"24"},{"position":"8","team_id":"30750","team_name":"Stade Rochelais","short_name":"Stade Rochel.","original_team_name":"Stade Rochelais","matches_total":"13","matches_won":"5","matches_draw":"0","matches_lost":"8","points_for":"264","points_against":"364","points_difference":"-100","tries_for":"33","tries_against":"36","try_bonus":"2","losing_bonus":"0","points":"23"},{"position":"9","team_id":"30748","team_name":"Section Paloise","short_name":"Section Palois","original_team_name":"Section Paloise","matches_total":"13","matches_won":"3","matches_draw":"0","matches_lost":"10","points_for":"231","points_against":"517","points_difference":"-286","tries_for":"24","tries_against":"67","try_bonus":"0","losing_bonus":"0","points":"17"},{"position":"10","team_id":"37085","team_name":"SU Agen","short_name":"SU Agen","original_team_name":"SU Agen","matches_total":"13","matches_won":"3","matches_draw":"0","matches_lost":"10","points_for":"220","points_against":"401","points_difference":"-181","tries_for":"21","tries_against":"52","try_bonus":"0","losing_bonus":"2","points":"14"},{"position":"11","team_id":"30752","team_name":"RC Toulonnais","short_name":"RC Toulonnais","original_team_name":"RC Toulonnais","matches_total":"13","matches_won":"2","matches_draw":"0","matches_lost":"11","points_for":"214","points_against":"348","points_difference":"-134","tries_for":"24","tries_against":"37","try_bonus":"0","losing_bonus":"1","points":"10"},{"position":"12","team_id":"30741","team_name":"Union Bordeaux Bègles","short_name":"Union Bordeaux","original_team_name":"Union Bordeaux Bègles","matches_total":"13","matches_won":"2","matches_draw":"0","matches_lost":"11","points_for":"223","points_against":"456","points_difference":"-233","tries_for":"25","tries_against":"57","try_bonus":"0","losing_bonus":"2","points":"9"},{"position":"13","team_id":"35744","team_name":"USA Perpignan","short_name":"Perpignan","original_team_name":"USA Perpignan","matches_total":"13","matches_won":"1","matches_draw":"0","matches_lost":"12","points_for":"212","points_against":"428","points_difference":"-216","tries_for":"20","tries_against":"52","try_bonus":"0","losing_bonus":"2","points":"6"},{"position":"14","team_id":"30745","team_name":"FC Grenoble","short_name":"FC Grenoble","original_team_name":"FC Grenoble","matches_total":"13","matches_won":"0","matches_draw":"1","matches_lost":"12","points_for":"187","points_against":"388","points_difference":"-201","tries_for":"15","tries_against":"49","try_bonus":"0","losing_bonus":"2","points":"5"}]}}}}}}