Use REST API to get details of a Change Request

Shikhar Tandon · ‎08-23-2022

Hi,

I am very new to this SNOW.

I am looking for help in REST API solution where I can pass the Change Request Number and in the output response I can get the Change request values like "Type", "Configuration Item", "Short description", "description".

Something like - https://test.service-now.com/api/sn_chg_rest/change/standard/CHG1234567

some this kind of URL and in response the values of these fields from the CRQ - "Type", "Configuration Item", "Short description", "description".

Looking forward for some help.

Thanks

ShubhamGarg · ‎08-24-2022

Hi @Shikhar Tandon ,

CI is also coming in correct format. This is how ServiceNow provides results for any reference field. If you are expecting Display value of CI, then make sysparm_display_value as true.

Then, your response would look like -

{
  "result": {
    "short_description": "testing else part",
    "cmdb_ci": {
      "link": "https://instance.service-now.com/api/now/table/cmdb_ci/f383a25ddb80d890bcb8dd3b5e96197a",
      "display_value": "HelloCI"
    },
    "description": "Datachange  Request"
  }
}

Let me know if issue persists.

Mark this as Correct answer and close this thread for reference to other people seeking same info.

Regards,

Shubham

View solution in original post

Rohit Sarkar1 · ‎08-25-2022

Hello you can take the SYSID from the available field from the REST API Explorer

ShubhamGarg · ‎08-25-2022

Hi @Shikhar Tandon ,

To fetch record using number, you can use this Table API - Retrieve records from a table

https://instance-name.service-now.com/api/now/table/{tableName}

>Pass Table Name in path parameter.
>In Query parameters -
   sysparm_query - number=1234xxxx
   sysparm_display_value - true (For CI label)
   sysparm_fields - short_description,description,configuration_item

It will solve your issues.

If this answers and clarifies your doubts, feel free to mark this answer as correct. It will be positive reference for others looking for same kind of information.