Retrieve Array from Webhook Post

[Jonyskids]

I am trying to pull info from an array from within a webhook response.

The response of the webhook is: (Well, the part that is pertinent.)

"task_result": {

          "image_url": "https://imageThumbnail.png",

          "image_urls": [

                        "https://image/0_0.png",

                        "https://image/0_1.png",

                        "https://image/0_2.png",

                        "https://image/0_3.png"

],

[WebHook-Retrieve].[task_result.image_url] allows me to grab the thumbnail and put the url into a cell.

I believe to pull image 0 from the array and put in a cell I should use:

INDEX([WebHook-Retrieve].[task_result.image_urls], 0)

I get: INDEX has invalid inputs

ref:https://support.google.com/appsheet/answer/12738438?hl=en

Please advise.

[Jonyskids]

While INDEX([WebHook-Retrieve].[task_result.image_urls], 0) Gives me an error in the formula, INDEX(LIST([WebHook-Retrieve].[task_result.image_urls]), 1) Does not throw a formula error but does not give any results?

[Jonyskids]

Okay, Can only pull as an enum list into a cell and then use another data action to index them across additional cells. I hop this helps someone else.

So all I used in the end is: [WebHook-Retrieve].[task_result.image_urls] to an enum list cell and then Index them across individual cells.

[Steve]

Note that list elements are indexed from 1, not 0. See also: INDEX()

[scott192 · Accepted solution]

Try INDEX([WebHook-Retrieve].[task_result.image_urls],1)

[Jonyskids]

 Touché, I see my error and thank you.