Athlete | Customer Support College Pipe

Field	Type	Description
firstname	VARCHAR(256)	The first name of the user
lastname	VARCHAR(256)	The last name of the user
gender	'MALE', 'FEMALE'	The gender of the user
sport	VARCHAR(45)	The name of the sport the user is associated with
status	Athlete Status	Status of the athlete
universitySignedWith	University	University the athlete committed to or signed with
startingDateLabel	'Fall YYYY', 'Spring YYYY'	Earliest enrollment period
publicProfile	VARCHAR(512)	The URL of the user's public profile
profileCompleted	DECIMAL (5,2)	The percentage of the user's profile completed
created	DATE	The date when the user's account was created

Contact

email	Varchar(512)	The email address of the user.
address	Varchar(1024)	The address of the user.
city	Varchar(256)	The city where the user is located.
postalCode	Varchar(256)	The postal code of the user's address.
countryCode	Varchar(3) ISO Alpha 3 Digit	The 3-digit ISO country code for the user's country.
stateCode	Varchar(2) ISO 3166-2	The 2-letter state or region code
agent	Agent	The user's agent.
supportStaff	Agent	Support Staff of the athlete

Personal Data

athleteType	Athlete Type	Student Type
dateOfBirth	Date	Athlete’s date of birth
fafsa	QUALIFIER, NO_QUALIFIER, PARTIAL_QUALIFIER	FAFSA eligibility status
ncaaId	Varchar(256)	NCAA ID
naiaId	Varchar(256)	NAIA ID
about	Text	Bio or achievements

Socials Data

facebook	Varchar(256) (Url)	Link to athlete’s Facebook account
instagram	Varchar(256) (@username)	Athlete’s Instagram handle (start with @)
twitter	Varchar(256) (@username)	Athlete’s Twitter handle (start with @)
tiktok	Varchar(256) (Url)	Link to athlete’s TikTok account

Media

pictureUrl	Varchar(512)	URL of the user’s profile picture
pictures	Array of Varchar(512)	URLs of additional profile pictures
videos	Array of Video	Video objects associated with the user

Academics Data

gpa	Decimal	Student's GPA
sat	Integer	SAT Score
satDate	Date	Date SAT was (or will be) taken
act	Integer	ACT Score
actDate	Date	Date ACT was (or will be) taken
toefl	Integer	TOEFL Score
toeflDate	Date	Date TOEFL was (or will be) taken
duolingo	Integer	Duolingo Score
duolingoDate	Date	Date Duolingo was (or will be) taken
ielts	Decimal	IELTS Score
ieltsDate	Date	Date IELTS was (or will be) taken
majors	Array of Major	Educational areas athlete is interested in
hsGraduationYear	Year	High School Graduation Year
hsName	Varchar(256)	High School name
hsClassRank	Varchar(256)	High School Class Rank
hsHonorClasses	Boolean	High School Honor Classes
hsApIbClasses	Boolean	High School AP/IB Classes
gmat	Integer	GMAT Score
currentUniversity	University	Athlete’s current university

Key Stats and Personal Best

athleticsCategories	Array of Athletics Category
~~sportStats~~	~~Array of~~ ~~Sport Stat~~	DEPRECATED. use athletics Categories instead.

Athletics

height	Decimal(10,2)	Athlete’s height in feet
weight	Decimal(10,2)	Athlete’s weight in pounds (lbs)
dominantFoot	LEFT or RIGHT	Athlete’s dominant foot
dominantHand	LEFT or RIGHT	Athlete’s dominant hand
wingspan	Decimal(10,2)	Athlete’s wingspan in feet
standingReach	Decimal(10,2)	Athlete’s standing reach in feet

Teams

clubName	Varchar(256)	Name of the athlete’s club
clubDivision	Varchar(256)	Division of the athlete’s club
nationalExp	Boolean	Whether the athlete has national-level experience
position1	Varchar(45)	Primary Position (team sports only
position2	Varchar(45)	Secondary Position (team sports only)
position3	Varchar(45)	Third Position (team sports only)
athleticLevel	Athletic Level	Athletic level, used to calculate fit with universities
seasons	Array of Season	Seasons the athlete participated in

Events

results

Array of Result

Performance results of the athlete

Example:

{
			"id": "00000130",
			"email": "collegepipe.e2e@gmail.com",
			"firstname": "Alex",
			"lastname": "Tennis",
			"gender": "MALE",
			"pictureUrl": "https://res.cloudinary.com/cp-test/image/upload/v1759224044/uz3eedduy8sjuwnu4bek.png",
			"publicProfile": "/a/alex-tennis/00000130",
			"dateOfBirth": "2003-01-23",
			"pictures": [
				"https://res.cloudinary.com/cp-test/image/upload/v1759224120/kt1mrdu0u7tmjf2zskzh.png",
				"https://res.cloudinary.com/cp-test/image/upload/v1759224129/a6g0aquu3msiztzsyrfa.png"
			],
			"phoneNumber": null,
			"address": null,
			"city": null,
			"postalCode": null,
			"countryCode": "AUT",
			"stateCode": null,
			"created": "2025-08-22 11:29",
			"profileCompleted": 72.0,
			"videos": [
				{
					"id": 1,
					"no": null,
					"created": "2025-09-30",
					"modified": "2025-09-30",
					"title": "My Best Video",
					"link": "https://www.youtube.com/shorts/pRYJHxmZdQE"
				}
			],
			"info": [],
			"sport": "Tennis",
			"agent": {
				"id": "00000004",
				"email": "agent.expert1@collegepipe.com",
				"firstname": "Agent",
				"lastname": "Expert1",
				"gender": "MALE",
				"pictureUrl": null
			},
			"supportStaff": {
				"id": "00000003",
				"email": "agent.support@collegepipe.com",
				"firstname": "Agent",
				"lastname": "Support",
				"gender": "MALE",
				"pictureUrl": null
			},
			"athleteType": "NEW_INCOMING",
			"currentUniversity": null,
			"universitySignedWith": null,
			"position1": null,
			"position2": null,
			"position3": null,
			"dominantFoot": null,
			"dominantHand": "RIGHT",
			"standingReach": null,
			"wingspan": null,
			"nationalExp": true,
			"weight": 155.0,
			"height": 7.75,
			"status": "SEARCHING",
			"startingDateLabel": "FALL 2028",
			"ncaaId": "123456",
			"naiaId": "654321",
			"about": "",
			"clubName": "Red Star",
			"clubDivision": "Division 3",
			"athleticLevel": "VERY_GOOD",
			"sportStats": [],
			"seasons": null,
			"athleticsCategories": [
				{
					"name": "UTR",
					"data": [
						{
							"name": "RATING",
							"value": "12.3",
							"type": "NUMBER"
						},
						{
							"name": "DATE",
							"value": "2025-09-17",
							"type": "DATE"
						},
						{
							"name": "VERIFY_LINK",
							"value": "https://www.utrsports.net/pages/play-tennis",
							"type": "TEXT"
						}
					]
				},
				{
					"name": "5K",
					"data": [
						{
							"name": "PB",
							"value": "1136.0",
							"type": "NUMBER"
						},
						{
							"name": "DATE",
							"value": "2025-09-05",
							"type": "DATE"
						}
					]
				},
				{
					"name": "10K",
					"data": [
						{
							"name": "PB",
							"value": "2303.0",
							"type": "NUMBER"
						}
					]
				},
				{
					"name": "WTN",
					"data": [
						{
							"name": "RATING",
							"value": "23",
							"type": "TEXT"
						},
						{
							"name": "DATE",
							"value": "2025-09-20",
							"type": "DATE"
						}
					]
				},
				{
					"name": "International Ranking/Rating U18",
					"data": [
						{
							"name": "RATING",
							"value": "56",
							"type": "TEXT"
						}
					]
				}
			],
			"results": [
				{
					"id": 1,
					"no": null,
					"event": "Master 1000",
					"date": "2025-08-06",
					"opponent": "John Doe",
					"score": "6-4 6-3",
					"perf": null
				}
			],
			"gpa": 3.8,
			"sat": 1280,
			"satDate": null,
			"act": 33,
			"actDate": null,
			"toefl": 115,
			"toeflDate": null,
			"duolingo": 85,
			"duolingoDate": null,
			"ielts": 7.0,
			"ieltsDate": null,
			"majors": [
				{
					"id": 512311,
					"cat": 51,
					"name": "Kinesiotherapy/Kinesiotherapist"
				},
				{
					"id": 512308,
					"cat": 51,
					"name": "Physical Therapy/Therapist"
				}
			],
			"hsGraduationYear": 2024,
			"hsName": "Lincoln High School",
			"hsClassRank": "2",
			"hsHonorClasses": true,
			"hsApIbClasses": null,
			"facebook": "https://www.facebook.com/my-account",
			"instagram": "@my-instagram-account",
			"twitter": "@my-twitter-account",
			"tiktok": "https://www.tiktok.com/my-account",
			"fafsa": "PARTIAL_QUALIFIER"
		}