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

Six Stars

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

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. Capture.JPG

 

 

can some please explain how i can get expected target.

Thirteen Stars

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

it is there, Advanced tab of tWriteJsonField:

Screen Shot 2018-12-07 at 12.52.04 AM.png

 

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
-----------
Six Stars

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

its not showing in my productimage001.png

 

 

Thirteen Stars

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

 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

-----------
Six Stars

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

product details:

 

Talend Big Data Platform

 

Version: 6.5.1

Build id: 20180116_1512

Thirteen Stars

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

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 Smiley Wink

in 6.5 - no this settings

-----------
Six Stars

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

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

btw thanks for your time. appreciate it
Highlighted
Thirteen Stars

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

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)

-----------
Thirteen Stars

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

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

Screen Shot 2018-12-07 at 7.23.34 PM.png

 

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

-----------

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.