tExtractJsonFields doesn't parse json request properly

nvtd4000 — Fri, 15 Nov 2024 23:43:23 GMT

I am using Talend 7.3.1 for BigData Platform.

I have a rest service with request is Json format String (bookList with 2 books).

{ "bookList": [ {"onSale": false,"book": [ {"name":"book1","id":1}, {"name":"book2","id":2 } ] } ] }

What i want is : after running tExtractJsonFields, it should return an array of 2 elements: { "name": "book1", "id":1} and { "name": "book2", "id":2 }.

The jsonpath i used is $.bookList[*].book[*]. But What i have in tLogRow is only 1 string includes 2 elements. This is not what i want

.-------------------------------------------------.

| tLogRow_1 |

|=-----------------------------------------------=|

|single_book |

|=-----------------------------------------------=|

|[{"name":"book1","id":1},{"name":"book2","id":2}]|

'-------------------------------------------------'

Bellow is what i want to have. It should have 2 elements. Do you know how to do that?

.-------------------------------------------------.

| tLogRow_1 |

|=-----------------------------------------------=|

|single_book |

|=-----------------------------------------------=|

|{"name":"book1","id":1}

{"name":"book2","id":2}

'-------------------------------------------------'

Bellow is what I have with the Talend Job:

Re: tExtractJsonFields doesn't parse json request properly

manodwhb — Wed, 22 Sep 2021 02:04:52 GMT

@Not defined Not defined , After tExtractJson use the tNormalize component and split based on }, then you will get two records and the use tMap if you want to remove any extra characters like [ or ] and check if you want to add any character if required like { or }

this is one way,since they are multiple ways.

Thanks,

Manohar

topic tExtractJsonFields doesn't parse json request properly in Talend Studio

tExtractJsonFields doesn't parse json request properly

Re: tExtractJsonFields doesn't parse json request properly