How do I add "STARTS WITH" condition on REST API URL?

[Rajanmehta]

Hello 

We are on Jakarta. 

For example, I need to filter some assignment groups that starts with the name "ABCDE". How do I pass this variable into URL? What syntax I can use?

Please advise.

Thanks,

Rajan

https://xxx.service-now.com/api/now/table/change_request?sysparm_query=assignment_group STARTS WITH "ABCDE" ;

[kristenankeny · Accepted solution]

https://xxx.service-now.com/api/now/table/change_request?sysparm_query=active%3Dtrue%5Eassignment_group.u_display_nameSTARTSWITHabcde

I found this by going to the change table, adding the filter, run, right click on last breadcrumb in filter and select "copy query". 

[Rajanmehta]

Awesome Kristen.

Thank you so much. That really helped.

Thanks,

Rajan