Reads the content of a JSON column and makes it available to an external caller. This node is used in workflows deployed as REST services, where the result of the web service is represented by the input of this node. By default a JSON array is returned, where each row of the input table is an element in the array. Tables with no or only one row result in an array with zero or one element. This behavior can be changed in the dialog, see the settings below.
Options
Popular Predecessors
- Table to JSON7 %
- Wait...3 %
- Workflow Service Output2 %
- Container Output (Table)2 %
- End IF2 %
- JSON Transformer2 %
Column Appender1 %- JSON to Table1 %
Loop End1 %- String Manipulation1 %
- JSON Row Combiner1 %
- Container Input (JSON)1 %
- Columns to JSON1 %
- Python Source (legacy)1 %
- POST Request1 %
Call Workflow (Table Based)1 %- DB Reader1 %
Variable to Table Row1 %CSV Reader1 %- XML to JSON1 %
Python Script (1⇒1)1 %- Concatenate< 1 %
- Files to Binary Objects< 1 %
- Excel Reader< 1 %
Scorer< 1 %Excel Reader (XLS)< 1 %- JSON Column Combiner< 1 %
- String to JSON< 1 %
- PUT Request< 1 %
- Container Input (Table)< 1 %
- Capture Workflow Start< 1 %
- CASE Switch End< 1 %
- Python Script (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- Variable to Table Column< 1 %
- Neo4j Reader< 1 %
- String to URI< 1 %
- Column Filter< 1 %
- GroupBy< 1 %
- Rule-based Row Filter< 1 %
- JSON Path< 1 %
MongoDB Reader< 1 %- GET Request< 1 %
- Breakpoint< 1 %
- Column Resorter< 1 %
- Cache< 1 %
- JSON to XML< 1 %
- Variable to Table Row< 1 %
- Scorer< 1 %
- Column Appender< 1 %
- Joiner< 1 %
- Merge Variables< 1 %
- JSON Reader< 1 %
- JSON Writer< 1 %
- MongoDB Reader< 1 %
- Reference Row Filter< 1 %
- Table Row to Variable< 1 %
- Amazon DynamoDB Batch Put< 1 %
- Table Reader< 1 %
Database Reader< 1 %- Table Creator< 1 %
JSON Reader< 1 %- JSON Schema Validator< 1 %
- Constant Value Column< 1 %
- String Replacer< 1 %
CASE Switch Data (End)< 1 %- Table Manipulator< 1 %
- Pivot< 1 %
- Top k Row Filter< 1 %
- Webpage Retriever< 1 %
- Create Collection Column< 1 %
Database Connection Table Reader< 1 %File Reader< 1 %Table Writer< 1 %- Java Snippet< 1 %
- Add Empty Rows< 1 %
- RowID< 1 %
- Image Viewer< 1 %
Variable to Table Row< 1 %Numeric Scorer< 1 %- Timer Info< 1 %
- Moving Aggregator< 1 %
Extract Outer/InnerHTML< 1 %- Salesforce SOQL< 1 %
- Random Forest Predictor< 1 %
Concatenate (Optional in)< 1 %- Cross Joiner< 1 %
Joiner< 1 %Merge Variables< 1 %- Data Generator< 1 %
- Document Vector Applier< 1 %
- Google Sheets Reader< 1 %
- R to Table< 1 %
- Catch Errors (Data Ports)< 1 %
- Catch Errors (Var Ports)< 1 %
Database Update< 1 %- Naive Bayes Predictor< 1 %
- IF Switch< 1 %
- DB Query Reader< 1 %
- Empty Table Creator< 1 %
- Twitter Users< 1 %
- RDKit Descriptor Calculation< 1 %
- Find Elements< 1 %
- Quit WebDriver< 1 %
- Column to Grid< 1 %
- DB Connection Closer< 1 %
- Transfer Files< 1 %
Database Query< 1 %Loop End (2 ports)< 1 %- k-Means< 1 %
- Decision Tree Predictor< 1 %
- MultiLayerPerceptron Predictor< 1 %
Row Filter (deprecated)< 1 %Column Rename< 1 %- Column Splitter< 1 %
- Rule Engine< 1 %
- Empty Table Switch< 1 %
- Send Email< 1 %
- Column Filter (legacy)< 1 %
Python Script (1⇒1)< 1 %- R Snippet< 1 %
- SPARQL Query< 1 %
- Fail in execution< 1 %
- XML Column Combiner< 1 %
- XPath< 1 %
- Text Classifier Predictor< 1 %
- HTTP Retriever< 1 %
- Advanced MolConverter< 1 %
- Elasticsearch Reader (ES 6)< 1 %
Binary Objects to Files< 1 %- List Remote Files (legacy)< 1 %
- Strings to Binary Objects< 1 %
- Upload (legacy)< 1 %
- Active Branch Inverter< 1 %
- Inject Variables (Data)< 1 %
Database Writer< 1 %Line Reader< 1 %List Files< 1 %Table Reader< 1 %- Loop End (Column Append)< 1 %
Variable Loop End< 1 %Regression Predictor< 1 %- Column Merger< 1 %
- Column Rename (Regex)< 1 %
- Constant Value Column Filter< 1 %
Row Splitter (deprecated)< 1 %- Ungroup< 1 %
- Unpivot< 1 %
- Value Counter< 1 %
- Single sample t-test< 1 %
- Statistics< 1 %
- Extract Table Dimension< 1 %
- Size Manager< 1 %
- Save Workflow< 1 %
- Random Number Assigner< 1 %
- Distance Matrix Calculate< 1 %
- Parallel Coordinates Plot (JavaScript)< 1 %
PMML Predictor< 1 %- H2O Numeric Scorer< 1 %
- Math Formula< 1 %
XLS Reader< 1 %Excel Reader (XLS)< 1 %- Word Parser< 1 %
- Decision Tree View (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- JSON Diff< 1 %
Python Script (2⇒1)< 1 %- Create Date&Time Range< 1 %
- Time to String (legacy)< 1 %
Twitter Streaming< 1 %- Column to XML< 1 %
- Fingerprints< 1 %
- URL Extractor< 1 %
- HTTP Result Data Extractor< 1 %
- Feed Parser< 1 %
- Chunk Loop Start< 1 %
Recursive Loop End< 1 %- Gradient Boosted Trees Predictor (Regression)< 1 %
- Duplicate Row Filter< 1 %
- Row Splitter (Labs)< 1 %
- Column Filter (PMML)< 1 %
- ROC Curve (legacy)< 1 %
- Explorer Browser< 1 %
- PDF Parser< 1 %
- Table View (JavaScript)< 1 %
- MongoDB Save< 1 %
Views
- JSON Snapshot
- Shows the JSON structure as read from the input (possibly converted into JSON array)
Workflows
_01_TestWF_Fails_Then_SucceedsKNIME Hub- _02_TestWF_FailsKNIME Hub
- _03_TestWF_SucceedsKNIME Hub
- _Configuration_TemplateKNIME Hub
- _Predictor_FlowKNIME Hub
- Show all 130 workflows
Links
- No links available
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.