question Re: How to delete a record from a ServiceNow table through scripted REST API? in Developer forum

How to delete a record from a ServiceNow table through scripted REST API?

Mon, 01 Aug 2022 16:39:47 GMT

Scenario: There is a table name "x_test", in this table i need to delete a record through JSON request in "Request body"

Payload:

{"name": "xyz"}

is there any way to achieve this solution?

Re: How to delete a record from a ServiceNow table through scripted REST API?

Muhammad Khan — Mon, 01 Aug 2022 16:49:54 GMT

Hi,

You will need to create Scripted Rest API with delete resource.

Hopefully, this will give you a direction.

Re: How to delete a record from a ServiceNow table through scripted REST API?

Ethan Davies — Mon, 01 Aug 2022 16:50:42 GMT

Hey VJ,

Take a look at this article here, should contain all you need.

Thanks,

Ethan

Please mark my answer as correct or helpful if it aided in solving your issue.

Re: How to delete a record from a ServiceNow table through scripted REST API?

Ankur Bawiskar — Mon, 01 Aug 2022 16:57:16 GMT

Hi,

Didn't get completely the use-case

You can use OOB Table API with DELETE method

You can use Scripted REST API with Delete HTTP method

Regards
Ankur

Re: How to delete a record from a ServiceNow table through scripted REST API?

PavanK960672992 — Mon, 01 Aug 2022 16:57:37 GMT

Hi,

On Scripted REST API use DELETE HTTP method.

Make the script based on your requirement that is when you need to perform delete operation.

Thanks,

Pavankumar

Re: How to delete a record from a ServiceNow table through scripted REST API?

Sameer18 — Mon, 01 Aug 2022 17:04:16 GMT

Hello,

I am adding little elaborative answer, I have pasted below code you need to write down code on similar lines.

Note: Instead of passing name in payload you can pass it as path parameter.

(function process(/*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {

	var name = request.pathParams.name || null;
	if (!name)
		return new sn_ws_err.BadRequestError("Change Request id not provided");
	
	var result = {};

	var record = new GlideRecord('x_test');
	if(record.get('name', name)){
		if (!record.deleteRecord())
			return new sn_ws_err.BadRequestError("Change Request not deleted");
		else{
			result.status = 'success';
			response.setStatus(200);
			response.setBody(result);
		}
	}else
		return new sn_ws_err.NotFoundError("Change Request not found");

})(request, response);

Step1: Create a scripted REST API with proper name (e.g. Test Table APIs )

Step 2: Create a DELETE scripted REST Resource as shown in below screenshot

Re: How to delete a record from a ServiceNow table through scripted REST API?

Ankur Bawiskar — Wed, 17 Aug 2022 06:27:57 GMT

Thank you for marking my response as helpful.

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

Regards
Ankur