Call Remote Workflow (Row Based)

This node can be used to call other workflows that reside on a KNIME Server. Input data can be passed to Quickform Input nodes (only the new input nodes, e.g Container Input (JSON)) in the other workflow and results can likewise be read back as a JSON value from JSON Output nodes(e.g Container Output (JSON)). The input can either be a static JSON values provided via the dialog (which itself can be overridden by a flow variable) or from a JSON column in the input table. The node will call the other workflow with every row of the input table and append the results of the call to it.
The node will call the other workflow with every row of the input table and append the results of the call to it. The same remote workflow can be called by multiple nodes at the same time, a new job is created on the server for each node.

Options

Server address

The address to the KNIME Server's REST interface. This is usually something like http://server:8080/knime/rest.

User

The username on the server.

Password

The user's password the server.

Short duration: the workflow is expected to run quickly, less than 10 seconds (only applies if the called workflow is executed on a KNIME server)

Choose this if the called workflow is expected to finish within ten seconds. When selected, the invocation of the workflow will not poll its status, but wait until the job completes (or fails). This removes the polling overhead and makes this option quicker for short running workflows. Choosing this option for long running workflows (> a minute) will cause timeout problems.

Long duration: the workflow is expected to run longer than 10 seconds (only applies if the called workflow is executed on a KNIME server)

Choose this if the called workflow is expected to run for more than ten seconds. When selected, the invocation of the workflow will poll its status, that is start, poll, poll, ..., finish, until the job completes (or fails). This option is reasonable for long running workflows where the overhead of regularly polling the status is negligible. The polling is implemented so that for the first few seconds there will be frequent status checks (poll interval 100ms or 500ms), whereas jobs that run minutes or hours will be checked only every few seconds.

Asynchronous Invocation

The user's password the server.

Workflow path

The path of the workflow on the server you want to call. The path must an absolute path in the server's repository. You can either enter the path by hand, or click on List available workflows and then select a workflow in the dropdown list.

Create Report

If checked the report associated with the remote workflow will be generated and put into the output table. The format can be chosen in the drop-down. The output table will contain a column containing the binary content of the report (column type: binary object); the column can be further processed, e.g. use a "Binary Objects to Files" node to write the content to a file, or use a database writer to write the report as BLOB into a database. Failures to generate the report (for instance, because no report is attached to the workflow) will result in a missing cell.

Use Fully Qualified Name for Input and Output Parameters

If checked, use the full parameter name to select the input and output. The parameter names are defined by the user in the configuration dialog of each of the parameters (like JSON In/Output node), e.g. "timeout", "count", etc. Using these 'simple names' may lead to duplicates, hence a 'fully qualified name' is constructed by appending a suffix, e.g. "timeout-1" or "count-5:6". While these suffixes guarantee unique parameter names across one workflow they may cause names not to match in case you call out to different workflows (e.g. in a loop). It's good practice to (manually) ensure that parameter names in the called workflow are unique and hence often the 'simple name' is sufficient (= do not check the box).

Inputs

After you have loaded the input format you will see an input block for every input node in the called workflow. You can select if you want to use a static value or the value of a column for the respective input field or use the default value (that is the value that is set up in the workflow being called).

Input Ports

Any input, possibly with JSON column.

Output Ports

Output of workflow call

Best Friends (Incoming)

• Table to JSON (8 %) 
• Call Remote Workflow (Row Based) (6 %) 
• Table Creator (6 %) 
• Empty Table Creator (6 %) 
• Timer Info (4 %) 
• Table to JSON (4 %) 
• Credentials Input (3 %) 
• Table Row to Variable (2 %) 
• File Reader (2 %) Streamable
• Table Creator (2 %) 
• Loop End (2 %) 
• Chunk Loop Start (2 %) 
• Partitioning (2 %) 
• Transpose (2 %) 
• Data Generator (2 %) Streamable
• String to JSON (2 %) Streamable
• Container Input (JSON) (2 %) 
• Columns to JSON (2 %) Streamable
• Copy/Move Files (< 1 %) 
• Files to Binary Objects (< 1 %) 
• Unzip Files (< 1 %) 
• Table Column to Variable (< 1 %) 
• Variable to Table Row (< 1 %) 
• CSV Reader (< 1 %) 
• Database Reader (legacy) (< 1 %) 
• Extract System Properties (< 1 %) 
• File Reader (< 1 %) Streamable
• Table Writer (< 1 %) 
• Java Edit Variable (< 1 %) 
• Java Snippet (< 1 %) Streamable
• Variable Condition Loop End (< 1 %) 
• Generic Loop Start (< 1 %) 
• Recursive Loop Start (< 1 %) 
• Concatenate (< 1 %) Streamable
• Concatenate (Optional in) (< 1 %) Streamable
• Column Appender (< 1 %) Streamable
• Column Filter (< 1 %) Streamable
• Row Filter (< 1 %) Streamable
• Column Rename (< 1 %) Streamable
• RowID (< 1 %) Streamable
• Rule-based Row Filter (< 1 %) Streamable
• IF Switch (< 1 %) 
• CASE Switch Data (Start) (< 1 %) 
• Merge Variables (< 1 %) 
• Parallel Chunk Start (< 1 %) 
• Empty Table Creator (< 1 %) 
• Call Local Workflow (Row Based) (< 1 %) 
• Call Local Workflow (Row Based) (< 1 %) 
• Math Formula (< 1 %) Streamable
• Java IF (Table) (< 1 %) 
• String Input (< 1 %) 
• JSON Row Combiner (< 1 %) 
• Container Input (JSON) (< 1 %) 
• JSON Path (< 1 %) Streamable
• JSON Transformer (< 1 %) Streamable
• JSON Reader (< 1 %) 
• Columns to JSON (< 1 %) Streamable
• Call Workflow (Table Based) (< 1 %) 
• Python Script (2⇒1) (< 1 %) Deprecated
• GET Request (< 1 %) Streamable
• Create Date&Time Range (< 1 %) 
• XML Reader (< 1 %) 
• Show all 62 recommendations

Best Friends (Outgoing)

• Call Remote Workflow (Row Based) (11 %) 
• JSON to Table (9 %) 
• JSON to Table (9 %) 
• Binary Objects to Files (7 %) 
• Loop End (5 %) 
• JSON Path (5 %) Streamable
• Column Filter (4 %) Streamable
• JSON Path (4 %) Streamable
• Date&Time Difference (4 %) Streamable
• Data to Report (2 %) 
• Save File Locally (2 %) Streamable
• SSH Connection (2 %) 
• Catch Errors (Data Ports) (2 %) 
• Table Row to Variable (2 %) 
• Database SQL Executor (legacy) (2 %) 
• Database Writer (legacy) (2 %) Streamable
• Group Loop Start (2 %) 
• Recursive Loop Start (2 ports) (2 %) 
• Concatenate (2 %) Streamable
• Category To Number (2 %) Streamable
• Reference Column Filter (2 %) Streamable
• Column Rename (2 %) Streamable
• Ungroup (2 %) Streamable
• CASE Switch Data (Start) (2 %) 
• Create Temp Dir (2 %) 
• Merge Variables (2 %) 
• Parallel Chunk End (2 %) 
• Container Output (JSON) (2 %) 
• Columns to JSON (2 %) Streamable
• Time Generator (legacy) (2 %) 
• Table Row to Variable (2 %) 
• Column Filter (2 %) Streamable
• WrappedNode Output (2 %) 
• Call Workflow (Table Based) (2 %) 
• Show all 34 recommendations

Workflows

• 01_​call_​server_​workflow_​(JSON)
• 02_​Call_​a_​Workflow_​on_​a_​Server
• Model_​Factory

Installation

To use this node in KNIME, install KNIME nodes to connect to KNIME Server from the following update site: