auto{API} – A Web-Based Tool for Specification of an API Endpoint to Return JSON Data From an XML Source

Adrian Moore

doi:10.5334/jors.335

auto{API} – A Web-Based Tool for Specification of an API Endpoint to Return JSON Data From an XML Source

Journal of Open Research Software

Volume 9 (2021): Issue 1

By: Adrian Moore

Open Access

|Aug 2021

Abstract

auto{API} is a web-based tool for the specification and management of API endpoints to online XML data sources. The APIs generated return the data in JSON format. The tool allows users to specify the field names to be used in the JSON data and to control which elements of the original data set are returned. Options are provided for the returned data to skip null values and to flatten the structure that is retrieved. auto{API} is written in Python/Flask and is available under the MIT licence. The software is available from GitHub (https://github.com/aamoore/autoAPI) and can be seen deployed at https://autoapi-app.herokuapp.com/?http://apis.opendatani.gov.uk/translink/3042AA.xml.

References

Quin L. Extensible Markup Language (XML) [online]; 2016. Available at: https://www.w3.org/XML/ [Accessed 10 June 2020].
Search in Google Scholar Back to article
ECMA International. The JSON Data interchange Syntax, 2nd Ed. [online]; 2017. Available at: http://www.ecma-international.org/publications/files/ECMA-ST/ECMA-404.pdf [Accessed 10 June 2020].
Search in Google Scholar Back to article
Blech M. xmltodict. Python module that makes working with XML feel like you are working with JSON. [online]; 2014. Available at: https://github.com/martinblech/xmltodict [Accessed 10 June 2020].
Search in Google Scholar Back to article
OpenDataNI. Open Data Northern Ireland. [online]; 2015. Available at https://www.opendatani.gov.uk [Accessed 10 June 2020].
Search in Google Scholar Back to article
Jiffy J, Panicker J, Meera M. An efficient natural language interface to XML database. 2016 International Conference on Information Science (ICIS), Kochi, 2016; 207–212. DOI: 10.1109/INFOSCI.2016.7845328
Open DOI Search in Google Scholar Back to article
David M. Ten Problems with XQuery and the SQL/XML Standard. [online]; 2010. Available at https://www.databasejournal.com/sqletc/article.php/3865201/Ten-Problems-with-XQuery-and-the-SQLXML-Standard.htm [Accessed 07 July 2020].
Search in Google Scholar Back to article
Lu C, Dos Santos RF, Sripada LN, Kou Y. Advances in GML for Geospatial Applications. Geoinformatica. 2007; 11: 131–157. DOI: 10.1007/s10707-006-0013-9
Open DOI Search in Google Scholar Back to article
Somaraki V, Xu Z. Knowledge representation of large medical data using XML. 22nd International Conference on Automation and Computing (ICAC), Colchester. 2016; 423–428. DOI: 10.1109/IConAC.2016.7604956
Open DOI Search in Google Scholar Back to article