Leveraging Web 2.0 technologies to add value to the IUPAC Solubility Data Series: Development of a REST style website and application programming interface (API)

Document Type

Article

Publication Date

12-1-2015

Abstract

This paper details an approach to re-purposing scientific data as presented on a web page for the sole purpose of making the data more available for searching and integration into other websites. Data 'scraping' is used to extract metadata from a set of pages on the National Institute of Standards and Technology (NIST) website, clean, organize and store the metadata in a MySQL database. The metadata is then used to create a new website at the authors institution using the CakePHP framework to create a representational state transfer (REST) style application program interface (API). The processes used for website analysis, schema development, database construction, metadata scraping, REST API development, and remote data integration are discussed. Lessons learned and tips and tricks on how to get the most out of the process are also included.

Publication Title

Pure and Applied Chemistry

Volume

87

Issue

11-12

First Page

1127

Last Page

1137

Digital Object Identifier (DOI)

10.1515/pac-2015-0403

ISSN

00334545

E-ISSN

13653075

Share

COinS