Icon

S2 API XPATH EXCEL 1

This workflow extracts academic papers from Semantic Scolar. Data included:

Search term(s)
Paper Title
Paper ID
Authors
Author IDs
Journal
Year published
Abstract
Citations
Influential Citations

Inputs are through a component. Output currently are Tile View, Javascript Table View, Table View (Labs) and user choice of xlsx or csv.

Change folderpath in TableCreatornode to your localdestination. Filter duplicatepaperIDsSelect InitialColumnsDouble ClickInput SearchTermsCreate AuthorListRemove ExtraSpaces in Author ListCreateInteractive TableCreate AuthorIdListRemove ExtraSpaces in AuthorId ListJoin Authors& AuthorIdsFinal ColumnOrderEdit TitleStyleNode 140Flow Variables CreateSearch Terms,Year & Offset FilenameCreate BaseFile PathCreates FilePath StringCreates File PathInput Filefor FormatterNode 147Node 148Writes SelectedFile TypeWait for InputFile WriteNode 151Retain CR/LF DuplicateRow Filter Table Manipulator SemanticScholar API String Manipulation String Manipulation Table View String Manipulation String Manipulation Joiner Table Manipulator CSS Editor Table View (Labs) String Manipulation Table Creator Table Rowto Variable String to Path(Variable) Excel Writer XLS Control Tablefrom Cell Range XLS Cell Formatter XLS Formatter(apply) Wait... Tile View String Manipulation(Multi Column) Change folderpath in TableCreatornode to your localdestination. Filter duplicatepaperIDsSelect InitialColumnsDouble ClickInput SearchTermsCreate AuthorListRemove ExtraSpaces in Author ListCreateInteractive TableCreate AuthorIdListRemove ExtraSpaces in AuthorId ListJoin Authors& AuthorIdsFinal ColumnOrderEdit TitleStyleNode 140Flow Variables CreateSearch Terms,Year & Offset FilenameCreate BaseFile PathCreates FilePath StringCreates File PathInput Filefor FormatterNode 147Node 148Writes SelectedFile TypeWait for InputFile WriteNode 151Retain CR/LFDuplicateRow Filter Table Manipulator SemanticScholar API String Manipulation String Manipulation Table View String Manipulation String Manipulation Joiner Table Manipulator CSS Editor Table View (Labs) String Manipulation Table Creator Table Rowto Variable String to Path(Variable) Excel Writer XLS Control Tablefrom Cell Range XLS Cell Formatter XLS Formatter(apply) Wait... Tile View String Manipulation(Multi Column)

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: genef
Created at: 2023-02-21
On NodePit since: 2023-04-05
Last update: 2024-04-26
Created with KNIME version: v4.7.2
Tags: Semantic Scholar

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!