value outside the json array

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,

 

 

Forteen 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)
Forteen 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 " ")

-----------

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read