Import Set API - GET /now/import/{tableName}/{sys_id}

This method retrieves the specified import staging record and resulting transformation result.

URL format

Versioned URL: /api/now/v1/import/{tableName}/{sys_id}

Default URL: /api/now/import/{tableName}/{sys_id}

Supported request parameters

Table 1. Parameters
Parameter Description


The following request and response headers apply to this HTTP action only, or apply to this action in a distinct way. For a list of general headers used in the REST API, see Supported REST API headers.

Table 2. Request headers
Header Description
Table 3. Response headers
Header Description

Status codes

The following status codes apply to this HTTP action. For a list of possible status codes used in the REST API, seeREST response codes.

Table 4. Status codes
Status code Description
200 Indicates the query ran successfully.
404 Indicates the specified resource was not available. As import set tables are deleted frequently based on a schedule, GET requests may return 404 NotFound responses if the transformation result no longer exists.

Sample cURL request

curl "" \
--request GET \
--header "Accept:application/json" \
--user 'admin':'admin'
  "import_set": "ISET0010001",
  "staging_table": "imp_user",
  "result": [
      "transform_map": "User",
      "table": "sys_user",
      "display_name": "name",
      "display_value": "John Public",
      "record_link": "",
      "status": "inserted",
      "sys_id": "ea928be64f411200adf9f8e18110c777"

Sample Python request

#Need to install requests package for python
#easy_install requests
import requests

# Set the request parameters
url = ''

# Eg. User name="admin", Password="admin" for this code sample.
user = 'admin'
pwd = 'admin'

# Set proper headers
headers = {"Content-Type":"application/xml","Accept":"application/xml"}

# Do the HTTP request
response = requests.get(url, auth=(user, pwd), headers=headers  )

# Check for HTTP codes other than 200
if response.status_code != 200: 
    print('Status:', response.status_code, 'Headers:', response.headers, 'Error Response:',response.json())

# Decode the JSON response into a dictionary and use the data
data = response.json()
<?xml version="1.0" encoding="UTF-8"?>
      <display_value>John Public</display_value>