We are all in the same page, but you’re insistingly looking to a way different direction.
[A] Problem: How to filter records from a Table or a Slice
This is quite easy and robust because there are 2 main expressions to do that. These are:
[A1] How to filter top N records from a Table or a Slice
To provide this, you need to use 2 main expressions:
1.a.) SORT() - Used to sort ordinary lists in asc. or desc. order only
1.b.) ORDERBY() - Used to sort key column values as per criteria in asc. or desc. order
[B] Workflows, Scheduled Reports and AppSheet API
There are 3 distinct but similar ways to manipulate AppSheet Data as the header explains. As you want to manipulate bulk data all at once you can use 2 options:
Scheduled Report w/DataChange for EachRow in Table or for Entire Table
Scheduled Report w/Webhook+Preset AppSheet API for Entire Table
[C] Your App Setup
[C1] Behavior Action
In your DataFeed table, you have setup an action:
1.) For this action you had defined an Only if this condition is true property. As you are intending to execute this action either from a DataChange or Webhook Scheduled Report, you don’t need to set this expression. This expression have to be set up either in the workflow/scheduled report’s running condition OR as the Y/N conditional parameter of the data selection.
2.) This action has been set up as a Grouped action consisting of 3 individual actions. There’s neither an explanation or description of what these actions are doing nor you have answered my question provided there 3 individual actions have an Only if this condition is true expression or not.
[C2] AppSheet API Payload
I’m considering that you should have been enabled AppSheet API via Manage > Integrations > IN and you have the basic knowledge about the JSON payload and the key-value pairs for proper setup. However, I would like to sweetly remind:
An AppSheet API call, has 3 integrat parts:
Endpoint URL (provided you haven’t appended the applicationAccessKey parameter to the endpoint URL, then you have to specify it within the HTTP Header)
- HTTP Request Body
HTTP Header (where you define your applicationAccessKey parameter)
HTTP Request Body has 3 integral key params:
Action: where the API action has to be specified: add, edit, delete, behavior action name
Properties: where API properties need to be specified i.e. Locale, Location, Timezone, UserSettings etc.
Rows: *where you need to specify each [Column, Value] pairs that you want to manipulate. With each one of the used Actions, this array parameter shall explicitly contain the key column
With the workflows and scheduled reports, it’s possible to loop thru data. To achieve this, you need to define a
<<Start>><<End>> expression within the Rows array. This expression is the expression that you select/filter the table records as per the basic guidelines clarifed under Section [A].
[D] Debugging or Tracing Errors
To debug or trace any errors, you need to examine your Audit History Log carefully to see what was wrong and why the error is generated. I have asked your audit log and what was the error message and you have posted this in post#15:
which has clearly implicated that the Action is missing.