How to convert Servicenow Incident number into servicenow Incident Sys_id?

[selestinesheeba]

I am using UiPath integration service - Servicenow connector. I want to update an incident using its number. The activities accepts only incident sys_id. Is it possible to find or convert incident number into sys id?
Eg: Incident number: INC0010007 into
Sys_ID: 92059dc147093110367b2398c26d43a7

[arjunshenoy]

Hi @selestinesheeba

Please give this approach a try:

Use the UiPath HTTP Request activity to send a GET request to the ServiceNow API endpoint for retrieving an incident’s Sys_ID based on its number. The endpoint should look something like this:

https://your-instance.service-now.com/api/now/v1/table/incident?sysparm_query=number=INC0010007

This query should return JSON data that includes the Sys_ID of the incident with the specified number. Then you can deserialize the JSON response and access the Sys_ID field.

Hope this helps,
Best Regards.

[selestinesheeba]

@arjunshenoy Thanks for the solution