Using Scopus and OpenAlex APIs to retrieve bibliographic data for evidence synthesis. A procedure based on Bash and SQL

Abstract

Evidence synthesis methodologies rely on bibliographic data. The process of searching and retrieving bibliographic data can be supported by using bibliographic APIs. This paper presents a collection of code that serves both as a recipe book and a finished working example of how to interact with Scopus and OpenAlex APIs for the purpose of supporting evidence synthesis. While the procedure and code base presented here were developed as part of an evidence synthesis project in the field of nutrient recovery from human excreta and domestic wastewater for reuse in agriculture, the procedure and code base should be useful more broadly for evidence syntheses or bibliographic analyses also in other fields. center dot This paper presents a working example of how to interact with Scopus and OpenAlex APIs center dot The code base is written in SQL (MySQL) and Unix Shell (Bash) center dot The procedure was developed in an MacOS environment but should be portable to other environments

Keywords

Systematic map; Systematic review; Citation map; Bibliographic analysis; Bibliometric analysis

Published in

MethodsX
2024, volume: 12, article number: 102601

SLU Authors

• Harder, Robin

  • Department of Energy and Technology, Swedish University of Agricultural Sciences
    

UKÄ Subject classification

Environmental Sciences related to Agriculture and Land-use
Information Science

Publication identifier

• DOI: https://doi.org/10.1016/j.mex.2024.102601

Permanent link to this page (URI)

https://res.slu.se/id/publ/129089