topic Re: tfileInputJSON and XPATH in Talend Studio

tfileInputJSON and XPATH

Anonymous — Sat, 16 Nov 2024 10:35:35 GMT

I have a JSON file that contains

{"ORDER":"250"}

I would like to parse JSON with the use of XPATH. I use tFileIputJSON and logRow. What I have to do so that "250" will be shown with tLogRow.
I don't know what I have to put inside 'Loop Xpath query' and 'Xpath query' ?

Re: tfileInputJSON and XPATH

Anonymous — Thu, 09 Jun 2016 09:37:29 GMT

{"ORDER","250"} is not a json. Maybe you want to put {"ORDER":"250"}? If yes, you put just "/" in the 'Loop XPath query' and "ORDER" in 'XPath query'.
Lin LIN
Consultant BI/Talend
Synaltic Group

Re: tfileInputJSON and XPATH

Anonymous — Thu, 09 Jun 2016 11:12:48 GMT

It works but if I change JSON to

{"ORDER":{"seba":"250"}}

it doesn't work anymore, why so?

Re: tfileInputJSON and XPATH

Anonymous — Thu, 09 Jun 2016 12:40:34 GMT

Do you want to take "250" or "seba":"250"? If you want to take "250", you need to put "ORDER/seba" in "XPath query". Or "/Order" in "Loop XPath query" and "seba" in "XPath query".
Lin LIN
Consultant BI/Talend
Synaltic Group

Re: tfileInputJSON and XPATH

Anonymous — Thu, 09 Jun 2016 12:50:11 GMT

I would like to take {"seba":"250"}.

Re: tfileInputJSON and XPATH

Anonymous — Thu, 09 Jun 2016 13:07:25 GMT

If you want to take {"seba":"250"}, maybe you should use JsonPath. You put "$" in "Loop Json query" and "ORDER" in Json query.
Lin LIN
Consultant BI/Talend
Synaltic Group

Re: tfileInputJSON and XPATH

Anonymous — Thu, 09 Jun 2016 13:14:57 GMT

How should I get "seba":"250" ?

Re: tfileInputJSON and XPATH

Anonymous — Thu, 09 Jun 2016 13:20:43 GMT

I think you should use the component tReplace or you code in tJavaRow.
Lin LIN
Consultant BI/Talend
Synaltic Group

Re: tfileInputJSON and XPATH

Anonymous — Fri, 10 Jun 2016 07:40:54 GMT

So with XPATH I cannot get out {"seba":"250"} if my JSON file looks like {"ORDER":{"seba":"250"}} ?

Re: tfileInputJSON and XPATH

Anonymous — Fri, 10 Jun 2016 09:29:42 GMT

No, you can't.
Lin LIN
Consultant BI/Talend
Synaltic Group

Re: tfileInputJSON and XPATH

Anonymous — Sat, 16 Jul 2016 16:05:39 GMT

No, you can't.

This is not true. This can be achieved with this setting:

Re: tfileInputJSON and XPATH

Anonymous — Tue, 05 Nov 2019 14:03:26 GMT

Hi,

@louislinlin

let's assume I have data like below

{"order":{"seba":120,"saran":121,"louislinlin":100,"aaa":120,"bbb":123}}

In this case, if I create two columns, how can store all the key values into this.

and I know to loop it I have to give "/order" Loop Xpath query, what do I need to give at XPath Query