29-08-19 05:09 PM
Hi
I am trying to utilize Sharepoint List Library VBO from Digital exchange. I tried to update few records/items in sharepoint but I am facing issues with customized Odata query. I tried with different HTTP methods in my query as well PUT, POST and PATCH but it didn't work. Can you please help us to share how we can update sharepoint data and what will be customized Odata query syntax?
Here are few sample queries to pull/read data from sharepoint:
getbytitle('Test List 1')/items?$filter=(FName eq 'FNameABC')
getbytitle('Test List 1')/items?$filter=ID eq 5
But for update, no luck. Attached is the screenshot of sharepoint.
Update scenario: Update any item under FName column.
Answered! Go to Answer.
04-09-19 03:04 PM
04-09-19 03:04 PM
04-09-19 04:08 PM
Bimal,
Thank you for the info. Independently from Swati, I had gotten as far as creating an Update Item API as you've described. However, we are getting the following error.
Internal : Unexpected error Error during Web API HTTP Request
HTTP Status Code: 400
HTTP Response Content: {"error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"The type SP.ListItemEntityCollection does not support HTTP PATCH method."}}}
Here is the set up:
I have tried both "etag or *" and simply "*"
|
| Ryan Godsey, Sr. Developer Applications Tyson Foods |
04-09-19 04:53 PM
04-09-19 09:53 PM
05-09-19 04:26 PM
20-09-19 05:35 PM
26-09-19 12:13 PM
21-10-19 10:14 AM
IF-MATCH | etag or * |
X-HTTP-Method | MERGE |
X-RequestDigest | [Form Digest Values] |
21-10-19 11:22 AM