JSON Path to extract Parent

[Jennifer_siders]

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"

      }

     ]

   }

  }

}

[Jennifer_siders]

any advise?

[jonlar · Accepted solution]

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

[Jennifer_siders]

Thank you very much @Laroche Jonathan​