Get Columns via REST

Question

I'm trying to get a list of all columns/fields for a list via REST using the /_api/Web/Lists(guid'xxxx')/Fields endpoint. This works fine, except it's adding in all of the system and duplicate fields such as LinkTitle, LinkTitleNoMenu, ContentTypeId, etc.

Short of filtering it out after retrieval using $.grep, is there a way I could use the filter syntax or similar to have SharePoint just return the user columns from a list, i.e. the ones a user might see in an edit or display form?

Thanks!

Answer 1

You could apply the following filter to exclude the fields that are not available in List forms:

/_api/web/lists/getbytitle('<list title>')/fields?$filter=Hidden eq false and ReadOnlyField eq false 

Answer 2

All system fields in SharePoint have a SourceId of "http://schemas.microsoft.com/sharepoint/v3" defined in their SchemaXml. Any user defined fields will have a Guid. So you can filter using this to return just the user defined ones:

$filter= substringof('SourceID=\"{',SchemaXml)

Answer 3

For instance, My list is like below.

Column1 Column2 Valuea1 Valuea2 Valueb1 Valueb2 Valuec1 Valuec2

Using Rest, If i want to filter a column by its value, Lets say Filter Column1 by the Value 'Valueb1'., then endpoint is

/_api/web/lists/getbytitle('listname')/items?$filter=Column1 eq 'Valueb1'

This will work for One Column only. But if I wanted to include more than one column in such a filtering condition, The EndPoint is

/_api/web/lists/getbytitle('listname')/items?$filter=Column1 eq 'Valuea1’ &$filter=Column2 eq 'Valueb2’

Hope this would help you.