topic Re: Multiple JSON reading using tfileinputjson or textractjsonfields in Talend Studio

Multiple JSON reading using tfileinputjson or textractjsonfields

NarenS701 — Wed, 05 May 2021 15:28:35 GMT

Hi Team,

I have provided the source JSON file structure and simple mapping to extract id from it.

my first mapping using tinputfilejson (used Readby as JsonPath) as doesnt return anything and second option with textractjsonfields (same Readby option) gave null output.

Can someone tell me what is wrong in it?

{

"object": "list",

"data": [

{

"id": "ID1",

}

"has_more": false

}

{

"object": "list",

"data": [

{

"id": "ID2",

}

"has_more": false

}

{

"object": "list",

"data": [

{

"id": "ID3",

}

"has_more": false

}

Thanks.

Re: Multiple JSON reading using tfileinputjson or textractjsonfields

gjeremy1617088143 — Wed, 05 May 2021 16:14:01 GMT

Hi it seems your JSON is not validate in a json validator.

You have to correct it before you want to extract something from it

Send me love and kudos

Re: Multiple JSON reading using tfileinputjson or textractjsonfields

gjeremy1617088143 — Wed, 05 May 2021 16:18:07 GMT

here is a valid one :

[{

"object": "list",

"data": [

{

"id": "ID1"

}

"has_more": false

{

"object": "list",

"data": [

{

"id": "ID2"

}

"has_more": false

{

"object": "list",

"data": [

{

"id": "ID3"

}

"has_more": false

}

]

Re: Multiple JSON reading using tfileinputjson or textractjsonfields

NarenS701 — Wed, 05 May 2021 16:52:31 GMT

Thanks for your reply. There is small mistake in above edited JSON. please ignore the comma in "id".

I simplified the JSON for reference here. Actually realtime file is huge. each object list like below is separate JSON. I could extract data from 1 JSON, but when it get merged into 1 single file with multiple object list it is not working.

{

"object": "list",

"data": [

{

"id": "ID3"

}

"has_more": false

}

Re: Multiple JSON reading using tfileinputjson or textractjsonfields

gjeremy1617088143 — Thu, 06 May 2021 07:53:20 GMT

Hi in the first one I saw this :

{json 1}

{json 2}

{etc}

they have to be merged in this way :

[

{json 1}

,{json2}

,{etc}

]

Re: Multiple JSON reading using tfileinputjson or textractjsonfields

NarenS701 — Thu, 06 May 2021 08:58:25 GMT

Thanks @guenneguez jeremy . I made it working, like the same way you suggested.

Re: Multiple JSON reading using tfileinputjson or textractjsonfields

gjeremy1617088143 — Thu, 06 May 2021 08:59:59 GMT

select one of my answer as the best to close the ticket please