Merging 2 JSON strings

I have 2 JSON strings in a single row of a table that I would like to merge for a POST request. Column 1 contains:

{"Plant":"Ballenger","steps":"5"}

		<p>while column 2 contains:</p>
		</td>
	</tr>
</tbody>

{ "metrics" : [ { "lowLimit" : "15141.6471360028", "metric" : "flow", "variance" : "4428.056652128874", "mean" : "21281.429122485933", "highLimit" : "34068.706056006304" }, { "lowLimit" : "4.444444444444445", "metric" : "temperature", "variance" : "0.5179906770510477", "mean" : "14.305004070036242", "highLimit" : "26.666666666666668" } ] }

		<p>Is there a way of merging the two in:</p>

		<p>{&quot;Plant&quot;:&quot;Ballenger&quot;, &quot;steps&quot;:&quot;5&quot;,&nbsp; &quot;metrics&quot; : [ { &quot;lowLimit&quot; : &quot;15141.6471360028&quot;, &quot;metric&quot; : &quot;flow&quot;, &quot;variance&quot; : &quot;4428.056652128874&quot;, &quot;mean&quot; : &quot;21281.429122485933&quot;, &quot;highLimit&quot; : &quot;34068.706056006304&quot; }, { &quot;lowLimit&quot; : &quot;4.444444444444445&quot;, &quot;metric&quot; : &quot;temperature&quot;, &quot;variance&quot; : &quot;0.5179906770510477&quot;, &quot;mean&quot; : &quot;14.305004070036242&quot;, &quot;highLimit&quot; : &quot;26.666666666666668&quot; } ] }</p>

		<p>Thanks in advance.</p>
		</td>
	</tr>
</tbody>

Maybe with JSON Merge/Transform.

JSON Transformer's merge patch option should do the trick, though you need to have one of the JSONs as a constant string, or as a flow variable. In case both are in a table with multiple rows, you will have to Chunk Loop Start (1-by-1) and use the Table Row to Variable nodes ending with a Loop End node.

Cheers, gabor

Thanks thor and aborg.  I was able to transform my JSON string as described in my original post using the JSON Merge/Transform node. Now I cannot seem to figure out what to do with it.  I tried to atttach the transformer node to a POST node; however, the POST node does not seem to recognize the column containing the JSON data. Using a Column Rename to change the column type to String has no effect. Passing the Transformer output through a "Create REST Representation" nodes adds a column name as an outer value and adds carriage returns and new lines which is not what I want.  Any ideas?  Thanks.

I would recommend wait a (few) day(s), soon KNIME will release 3.2 with a new KNIME labs project for REST calls.