I'm trying to use UpdateListItems in the easiest possible way and it is painfully not working. I've narrowed it down to the fact that the xml I am building is being URL encoded while being passed to the web service data connection.
I have a field called tmp_UpdateXML which I created with the value:
concat("<Batch OnError='Continue' ListVersion='1' ViewName='All Items'><Method ID='1' Cmd='New'><Field Name='ID'>New</Field><Field Name='Title'>", Filename, "</Field></Method></Batch>")
(Filename is actually an "inserted field")
I tried it as an XHTML field, a text field, a complex type, and in the data connection I have chosen to send the parameter as a string and another not as a string. But I always get the error:
<?xml version="1.0" encoding="utf-8"?><SOAP-ENV:Envelope xmlns:SOAPSDK1="http://www.w3.org/2001/XMLSchema" xmlns:SOAPSDK2="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAPSDK3="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Body><tns:UpdateListItems xmlns:tns="Voucher'>http://schemas.microsoft.com/sharepoint/soap/"><tns:listName>Voucher Numbering</tns:listName><tns:updates><my:tmp_UpdateXML xmlns:my="<Batch'>http://schemas.microsoft.com/office/infopath/2003/myXSD/2011-06-08T19:21:38"><Batch OnError='Continue' ListVersion='1' ViewName='All Items'><Method ID='1' Cmd='New'><Field Name='ID'>New</Field><Field Name='Title'>74478b53-d337-459f-b5eb-d38e9e978a65</Field></Method></Batch>......
Obviously it is encoding the values.. Any way to make this madness stop? I am so used to easily doing this with Nintex, this is driving me crazy. I've read other solutions about creating repeating tables, etc, but I don't want anything visible and I'm just posting one value. It seems that every post I have found is a copy and paste or someone's elses that all talks about the repeating table approach to dynamically creating CAML, etc, but nothing that addresses trying to create this XML by hand or dynamically.
Help?