Forum Discussion

ArtyomShegeda's avatar
ArtyomShegeda
Copper Contributor
Mar 07, 2023

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.

 

  1. Create empty list. Name it TestList:
  2. Do REST API OData query:
    /_api/web/lists/GetByTitle('TestList')/items?$select=Author/ID,Edit&$expand=Author
  3. Make sure you receive empty rowset.
  4. Create new list item in list TestList with any title.
  5. Do (the same) REST API OData query:
    /_api/web/lists/GetByTitle('TestList')/items?$select=Author/ID,Edit&$expand=Author
  6. Make sure you receive error state with error text:
    'Column 'Edit' does not exist. It may have been deleted by another user.'
  7. Run REST API OData query:
    /_api/web/lists/GetByTitle('TestList')/items?$select=AuthorId,Edit
  8. Make sure you receive a non-empty set of items with both fields AuthorId and Edit.
  9. Do REST API OData query:
    /_api/web/lists/GetByTitle('TestList')/items?$select=Author/ID&$expand=Author
  10. Make sure you receive a non-empty set of items with expanded field Author.
  11. Remove all items from the TestList.
  12. Do REST API OData query:
    /_api/web/lists/GetByTitle('TestList')/items?$select=Author/ID,Edit&$expand=Author
  13. 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

Resources