topic Extract field Json Referencing in Talend Studio

Extract field Json Referencing

GGeded1618913227 — Tue, 28 Sep 2021 14:53:32 GMT

Hello Everyone,

I have a JSON like this :

"listOfMovies": {

"numberMovie" : 15

"movies" : {

"15" : {

"name": "Matrix",

"duration":"blabla"

"16" : {

"name": "NameOfMovie",

"duration":"blabla"

}

I want to get a name field of movies in terms of what it contains the field "numberMovies",

So if the numberMovie field is "15" , therefore I want the name "Matrix" for example

I hope this is understandable, How can I do with tExtractJsonFields ?

Thanks everyone for your participation 🙂

Re: Extract field Json Referencing

Anonymous — Wed, 29 Sep 2021 07:23:19 GMT

Unfortunately this is not possible with the build-in components because the build-in components always maps the attribute names to schema column names.

You can do such things with the components: https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F1438&pi=marketplace%252F1%252Fproducts%252F1438%252Fitems%252F2982

Use here the component tJSONDocOpen to read in the json and the component tJSONDocTraverseFields

This component returns every attribute and value and the path to it. Now you can filter afterwards what you need.