I have a workflow consisting of three forms: Customer Details, Address, and Health Care Details.
Customer Details Form: After filling out this form, I save the information to the customer table via an API call. If this operation is successful, I proceed to the next form. If it fails, I delete the customer entry from the table.
Address Form: Upon successful submission of the customer details, I fill out and submit the address form.
Health Care Details Form: After successfully submitting the address form, I proceed to the health care details form. However, if an error occurs while saving the health care details to the table (for instance, a failure in the write operation), and no entry is created in the health care details table (which uses the customer ID as a foreign key), I need to delete the previously saved entries in both the customer and address tables to maintain data consistency.
The challenge is that if a node fails during this process, Appian halts further execution, making it difficult to continue the workflow or perform cleanup operations.Any solution to solve this ..?
Discussion posts and replies are publicly visible
For the API call you just need to store the response (with error code) and manage with a XOR node on the exit. As for Write Records node there is a Pause On Error input parameter that allows you to have it continue past the node and allow you to catch and manage the error.