Alps-iSAMS Integration

Alps-iSAMS Integration

Please Note: If you have existing data in Alps Connect for the current academic year, this will need deleting before integration. We recommend exporting and saving a copy of your student data, gradepoints and any personalised targets. Once integrated, you will need to reupload your prior attainment, any custom columns, gradepoints and personalised targets.

What is an API? 

If you are an iSAMS user, you can now integrate your Student Data and Teaching Data with Alps, using our API integration. An API is a connection that can be used to link applications, either through a one way integration or both ways. The Alps-iSAMS API is a one way integration, which feeds data from iSAMS into Alps and updates in both platforms when you make changes in iSAMS. The integration will significantly reduce the amount of manual uploads required and ensure your Alps data matches iSAMS. 

Please follow the steps below to set up your integration. If you have any questions about iSAMS integration, please email support@alps.education

Step 1: Setup REST API

Please note integration requires schools to have a subscription to the iSAMS API Services Manager.

To start the integration, a REST API Client ID and Client Secret is required. These can be requested from support@isams.com.

Read Only permissions for the REST API will need to be added for:
  1. School Manager
  2. Pupil Manager
  3. Timetable Manager
  4. Teaching Manager
  5. Pupil Register
    1. Read Activity permissions must also be given within the module, to allow access to the specific registers required
If you need any support with REST API, please see this iSAMS support article: Overview of REST API – iSAMS Support

Step 2: Register your School

After approving, you can log into Alps Connect and navigate to the MIS Integration page, accessible via the Data Management tab: 


In the MIS Integration page, select iSAMS in the drop down menu and enter your iSAMS URL, Client ID and Client Secret. Then click Submit.


Step 3: Field Mapping

After submitting, the Field Mapping tab will appear. In this tab, select the iSAMS field you wish to use for Student ID and Year Group.



A preview table will appear for you to check the fields you have selected give the values you expect:


Please note Alps only syncs Year 7-14, so any students with a year group below or above that will not be integrated and those year groups will highlight in yellow. Once you have checked your fields, select the tick box and click Confirm Mapping.


Step 4: Select Year Groups

Once registered, the Year Groups tab will appear. Select the Prior Attainment type for each of the year groups you wish to import and press Import Year Groups.


Once the sync has happened, the Last Sync box will turn green and a green tick will appear next to the synced year groups:


Step 5: Review Skipped Students

After syncing your year groups a Skipped Pupils box will appear in the far right of the screen. Click View list. 


A window will appear showing all the students that are not included in the integration due to the Field Mapping. If you wish to include these students in the integration, you need to edit them in iSAMS. 


Step 6: Ethnicity Mapping

After your year groups have synced, the mapping tabs will appear. Select the Ethnicity Mapping tab and a list of all your ethnicity codes will appear. Codes in red need mapping to an Alps ethnicity value, which can be done via the edit pencil and drop down box. After selecting a value, press the tick and the line will turn yellow.

When you have completed the mappings, press Save.


Step 7: SEND Mapping

Navigate to the SEND Mapping tab and like above, map any red SEND values to an Alps SEND value using the edit pencil and dop down.

Once all have been mapped, press Save.


Step 8: Subject Mapping

Navigate to the Subject Mapping tab, and a list of all your imported subject names will appear. Click the edit icon and a drop down box will appear with the Alps subject names, select the relevant subject mapping and then click the tick. You can use the year buttons above the list to filter by year group. Go through the list and map all red subjects.

If you have any subjects that are not assessed, e.g. PSHE or Study Time, these can be removed by clicking the bin icon. 

If you have any subjects that contain two different qualifications, for example English but you do both literature and language, you can duplicate subject values by pressing the duplicate icon and map them to the separate qualifications.


Selecting the subject type in the drop down filters the list by subject type: 


Step 9: Import Prior Attainment

Once you have synced your year groups and completed the mappings, navigate to the Cohorts page. The synced year groups will appear with a green tick next to them. The final step is to import your Prior Attainment data, via the Add Data link. Guides on uploading Prior Attainment can be found here: Support Hub | Prior Attainment Knowledge Base