topic Re: tJSONFileInput cascading header level to detail in Talend Studio

tJSONFileInput cascading header level to detail

Anonymous — Sat, 16 Nov 2024 12:43:34 GMT

I have been messing around with the JSONPath expressions but have not been able to get it to work.
JSON structure sample:

{
"type": "Actors",
"detail":
},
{
"firstname": "Jason",
"lastname": "Mewes",
"movies":
}
]
}
I want my output to look like:
Actors|Kevin Smith | Clerks | 1994 |8| Silent Bob
Actors|Kevin Smith | Jay and Silent Strike Back |2001 | 7|Silent Bob
Actors|Jason Mewes | Clerks | 1994 |8| Jay
Actors|Jason Mewes | Jay and Silent Strike Back | 2001 |7| Jay
But right now I get an output more like this:
Actors|Kevin Smith | Clerks | 1994 |8| Silent Bob
|| Jay and Silent Strike Back | 2001 |7| Silent Bob
|| Clerks | 1994 |8| Jay
|| Jay and Silent Strike Back | 2001 |7| Jay

Also, even though my JSON is valid per lint, I sometimes get an error message: "The Json resource datas maybe have some problems, please make sure the data structure with the same fields."
Thanks,
Ben

Re: tJSONFileInput cascading header level to detail

Anonymous — Tue, 23 Aug 2011 08:50:53 GMT

Hi Ben
Can you upload a screenshot of basic setting of tFileInputJson?
Best regards
Shong

Re: tJSONFileInput cascading header level to detail

Anonymous — Tue, 23 Aug 2011 17:08:07 GMT

Image attached. I have tried a few different path notations. ex $.detail. vs $..
Output
The Json resource datas maybe have some problems, please make sure the data structure with the same fields.
The Json resource datas maybe have some problems, please make sure the data structure with the same fields.
Actors|Kevin|Smith|Clerks|1994|8|Silent Bob
|Jason|Mewes|Jay and Silent Strike Back|2001|7|Silent Bob
|||Clerks|1994|8|Jay
|||Jay and Silent Strike Back|2001|7|Jay
BTW, I had to fix the moviename field in the JSON file, and I am open to restructuring the JSON if that is required.

Re: tJSONFileInput cascading header level to detail

Anonymous — Wed, 24 Aug 2011 02:06:16 GMT

Hi Ben
I got the same problem with many examples and confirmed that the component can't cascading the header to next level element if there are many rows.
Can you please report a bug on our bugtracker? Our developer will investigate it further and see if it is possible.
Best regards
Shong

Re: tJSONFileInput cascading header level to detail

Anonymous — Wed, 24 Aug 2011 14:29:58 GMT

Bug created. Thanks, Ben

Re: tJSONFileInput cascading header level to detail

Anonymous — Thu, 25 Aug 2011 01:35:57 GMT

Bug created. Thanks, Ben

Thank you, Ben, please add the issue ID here.
Best regards
Shong

Re: tJSONFileInput cascading header level to detail

_AnonymousUser — Fri, 30 Mar 2012 21:55:34 GMT

Is there a workaround to achieve cascading header to detail.. Im new to Talend and Im not able to find a workaround.

Re: tJSONFileInput cascading header level to detail

_AnonymousUser — Sat, 21 Jul 2012 11:44:14 GMT

Hello,
I have the same problem with this JSON data:

{
    "championships":
    
        },
        {
            "name": "Premier League",
            "teams":
            
        }
    ]
}

I would like to have a result like:
Serie A | Milan AC
Serie A | Juventus Turin
Premier League | Liverpool FC
Is there any workaround to resolve it?
Many thanks in advance!

Re: tJSONFileInput cascading header level to detail

Anonymous — Fri, 25 Jan 2013 09:59:53 GMT

has this issue been resolved yet? i'm currently facing the same problem. thanks

Re: tJSONFileInput cascading header level to detail

Anonymous — Thu, 31 Jan 2013 15:48:38 GMT

Me too +1
Running TOS 4.2.3.r67267

Re: tJSONFileInput cascading header level to detail

Anonymous — Fri, 01 Feb 2013 09:32:12 GMT

Hi All
For your information, we will enhance this component on v5.3.0, see jira issue.
This modification might be available in next release, we sincerely invite you to test the changes and feedback to us!
Shong

Re: tJSONFileInput cascading header level to detail

Anonymous — Wed, 30 May 2018 00:45:20 GMT

We are using Talend 6.3.1 and still get the same error for tFileInputJSON (screenshot attached) even though the source json is valid. The input file has 346 records, but only 329 records come out before the job throws below log:

[statistics] connecting to socket on port 3604
[statistics] connected
[WARN ]: renew_checks_0_1.Renew_Checks - tFileInputJSON_1 - The Json resource datas maybe have some problems, please make sure the data structure with the same fields.
1296 milliseconds
[statistics] disconnected

tFileInputJSON-Error.PNG