Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 10.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3   11.4    Statistic    FMM    Blog  

XML.SetPathValue

Sets a xml node.

Component Version macOS Windows Linux Server iOS SDK
XML 7.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XML.SetPathValue"; XML; Path; Flags; Value )   More

Parameters

Parameter Description Example
XML The XML to process.
Can be XML as text or the reference returned by XML.Parse function, so you can make several times changes to the XML without parsing it each time.
"<test>Hello</test>"
Path The path to the node or attribute to query. "name"
Flags Various Flags.
Add 1 to ignore errors in xml and continue parsing. This may lead to not everything in the xml being read.
Add 4 to format returned XML.
Add 32 to return result as XML.
0
Value The new value for node or attribute.
This is for passing text to be used in XML and encoded properly.
If you pass new value as XML, please use XML.SetPathXML instead!.
"Hello"

Result

Returns XML, OK or error.

Description

Sets a xml node.
If needed, new nodes / attributes are added.
This function uses a path notation like the JSON functions in FileMaker to describe paths.
You can use name of a node followed by option index in square brackets. On the end you can use # followed by a name of an attribute to select only the attribute. Empty brackets or too big index allow you to append new node in v8.1.
Delimiter between items can be dot like FileMaker or newline.

If you pass in a XML reference number and you do not pass Flag value 32 for returning as XML, we just modify the XML reference in memory. This avoids performance hit for outputting and parsing xml for each change.

Examples

Add a first name:

MBS( "XML.SetPathValue"; "<person/>"; "person.firstName"; 0; "Joe" )

Example result:
"<?xml version="1.0" encoding="UTF-8"?>
<person><firstName>Joe</firstName></person>"

Add id attribute:

MBS( "XML.SetPathValue"; "<person/>"; "person#id"; 0; "123" )

Example result:
"<?xml version="1.0" encoding="UTF-8"?>
<person id="123"/>"

Adds a new name node with href number.

MBS( "XML.SetPathValue"; "<person></person>"; "person.name href=\"10.00\"" ; 4 ; "" )

Example result:
"<?xml version="1.0" encoding="UTF-8"?>
<person>
  <name href="10.00"/>
</person>"

Encode with entities:

MBS("XML.SetPathValue" ; "<foo/>" ; "foo.bar" ; 0 ; "test & test ¶ < > ")

Example result:
<?xml version="1.0" encoding="UTF-8"?>
<foo><bar>test &amp; test &#13; &lt; &gt; </bar></foo>

See also

Release notes

Example Databases

Blog Entries

Created 16th September 2017, last changed 3th August 2021


XML.SetPathCData - XML.SetPathXML

Feedback: Report problem or ask question.




Links
MBS Xojo Chart Plugins

Start Chat