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

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

kmrprvn — Sat, 16 Nov 2024 07:06:46 GMT

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.

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

vapukov — Thu, 06 Dec 2018 11:54:08 GMT

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

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

kmrprvn — Thu, 06 Dec 2018 11:58:33 GMT

its not showing in my product

image001.png

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

vapukov — Thu, 06 Dec 2018 12:09:48 GMT

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

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

kmrprvn — Thu, 06 Dec 2018 13:12:24 GMT

product details:

Talend Big Data Platform

Version: 6.5.1

Build id: 20180116_1512

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

vapukov — Thu, 06 Dec 2018 20:14:46 GMT

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

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

kmrprvn — Fri, 07 Dec 2018 06:18:00 GMT

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

btw thanks for your time. appreciate it

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

vapukov — Fri, 07 Dec 2018 06:21:41 GMT

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)

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

vapukov — Fri, 07 Dec 2018 06:24:57 GMT

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