Bulk Fetch of Players WTN Ratings
- Abhineet Mittal
Overview
For bulk lookup of WTN rating of the players. USTA offers USTA Connect portal to upload a file in specified format. Once uploaded, USTA backend system will generate a file with WTN rating and it will be available to download from portal itself.
Â
Request File Name Convention
Player files use the following naming convention
[SOURCENAME]_UAID_[YYYYMMDD].csv
Where:
SOURCENAME: The contributor name assigned by USTA.
YYYYMMDD: Date of upload
Column Definitions
The following table lists the fields and formats.
Field | Required/Optional |
|---|---|
UAID | Required |
Example
TESTPORTS_UAID_20240101.csv
Where:
SOURCENAME: TESTSPORTS
Upload Date: 20240101
File format:
UAID
2987656733
2034344444
2323233233
2894363773Request File Name Convention
Player files use the following naming convention
[SOURCENAME]_UAID_[YYYYMMDD].csv
Where:
SOURCENAME: The contributor name assigned by USTA.
YYYYMMDD: Date of upload
Column Definitions
The following table lists the fields and formats.
Field | Required/Optional |
|---|---|
UAID | Required |
Example
TESTPORTS_UAID_20240101.csv
Where:
SOURCENAME: TESTSPORTS
Upload Date: 20240101
File format:
UAID
2987656733
2034344444
2323233233
2894363773Response File Name Convention
Player files use the following naming convention
[SOURCENAME]_WTN_RATING_[YYYYMMDD].csv
Where:
SOURCENAME: The contributor name assigned by USTA.
YYYYMMDD: Date when the file was generated
Column Definitions
The following table lists the fields and formats.
Field | Description |
|---|---|
orig_uaid | UAID of the player |
rating_date | WTN rating date |
singles_rating | Singles WTN Rating |
singles_confidence | Singles WTN Confidence |
doubles_rating | Doubles WTN Rating |
doubles_confidence | Doubles WTN Confidence |
tennis_id | ITF Tennis Id of the player |
upload_date | Rating generated date |
Example
TESTPORTS_WTN_RATING_20240101.csv
Where:
SOURCENAME: TESTSPORTS
Generated Date: 20240101
File format:
orig_uaid,rating_date,singles_rating,singles_confidence,doubles_rating,doubles_confidence,tennis_id,upload_date
2018922828,10/2/2023,28.96,100,30.44,90,TEST12345,10/2/2024On This Page:
- 1 Overview
- 1.1 Request File Name Convention
- 1.2 Column Definitions
- 1.3 Example
- 1.4 File format:
- 1.5 Request File Name Convention
- 1.6 Column Definitions
- 1.7 Example
- 1.8 File format:
- 1.9 Response File Name Convention
- 1.10 Column Definitions
- 1.11 Example
- 1.12 File format: