How to make a REST api call and process the data received in response?

[Jamshaid]

Hi Everyone

I am new to ServiceNow and trying to do the following stuff. I am not getting a lead to do it as I have been using traditional programming IDEs to solve different tasks but did not use an app like ServiceNow earlier. I am trying to do the following:

- make an outbound Rest call to an external RestAPI and get JSON back. (able to do this but the results can not be processed as using Outbound rest messages)

 - find a way to process the JSON response with javascript in the test app.

- make authentication with API token with the RestAPI call

Is there any way I could achieve such functionality? Thanks a lot

[Pavankumar_1]

Hi Jamshaid,

You can use the below script in business rule to trigger the integration and get the response.

//call the rest message and method

var r = new sn_ws.RESTMessageV2('rest message name', 'post');

//provide the endpoint

 r.setEndpoint('end point');

//json is available on output payload field

 r.setRequestBody(current.output_payload + '');

 var response = r.execute();

// to get the response body

var responseBody = response.getBody();   

//setting response on input payload field

  current.input_payload = responseBody;

  current.update();

Hope it helps!!

Please Mark ✅ Correct/helpful, if applicable, Thanks!! 

Regards

Pavankumar

[Jamshaid]

hi there. could you please guide me about it a bit? I am totally new to ServiceNow. Is there any tutorial for it about where to place this code or you could guide by referring to an example? Thanks

[Jamshaid]

@Pavan i don't see any field for code in the mentioned file.

here is a screenshot indicating the file you mentioned. please clarify. thanks a lot for your help

[Hitoshi Ozawa · Accepted solution]

Check the "Advanced" checkbox.

The body of the script can be generated using REST Message.

1. From the Navigator, go to "System Web Services" > " Outbound" > "REST Message".
2. Create a new REST Message by clicking on the "New" button.
3. Fill in the Endpoint (i.e. enter the URI of the external url. e.g. http://xxx.aaa.com:8080)
4. Select "Authenentication type" from pull down
5. If there is a HTTP Request header, select the "HTTP Request" tab and insert the required headers.
6. Select the "New" button next to the HTTP Methods
7. Enter the "Name" and the "HTTP method".
8. To test the uri and if there is argument to be passed in the uri, click on the "New" button next to the "Variable Substitution". For example, to replace "id" with some value such as "abc"
9. Click the "Test" link under "Related Links" to test the endpoint.
10. If all goes well, click on the "Preview Script Usage" link under the "Related Links". This will generate JavaScript code template.
11. Paste the generated source code to business rule.
12. If using MID Server, edit the source code as needed.

To parse JSON response, 

      var responseBody = response.getBody();
      var response= JSON.parse(responseBody);
      for(i=0;i<response.length;i++) {
        // process json object
      }