Six Stars

value outside the json array

Hi everybody,

 

During my searching, I would like some advice about this thing.

 

Here is my job :

 

image.png

 

I have this file at the end of my job :

image.png

 

When I launch the job with the mode " debug of the traces "

image.png

 

I don't understand why in the Json file in notepad ++ the value of the date is outside the structure and not in the value "created".

 

Could you explain me why ?

 

Thanks in advance,

 

 

  • Data Quality
3 REPLIES
Nine Stars

Re: value outside the json array

something wrong in previous components

 

You need attach more information about - how You prepare JSON and how add column created, from current pictures it not seen

-----------
Six Stars

Re: value outside the json array

Hi,

 

I show you more details :

 

row1 :

.png

 

row2 :

.png

 

row3 :

 

 

Here are the details of my tFileOutputDelimited :

.png

 

Here are the details tWriteJSONField :

.png

 

Anyone has an idea about my problem ?

 

Thanks

 

Tags (1)
Nine Stars

Re: value outside the json array

if return to Your question:

 

I don't understand why in the Json file in notepad ++ the value of the date is outside the structure and not in the value "created".

where on last screenshots - date? You do not have it JSON

 

in JSON You have exactly what You add to JSON

from ID till Label

so if You somewhere (not in components from pictures, may be in tJavaRow3?) add date - it will be exactly outside JSON as separate COLUMN (as You have column separator " ")

-----------