Forum Discussion
ArtyomShegeda
Mar 07, 2023Copper Contributor
REST API call issue: Column “Edit” does not exist
I've met weird non-expected behavior. I ask for further research for discovering possible bigger issue in SP Services.
- Create empty list. Name it TestList:
- Do REST API OData query:
/_api/web/lists/GetByTitle('TestList')/items?$select=Author/ID,Edit&$expand=Author
- Make sure you receive empty rowset.
- Create new list item in list TestList with any title.
- Do (the same) REST API OData query:
/_api/web/lists/GetByTitle('TestList')/items?$select=Author/ID,Edit&$expand=Author
- Make sure you receive error state with error text:
'Column 'Edit' does not exist. It may have been deleted by another user.' - Run REST API OData query:
/_api/web/lists/GetByTitle('TestList')/items?$select=AuthorId,Edit
- Make sure you receive a non-empty set of items with both fields AuthorId and Edit.
- Do REST API OData query:
/_api/web/lists/GetByTitle('TestList')/items?$select=Author/ID&$expand=Author
- Make sure you receive a non-empty set of items with expanded field Author.
- Remove all items from the TestList.
- Do REST API OData query:
/_api/web/lists/GetByTitle('TestList')/items?$select=Author/ID,Edit&$expand=Author
- Make sure you receive empty rowset.
On step 5 SharePoint services return irrelevant message because of both $expand clause used and the Edit field reference.
No RepliesBe the first to reply