Drupal Edubase API Validation

Validating school information at entry

Business need

New Schools Network needed school reference and local-authority information checked against the Edubase database.

My contribution

I developed the custom API validation and integrated it with Drupal forms, logging and error reporting.

Delivered capability

The delivered functionality checked entered information against the external data source and worked with Drupal publishing rules.

Retrospective technical perspective

Using existing Drupal components for publishing and notification keeps custom code focused on the integration itself.

Delivery statements above are drawn from the original portfolio. The technical perspective is a present-day explanation, not a recovered record of the original decision process.

Original project detail

Historical portfolio · Work documented before the 2018 static archive. Descriptions reflect the original delivery, not current client systems. Explore selected case studies.

A custom module for validating the school reference number and the local authority name entered by the user against Edubase's database using Drupal's http request to connect to Edubase API.

Edubase is a central database of UK schools, such as the school name and type, the school's unique reference number, local authority and number of students.

The module uses Drupal’s core as much as possible, relying on the built-in comment module, views, rules and display suite. The module interacts with the comments form and other Drupal’s components for extending requests and validations, with event logging and error reporting.

Email notification, comment/review publishing and node publishing when a positive review is received are all done with the Rules module.

Edubase API returns different formats including XML and JSON, and it offers convenient views for returning objects with additional data.

Category