topic Re: empty/null table show up in ExtractJSON Fields in Talend Studio

empty/null table show up in ExtractJSON Fields

Anonymous — Wed, 22 May 2019 11:05:12 GMT

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

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Wed, 22 May 2019 11:50:10 GMT

can you please attache sample file?

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Wed, 22 May 2019 12:13:41 GMT

thanks

i attache my input json

regards

inputfille.docx

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Wed, 22 May 2019 12:18:21 GMT

thanks

i attache my project

regards

test12.zip

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Wed, 22 May 2019 12:38:23 GMT

Please attach your input file in a plain text file or jsonl file but not in docx. The docs contains only one record and the given json is too large to copy and paste into a notepad++. Or if possible please add sample records instead of full file.

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Wed, 22 May 2019 13:12:54 GMT

i attach the file json

thanks

regards

debainDB.zip

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Wed, 22 May 2019 14:58:20 GMT

hello

i attach file input json into a notepad++

thanks for your help

regards

newinput1.txt

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Wed, 22 May 2019 17:04:48 GMT

Hello,

Please add the sample output for one record, so that it will be easy, since the status, urgency and fixed_version keys are present in different objects of releases object. So do you want to consider all the values or from any one of the object. Here is the sample record.

{
"scope":"remote",
"description":"FFmpeg before 0.5.4, as used in MPlayer and other products, allows remote attackers to cause a denial of service (memory corruption and application crash) or possibly execute arbitrary code via a malformed WMV file.",
"releases":
{
"buster":
	{"fixed_version":"7:2.4.1-1","repositories":{"buster":"7:4.1.1-1"},"urgency":"medium**","status":"resolved"},
"stretch":
	{"fixed_version":"7:2.4.1-1","repositories":{"stretch-security":"7:3.2.12-1~deb9u1","stretch":"7:3.2.12-1~deb9u1"},"urgency":"medium**","status":"resolved"},
"sid":
	{"fixed_version":"7:2.4.1-1","repositories":{"sid":"7:4.1.3-1"},"urgency":"medium**","status":"resolved"}
}
}

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Wed, 22 May 2019 20:47:59 GMT

hello
first of all, thank you for your answer.
next, did you see my json file with all the CVEs?
in fact, i khnow that the status, urgency and fixed_version keys are present in different objects of releases object but in all objects they have the same values so it's no different I extract status, urgency and fixed_version keys are present from which object.
what is your advice?
thank you to you

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Thu, 23 May 2019 13:06:28 GMT

Hi @mitra1367,

It is depends on your requirement, to consider one object from releases object or all objects from releases object. Anyhow if you consider one object the output will be as follows.

Note: I just took, limited no of characters of description column to show you the output instead of full value. In the final output i'm getting full description value.

If you consider all objects from releases object, then the output will be as follows

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Thu, 23 May 2019 13:45:42 GMT

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

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Thu, 23 May 2019 14:18:05 GMT

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

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Thu, 23 May 2019 14:19:51 GMT

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.

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Thu, 23 May 2019 15:24:34 GMT

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

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Thu, 23 May 2019 15:58:32 GMT

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.

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Mon, 17 Jun 2019 15:43:27 GMT

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.

Re: empty/null table show up in ExtractJSON Fields

Anonymous — Mon, 17 Jun 2019 15:59:44 GMT

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.