How to delete comment or work notes from an incident task using Table API

[ellinorM]

Hi, 
I just started working with Servicenow. I have tried to find a easy way to delete a specific comment or work note from an incident via the Table API. I want to delete a comment using the comment ID/work note ID (sys_id) with the Table API from all tables needed. From what I understand there is three tables that I need to handle? 

sys_journal_field
sys_audit
sys_history_set

The problem is that the sys_id is different  in all tables and there is really no way of making sure that I delete the correct items? My code will have the incident sys_id and the comment/work note sys_id available when doing this operations. What is the best way to do this? 

[ellinorM]

Hi again,
Yes I have read that article before and my need was to do this programmatically via REST API. I will discuss with my team how to proceed.

 

[Dr Atul G- LNG]

Hi @ellinorM 

You already have expert @Brian Lancaster on this case, and i would like add my point. In my previous project we also delete the comments once added via going in logs , but doing with api is not that easy.

Manually it take 5 to 7 mins to delete one comment.

[ellinorM]

Thank you for your input. It's not an option to do this manually for us with the business modell we have today. If we are going to keep deleting comments we need to do this via the API without manual action. But since this is not an easy operation in Servicenow I will discuss with my team if we can change the business logic instead and remove the need of deleting comments. But thanks for you input!