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

Webservice send JSON without doble-quote("")

I have a simple webservice where I send the result from a mssql query through a webservice:

 

tMMSQLlinput-->tXMLmap-->tRESTtresponse

 

Problem is that I am sending a string through the webservice and the JSON field doesn't always have the doble-quote(""). This is the best picture to show the error:

0683p000009M1uN.png

I have to say that "quantitat" is a numeric field(talend bigdecimal) at the database but I have done all the possible casts to make it a string and still doesn't work.

 

This is my tXMLmap:

0683p000009M1sr.png

Any Ideas? I have checked all the schemas and stuff. Weirdest thing is that sometimes I am getting " " and sometimes doesn't. 

I have been working on it all the day but I am not being able to fix it.  I would appreciate any idea because I am not sure if this is a txmlmap problem, json...database with bigdecimal,deploying at karaf....I am lost.

Labels (5)
0 Replies