REST API Query for Hyperlinks

Question

Hi All, is there any possibility to query Hyper link columns using REST Api? Thanks, Bhargava

Sagar Pardeshi · 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" }

Dinesh Gabhane · Answer

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

Bhargava Ch · Answer

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 Ch · Answer

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