Tag Info

New answers tagged

0

I have various parameters for testing ODATA API And have tested: "_api/Web/Lists/getByTitle('Documents')/itemcount" result: Is equivalent of "_vti_bin/ListData.svc/Documents/$count" the result is fast and immediate: with this "/_vti_bin/ListData.svc/listname?$inlinecount=allpages" add to result as field called "count", see image below: You can ...


3

Date and time OData functions: day() month() year() hour() minute() second() does not seem to work with SharePoint 2013 REST Service Error: The query is not valid But you could consider the following approaches. Option 1 Utilize SharePoint 2010 REST endpoint: /_vti_bin/listdata.svc/ListName?$filter=month(<DateColumn>) eq <MonthNumber> ...


3

In order to select User or Lookup field values the $expand operator is used (for making a projection of AnnouncedBy column with User Information List). For example, the following query https://contoso.sharepoint.com/news/_api/web/lists/getByTitle('Announcements')/items?$select=*,AnnouncedBy/Title&$expand=AnnouncedBy will return the following result: ...


2

Try adding following in the URL $select=AnnouncedBy/Id,AnnouncedBy/Title,*&$expand=AnnouncedBy Reference: SharePoint 2013–retrieving the lookup value of User fields using the REST API Getting User Information with the SharePoint 2013 REST API


0

Using REST API query the list information. http://<site url>/_api/web/lists(guid'')/fields/getbyinternalnameortitle('zopv') http://<site url>/_api/web/lists(guid'')/fields/getbyinternalnameortitle('s2u2') This will give you the field information and use Title to get the display name


1

For filtering you can use $filter Supported operations are explained in below image


1

You should use the internal name of the fields in the query. Check the internal name of the 'parent' field, for example via PowerShell: $web = Get-SPWeb http://mysite $list = $web.Lists["Customer"] $list.Fields | % { $_.InternalName } or via http://mysite/_api/web/lists/getByTitle('Customer')/items If the lookup field was renamed, it might have already ...


2

The syntax of your query seems correct. Most probably this error occurs since $select and $expand operators are case-sensitive. Try the following query: /_api/web/lists/getByTitle('Customer')/items?$select=Parent/Title&$expand=Parent


0

So after much trial and error and reading everything I could, I have found the general issue, so sharing so anyone else that stumbles upon this. The issue is that the wildcard does not seem to be capable of passing the functions such as substringof() or startswith() to the ODataEntityUrl. You have to use a Comparison instead of a Wildcard. Here is the ...



Top 50 recent answers are included