Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
javvaji
Creator II
Creator II

Getting backslashes in tFileOutputJson output

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.

Labels (3)
13 Replies
Anonymous
Not applicable

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.

F

 

jain1
Contributor
Contributor

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

Anonymous
Not applicable

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
Anonymous
Not applicable

@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