SOCS Music and Tuition - XML Feeds

Modified on Thu, 13 Feb at 1:56 PM

There are 4 main XML feeds for SOCS Music and Tuition lessons data (depending on which modules your school uses):

Music Lessons
Sport Coaching
Academic Tutoring
Performing Arts

Each feed will include all lessons for the specified Tuition module for the current date by default.

A date can be specified by adding "startdate" querystring to the URL as follows: &startdate=1 Sep 2017

Lesson Data Fields:

XML Field	Data Type	Notes
lessonid	INTEGER	The id of the activity club
startdate	DATE	The startdate of the lessons
starttime	STRING	The start time of the lesson
endtime	STRING	The end time of the lesson
instrument / sport / subject / discipline	STRING	The instrument / sport / subject / discipline of the lesson. Field title is dependent on module.
title	STRING	The title of the lesson
location	STRING	The location of the lesson
costschool	DECIMAL	The cost of the lesson to the school
costpupil	DECIMAL	The cost of the lesson to the pupil
staffid	STRING	The ID of the staff member for the lesson
pupilid	STRING	The ID of the pupil for the lesson
attendance	STRING	The attendance status of the pupil for the event. THis can be one of the following: authorised absent \| absent \| attended \| blank

Tuition Staff-Pupil Relationships

There are 4 main XML feeds for SOCS Tuition staff-pupil relationships data (depending on which modules your school uses):

Music Lessons
Sport Coaching
Academic Tutoring
Performing Arts

Each feed will include all staff pupil groups along with their sessions and instrument//sport/discipline if added. Note: if a pupil has more than one session linked to a teacher then that will appear in the data as separate records.

Staff-Pupil Realtionships Data Fields:

XML Field	Data Type	Notes
pupilid	STRING	The ID of the pupil
staffid	STRING	The ID of the staff member
sessiontitle	STRING	The session linked to this pupil for this teacher (if added)
instrument / sport / subject / discipline	STRING	The instrument / sport / subject / discipline of the session linked to this pupil for this teacher. Field title is dependent on module.