topic Re: JSON Path to extract Parent in Talend Studio

JSON Path to extract Parent

Jennifer_siders — Thu, 02 Nov 2023 07:43:57 GMT

Hi Team,

From the JSON, how to i get lead-request.lead.ExternalId?

JSON:

{

"lead-request": {

"lead": {

"ExternalId": "100",

"leadProducts": [

{

"ExternalId": "100",

"ProductCode": "PD1",

"ProductType": "Model"

{

"ExternalId": "100",

"ProductCode": "PD2",

"ProductType": "Model"

{

"ExternalId": "100",

"ProductCode": "PD3",

"ProductType": "Vehicle"

}

"leadActivities": [

{

"ExternalId": "100",

"EventType": "Campaign"

}

]

}

Re: JSON Path to extract Parent

Jennifer_siders — Sat, 04 Nov 2023 07:56:55 GMT

any advise?

Re: JSON Path to extract Parent

jonlar — Sun, 05 Nov 2023 15:49:09 GMT

Hi, certain information is missing from your question, but i'm assuming that you are trying to create a input JSON file in the metadata section. If so, this has worked for me with your provided json example

Hope this helped

Re: JSON Path to extract Parent

Jennifer_siders — Mon, 06 Nov 2023 01:52:22 GMT

Thank you very much @Laroche Jonathan