Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Detect deleted records using REST API

Hapatil
Tera Contributor

Uusing servicenow as a web service provider and will be reading records using TABLE API for a given duration. For same duration, want to know how to find deleted records using Rest API.

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@Hapatil 

Deletion of records may or may not be stored based on auditing.

Use the Deleted Records module to restore a deleted record 

you can check this in sys_audit_delete table; but providing access to external systems for this OOB table is not a good practice

AnkurBawiskar_0-1694427877290.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

10 REPLIES 10

Ankur Bawiskar
Tera Patron
Tera Patron

@Hapatil 

Deletion of records may or may not be stored based on auditing.

Use the Deleted Records module to restore a deleted record 

you can check this in sys_audit_delete table; but providing access to external systems for this OOB table is not a good practice

AnkurBawiskar_0-1694427877290.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Rest API explorer does not show 'sys_audit_delete'. Any reason for same?

@Hapatil 

that's system table so it won't show.

you need to add that table in the property then it will start showing

glide.ui.permitted_tables

AnkurBawiskar_0-1694429131272.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

this works for rest api explorer, but how do i achieve same using curl?

@Hapatil 

Glad to know.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader