How to find and update the request record (sc_request) without using sys_id

[lakshmi123]

Hi all,

   I wanted to know if there are any options to search a request number and update the status without using the sys_id through put method of Table API.

[SANDEEP28]

@lakshmi123 Its not possible to change behavior of out of box Table API and sys_id is mandatory for it. 

You can do this by using the import set API rather than the direct table API. This allows you to use a transform map (and scripts if needed) to manipulate the data before it hits the target table.

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

[James Chun]

Hi @lakshmi123,

You can query the table with an encoded query and it doesn't have to have a sys_id.

Instead, you can use various queries such as by the number, opened by, and so on.

e.g.

Cheers