topic Re: How I can extract the data from Json in Talend Studio

How I can extract the data from Json

sudarshank — Fri, 15 Nov 2024 22:22:17 GMT

How to extract the data from below Json. I want to fetch orderId along with f_code and in_Kg value in table format. How can I retrieve it.

[

{

"orderId": 1,

"orderDetails": [

{

"f_code": 8,

"fruit": "Apple",

"In Kg": {

"value": [

"2"

]

}

{

"f_code": 5,

"fruit": "Orange",

"In Kg": {

"value": [

"1"

]

}

]

{

"orderId": 2,

"orderDetails": [

{

"f_code": 4,

"fruit": "Mango",

"In Kg": {

"value": [

"2"

]

}

{

"f_code": 2,

"fruit": "Kiwi",

"In Kg": {

"value": [

"1"

]

}

]

}

]

The output should be in the format screenshot.

Re: How I can extract the data from Json

InfoCraft — Sat, 12 Nov 2022 20:04:49 GMT

Hi @sudarshan khandu,

I propose 2 solutions to extract the data.

Kind regards,

😷19.

Re: How I can extract the data from Json

sudarshank — Sun, 13 Nov 2022 04:39:01 GMT

Hi @not specified not specified ,

Thanks for reply, Its working for above json.

I forgot to add a field price_perKg in json, after added that in json I am getting error. I think there is numeric document.("1" and "2").

(Error on line 1 of document : The content of elements must consist of well-formed character data or markup.)

newJson:

[

{

"orderId": 1,

"orderDetails": [

{

"f_code": 8,

"fruit": "Apple",

"price_perKg": {

"1": "$1",

"2": "$1.5"

"In_Kg": {

"value": [

"2"

]

}

{

"f_code": 5,

"fruit": "Orange",

"In_Kg": {

"value": [

"1"

]

}

]

{

"orderId": 2,

"orderDetails": [

{

"f_code": 4,

"fruit": "Mango",

"In_Kg": {

"value": [

"2"

]

}

{

"f_code": 2,

"fruit": "Kiwi",

"In_Kg": {

"value": [

"1"

]

}

]

}

]

Re: How I can extract the data from Json

sudarshank — Mon, 14 Nov 2022 13:46:38 GMT

Hi @not specified not specified,

can you please share the screenshot of tFixedFlowInput setting.?

Re: How I can extract the data from Json

InfoCraft — Mon, 14 Nov 2022 16:24:57 GMT

Hi @sudarshan khandu,

Seems Talend doesnt like JSON fields that start with a number, so put a tReplace before the tExtractJSONFields to replace "1" ==>"p1"

"price_perKg": {

"p1": "$1",

"p2": "$1.5"

}

Kind regards,

😷19.

Re: How I can extract the data from Json

InfoCraft — Mon, 14 Nov 2022 16:27:24 GMT