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)
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.
Pure and Applied Chemistry
Digital Object Identifier (DOI)
Chalk. (2015). 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). Pure and Applied Chemistry, 87(11), 1127–1137. https://doi.org/10.1515/pac-2015-0403