topic Re: How to create json output to file retaining non-string data types in Talend Studio

How to create json output to file retaining non-string data types

andre4598 — Sat, 16 Nov 2024 09:34:38 GMT

I have a job where I am trying to transform a csv input file to create a json output to file.

The csv file contains string values as well as integer values. However it produces all values as string (between quotes) even when the data types are not string i.e. integer value 123456789 as "123456789".

My job has the following components

tFileInputDelimited >>tMap>>tWriteJSONField>>tLogRow>>tFileOutputDelimited

Is there a simple way of doing this?

Re: How to create json output to file retaining non-string data types

Anonymous — Thu, 29 Jun 2017 07:29:20 GMT

Input and tFileOutputJson components is enough for this task.

in tFileOutputJson component if we have int as datatype then we will get with out quotes for integer values.

See attached screenshots.

json_1.PNG
output_Json.PNG

Re: How to create json output to file retaining non-string data types

andre4598 — Thu, 29 Jun 2017 13:58:35 GMT

Thanks but what I am trying to do is take in a csv file and transform it into a json file.

I have an example below...

This is the sample file

In the tMap the person_id is converted from string to an integer

However when I execute my job it writes out person_id value as a string (see log output below)

Is there a way to solve this?

Re: How to create json output to file retaining non-string data types

cterenzi — Thu, 29 Jun 2017 16:00:33 GMT

@ThirupathiReddy is using tFileOutputJSON rather than tWriteJSONField. Here is the documentation for tWriteJSONField:

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/ZXYb2NIVoiib7B8sYGRVJQ

The section on Configuring a JSON Tree addresses your issue specifically.

Re: How to create json output to file retaining non-string data types

andre4598 — Mon, 03 Jul 2017 15:13:34 GMT

Thanks but it does not produce the json in the format that I need.

I have created a work-around by building the json as variables in a tMap and concatenating the variables together and writing to a file with .json extension, this does the trick for me.

Re: How to create json output to file retaining non-string data types

Anonymous — Tue, 04 Jul 2017 09:20:10 GMT

Hello,

I have created a work-around by building the json as variables in a tMap and concatenating the variables together and writing to a file with .json extension, this does the trick for me.

Would you mind posting your work around and solution on forum?

Best regards

Sabrina

Re: How to create json output to file retaining non-string data types

andre4598 — Wed, 12 Jul 2017 18:06:34 GMT

I revisited @cterenzi suggestion and have got my job working.

Thanks