topic Re: [resolved] Problem tXmlMap and null value in Talend Studio

[resolved] Problem tXmlMap and null value

Anonymous — Sat, 30 Aug 2014 10:13:26 GMT

I have this structure
Database-tXmlMap-tRestClient to convert xml to json....I have a problem because if i have null value, tRestClient convert null value with "" for example
"chiave":"" this is not correct i will "chiave":"null"
I have try another structure
tDatabase-tWriteJsonField but i have multiple errore for example impossible to convert map(string,sting) to map(string,date) and is impossible to execute this operation

If i have
database-txmlmap-trestclient is possible to insert null value??
Is possibile to use
Database-tWriteJsonField and resolve the problem of field date?

Re: [resolved] Problem tXmlMap and null value

Anonymous — Sun, 31 Aug 2014 13:26:45 GMT

What you want is actually not correct because "null" mean nothing else than a String with the content "null". In JSON or XML you have only the chance to leaf the attribute out completely or write an empty string.

Re: [resolved] Problem tXmlMap and null value

Anonymous — Mon, 01 Sep 2014 14:17:41 GMT

This is a problem, the component for generate Json are wrong..because txml generate null field with "" but a web service use the controll
if( field == null || ...ecc---all web service
tWriteJsonField generate all field with string value but all web service will deduce the type of a field in base of the syntax of the field....i use a tjava with json library but is not a good solution

Re: [resolved] Problem tXmlMap and null value

Anonymous — Mon, 01 Sep 2014 14:34:13 GMT

Serve a new component

Re: [resolved] Problem tXmlMap and null value

TRF — Fri, 19 Jun 2015 17:17:12 GMT

Hi,
I have the same problem with tXMLMap (null values changed to "").
Does anyone has a solution for that?
In my case, I have a flow issued from an Excel file transformed to XML by tXMLMap then push to tRESTClient which call a service with JSON content:
tFileInputExcel --> tXMLMap --> tRESTClient
Received messages by the service contain for example "lastContactAdded":"" but "lastContactAdded":null is expected.
Regards,
Fred

Re: [resolved] Problem tXmlMap and null value

TRF — Fri, 19 Jun 2015 17:39:43 GMT

Found the solution.
If you got the same problem, in tXMLMap, go to Settings in output part then select "false" for the option "Create empty element".
As empty elements are not sended any more with this option activated, the service now receive null values for the corresponding fields.
That's what I want.
Regards,
Fred