Octophin built ticketing pipelines for many ticketing systems (Spektrix, TicketSolve, Tessitura and more); creating APIs, scrapers and importers to ingest, parse, normalise, analyse and anonymise (via Experian APIs) daily data on tickets, people and events.

Whether a REST API, SOAP API, SFTP server or csv files with bespoke naming conventions, we built a standard system and a series of ticketing provider engines to validate and convert data into a standard. This is then run through an anonymisation service, tagged with bespoke data and APIs from Experian, anonymised and sent to a relational database. 

 

Dealing with so many transactions from so many organisations, tuning for performance was essential. We also made the project, built almost entirely in python, highly modular, lightweight and easy to extend with new ticketing systems and fields. Detailed logging, documentation and an interface for non-programmers to use made this something that can grow long into the future. 

Using multiple external and internal datasets, we organised the information into a fast relational database enabling a wealth of reports, apps and beautiful interactive dashboards.

We also worked to get the demographic tagged information (analysed by arts audience experts at The Audience Agency) back into the ticketing system by building a multi-system API framework.