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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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