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, 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).