Subscription to this function is not available for your account. To upgrade and receive access to this contact sales@datasportsgroup.com
v3 GET /bandy/get_tables
Returns the league, home & away tables per season or round.
Request URL
https://dsg-api.com/clients/{client_name}/bandy/get_tables?type={type}&id={id}&client={client_name}&authkey={client_authkey}
API Threshold
- 10k calls per hour (2.78 calls per second)
- This threshold applies to ALL your calls you do across the API.
- Your number of calls get reset every hour at :00
- If the thresold is reached within the hour you will get a xml/json message accordingly (which is gone when the next hour starts, see previous point)
Parameters
authkey
string Required
client authentification key
client
string Required
unique client ID
date
string
set a date in format yyyy-mm-dd as limit
ftype
string
changes feed type from XML to json (ftype=json or ftype=json_array)
gameweek
int
gameweek value to get table from
id
int Required
object id to return
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
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 team/contestant table entry
area_id
unique identifier for an area
common_name
common name of the person
contestant_1_common_name
common name of the contestant
contestant_1_first_name
first name of the contestant
contestant_1_id
unique identifier for the contestant
contestant_1_last_name
last name of the contestant
contestant_1_nationality_area_code
area code of contestants nationality
contestant_1_nationality_area_id
unique area_id of the contestants nationality
contestant_1_nationality_area_name
nationality of the contestant
contestant_1_short_name
short name of the contestant
contestant_2_common_name
common name of the contestant
contestant_2_first_name
first name of the contestant
contestant_2_id
unique identifier for the contestant
contestant_2_last_name
last name of the contestant
contestant_2_nationality_area_code
area code of contestants nationality
contestant_2_nationality_area_id
unique area_id of the contestants nationality
contestant_2_nationality_area_name
nationality of the contestant
contestant_2_short_name
short name of the contestant
contestant_team_id
unique identifier for the contestant team/double
first_name
first name of the person
form
performance of the last 5 matches in the particular round (W = win, D = draw, L = loss)
last_name
last name of the person
live
indicates if there is a live game for the team
nationality_area_code
three character area code
nationality_area_id
unique identifier for an area
nationality_area_name
area name of peoples nationality
next_match_id
match_id of the upcoming match in the particular round
next_opponent_contestant_name
contestant name of the next opponent in the particular round
next_opponent_contestant_team_id
contestant_team_id of the next opponent 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
people_id
unique identifier for person
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
values❯
tables values of the team (badminton/tennis/table_tennis)
games_against
number of games against
games_for
number of games
game_difference
value for total game difference
matches_lost
value for total lost matches
matches_total
value for total played matches
matches_won
value for total won matches
points
value for total points gained
points_against
number of points against
points_difference
value for total points difference
points_for
number of points
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}/bandy/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}/bandy/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}/bandy/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}/bandy/get_tables?type={type}&id={id}&client={client_name}&authkey={client_authkey}", auth=("User", "Password"))
Response Example200 Success{"datasportsgroup":{"version":"2.1723.3","sport":"bandy","lang":"en","generated_utc":"2025-08-01T15:25:57+00:00","method":{"method_id":"1723","name":"get_tables"},"tour":{"tour_id":"","name":"","gender":"female","tour_type":"non-tour","tour_season":{"tour_season_id":"","title":"","name":"","logo":"","competition":{"competition_id":"3501","name":"FIB World Championship","gender":"female","type":"international","format":"international_cup","area_id":"1","area_name":"World","last_updated":"2025-07-07 20:44:08","season":{"season_id":"75538","title":"2025 Lidköping","original_name":"FIB World Championship","start_date":"2025-03-25","end_date":"2025-03-30","logo":"https:\/\/www.dsg-images.com\/comps\/200x200\/3502.png","last_updated":"2025-07-17 20:56:46","round":{"round_id":"120826","name":"Preliminary Round","start_date":"2025-03-25","start_time":"","start_date_utc":"2025-03-25","start_time_utc":"","end_date":"2025-03-28","end_time":"","end_date_utc":"2025-03-28","end_time_utc":"","type":"table","last_updated":"2025-04-01 11:54:22","list":[{"type":"group","id":"4803493","name":"Pool A","last_updated":"2025-04-01 11:56:03","total":{"table":[{"position":"1","team_id":"53596","team_name":"Sweden","short_name":"Sweden","original_team_name":"Sweden","area_id":"184","live":"no","zone":"Final","zone_id":"final","prev_season":"","form":"W,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53596.png","values":{"matches_total":"3","matches_won":"3","matches_draw":"0","matches_lost":"0","score_for":"35","score_against":"4","score_difference":"31","points":"0"}},{"position":"2","team_id":"53600","team_name":"United States","short_name":"United States","original_team_name":"United States","area_id":"203","live":"no","zone":"Play-in","zone_id":"playin","prev_season":"","form":"W,L,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53600.png","values":{"matches_total":"3","matches_won":"2","matches_draw":"0","matches_lost":"1","score_for":"11","score_against":"13","score_difference":"-2","points":"0"}},{"position":"3","team_id":"53594","team_name":"Norway","short_name":"Norway","original_team_name":"Norway","area_id":"146","live":"no","zone":"Play-in","zone_id":"playin","prev_season":"","form":"L,W,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53594.png","values":{"matches_total":"3","matches_won":"1","matches_draw":"0","matches_lost":"2","score_for":"11","score_against":"18","score_difference":"-7","points":"0"}},{"position":"4","team_id":"53592","team_name":"Finland","short_name":"Finland","original_team_name":"Finland","area_id":"75","live":"no","zone":"Next Round","zone_id":"next_round","prev_season":"","form":"L,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53592.png","values":{"matches_total":"3","matches_won":"0","matches_draw":"0","matches_lost":"3","score_for":"2","score_against":"24","score_difference":"-22","points":"0"}}]},"home":{"table":[{"position":"1","team_id":"53592","team_name":"Finland","short_name":"Finland","original_team_name":"Finland","area_id":"75","form":"","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53592.png","values":{"matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}},{"position":"2","team_id":"53594","team_name":"Norway","short_name":"Norway","original_team_name":"Norway","area_id":"146","form":"W,L","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53594.png","values":{"matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}},{"position":"3","team_id":"53596","team_name":"Sweden","short_name":"Sweden","original_team_name":"Sweden","area_id":"184","form":"W,W,W","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53596.png","values":{"matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}},{"position":"4","team_id":"53600","team_name":"United States","short_name":"United States","original_team_name":"United States","area_id":"203","form":"W","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53600.png","values":{"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":"53592","team_name":"Finland","short_name":"Finland","original_team_name":"Finland","area_id":"75","form":"L,L,L","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53592.png","values":{"matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}},{"position":"2","team_id":"53594","team_name":"Norway","short_name":"Norway","original_team_name":"Norway","area_id":"146","form":"L","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53594.png","values":{"matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}},{"position":"3","team_id":"53596","team_name":"Sweden","short_name":"Sweden","original_team_name":"Sweden","area_id":"184","form":"","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53596.png","values":{"matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}},{"position":"4","team_id":"53600","team_name":"United States","short_name":"United States","original_team_name":"United States","area_id":"203","form":"L,W","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53600.png","values":{"matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}}]}},{"type":"group","id":"4803494","name":"Pool B","last_updated":"2025-04-01 11:56:03","total":{"table":[{"position":"1","team_id":"53606","team_name":"Netherlands","short_name":"Netherlands","original_team_name":"Netherlands","area_id":"138","live":"no","zone":"Next Round","zone_id":"next_round","prev_season":"","form":"W,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53606.png","values":{"matches_total":"3","matches_won":"3","matches_draw":"0","matches_lost":"0","score_for":"26","score_against":"1","score_difference":"25","points":"0"}},{"position":"2","team_id":"53610","team_name":"Ukraine","short_name":"Ukraine","original_team_name":"Ukraine","area_id":"201","live":"no","zone":"","zone_id":"","prev_season":"","form":"L,W,W","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53610.png","values":{"matches_total":"3","matches_won":"2","matches_draw":"0","matches_lost":"1","score_for":"4","score_against":"10","score_difference":"-6","points":"0"}},{"position":"3","team_id":"69671","team_name":"Germany","short_name":"Germany","original_team_name":"Germany","area_id":"80","live":"no","zone":"","zone_id":"","prev_season":"","form":"D,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/69671.png","values":{"matches_total":"3","matches_won":"0","matches_draw":"1","matches_lost":"2","score_for":"3","score_against":"12","score_difference":"-9","points":"0"}},{"position":"4","team_id":"53608","team_name":"Switzerland","short_name":"Switzerland","original_team_name":"Switzerland","area_id":"185","live":"no","zone":"","zone_id":"","prev_season":"","form":"D,L,L","next_match_id":"","next_opponent_team_id":"","next_opponent_name":"","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53608.png","values":{"matches_total":"3","matches_won":"0","matches_draw":"1","matches_lost":"2","score_for":"4","score_against":"14","score_difference":"-10","points":"0"}}]},"home":{"table":[{"position":"1","team_id":"53606","team_name":"Netherlands","short_name":"Netherlands","original_team_name":"Netherlands","area_id":"138","form":"W","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53606.png","values":{"matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}},{"position":"2","team_id":"53608","team_name":"Switzerland","short_name":"Switzerland","original_team_name":"Switzerland","area_id":"185","form":"L,L","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53608.png","values":{"matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}},{"position":"3","team_id":"53610","team_name":"Ukraine","short_name":"Ukraine","original_team_name":"Ukraine","area_id":"201","form":"L","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53610.png","values":{"matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}},{"position":"4","team_id":"69671","team_name":"Germany","short_name":"Germany","original_team_name":"Germany","area_id":"80","form":"D,L","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/69671.png","values":{"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":"53606","team_name":"Netherlands","short_name":"Netherlands","original_team_name":"Netherlands","area_id":"138","form":"W,W","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53606.png","values":{"matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}},{"position":"2","team_id":"53608","team_name":"Switzerland","short_name":"Switzerland","original_team_name":"Switzerland","area_id":"185","form":"D","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53608.png","values":{"matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}},{"position":"3","team_id":"53610","team_name":"Ukraine","short_name":"Ukraine","original_team_name":"Ukraine","area_id":"201","form":"W,W","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/53610.png","values":{"matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}},{"position":"4","team_id":"69671","team_name":"Germany","short_name":"Germany","original_team_name":"Germany","area_id":"80","form":"L","team_logo":"https:\/\/www.dsg-images.com\/clubs\/200x200\/69671.png","values":{"matches_total":"0","matches_won":"0","matches_draw":"0","matches_lost":"0","score_for":"0","score_against":"0","score_difference":"0","points":"0"}}]}}]}}}}}}}