Hi Harish,
I developed it in my demo instance and here are the steps. Here you go:
1) Only POST and GET methods are supported.
2) Create web service import set, transform map and field map etc
a) Name of web service - REST API Import Set
b) Label - u_rest_api_import_set
c) 2 fields for testing Short Description(u_short_description) and Incident Number(u_incident_number)
d) Transform map
e) 2 Field maps for the above 2 fields with coalesce on incident number field.
3) Consuming the API: I tested this using Hurl.it - Make HTTP requests . This testing will allow you to understand how the client/end system will consume your REST API
Screenshot below:
a) Method - POST
b) Endpoint - https://instanceName.service-now.com/api/now/import/u_rest_api_import_set
c) Header -
i) Accept -> application/xml OR application/json (Response accepted will be in this format)
ii) Content-Type -> application/xml OR application/json (Request sent to Servicenow will be either XML or JSON based on this)
d) Request Body - this you will have to tell the client/user that you will accept in this sample request body.
{
"u_short_description": "hello122",
"u_incident_number" : "INC0010043"
}
e) Authentication - create a user with rest role and give id and password in that field. example: user id -> rest.user
Sample Response received as XML:
<?xml version="1.0" encoding="UTF-8"?>
<response>
<import_set>ISET0010381</import_set>
<staging_table>u_rest_api_import_set</staging_table>
<result>
<display_value>INC0010043</display_value>
<sys_id>2a8c29254f500300fc11fa218110c7df</sys_id>
<transform_map>REST API Transform Map</transform_map>
<record_link>https://instanceName.service-now.com/api/now/table/incident/2a8c29254f500300fc11fa218110c7df</record_link>
<display_name>number</display_name>
<table>incident</table>
<status>inserted</status>
</result>
</response>
Sample Response received as JSON:
{
"import_set": "ISET0010381",
"staging_table": "u_rest_api_import_set",
"result": [
{
"transform_map": "REST API Transform Map",
"table": "incident",
"display_name": "number",
"display_value": "INC0010043",
"record_link": "https://instanceName.service-now.com/api/now/table/incident/2a8c29254f500300fc11fa218110c7df",
"status": "ignored",
"sys_id": "2a8c29254f500300fc11fa218110c7df",
"status_message": "No field values changed"
}
]
}
You can explore further on this as per your requirement.
Endorse the content if you feel this was helpful. How to Endorse Content
Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.
Thanks
Ankur
