Solved: How to send request throught webhook with data fro... - Page 2

opontes · 12-06-2024 09:57 AM

Hello everyone,

I am working on integrating Appsheet with Vertex AI Studio. My goal is to have Appsheet save files to GCP Storage and then send a REST API call with information about which FILES should be analyzed. This API call would trigger a GCP Run Function to process the files using Vertex AI Studio.

However, I am encountering an issue where I can only send information about one file per request.

Has anyone faced a similar challenge or have any advice on how to handle multiple files in a single request?

I appreciate any guidance you can provide.

Thank you!

opontes

And even better solution that take care of inconsistency of data.

[
    <<If: COUNT(FILTER("My Files", ([To process] = TRUE))) > 1>>
    <<Start: TOP(ORDERBY(FILTER("My Files", ([To process] = TRUE)), [_ROWNUMBER], TRUE), COUNT(FILTER("My Files", ([To process] = TRUE))) - 1)>>
    {
        "name": "<<[Name]>>",
        "file": "<<[File]>>"
    },
    <<End>>
    <<EndIf>>
    <<Start: TOP(ORDERBY(FILTER("My Files", ([To process] = TRUE)), [_ROWNUMBER], FALSE), 1)>>
    {
        "name": "<<[Name]>>",
        "file": "<<[File]>>"
    }
    <<End>>
]

View solution in original post

How to send request throught webhook with data from multiple records?