topic Re: Extract Json Array Fields with character in Talend Studio

Extract Json Array Fields with character

GGeded1618913227 — Tue, 20 Apr 2021 10:10:24 GMT

Hello,

I need help please,

I need to know how I can extract this type of JSON :

"paymentData"

"{\"cardno\":\"5017# # # # # # # # # # 00\",\"expDate\":\"202210\",\"walletId\":\"test\",\"paymentMeanId\":\"1\",\"replacedWallets\":[{\"cardno\":\"4990# # # # # # # # # # 34\",\"expDate\":\"201302\",\"walletId\":\"test\",\"paymentMeanId\":\"1\"}]}"

With tExtractJsonfields or Tjava , how I can do ?

Thanks Everyone

Re: Extract Json Array Fields with character

gjeremy1617088143 — Tue, 20 Apr 2021 15:18:12 GMT

Hi,

"paymentData"

is not a valid json

but

{

"paymentData": {

"cardno": "5017# # # # # # # # # # 00",

"expDate": "202210",

"walletId": "test",

"paymentMeanId": "1",

"replacedWallets": [

{

"cardno": "4990# # # # # # # # # # 34",

"expDate": "201302",

"walletId": "test",

"paymentMeanId": "1"

}

]

}

is a valid json you can surely parse it via tExtractJsonfields

Re: Extract Json Array Fields with character

gjeremy1617088143 — Tue, 20 Apr 2021 15:44:17 GMT

If you want to parse :

read it as a String then in a tjavarow by example :

String str = input_row.body.replaceAll("\\\\","");

output_row.body = str.substring(1, str.length() - 1);;

it will suppress all the \ and the first and last ".

then you could parse it via tExtractJSONFields with a String type

Send me Love and Kudos

Re: Extract Json Array Fields with character

gjeremy1617088143 — Tue, 20 Apr 2021 15:51:30 GMT