Hello All
I have an API end point that takes in an ID, and then deletes records using direct query from two relational tables (i.e. table1_table2, with table1_id and table2_id as fields, and table1_table3, with table1_id and table3_id as fields), and then finally from the primary table (table 1 from the above examples).
It runs fine if I provide it with an ID that exists. However, when I provide it an ID that doesn't exist, rather than gracefully do nothing, I get an error/exception thrown.
'Whoops! An error occurred.Exception: Not Found'
I have no response type set for the API. There are default output settings using the 'Delete Record' option for the third and final call, rather than a direct database query. While I think I could probably just change that to a direct database query as well and avoid the issue, I'd like to know what I'm doing wrong as I can't imagine this is intended behavior.
Thank you