REST API Query for Hyperlinks

Bhargava Ch

6y5.3k

Hi All,

is there any possibility to query Hyper link columns using REST Api?

Thanks,

Bhargava

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sagar Pardeshi6y ago

Accepted answer

Hi Bhargava,

It is a limitation in SharePoint 2013 REST filter.

You need to use CAML query along with REST.

url: "/_api/web/lists/getbytitle('MyTeam')/getitems" method: "POST", body: "{ 'query' : {'__metadata': { 'type': 'SP.CamlQuery' }, "ViewXml": "<View><Query><Where><BeginsWith><FieldRef Name='URL'/><Value Type='URL'>url</Value>BeginsWith></Where>Query>View>" } }", headers: { "accept": "application/json; odata=verbose", "content-type": "application/json; odata=verbose" }

Bhargava Ch6y ago
Hi Sagar,

Thanks for your reply,

url: "/_api/web/lists/getbytitle('MyTeam')/getitems" method: "POST", body: "{ 'query' : {'__metadata': { 'type': 'SP.CamlQuery' }, "ViewXml": "url" } }", headers: { "accept": "application/json; odata=verbose", "content-type": "application/json; odata=verbose" }

I know above soultion will give results, but I thought if we have any solution using REST Api, I am not aware of limitation

Thanks & Regards
Bhargava Channooru
Bhargava Ch6y ago
Hi Dinesh,
Thanks for quick reply but
https://sharepoint.stackexchange.com/questions/206678/get-url-description-from-hyperlink-field-using-rest-api-sharepoint?noredirect=1&lq=1
it is not having filters and we need to get all the rows and we need to apply the filter on REST data.

this will not give exact data because it was contains filter not exact
https://social.msdn.microsoft.com/Forums/office/en-US/dcc1af52-7c9f-4741-be0a-47920d184bf5/rest-api-get-hyperlinktype-of-data-returned-from-a-list?forum=sharepointdevelopment
Dinesh Gabhane6y ago
Please go through below URLs, it might help you

https://social.msdn.microsoft.com/Forums/office/en-US/dcc1af52-7c9f-4741-be0a-47920d184bf5/rest-api-get-hyperlinktype-of-data-returned-from-a-list?forum=sharepointdevelopment

https://sharepoint.stackexchange.com/questions/206678/get-url-description-from-hyperlink-field-using-rest-api-sharepoint?noredirect=1&lq=1