how to validate dropdown /choices in Scripted REST Resource.

[jobin1]

Hi All

I need to validate the languages in user table while end user is sending data through payload. The similar kind of validation I did for company and its working fine but how we can give the same for a drop down choice?

sample company filed validation->

var user_company = body['Company'].toString().trim();
if (user_company == '' || user_company == null || user_company == undefined)
return {
"Status": "Enter the Company"
};

var company = new GlideRecord('core_company');
company.addQuery('name', user_company);
company.query();
if (company.next()) {
user.company = company.getUniqueValue();
} else {
return {
"Status": "Invalid company"
};
}

[jobin1]

@Ankur Bawiskar 

like this?

var lang = new GlideRecord('sys_choice');
lang.addQuery('name', 'sys_user');
lang.addQuery('element', 'preferred_language');
lang.query();
if (lang.next()) {
user.lang = lang.getUniqueValue();
} else {
return {
"Status": "Invalid language"
};
}

[Ankur Bawiskar]

yes

[Ankur Bawiskar]

@jobin 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards
Ankur

[jobin1]

@Ankur Bawiskar  Done.

[Snehangshu Sark]

Hi,

The first question would be - are you getting the user_name in the payload, if yes, then you can run GlideRecord on "sys_user" table and validate it.

user.preferred_language =<language>;

Please elaborate the issue

Regards,

Snehangshu Sarkar