I need to create a REST request in json format with an array of a second result in it.
My job works so far in 2 msqlinputs -> tXMLMap -> RESTClient (see screenshot 2)
The tXMLMap maps and joins to 2nd result of tMSSQLInput_2 to a loop item (lineItems - see screenshot 1) which is interpreted correctly as the formatting to json at the REST request does it as array - but only if there are at least 2 items in the tMSSQLInput_2 result.
If there is only 1 item in the resultset "lineItems" is formatted as object.
Unfortunately the REST server always expects an array there - no matter if there is only 1 item or more.
What do I need to do that "lineItems" are always formatted as array? Or do I need an other way of formatting the json?
Thanks in advance