topic Re: tExtractJsonFields error on json field extraction in Talend Studio

tExtractJsonFields error on json field extraction

Anonymous — Tue, 22 May 2018 10:37:30 GMT

Hi , I have a job as shown below

The XML format is as follows

|200 |<?xml version="1.0" encoding="UTF-8"?>
<root><status>1</status><data>110.0</data></root>|null |

And the textractjsonfield configuration is as shown below. I want to capture the value of the <data> thats coming out of txmlmap

When I run the job I get this error

Any ideas on this?

Re: tExtractJsonFields error on json field extraction

David_Beaty — Tue, 22 May 2018 11:21:27 GMT

Hi,

Have you clicked on the "Code" tab in the bottom of the job design, next to "Designer" - look for the red section on the right had of the generated Java.

Thanks

David

Re: tExtractJsonFields error on json field extraction

Anonymous — Tue, 22 May 2018 11:36:41 GMT

Hi David,

The red ones on the code are

XML_API_tXMLMap_1_TXMLMAP_OUT xml_api_tXMLMap_1_TXMLMAP_OUT = new XML_API_tXMLMap_1_TXMLMAP_OUT();

out3_tmp.data = treeNodeAPI_tXMLMap_1_TXMLMAP_OUT.get_String("row2.body:/root/data") treeNodeAPI_tXMLMap_1_TXMLMAP_OUT.get_String("row2.body:/root/data");

out3_tmp.status = treeNodeAPI_tXMLMap_1_TXMLMAP_OUT.get_String("row2.body:/root/status") treeNodeAPI_tXMLMap_1_TXMLMAP_OUT.get_String("row2.body:/root/status");allOutsForAggregate_tXMLMap_1.add(out3_tmp);

Can't get what's wrong here

Re: tExtractJsonFields error on json field extraction

vboppudi — Tue, 22 May 2018 15:30:37 GMT

Hi,

Are you looking for the following output?

Regards,

Re: tExtractJsonFields error on json field extraction

Anonymous — Wed, 23 May 2018 09:49:29 GMT

Yes Veeru I am expecting this output

However, the output of my response is this way

200||<?xml version="1.0" encoding="UTF-8" standalone="yes"?><ResponseStatus><data xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema" xsi:type="xs:decimal">110.00</data><status>1</status></ResponseStatus>

Can you please let me know how do I extract the value 110.00 from here?

Thanks

Re: tExtractJsonFields error on json field extraction

vboppudi — Wed, 23 May 2018 17:25:27 GMT

Please try below

Regards,