field CONTAINS filter in API link

[David Munoz]

Good morning quarantined fellas,

I'm asking for your help to understand how to insert a Field Contains filter to an API link:

display_name (Contains) 'Alteryx' OR (contains) 'Tableau'

https://xxxxxxxxxx/api/now/table/alm_entitlement_user?sysparm_fields=sysparm_fields=display_name,active,assigned_to.user_name,assigned_to,active,department,allocated_to,allocated_to.asset.install_status

Thanks ahead for your time!

[David Munoz · Accepted solution]

https://xxxxxxxxxx/api/now/table/alm_entitlement_user?sysparm_query=display_nameLIKEAlteryx^ORdisplay_nameLIKETableau&sysparm_fields=u_active,display_name,display_name.name,assigned_to.user_name,assigned_to,assigned_to.active,assigned_to.department,assigned_to.department.name,allocated_to,allocated_to.name=GRCRSSF-9DH9QW1,allocated_to.asset.ci.install_status

Heres the solution I found, thank you.

[Community Alums]

Great! Glad you solved it. 🙂

Cheers mate!

Joro