Sharepoint Lookup columns that allow multiple values are represented as a separate collection in the REST interface. For instance, if you have a list named BudgetLine and a list named Account, and BudgetLine has a multi-value lookup column called Account that looks up the Title on the Account list, you would use the following url to get a list of Accounts for the BudgetLine with an Id of 1:
To add a new Account to the BudgetLine with an ID of 1 you would do a POST to
with an http header ‘X-HTTP_method: MERGE’, and in the JSON Body, put the uri of the Account you want to add:
To remove the Account with an id of 2 from the BudgetLine with an Id of 3 you could do a delete on
Note that if you do a DELETE on
without the $links Sharepoint will delete the Item from the Accounts list rather than just removing it from the lookup.
You CANNOT delete all the lookup values in a single DELETE call to
This returns an error (…/$links/Account/’ is not valid for DELETE operation. The URI must refer to a single resource from an entity set or from a property referring to a set of resources.)