Trigger and Write to records smart service

Question

Hello Everyone,

I am trying to insert a record which would be using the Write to Records or Write to Data Store Entity smart service to a table that has a trigger at the backend DB.
The trigger is for checking for the existence of a particular value in another  table.

If the ID being inserted exists in the another table, the insertion will proceed without any issues.
If the ID does not exist in the another table, the trigger will prevent the insertion and typically raise an error.

So in the second scenario if  the ID is not found, will the write to records execute normally or would it give an error because of the trigger?

karumurua531442 · Accepted Answer

hi [mention:04ccf59282b3437292bf0fc417dcebc4:e9ed411860ed4f2ba0265705b8793d05]  the Write to Records or Write to Data Store Entity smart service will give an error if the trigger prevents the insertion

stefanhelzle0001 · Answer

Did you already test that? I would expect to see that error coming up.

Sign up

Login with SSO

Login to the community

Login with SSO