Add or update a single row in a Sheet.
The following actions can be specified:
- SET (default if no action is specified)
Inserts or updates a Sheet row.
When updating a Data or Member Sheet, the updateColumns attribute controls which fields are updated.
Note: This action is not allowed for Sheets with generated keys.
Inserts a Sheet row if it doesn't already exist, but does NOT update the row if it already exists.
Updates an existing Sheet row, but does NOT create it if it doesn't already exist.
When updating a Data or Member Sheet, the updateColumns attribute controls which fields get updated.
Removes the Sheet row. Only the key fields need top be passed in.
attribute must be used together with SET and UPDATE_ONLY for Data Sheets and Member Sheets to control which columns get updated.
It contains a comma-separated list of the columns to update. Specify '\*' (just star) to update all columns.
For Member sheets, there must always be one attribute called member_id. This can contain any MemberLookupId type (email, external Id etc).