Does anyone know how to use the Appian Smart Service Delete from Data Store Enti

Hi mark,please find the syntax below:
={entity:cons!MMS_APP_ENTITY_MEETING_DETAILS,identifiers:{4,2,3}}.
here identifiers refers to the primary keys of the table that identifies a record uniquely.

What does the constant represent, table name or a CDT? Is 'identifiers' the field? Are 4,2,3 the rows? Clarification is definitely needed. What would an example for the related Write to Data Store Entity look like?

The constant points to the data store entity. Identifiers is not the field, it's a key word. {4,2,3} are the primary key values for the rows you want to delete. The Write to Data Store Entity would write to the same data store, probably with the same constant as above.

I'm using a process variable instead of a constant for the Data Store Entity, any issue with that? For identifier 'key word', I'm using the first item name, which called ID, in a CDT that represents what what stored in the Data Store Entity. eg. My Appian Smart Service Write to Data Store Entity Value =pv!Xform, Save into dseFormX. So Data to Delete value is ={entity:pv!dseFormHSSD,ID:{4}} to delete the row whose ID=4?

Oops, I meant Data to Delete value is ={entity:pv!dseFormX,ID:{4}} ...please correct if wrong

Regardless of the primary key field in your table, I believe you are supposed to write "identifiers: {4}".

** "regardless of the name of the primary key field"

Ok. So, your example deletes three records, rows whose identifiers matches the values in the set {4,2,3} ? No secondary key fields allowed?

Hi mike,Only primary keys need to be provided, else it will throw an error saying there is no primary key defined. If you provide a column name as label instead of identifiers as you specified in your example (say ID) it may not throw error but there will be no deletions.

So... I have one primary key, if we say {4,2,3} does that delete three records?