Retrieving request information form ServiceNow via API

Elena Kretova

Retrieving request information form ServiceNow via API

Within our ServiceNow installation we have created a simple new Request form with two text input values. The form looks something like this:

+--------------------------------------------------------+
| Get new Computer-request                               |
+--------------------------------------------------------+
| model: <text input field>                              |
+--------------------------------------------------------+
| organization: <text input field>                       |
+--------------------------------------------------------+

When a new request has been created using this form, we can retrieve all relevant information using the ServiceNow table API, by querying the following tables:

  • sc_req_item
  • sc_item_option_mtm
  • sc_item_option
  • sc_cat_item

When issuing these REST calls we have to use several filters to navigate from one table to another and to only get the most recent items and only the request items within our service catalog category.

Ideally, we would like to save the entire request (timestamp, user, input values) as a JSON String within a single table. This way, we would only have to query this single table to retrieve all relevant information for a request.

Does ServiceNow admin support generating/saving a single JSON file from request form?


Having more than 3 years experience at TekSlate.com in IT professional with expertise in providing Enterprise Performance Engineering solutions.