Save Sheet Row

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, by default only the specified columns will be updated, leaving any other columns untouched. This can be overridden through the updateDataColumns attribute.
    Note: This action is not allowed for Sheets with generated keys.
  • ADD_ONLY
    Inserts a Sheet row if it doesn't already exist, but does NOT update the row if it already exists.
  • UPDATE_ONLY
    Updates an existing Sheet row, but does NOT create it if it doesn't already exist.
    When updating a Data or Member Sheet, by default only the specified columns will be updated, leaving any other columns untouched. This can be overridden through the updateDataColumns attribute.
  • REPLACE
    Adds a Sheet row if it doesn't exist, otherwise overwrites the entire row.
    Note: This action is not allowed for Sheets with generated keys.
  • REMOVE
    Removes the Sheet row.

The updateColumns can be used together with SET and UPDATE_ONLY for Data Lists to control exactly which fields get updated. It contains a comma-separated list of columns.

For Member sheets, there must always be one attribute called member_id. This can contain any MemberLookupId type (email, external Id etc).
Language
Click Try It! to start a request and see the response here!