Webservice send JSON without doble-quote("")

Highlighted
Seven Stars

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:

1.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:

123.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.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read