Filter Hyperlink field url using SharePoint REST API

Question

I want to filter Hyperlink filed URL using REST API in SharePoint 2013.

My URL is like below is working fine

https://<siteurl>/_api/Web/Lists/GetByTitle('Pages')/items?$select=NavigateURL/Url

But the below is not working

https://<siteurl>/_api/Web/Lists/GetByTitle('Pages')/items?$select=NavigateURL/Url,Title&$expand=NavigateURL&$filter=NavigateURL/Url eq 'https://bing.com'

Please can any one help me on this to get the items with the url https://www.bing.com?

Answer 1

This is the limitation of REST API Filter that it cannot filter the Hyperlink fields.

So whats the workaround?

You can use CAML with REST to achieve what you want.

The CAML query will be like:

<View><Query><Where><Eq><FieldRef Name='URL'/><Value Type='URL'>url</Value></Eq></Where></Query></View>

For using REST API with CAML you can refer this post.