The below will get a list containing all fields
$.ajax({
url: "http://<site url>/_api/web/lists/GetByTitle('ListTitle')/items?$select=*"
,type: "GET",
dataType: "json",
headers: {
Accept: "application/json;odata=verbose"
}
});
Say I want to retrieve all fields excluding the Title field... Is there a way to express this without writing out all fields (minus the Title field)? i.e. is there a way to exclude a field explicitly?
I am thinking something like this
url: "http://<site url>/_api/web/lists/GetByTitle('ListTitle')/items?$select!=Title
which surprisingly does not throw an error and returns all fields including Title...
or
url: "http://<site url>/_api/web/lists/GetByTitle('ListTitle')/items?$select=*&exclude=Title
exclude is not a valid query option, so obviously this fails.
Is there anything clever I can do to exclude a field or is this not possible?
/_api/SP.AppContextSite(@target)/web/lists/getbytitle('Custom List')/Fields
$select=Price,effectivebasepermissions,bla,bla