Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to filter the short description which contains number using servcienow api

Phanikanth
Kilo Contributor

Hi Team,

I have api which gives the SC task details and short_description.I want to filter the data using short description LIKE number(37602) and string(SHOP).Please find the attached snapshot for reference.

Example: I have short_description like below, want to filter using shop-37602.

    "Short_description" : SHOP IT Order: RSA Token -  PO: SHOP-37602

 

https://text.service-now.com/api/now/table/sc_task?sysparm_query=short_descriptionLIKEshop&sysparm_limit=2&sysparm_display_value=true&sys_created_by=talenduser.

find_real_file.png

2 REPLIES 2

Sulabh Garg
Mega Sage

Hello,

In thiscase, you can build your query like this

https://text.service-now.com/api/now/table/sc_task?sysparm_query=short_descriptionLIKESHOP-37602&sysparm_limit=2&sysparm_display_value=true&sys_created_by=talenduser.

 

 

Please Mark Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

Please Mark Correct/helpful, if applicable, Thanks!!
Regards
Sulabh Garg

@Phanikanth - I am glad my answer helped you, Please mark it correct so that this thread can be closed and others are benefitted.

Please Mark Correct/helpful, if applicable, Thanks!!
Regards
Sulabh Garg