post https://neon-loyalty-qa.spika.com/loyalty/v1//sheets//rows
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).