Not completely clear what you’re trying to do, but:
1) you can’t have reserved characters like “<“ , “>” in an XML attribute, so you should use >, < entities — something like:
<variable name="$message" value="<Id>CTN55</Id>" />
2) If you bind to the variable message with that statement, then you don’t need the ‘let $message” , but you do need to declare the variable as external, as it’s being bound with that variable element:
<text>declare variable $message external; . . .
3) and then, since that variable is a text string, you can use Fn:parse-xml-fragment() to convert it into a node that you can insert somewhere:
insert node fn:parse-xml-fragment($message) into . . .
I’m not sure that the destination node for your insert into clause is going to do what you want, but I can’t tell without knowing what the initial value of the doc node is.
I *think* this may answer your question, but if not, try to post what the initial value of that doc node is and what you want the final result to look like.
— Steve M.
On May 14, 2020, at 3:44 PM, Ramzi Hammouda Ramzi.Hammouda@se.linedata.com wrote:
Hello BaseX team,
Using Resful API, I'm trying to make POST method update BaseX database, I want to insert an xml node to an existing document calastone.xml in calastone database , but the node contains '<', you replied to a previous email that I should use fn:parse-xml to make this happen without error.
I tried using the function fn:parse-xml, I had success with using it in BaseX GUI like this:
let $message := fn:parse-xml('<Id>CTN55</Id>') return insert nodes $message as last into doc("calastone/calastone.xml")
But when I tried to do the same with POST method from my application with using this xquery:
string xquery = "<query><text>let $message:= fn:parse-xml('<Id>CTN58</Id>')" + "return insert nodes $message as last into doc("calastone/calastone.xml")</text>" + "<variable name = 'message' value = fn:parse-xml('<Id>CTN58</Id>'))/></query>";
I get the error: "" (Line 1): Element type "variable" must be followed by either attribute specifications, ">" or "/>"
Can you help on how to do this insertion?
Thanks.
P Respectons ensemble l'environnement. N'imprimez ce message que si nécessaire. Let's respect the environment together. Only print this message if necessary.