{"id":"https://openalex.org/W4391515352","doi":"https://doi.org/10.1016/j.mex.2024.102601","title":"Using Scopus and OpenAlex APIs to retrieve bibliographic data for evidence synthesis. A procedure based on Bash and SQL","display_name":"Using Scopus and OpenAlex APIs to retrieve bibliographic data for evidence synthesis. A procedure based on Bash and SQL","publication_year":2024,"publication_date":"2024-02-03","ids":{"openalex":"https://openalex.org/W4391515352","doi":"https://doi.org/10.1016/j.mex.2024.102601","pmid":"https://pubmed.ncbi.nlm.nih.gov/38361986","pmcid":"https://www.ncbi.nlm.nih.gov/pmc/articles/10867663"},"language":"en","primary_location":{"id":"doi:10.1016/j.mex.2024.102601","doi":"https://doi.org/10.1016/j.mex.2024.102601","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.mex.2024.102601","pdf_url":null,"source":{"id":"https://openalex.org/S2898269294","display_name":"MethodsX","issn_l":"2215-0161","issn":["2215-0161"],"is_oa":true,"is_in_doaj":true,"is_core":true,"listed_in":["anvur-scientific","cwts-core","doaj","dongbi-d","norway-1","poland-70"],"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"MethodsX","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref","doaj","pubmed"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1016/j.mex.2024.102601","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5019168180","display_name":"Robin Harder","orcid":"https://orcid.org/0000-0001-5723-1684","observed_orcids":["https://orcid.org/0000-0001-5723-1684"]},"institutions":[{"id":"https://openalex.org/I298625061","display_name":"Swedish University of Agricultural Sciences","ror":"https://ror.org/02yy8x990","country_code":"SE","type":"education","lineage":["https://openalex.org/I298625061"]}],"countries":["SE"],"is_corresponding":true,"raw_author_name":"Robin Harder","raw_affiliation_strings":["Environmental Engineering Group, Department of Energy and Technology, Swedish University of Agricultural Sciences (SLU), Uppsala, Sweden"],"raw_orcid":"https://orcid.org/0000-0001-5723-1684","affiliations":[{"raw_affiliation_string":"Environmental Engineering Group, Department of Energy and Technology, Swedish University of Agricultural Sciences (SLU), Uppsala, Sweden","institution_ids":["https://openalex.org/I298625061"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5019168180"],"corresponding_institution_ids":["https://openalex.org/I298625061"],"apc_list":{"value":850,"currency":"USD","value_usd":850},"apc_paid":{"value":850,"currency":"USD","value_usd":850},"fwci":2.7272,"has_fulltext":true,"cited_by_count":23,"citation_normalized_percentile":{"value":0.95382114,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":"12","issue":null,"first_page":"102601","last_page":"102601"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10206","display_name":"Meta-analysis and systematic reviews","score":0.6098999977111816,"subfield":{"id":"https://openalex.org/subfields/1804","display_name":"Statistics, Probability and Uncertainty"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T10206","display_name":"Meta-analysis and systematic reviews","score":0.6098999977111816,"subfield":{"id":"https://openalex.org/subfields/1804","display_name":"Statistics, Probability and Uncertainty"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10102","display_name":"scientometrics and bibliometrics research","score":0.33009999990463257,"subfield":{"id":"https://openalex.org/subfields/3309","display_name":"Library and Information Sciences"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11937","display_name":"Research Data Management Practices","score":0.015399999916553497,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/scopus-api","display_name":"Scopus API","score":0.7929999828338623},{"id":"https://openalex.org/keywords/openalex-api","display_name":"OpenAlex API","score":0.9980000257492065},{"id":"https://openalex.org/keywords/bibliographic-data-retrieval","display_name":"bibliographic data retrieval","score":0.9800000190734863},{"id":"https://openalex.org/keywords/evidence-synthesis","display_name":"evidence synthesis","score":0.8080000281333923},{"id":"https://openalex.org/keywords/nutrient-recovery","display_name":"nutrient recovery","score":0.7440000176429749},{"id":"https://openalex.org/keywords/human-excreta","display_name":"human excreta","score":0.9520000219345093},{"id":"https://openalex.org/keywords/domestic-wastewater","display_name":"domestic wastewater","score":0.8100000023841858},{"id":"https://openalex.org/keywords/agricultural-reuse","display_name":"agricultural reuse","score":0.628000020980835},{"id":"https://openalex.org/keywords/bash-scripting","display_name":"Bash scripting","score":0.5329999923706055},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6269999742507935}],"concepts":[{"id":"https://openalex.org/C112968700","wikidata":"https://www.wikidata.org/wiki/Q11368","display_name":"Unix","level":3,"score":0.8249446153640747},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7823482751846313},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6685766577720642},{"id":"https://openalex.org/C83867959","wikidata":"https://www.wikidata.org/wiki/Q371467","display_name":"Scopus","level":3,"score":0.6647520065307617},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5135310292243958},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5015554428100586},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4899653494358063},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.4773431122303009},{"id":"https://openalex.org/C206588197","wikidata":"https://www.wikidata.org/wiki/Q846574","display_name":"Reuse","level":2,"score":0.47000107169151306},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.44057926535606384},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.4061220586299896},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.35064196586608887},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3398545980453491},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.17858484387397766},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.1066582202911377},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","level":2,"score":0.09635809063911438},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.07695391774177551},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C548081761","wikidata":"https://www.wikidata.org/wiki/Q180388","display_name":"Waste management","level":1,"score":0.0}],"mesh":[],"locations_count":5,"locations":[{"id":"doi:10.1016/j.mex.2024.102601","doi":"https://doi.org/10.1016/j.mex.2024.102601","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.mex.2024.102601","pdf_url":null,"source":{"id":"https://openalex.org/S2898269294","display_name":"MethodsX","issn_l":"2215-0161","issn":["2215-0161"],"is_oa":true,"is_in_doaj":true,"is_core":true,"listed_in":["anvur-scientific","cwts-core","doaj","dongbi-d","norway-1","poland-70"],"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"MethodsX","raw_type":"journal-article"},{"id":"pmh:oai:pubmedcentral.nih.gov:10867663","doi":null,"is_oa":true,"landing_page_url":"https://www.ncbi.nlm.nih.gov/pmc/articles/10867663","pdf_url":"https://pmc.ncbi.nlm.nih.gov/articles/PMC10867663/pdf/main.pdf","source":{"id":"https://openalex.org/S2764455111","display_name":"PubMed Central","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"MethodsX","raw_type":"Text"},{"id":"pmid:38361986","doi":null,"is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/38361986","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"MethodsX","raw_type":"Journal Article"},{"id":"pmh:oai:pub.epsilon.slu.se:33302","doi":null,"is_oa":true,"landing_page_url":"https://pub.epsilon.slu.se/33302/1/harder-r-et-al-20240402.pdf","pdf_url":"https://pub.epsilon.slu.se/33302/1/harder-r-et-al-20240402.pdf","source":{"id":"https://openalex.org/S4306402317","display_name":"Epsilon Open Archive (Sveriges lantbruksuniversitet biblioteket (Swedish University of Agricultural Sciences))","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I298625061","host_organization_name":"Swedish University of Agricultural Sciences","host_organization_lineage":["https://openalex.org/I298625061"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Research article"},{"id":"pmh:oai:doaj.org/article:14b112ba85544b838c9623e84729eeeb","doi":null,"is_oa":true,"landing_page_url":"https://doaj.org/article/14b112ba85544b838c9623e84729eeeb","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"MethodsX, Vol 12, Iss , Pp 102601- (2024)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.1016/j.mex.2024.102601","doi":"https://doi.org/10.1016/j.mex.2024.102601","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.mex.2024.102601","pdf_url":null,"source":{"id":"https://openalex.org/S2898269294","display_name":"MethodsX","issn_l":"2215-0161","issn":["2215-0161"],"is_oa":true,"is_in_doaj":true,"is_core":true,"listed_in":["anvur-scientific","cwts-core","doaj","dongbi-d","norway-1","poland-70"],"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"MethodsX","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G3107977577","display_name":"End-of-wastewater: Co-creation of a knowledge brokering and public engagement toolbox to support sustainable nutrient and carbon recovery and reuse","funder_award_id":"20200021","funder_id":"https://openalex.org/F4320325984","funder_display_name":"Familjen Kamprads Stiftelse"}],"funders":[{"id":"https://openalex.org/F4320325984","display_name":"Familjen Kamprads Stiftelse","ror":"https://ror.org/03qb1q739"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4391515352.pdf","grobid_xml":"https://content.openalex.org/works/W4391515352.grobid-xml"},"referenced_works_count":18,"referenced_works":["https://openalex.org/W2014453502","https://openalex.org/W2755149525","https://openalex.org/W2886042501","https://openalex.org/W2951317979","https://openalex.org/W2961191798","https://openalex.org/W3000895385","https://openalex.org/W3001137683","https://openalex.org/W3001554335","https://openalex.org/W3002281830","https://openalex.org/W3002924435","https://openalex.org/W3123554164","https://openalex.org/W3160856016","https://openalex.org/W3197982530","https://openalex.org/W4200362342","https://openalex.org/W4229010617","https://openalex.org/W4323050355","https://openalex.org/W4387380744","https://openalex.org/W4401981609"],"related_works":["https://openalex.org/W2914498600","https://openalex.org/W2954057334","https://openalex.org/W7222889724","https://openalex.org/W7132359345","https://openalex.org/W7025322601","https://openalex.org/W3091715664","https://openalex.org/W7125365508","https://openalex.org/W6986145962","https://openalex.org/W7108225041","https://openalex.org/W3165471434"],"abstract_inverted_index":{"Evidence":[0],"synthesis":[1,72],"methodologies":[2],"rely":[3],"on":[4],"bibliographic":[5,13,20,104],"data.":[6],"The":[7],"process":[8],"of":[9,27,41,53,69,77,115],"searching":[10],"and":[11,36,47,60,83,92,121,131],"retrieving":[12],"data":[14],"can":[15],"be":[16,96,144],"supported":[17],"by":[18],"using":[19],"APIs.":[21],"This":[22],"paper":[23,110],"presents":[24,111],"a":[25,33,37,112],"collection":[26],"code":[28,61,93,124],"that":[29],"serves":[30],"both":[31],"as":[32,67],"recipe":[34],"book":[35],"finished":[38],"working":[39,113],"example":[40,114],"how":[42,116],"to":[43,117,146],"interact":[44,118],"with":[45,119],"Scopus":[46,120],"OpenAlex":[48,122],"APIs":[49],"for":[50,86,100],"the":[51,58,75,90],"purpose":[52],"supporting":[54],"evidence":[55,71,101],"synthesis.":[56],"While":[57],"procedure":[59,91,135],"base":[62,94,125],"presented":[63],"here":[64],"were":[65],"developed":[66,137],"part":[68],"an":[70,139],"project":[73],"in":[74,88,107,128,138],"field":[76],"nutrient":[78],"recovery":[79],"from":[80],"human":[81],"excreta":[82],"domestic":[84],"wastewater":[85],"reuse":[87],"agriculture,":[89],"should":[95,143],"useful":[97],"more":[98],"broadly":[99],"syntheses":[102],"or":[103],"analyses":[105],"also":[106],"other":[108,147],"fields.\u2022This":[109],"APIs\u2022The":[123],"is":[126],"written":[127],"SQL":[129],"(MySQL)":[130],"Unix":[132],"Shell":[133],"(Bash)\u2022The":[134],"was":[136],"MacOS":[140],"environment":[141],"but":[142],"portable":[145],"environments.":[148]},"counts_by_year":[{"year":2026,"cited_by_count":10},{"year":2025,"cited_by_count":9},{"year":2024,"cited_by_count":4}],"updated_date":"2026-11-10T11:39:43.021295","created_date":"2024-02-04T00:00:00"}