How to avoid double quotes for json integer/boolean datatypes fields in tWriteJsonField

[kmrprvn]

Hi All,

I am able to construct json structure using tWriteJsonField but problem is i am getting double quotes for every field in json.

i don't want double quotes for int/Boolean data types. even i am passing those fields with respective data types. still tWriteJsonField not generating as expected.

i am seeing feature to on/off double quote option in this link https://help.talend.com/reader/WfrS1ZaBst3az8zJBGoMSQ/dNXrPF_vuwi0Smw5iIL~0g . but i did't find it not in my talend big data enterprise 6.5.1 version. 

can some please explain how i can get expected target.

[vapukov]

it is there, Advanced tab of tWriteJsonField:

unchecked:

[statistics] connected
{"rootTag":{"data":{"strCol":"this a string","intCol":1,"DateCol":"2018-12-06 15:35:44","boolCol":true}}}
[statistics] disconnected

checked:

[statistics] connected
{"rootTag":{"data":{"strCol":"this a string","intCol":"1","DateCol":"2018-12-06 15:35:44","boolCol":"true"}}}
[statistics] disconnected

[kmrprvn]

its not showing in my product

image001.png

[vapukov]

 what version you check in documentation and what you use?

as I could guess (could but not a must!!!)  it is 6.* - in this case you need upgrade

[kmrprvn]

product details:

Talend Big Data Platform

Version: 6.5.1

Build id: 20180116_1512

[vapukov]

yes, and in documentation link from your first post - Talend 7.0

this is why it is important to provide more information if need answer. Here not a quiz night

in 6.5 - no this settings

[kmrprvn]

I think you didn't read my whole question properly. i included version details in question.

btw thanks for your time. appreciate it

[vapukov]

you are right, sorry - skip this line with first reading

btw, as you can see - docs about version 7, and all there (I have 6.5 as well, this is why asking)

[vapukov]

for avoid wrong information, proper way to search in help:

start not from google, which return unpredicted version, but on start page choose version of product