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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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