Contents
How to get custom field value via REST API?
Create calculated column and try copying the value of lookup custom column as it is and fetch the calculated column in your query. Thanks for contributing an answer to Stack Overflow!
How are field expressions used in REST API?
You can combine field expressions with filtering and sorting to further refine the data you want returned from the method. For example, you can filter on the date a workbook was last updated and then combine that with the field expression to return just the names of the workbooks that meet that criteria.
How to select fields in a REST query?
Thus in your REST query you can select additional fields only with aforementioned field types. For example you have a list Category with fields Title, Id, Active (custom Yes\\No field).
How to filter SharePoint list with REST API?
Please Sign up or sign in to vote. I have a SharePoint list as below. col1 is a lookup field. I want to use Rest API and filter the list on a col1 in such a way that even if i give part of the string, it should search the record. “, but no luck. When i replace substring and use filter = lookup/col eq ‘value’ , i was able to search.
For example, if the Books list has a PublishedBy field that looks up to the Name field of a Publisher list, you can return those names with this URL: Possible solutions i can think of.. Create calculated column and try copying the value of lookup custom column as it is and fetch the calculated column in your query.
A slight change in the call structure, but easily altered to the ajax call. I have a SharePoint Picture Library (but a normal list works the same way). One of the columns is a Choice list of locations, e.g. “Perth”, “Melbourne”, etc. By using the following query I get an object back of all fields in the Picture library. e.g.
Do you have to use REST API in SharePoint 2013?
Note the the URL is different because you have to use SharePoint 2013 rest API. The url you provided is the SharePoint 2010’s way to use Rest API. It is still here in 2013 though. @Oleg Bul.. Go through this article and become pro.. https://msdn.microsoft.com/en-us/magazine/dn198245.aspx 😀