Reference a nested JSON - Return Value of a webhook

Dear Community, 

I am currently exploring the return value from a a call a webhook verb GET , As the title says, i am having a hard time to reference a field in a nested JSON , till now no luck to make it work and id appreciate any help me and explanation to undrstand how to reference 

How can i reference the fields in the "tour" such as 
Id, gId, partner, ... 

I tried the following so far: 
name of the previous webhook process is "call": 
[call].[tour.Id] as an example
[call].[tours].[0].[tour.Id] 

do i need to use index ? 


JSON Example: 

{
  "apiKey": "key",
  "username": "user",
  "partnerID": "ID",
  "tours": [
    {
      "tour": {
        "id": 3786064,
        "gId": 2860833,
        "partner": "partner",
        "partnerId": 32984,
        "source": "FRA",
        "destination": "MXP",
        "flightno": "flighno",
        "licTruck": "'42K4L2L",
        "licTrailer": "24J3K2K",
        "drivername1": null,
        "drivername2": null,
        "begin": "2024-03-17T22:01:00",
        "end": "2024-03-18T14:00:00",
        "loadTime": null,
        "unloadTime": "2024-03-18T16:00:00",
        "loadReady": null,
        "loadBegin": null,
        "loadEnd": null,
        "unLoadReady": null,
        "unLoadBegin": null,
        "unLoadEnd": null,
        "plannedBegin": null,
        "plannedEnd": "2024-03-18T12:00:00",
        "tourdata": []
      },
      "tourdataCount": 25
    }
  ]
}
3 REPLIES 3
Top Labels in this Space