Transform script validate User Active True or False

Ram050670 · ‎10-20-2023

Hi All, i am trying to find a solution for validate User ID active or not in Transform.

can someone help me if we can validate that using run script on the transform.

SanjivMeher · ‎10-20-2023

You can create a onBefore Transform script and create a query to check if the called id is valid. If not, if you want to ignore, you can set ignore=true. Below is an example.

var user = new GlideRecord('sys_user');
user.addQuery('user_name',source.u_caller_id);
user.query();

if (user.next() && user.active!='true')
{
ignore=true
}

View solution in original post

SanjivMeher · ‎10-20-2023

I dont think, unless you are using scripted rest api.

In the scripted rest api, you can validate the data even before transforming it.

Ram050670 · ‎10-20-2023

can you help me write Scripted rest api?

SanjivMeher · ‎10-20-2023

Below link is a good starting point

https://www.servicenow.com/community/itsm-articles/scripted-rest-api-in-servicenow-inbound-integrati...

Badal Khojare · ‎10-20-2023

Hi @Ram050670 ,

Also check this: https://www.servicenow.com/community/itsm-forum/transform-script-to-show-active-inactive-users/m-p/7...

Ram050670 · ‎10-20-2023

Thanks for your response, but i am trying to look for user active status when i use rest api in order to avoid create INC for inactive user and i want to get error info mesg on that response.