You can invoke an Action you have defined in AppSheet.

You can only invoke the following types of Actions from the API:

  1. Data: set the value of a column
  2. Grouped: execute a sequence of actions.
    All actions invoked in the Grouped sequence must be either "Data: set the value of a column" or "Grouped: execute a sequence of actions".

URL

Use a URL in the following form to invoke the API.

POST https://api.appsheet.com/api/v1/apps/{appId}/tables/{tableName} where

  • {appId} specifies the GUID of the AppSheet application.
  • {tableName} specifies the name of the table.

Body

The HTTP Body contains:

  1. The Action name.
  2. Optional properties such as Locale, Location, and Timezone.
  3. One, or more, Row values specifying the key field values of the records to which the Action is applied. In the following example, the key fields of the record are "FirstName" and "LastName".

{
"Action": "IncrementCountAction",
"Properties": {
"Locale": "en-US",
"Location": "47.623098, -122.330184",
"Timezone": "Pacific Standard Time",
},
"Rows": [
{
"FirstName": "Jan",
"LastName": "Jones"
},
{
"FirstName": "Ian",
"LastName": "Ivans",
}
]

Did this answer your question?