tExtractJSON convert row formatting Issue

Anonymous — Sat, 16 Nov 2024 07:26:33 GMT

Hi,

Below is the sample format of the JSON input from Kafka,we have 100+ columns are there and want to convert to a row.
Have used tExtracJsonfield transformation using JSON path, am getting below is the actual output

Input from Kafka :
{
"ACTION":{"string":"U"},
"RESTART":{"string":"1AX7GpFUZwAAAAAAAAX7GpFUVQAAAAcAAGGxAB39GgDoAAEAAAAAAAEAAAAA"},
"FLG":{"string":"Y"}
}

Actual Result:
"string":"U" | "string":"1AX7GpFUZwAAAAAAAAX7GpFUVQAAAAcAAGGxAB39GgDoAAEAAAAAAAEAAAAA" | "string":"Y"

Expected Result:
U | 1AX7GpFUZwAAAAAAAAX7GpFUVQAAAAcAAGGxAB39GgDoAAEAAAAAAAEAAAAA | Y

How to escape the data type and Double quote value in the tExtractjson field transformation? Please advise.

Thanks,

Regards,

Srini

Re: tExtractJSON convert row formatting Issue

Anonymous — Fri, 19 Oct 2018 03:56:36 GMT

Hi,

Could you please advise for above scenario?

Thanks,

Regards,

Srini

topic Re: tExtractJSON convert row formatting Issue in Talend Studio

tExtractJSON convert row formatting Issue

Re: tExtractJSON convert row formatting Issue