About Spotless web-based API service

API or application interface programming makes data integration easier than ever before

Our unique browseable API is the swiftest and surest route to data quality.

Spotless Data's unique web-based data quality API solution takes care of your big data throughout their life cycles in order to ensure that they remain clean from contamination or corruption from the moment you receive or generate your data until they are no longer required. We have identified six stages within this process:

1. Data collection

Most data are either entered by your employees, are User-Generated-Content (UGC), come from a specific 3rd party source or sources (for instance a UK TV listings service may receive its data from the six different TV channel owners or from a central repository such as Red Bee which itself receives the information directly from the six channel owners) or is generated automatically, either by systems which your company have designed, or by a third party. At this point of collection, you send your fresh data to us at Spotless.

2 Data storage

As soon as we receive your big data we will validate all the fields, checking for duplications and ensure the data validation of all the fields within said data.

3. Data integration

Many companies think they can cope with their single dataset but, when it comes to trying to merge two or more different datasets, for instance when upgrading your platform or because your data are in different formats, to ensure data integrity they are unable to do the job seamlessly. Using our unique API web-based service you will see the results when your new datasets or updated single dataset work perfectly.

4. Data analytics

Here we will inspect and transform your data using our latest Spotless Analytics. This means that you will then be able to draw conclusions and make critical decisions for your company's future based on accurate, well-organized data.

5. Data reporting

Management reporting is vital to the health and success of your business. For instance, without accurate sales reporting it is unlikely that your company will stand out among its competitors, regardless of how good your product is, and it could result in your business employing too many or too few salespeople. As the owner/CEO of your business, you need to have statistically accurate reports on every aspect of your business in order to ensure long-term success and the achievement of realistic goals.

6. Data archiving

Archiving can be particularly important for companies which need to preserve a record of their data for legal purposes, such as data storage compliance regulations and data protection laws. For instance, businesses in the UK need to comply with the Data Protection Act 1998 as well as the recently passed Investigatory Powers Act while any company which holds data on EU citizens needs to fulfil the requirements of the EU Data Protection Directive 1995. Given the nature of the modern world, you will have to comply with laws in at least one place, and if yours is an international business, in many places at the same time. Archived data which are well-organised, safely stored and easy to retrieve are going to ensure that yours is not the business caught out in violation of what is a complex web of laws and standards. Other reasons why data archiving is important include having a realistic picture of your company's history in order to plan for the future and having accurate records of customer information.

Ensuring that your data are well scrubbed is done by ensuring the data validation of them through the creation of validation solutions. We do this ourselves or you can create your own validation rules with our unique API. When a piece of data fails to meet a validation rule it is either rejected and expelled from the database or it is automatically corrected so that it can remain in your database. The needs of differing data vary. For instance, if the data is a number of email addresses and it is clear that a particular email address is beyond recovery, perhaps being simply the work of a UGC prankster, it can be expelled from the system forever but this cannot be allowed to happen with, say, a TV listings service entry piece of data. If something appears on the UK TV channel BBC2 at 11:30 pm it is not acceptable to delete the piece data and leave the space empty within the TV listings, as if nothing was appearing on BBC2 at that time. In these cases, following a series of pre-set rules, the solution is that if the problem cannot be fixed automatically it is escalated for a human being to review and correct manually.

Please do sign up for our service using your email address, Facebook, Google or GitHub accounts. Here is a quick link to our FAQ. You can also check out our range of Subscription Packages and Pricing, and try it out with 500Mb of free data cleaning. You can also view our videos on data cleaning an EPG file and data cleaning a genre column which explain how to use our API. If you would like to contact us you can speak to one of our team by pressing on the white square icon with a smile within a blue circle, which you can find in the bottom right-hand corner of any of the web pages on our site.

Spotless Data, the one stop data quality API! solution

If your data quality is an issue or you know that you have known sources of dirty data but your files are just too big, and the problems too numerous to be able to fix manually please do log in and try now