Reference a nested JSON - Return Value of a webhoo...

Hussein_Osseily

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
    }
  ]
}

Suvrutt_Gurjar

It sounds that in your JSON response there could be ( at least theoretically) multiple "tour" responses under "tours".

The return values currently do not support nested JSON responses. Please refer the last paragraph of the help article below. It even has an example of a not supported JSON response example.

Use return values from webhooks - AppSheet Help

Hussein_Osseily

Thanks gor your response, helpful as always.

Yes, tours has several nested tour

I think ill try to figure it out with the use of google apps script + call a script from appsheet.

Appreciated

Suvrutt_Gurjar

You are welcome.

@Hussein_Osseily wrote:

I think ill try to figure it out with the use of google apps script + call a script from appsheet.

Yes, you are correct. I also think that is a way to go.

Reference a nested JSON - Return Value of a webhook