topic Re: How to use tExtract JSON without a loop in Talend Studio

How to use tExtract JSON without a loop

JFryk — Fri, 15 Nov 2024 21:09:40 GMT

This seems like a simple fix but as you can see from the screens shots I've looked at this several ways and cannot determine how to extract a non-looping value in tExtractJSON.

I have a job that calls an API and needs to get the link for the next call.

Set up is:

{

"value": [

all chat related attributes that needs to imported

"odatlink": link

}

I have pulled the link and am attempting to extract the JSON. tExtract will not allow me to get the single non looping value that can be found in the JSON Evaluator or in the case when I use a test file and set the tFileInput to a single loop.

Is there a way to extract a JSON value without a loop?

Thank you in advance!

Re: How to use tExtract JSON without a loop

Anonymous — Fri, 22 Dec 2023 07:16:46 GMT

Set the root node as loop element, for example:

assuming the returned string from API looks like below:

{

"odatlink": "http://localhost:8080"

}

Set the root node as loop Set the Loop Jsonpath query as: "$", the Json query expression as: "odatlink", you should be able to extract the link value using tExtractJsonFields component.

Regards

Shong

Re: How to use tExtract JSON without a loop

jeoste — Thu, 25 Jan 2024 14:28:25 GMT

Hello,

I recommend you to use jsonpath.com. YOu put your JSON with the solution provided by shong and you can see the content you'll be extracting from this json