Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Force mapping as array in Rest json request / tXMLMap

Hi,
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
0683p000009MA21.jpg0683p000009MAHo.jpg

Labels (5)
10 Replies
Anonymous
Not applicable
Author

I've created a publicly visible issue:
https://jira.talendforge.org/browse/TESB-16205.
Sergey