empty/null table show up in ExtractJSON Fields

[Anonymous]

Hello,

 In fact, I just started working with talend open studio for data integration; I want to export a array long json ;I have a file containing; This showed me that the debianbug field does not always appear

How I would like the output to look like:

CVE	Scope	debainbug	description	status	fixed_version	urgency

They all appear to be individual CVE sections (and some are), but if you look deeper you will see that some are grouped together.

my job :

tExtractjson1: 

textarctjson2:

excute:the field is empty/null !!!

Does anyone have any advice or ideas on how I can achieve this?

I use "Talend open studio for data integration version 7.1.1.2018102681147

Thank you very much for your time and help

Best regard

Mitra

[Anonymous]

thank you for your time and help; can you attach the tExtarctjson photo or the project because I understand what you have changed please
can you extract all 2748 Cves?
thank you

[Anonymous]

Actually, I did the same thing. limited no of characters of description column to show you the output instead of full value but It doesn't work and it still displays null 

je vous remercie si vous m'envoye le zip projet que vous avez fait

thanks

regards

null.PNG

[Anonymous · Accepted solution]

Hi @mitra1367 ,

Here is the job and i just imported an additional jar and you can find it here http://www.java2s.com/Code/Jar/j/Downloadjsonsimple111jar.htm.

---

Please give Kudos and mark topics as solved where appropriate.

[Anonymous]

Thank you very much for your answer I did exactly the same thing and I wrote the code you sent but despite that there is the following error

regrads

[Anonymous]

Please go to the code tab, so you can able to see what the real error. But from the attached error screenshot i am unable to read so could you please add your error in English.

The Screenshot clearly saying that jsonvalue cannot be resolved or is not a field. Please make sure the schema should be in same case throughout the job.

[Anonymous]

The problem here looks like you do not have a "jsonvalue" column leaving your tJavaRow component. Check the schema and see that it exists, then try again.

[Anonymous]

Please, if you are going to attach code to help people out or as part of your problem, do not provide it as a screen shot. Actually provide the code. Copying and pasting code is far more likely to get you help because it reduces the effort that people have to put in to solving the issue.