Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Retrieve Array from Webhook Post

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
 
Please advise.
Solved Solved
0 5 180
1 ACCEPTED SOLUTION

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

View solution in original post

5 REPLIES 5
Top Labels in this Space