topic Re: Getting backslashes in tFileOutputJson output in Talend Studio

Getting backslashes in tFileOutputJson output

javvaji — Mon, 28 May 2018 16:01:38 GMT

Hi Team,

While i am trying to export json data to .json file using tFileOutputJson component every key and values are enclosing in backslashes. I am trying to export multiple json objects in one json file. Can any one help me on this.

Ex : {\"ID\":\"D722CAB9C24129B1\"}

Thanks,

Bharath.

Re: Getting backslashes in tFileOutputJson output

vboppudi — Tue, 29 May 2018 15:07:45 GMT

Please provide more details on your requirement.

Regards,

Re: Getting backslashes in tFileOutputJson output

javvaji — Tue, 29 May 2018 15:15:48 GMT

Hi @vboppudi,

We have to export data from table to .json file in json format. We have tried to parse and export it but while exporting data to Json file we are getting backslashes for each key and values in json.

Below is the sample record from file.

Ex : {\"ID\":\"C24129B121\",\"CUSTOMER_ID\":\"Null\"}

Thanks,

Bharath.

Re: Getting backslashes in tFileOutputJson output

vboppudi — Tue, 29 May 2018 15:22:00 GMT

Can you please provide input data as well if possible.

Regards,

Re: Getting backslashes in tFileOutputJson output

javvaji — Tue, 29 May 2018 17:41:18 GMT

Hi @vboppudi,

Input data is as follows

ID,CUSTOMER_ID

C24129B121,Null

C2412AB121,AB2324

C6556JKNS,SBH6844

Thanks,

Bharath.

Re: Getting backslashes in tFileOutputJson output

vboppudi — Tue, 29 May 2018 17:51:23 GMT

Hi,

Are you looking for the following out put?

Can you please post you job if possible?

Regards,

Re: Getting backslashes in tFileOutputJson output

abo — Mon, 06 Aug 2018 12:39:44 GMT

Hello Everyone,

i am interested by the answer. I have same issue.

Here is my job and the json file in output.

My second problem is , i still have the "root" named Json in the file.

Or i did check "remove root node" in my tWriteJSONField

thank you guys.

Re: Getting backslashes in tFileOutputJson output

UniperDataLake — Wed, 02 Jan 2019 16:13:37 GMT

Hi all,

Has anyone managed to resolve the issues?

I am using Talend Real-time Big Data Platfrom 6.4.1 (Build 20170623_1246) and 7.1.1 (20181026_1147), and experiencing exactly same issues on both versions.

- escape character backslash is included for every double quotation used for keys and values

- the option "Remove root node" in tWriteJSONField is not working in combination with tFileOutputJSON

The issue is not given when logging from tWriteJSONField into tLogRow, and writing directly from tWriteJSONField to tFileOutputDelimited.

I need to use tFileOutputJSON to put everything into a JSON array brackets.

Capture_Talend_Job.PNG
JSON_Result.PNG
MESAP_Data_Container_Dump_JSON_Test.zip
json_out.zip

Re: Getting backslashes in tFileOutputJson output

UniperDataLake — Wed, 02 Jan 2019 16:41:15 GMT

Hi all,

Has anyone managed to resolve the issues?

I am using Talend Real-time Big Data Platfrom 6.4.1 (Build 20170623_1246) and 7.1.1 (20181026_1147), and experiencing exactly same issues on both versions.

- escape character backslash is included for every double quotation used for keys and values

- the option "Remove root node" in tWriteJSONField is not working in combination with tFileOutputJSON

The issue is not given when logging from tWriteJSONField into tLogRow, and writing directly from tWriteJSONField to tFileOutputDelimited.

I need to use tFileOutputJSON to put everything into a JSON array brackets.

Please let me know.

Thanks

MESAP_Data_Container_Dump_JSON_Test.zip
Capture_Talend_Job.PNG
JSON_Result.PNG

Re: Getting backslashes in tFileOutputJson output

UniperDataLake — Wed, 02 Jan 2019 17:27:46 GMT

Hi all,

Has anyone managed to resolve the issues?

I am using Talend Real-time Big Data Platfrom 6.4.1 (Build 20170623_1246) and 7.1.1 (20181026_1147), and experiencing exactly same issues on both versions.

- escape character backslash is included for every double quotation used for keys and values

- the option "Remove root node" in tWriteJSONField is not working in combination with tFileOutputJSON

The issue is not given when logging from tWriteJSONField into tLogRow, and writing directly from tWriteJSONField to tFileOutputDelimited.

I need to use tFileOutputJSON to put everything into a JSON array brackets.

Please let me know.

Thanks

Re: Getting backslashes in tFileOutputJson output

Anonymous — Wed, 13 Feb 2019 14:24:05 GMT

Hi,

I encounter similar issue with the tRESTResponse component in TOS-ESB 7.1.1.

Part of the result :

roles

"{\"F06A\":[\"Resp\"],\"F06B\":[\"Resp\"],\"F06C\":[\"Resp\"],\"F06D\":[\"Resp\"],\"F06D1\":[\"Resp\"],\"F06E\":[\"Resp\"],\"F06E1\":[\"Resp\"],\"F06C2\":[\"Resp\"],\"F06C1\":[\"Resp\"],\"1F06\":[\"Resp\"],\"F06C4\":[\"Resp\"],\"F06C3\":[\"Resp\"]}"

The

I tried a lot of different settings without results.

My webservice must give data to another application which don't accept backslashes.

Thanks fo help.

Re: Getting backslashes in tFileOutputJson output

jain1 — Sun, 01 Dec 2019 07:46:02 GMT

I am facing the same issue while generating json files using tFileOutputJson. Is there any solution available for this issue?

Using Talend Cloud Real-Time Big Data Platform 7.2.1.

Thanks,

Jain

Re: Getting backslashes in tFileOutputJson output

Anonymous — Tue, 03 Dec 2019 06:19:17 GMT

Hi
I just created a simple job and made a testing, I can't reproduce the issue.
tFixedFlowInput--main--tFileoutputJson

Can you provide a sample job to reproduce the issue?

Regards
Shong

Re: Getting backslashes in tFileOutputJson output

Anonymous — Fri, 22 May 2020 22:43:29 GMT

@vboppudi - tLogRow it doesnt snow the eascape character "\" , can you check the json file driectectly.

@shong

My input is - /data/policy However in i JOSN output i get as \/data\/policy - extra escape character, how do we avoid id.

Regards,

Gopi