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, the updateColumns attribute controls which fields are updated.
    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, the updateColumns attribute controls which fields get updated.
  • REMOVE
    Removes the Sheet row. Only the key fields need top be passed in.

The updateColumns 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).
Language
Click Try It! to start a request and see the response here!