topic Re: Extract Fields from json file in Talend Studio

Extract Fields from json file

Anonymous — Sat, 16 Nov 2024 02:28:44 GMT

Hi,

I have json file like this:

{"2020-04-28":
{
"37, N7L2H4, Carry, CHOPA, PLX": {
"inter_results": {
"inter_mark": "GITA"
,"down": null
,"up": null
,"wiki": {"included": "false", "options": ["RRR", "SSS","HHH"]}}

,"38, N5L2J4, HURT, SERRA, PZT": {
"inter_results": {
"inter_mark": "MARI"
,"down": "250"
,"up": "1250"
,"wiki": {"included": "true", "options": ["XXX", "YYY"]}}

,"39, N4L2H4, HIBA, FILA, PFG": {
"inter_results": {
"inter_mark": "HILO"
,"down": "100"
,"up": "250"
,"wiki": {"included": "true", "options": ["RTG", "VTH","HJI","JKL"]}}

}

And i want extract the Values N7L2H4,N5L2J4,N4L2H4 from this json file using tFileInputJson with jsonPath...

Please help me to do that, i spend a time but i don't found the solution.

Thanks,

Re: Extract Fields from json file

manodwhb — Wed, 13 May 2020 08:13:30 GMT

@dadssia, your json is invalid please validate in the below link.

https://jsonlint.com/

Error: Parse error on line 40:
...					}				}			}
------------------^
Expecting '}', ',', got 'EOF'

Re: Extract Fields from json file

manodwhb — Wed, 13 May 2020 14:28:00 GMT

@dadssia , that is part of JSON filed which wants to get it right with the existing component you cannot achieve this, you may need to write java code get field and subtract information which you want.

Re: Extract Fields from json file

manodwhb — Fri, 15 May 2020 14:01:36 GMT

@dadssia , you need to call custom java code as routine and which you need to call in tjavarow to get the data out.