Web Services

Re: UpdateListItem web service not working for "Delete" but working for "Update"

Hilary Stoupa — Fri, 08 Jan 2016 20:52:11 GMT

Hmmm. I'm not sure what else to suggest. I just tried this again with U2U in case the behavior was different for site collections (my initial test was at the server root), and it worked as anticipated. I'm going to try to attach a copy of the CAML Query Editor I use here (it is freeware, but I think the newer versions don't have the UpdateListItems method) so maybe you could try it to experiment with CAML and see what works for you? After you connect, find your list in the column on the left, right click and select UpdateListItems - then you can build using their interface or just paste in your own and test it. :)

Re: UpdateListItem web service not working for "Delete" but working for "Update"

Sutharsni Karmegam — Fri, 08 Jan 2016 20:26:37 GMT

Hi Hilary,

I have checked the URL and I finally hardcoded as well, "<Method ID=\"1\" Cmd=\"Delete\"><Field Name=\"ID\">258</Field><Field Name=\"FileRef\">'http://**********/sites/subsite/Shared Documents/item.xml'</Field></Method>" and "<Method ID=\"1\" Cmd=\"Delete\"><Field Name=\"ID\">258</Field><Field Name=\"FileRef\">'http://**********/sites/subsite/Shared%20Documents/item.xml'</Field></Method>" both I have tried still same issue.

The error message is "0x81020030Invalid file name.\n\nThe file name you specified could not be used. It may be the name of an existing file or directory, or you may not have permission to access the file."

Thanks,

SK.

Re: UpdateListItem web service not working for "Delete" but working for "Update"

Hilary Stoupa — Fri, 08 Jan 2016 16:02:23 GMT

So, using U2U CAML Query Editor (my favorite free tool for this) I tested a batch that looks like this:

<Batch PreCalc='TRUE' OnError='Continue'>
   <Method ID='1' Cmd='Delete'>
      <Field Name='ID'>108</Field>
      <Field Name="FileRef">http://server/Shared Documents/Stages.xml</Field>
   </Method>
</Batch>

And was able to delete my file successfully. The interesting thing was, originally my URL was encoded - Shared%20Documents instead of Shared Documents - and the query returned an error of "Invalid file name". So maybe check your URL variable?

Re: UpdateListItem web service not working for "Delete" but working for "Update"

Hilary Stoupa — Fri, 08 Jan 2016 15:40:25 GMT

So, your code sample in the text file has the Cmd in the Method as Update - if you use the same code and change to Delete, it doesn't work? Can you run Fiddler while you try this in preview so you can see the response from the web service?

UpdateListItem web service not working for "Delete" but working for "Update"

Sutharsni Karmegam — Fri, 08 Jan 2016 11:26:21 GMT

Hi, I am trying to delete a form from SharePoint InfoPath Library by calling web service "UpdateListItem" method but the form isn't getting deleted, whereas on the same command I tried to Update and it is successful. Here is my code for calling web service method. StringBuilder sb = new StringBuilder(); sb.Append("Method ID='1' Cmd='Delete'"); sb.Append(String.Format("Field Name=\ID\" + id_value + "/Field")); sb.Append(String.Format("Field Name=\"FileRef\" + URL +"/Field")); sb.Append("/Method"); System.Xml.XmlElement elBatch = xmlDoc.CreateElement("Batch"); elBatch.SetAttribute("OnError", "Continue"); elBatch.SetAttribute("PreCalc", "TRUE"); elBatch.SetAttribute("ListVersion", "1"); elBatch.SetAttribute("ViewName", "view_id without '{}' braces"); elBatch.InnerXml = sb.ToString(); XmlNode ndReturn = client.UpdateListItems(ListID, elBatch); Certain tags are not shown in command please get the actual code in attachment. Any help will be greatly appreciated. Thanks, SK.