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
}
]
}
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
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
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.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |