question Rest call occurring twice during single update. in Developer forum

Rest call occurring twice during single update.

Fathima6 — Mon, 28 Sep 2020 09:38:53 GMT

Hi all!

I am updating single record in a single time but the api is hitting twice.

Description :

I created import set row table u_abc for targeting incident table using "number" and "work_notes" field. The table u_xyz have u_id and u_work_notes. Whenever I update those two field, Before business rule will run and call rest message to insert record in u_abc and finally update the incident record via transform mapping.

Issue :

Now the issue is, execution happening twice during every single update. Two times inserting in import table u_abc, at the same time two times updating incident table also

This is my BR:

Table : u_xyz
When : Before Update
Order : 13,500

Script :

(function executeRule(current, previous /*null when async*/) {

// Add your code here
gs.log("rest details"+current.u_id + current.u_work_notes);
var request = new sn_ws.RESTMessageV2("ServiceNow sample", "update comments");
request.setStringParameterNoEscape("number", current.u_id);
request.setStringParameterNoEscape("notes", current.u_work_notes);
request.execute();
var response = request.execute();
var requestBody = request.getRequestBody();
var responseBody = response.getBody();
var httpStatus = response.getStatusCode();
gs.log("response_incident" + httpStatus + responseBody );

})(current, previous);

This is my Rest message :

Using import API

{"u_number":"${number}","u_work_notes":"${notes}"}

Can anyone help?

Thanks in advance!

Re: Rest call occurring twice during single update.

Sajilal — Mon, 28 Sep 2020 09:50:13 GMT

Is only update checked in business rule or both? Just have insert/update checked and see if it resolves?

Please Mark as ✅ Correct if this solves your issue and also mark ???? Helpful if it helps resolve your problem.

Thanks,
Saji

Re: Rest call occurring twice during single update.

Ankur Bawiskar — Mon, 28 Sep 2020 09:53:21 GMT

Hi,

it is recommended to call the Rest Message in After or Async business rule and not in the before business rule

Please make the BR as After and test once

Regards
Ankur

Re: Rest call occurring twice during single update.

Fathima6 — Mon, 28 Sep 2020 11:27:57 GMT

No Its not working. If I changed to after or async , then records getting inserted in u_abc import set table but its not updating in incident table.

fyr this is my endpoint : https://xyz.service-now.com/api/now/import/u_abc

Re: Rest call occurring twice during single update.

Fathima6 — Mon, 28 Sep 2020 11:28:25 GMT

only update

Re: Rest call occurring twice during single update.

Ankur Bawiskar — Mon, 28 Sep 2020 11:53:20 GMT

Hi,

the ideal way to handle this is via After BR.

Can you explain below questions?

1) You are using BR on incident table in instance A

2) Which instance endpoint is being consumed in the Rest Message? is it the same instance or another instance

Regards
Ankur

Re: Rest call occurring twice during single update.

Sajilal — Mon, 28 Sep 2020 11:56:59 GMT

I see a comment in your Description "and finally update the incident record via transform mapping. " maybe can you not do this and see if system updates the record by backend only?

Thanks,

Saji

Re: Rest call occurring twice during single update.

Fathima6 — Mon, 28 Sep 2020 12:23:11 GMT

same instance

Re: Rest call occurring twice during single update.

Ankur Bawiskar — Mon, 28 Sep 2020 12:29:22 GMT

Hi,

so possibly the BR is triggering 2 times

please add this condition in the BR and check once

gs.getSession().isInteractive()

Regards
Ankur

Re: Rest call occurring twice during single update.

Fathima6 — Mon, 28 Sep 2020 12:57:53 GMT

even not using business rule, and trying via widget also calling twice

Re: Rest call occurring twice during single update.

Ankur Bawiskar — Mon, 28 Sep 2020 13:01:09 GMT

Hi,

you have BR configured for triggering the REST Message so please add the condition in the BR

gs.getSession().isInteractive()

Regards
Ankur

Re: Rest call occurring twice during single update.

Fathima6 — Mon, 28 Sep 2020 13:05:10 GMT

still getting twice

Re: Rest call occurring twice during single update.

Ankur Bawiskar — Mon, 28 Sep 2020 13:10:10 GMT

Hi,

few things to check

1) why are you consuming same instance endpoint in the same instance

Regards
Ankur

Re: Rest call occurring twice during single update.

Fathima6 — Mon, 28 Sep 2020 13:26:45 GMT

Actually two api calls generating to the third party end user side so I can't able to check in their end so calling my instance instead, therefor found two calls generating.

now wondering that , I called the same endpoint with the same parameters via postman, its hitting once . Again checking the same via widget by calling rest message its failing. Now I deactivated all BR in the particular table and trying via widget using the below code during button click

var request = new sn_ws.RESTMessageV2("ServiceNow sample", "update_comments");
request.setStringParameterNoEscape("number", orde.u_id);
request.setStringParameterNoEscape("notes", comments);
request.execute();
gs.log("rest details"+orde.u_id + comments);
var response = request.execute();
var requestBody = request.getRequestBody();
var responseBody = response.getBody();
var httpStatus = response.getStatusCode();
gs.log("response_incident" + httpStatus + responseBody );