Unable to extract JSON data from tExtractJSONFields

Anonymous — Sat, 16 Nov 2024 03:52:35 GMT

Hello Gurus,

I am unable to extract simple JSON file by using tExtractJSONFields component and need your help. Here is my JSON file format

[
    {
        "TRADE_DATE": "2019-11-14T01:00:00.0000000+01:00",
        "START_DATE": "2019-11-15T01:00:00.0000000+01:00",
        "END_DATE": "2019-11-16T01:00:00.0000000+01:00",
        "VALUE": "-0.6",
        "NOTE": "NULL"
    },
    {
        "TRADE_DATE": "2019-11-14T01:00:00.0000000+01:00",
        "START_DATE": "2019-11-16T01:00:00.0000000+01:00",
        "END_DATE": "2019-11-17T01:00:00.0000000+01:00",
        "VALUE": "-0.4",
        "NOTE": "NULL"
    },
.
.
.
]

And, I have designed as follows,

tFileInputJSON_2 --> tExtractJSONFields_2 --> tMap --> CSV file

during execution, it was creating with 0 KB CSV file. I am able to read JSON data with "tFileInputJSON_2" component but after that it was extracting 0 records. Also, I have changed "Loop Json query" or "Loop Json path query" as "$[*]" but still reading 0 records.

Need your advise or suggestions.

Thanks,

Nag

Re: Unable to extract JSON data from tExtractJSONFields

Anonymous — Fri, 20 Dec 2019 02:44:52 GMT

tExtractJsonFields is used to extract data from a Json string, if the source data is in a Json file, you only need a tFileInputJson component.
tFileInputJSON_2 --> tMap --> CSV file

Regards
Shong

topic Unable to extract JSON data from tExtractJSONFields in Talend Studio

Unable to extract JSON data from tExtractJSONFields

Re: Unable to extract JSON data from tExtractJSONFields